- Prometheus配置：
在 prometheus.yml 文件中添加以下内容：
scrape_configs:- job_name: 'greenplum_exporter'scrape_interval: 15sstatic_configs:- targets: ['<IP address of Greenplum exporter>:9187']
- Greenplum Exporter 配置：
在 greenplum_exporter.yml 文件中添加以下内容：
global:db_address: <Greenplum master node IP address>db_port: <Greenplum master node port>db_user: <Greenplum username>db_password: <Greenplum password>metrics:query_duration_seconds:help: "Duration of the last query executed in seconds."sql: "SELECT query_duration_seconds FROM pg_stat_activity WHERE state = 'active' ORDER BY query_start DESC LIMIT 1;"queries_running:help: "Number of active queries."sql: "SELECT COUNT(*) FROM pg_stat_activity WHERE state = 'active';"connections:help: "Number of database connections."sql: "SELECT numbackends FROM pg_stat_database WHERE datname = current_database();"
- Alertmanager 配置：
在 alertmanager.yml 文件中添加以下内容：
global:slack_api_url: '<Slack webhook URL>'route:group_by: ['alertname', 'severity']receiver: 'slack-notifications'routes:- match:severity: criticalreceiver: 'slack-notifications'- match:severity: warningreceiver: 'slack-notifications'receivers:- name: 'slack-notifications'slack_configs:- channel: '#<Channel name>'send_resolved: true
- Grafana 配置：
使用 Grafana UI 创建 dashboard，选择 Prometheus 数据源，并添加以下 query：
greenplum_exporter_queries_runninggreenplum_exporter_query_duration_seconds
这将显示当前运行的查询数和最近执行查询的持续时间。
然后可以根据需要添加其他查询和面板。
![× Install fail! Error: [@vue/cil] An unknown git error occurred
Error: [@vue/cil] An unknown git error occurred](https://linuxcpp.0voice.com/zb_users/upload/2023/05/202305162214296498388.png)
![zpw@zpw-ThinkStation-P340:~/study/redis$ make
for dir in src; do make -C $dir all; done
make[1]: 进入目录“/home/zpw/study/redis/src”
CC threads_mngr.o
threads_mngr.c:27:37: warning: initializing '_Atomic(run_on_thread_cb)' with an expression of ty...](https://linuxcpp.0voice.com/zb_users/upload/2023/05/202305162238408381987.png)
![hread_event.o src/ticker.o src/tsd.o src/witness.o
make[3]: 离开目录“/home/zpw/study/redis/deps/jemalloc”
make[2]: 离开目录“/home/zpw/study/redis/deps”
CC threads_mngr.o
threads_mngr.c:27:37: warning: initializing '_Atomic(run_on_thread_cb)' with an e...](https://linuxcpp.0voice.com/zb_users/upload/2023/05/202305162214438435275.png)
![zpw@zpw-ThinkStation-P340:~/study/redis$ make
for dir in src; do make -C $dir all; done
make[1]: 进入目录“/home/zpw/study/redis/src”
CC threads_mngr.o
threads_mngr.c:27:37: warning: initializing '_Atomic(run_on_thread_cb)' with an expression of ty...](https://linuxcpp.0voice.com/zb_users/upload/2023/05/202305162237121215388.png)
