# 系统资源监控指标
# CPU使用率：阈值80%
# 内存使用率：阈值85%
# 磁盘使用率：阈值90%
# 网络流量：根据实际情况设置

# 数据库监控指标
# 连接数：阈值90%
# 查询执行时间：阈值10秒
# 事务数量：根据实际情况设置
# 慢查询数量：根据实际情况设置

# 监控系统资源
# 查看CPU使用率
SELECT * FROM pg_stat_os_sysinfo;

# 查看内存使用率
SELECT * FROM pg_stat_os_memory;

# 查看磁盘使用率
SELECT * FROM pg_stat_file(‘pg_xlog’);

# 监控数据库指标
# 查看连接数
SELECT count(*) FROM pg_stat_activity;

# 查看慢查询
SELECT * FROM pg_stat_statements ORDER BY total_exec_time DESC LIMIT 10;

# 查看锁情况
SELECT * FROM pg_locks;

学习交流加群风哥微信: itpux-com
# 安装Prometheus和Grafana
wget https://github.com/prometheus/prometheus/releases/download/v2.35.0/prometheus-2.35.0.linux-amd64.tar.gz
wget https://github.com/grafana/grafana/releases/download/v8.5.0/grafana-8.5.0.linux-amd64.tar.gz

tar -zxvf prometheus-2.35.0.linux-amd64.tar.gz -C /opengauss/app
tar -zxvf grafana-8.5.0.linux-amd64.tar.gz -C /opengauss/app

# 配置Prometheus
cat > /opengauss/app/prometheus-2.35.0.linux-amd64/prometheus.yml << EOF global: scrape_interval: 15s scrape_configs: - job_name: 'opengauss' static_configs: - targets: ['localhost:9187'] EOF # 启动Prometheus /opengauss/app/prometheus-2.35.0.linux-amd64/prometheus --config.file=/opengauss/app/prometheus-2.35.0.linux-amd64/prometheus.yml # 启动Grafana /opengauss/app/grafana-8.5.0/bin/grafana-server