跳到主要内容
版本:0.4 · 当前版

PostgreSQL 检查

参考审阅日期:2026年10月11日
适用于:Excubius 0.4角色: 操作员, 编辑者, 实体管理员
计划Free · Pro · Enterprise部署自托管

postgresql 模块有 6 项检查。PostgreSQL(灵活服务器或自托管),通过具有 pg_monitor 的只读监视角色进行检查。

本页在构建文档时根据产品的检查目录生成,因此规则、间隔和默认严重性始终与你正在阅读的版本一致。阈值是默认值;实体和资源可以覆盖这些阈值。

检查间隔默认严重性规则
postgresql.connections
Connections used vs max
60swarningwarning > 80 percent / critical > 90 percent
postgresql.replication_lag
Replication lag
60swarningwarning > 60 seconds / critical > 300 seconds
postgresql.vacuum_wraparound
Transaction ID age (wraparound risk)
3600swarningwarning > 1000000000 count / critical > 1500000000 count
postgresql.bloat_estimate
Table bloat (estimated, top tables)
86400sinfowarning > 20 percent / critical > 40 percent
postgresql.slow_queries
Slowest statements (pg_stat_statements)
300sinfo±2σ over 14d (learning only)
postgresql.security_posture
Security posture (superusers, SSL, pg_hba)
3600swarningssl = on, risky_hba_rules = 0

检查​

postgresql.connections

Connections used vs max

度量
used_percent (percent) · 每 60s · pgsql
规则
warning > 80 percent / critical > 90 percent · 默认严重性: warning
措施
—
基线
Azure recommended rule for Flexible Server: connections > 80% of max.

postgresql.replication_lag

Replication lag

度量
lag_seconds (seconds) · 每 60s · pgsql
规则
warning > 60 seconds / critical > 300 seconds · 默认严重性: warning
措施
—

postgresql.vacuum_wraparound

Transaction ID age (wraparound risk)

度量
xid_age (count) · 每 3600s · pgsql
规则
warning > 1000000000 count / critical > 1500000000 count · 默认严重性: warning
措施
—
基线
Forced vacuum at ~2.1 billion; warn at 1 billion. · 来源

postgresql.bloat_estimate

Table bloat (estimated, top tables)

度量
dead_percent (percent) · 每 86400s · pgsql
规则
warning > 20 percent / critical > 40 percent · 默认严重性: info
措施
—

postgresql.slow_queries

Slowest statements (pg_stat_statements)

度量
mean_ms (milliseconds) · 每 300s · pgsql
规则
±2σ over 14d (learning only) · 默认严重性: info
措施
—
基线
Requires the pg_stat_statements extension.

postgresql.security_posture

Security posture (superusers, SSL, pg_hba)

度量
security_posture · 每 3600s · pgsql
规则
ssl = on, risky_hba_rules = 0 · 默认严重性: warning
措施
—
基线
superusers > 2 raises a warning; pg_hba_file_rules needs PostgreSQL 10+ and superuser or pg_read_server_files. · 来源