指标列表
Pigsty PGSQL 模块提供的完整监控指标列表与释义
PGSQL 模块包含有 638 类可用监控指标。
| Metric Name | Type | Labels | Description |
|---|---|---|---|
| ALERTS | Unknown | category, job, level, ins, severity, ip, alertname, alertstate, instance, cls | N/A |
| ALERTS_FOR_STATE | Unknown | category, job, level, ins, severity, ip, alertname, instance, cls | N/A |
| cls:pressure1 | Unknown | job, cls | N/A |
| cls:pressure15 | Unknown | job, cls | N/A |
| cls:pressure5 | Unknown | job, cls | N/A |
| go_gc_duration_seconds | summary | job, ins, ip, instance, quantile, cls | A summary of the pause duration of garbage collection cycles. |
| go_gc_duration_seconds_count | Unknown | job, ins, ip, instance, cls | N/A |
| go_gc_duration_seconds_sum | Unknown | job, ins, ip, instance, cls | N/A |
| go_goroutines | gauge | job, ins, ip, instance, cls | Number of goroutines that currently exist. |
| go_info | gauge | version, job, ins, ip, instance, cls | Information about the Go environment. |
| go_memstats_alloc_bytes | gauge | job, ins, ip, instance, cls | Number of bytes allocated and still in use. |
| go_memstats_alloc_bytes_total | counter | job, ins, ip, instance, cls | Total number of bytes allocated, even if freed. |
| go_memstats_buck_hash_sys_bytes | gauge | job, ins, ip, instance, cls | Number of bytes used by the profiling bucket hash table. |
| go_memstats_frees_total | counter | job, ins, ip, instance, cls | Total number of frees. |
| go_memstats_gc_sys_bytes | gauge | job, ins, ip, instance, cls | Number of bytes used for garbage collection system metadata. |
| go_memstats_heap_alloc_bytes | gauge | job, ins, ip, instance, cls | Number of heap bytes allocated and still in use. |
| go_memstats_heap_idle_bytes | gauge | job, ins, ip, instance, cls | Number of heap bytes waiting to be used. |
| go_memstats_heap_inuse_bytes | gauge | job, ins, ip, instance, cls | Number of heap bytes that are in use. |
| go_memstats_heap_objects | gauge | job, ins, ip, instance, cls | Number of allocated objects. |
| go_memstats_heap_released_bytes | gauge | job, ins, ip, instance, cls | Number of heap bytes released to OS. |
| go_memstats_heap_sys_bytes | gauge | job, ins, ip, instance, cls | Number of heap bytes obtained from system. |
| go_memstats_last_gc_time_seconds | gauge | job, ins, ip, instance, cls | Number of seconds since 1970 of last garbage collection. |
| go_memstats_lookups_total | counter | job, ins, ip, instance, cls | Total number of pointer lookups. |
| go_memstats_mallocs_total | counter | job, ins, ip, instance, cls | Total number of mallocs. |
| go_memstats_mcache_inuse_bytes | gauge | job, ins, ip, instance, cls | Number of bytes in use by mcache structures. |
| go_memstats_mcache_sys_bytes | gauge | job, ins, ip, instance, cls | Number of bytes used for mcache structures obtained from system. |
| go_memstats_mspan_inuse_bytes | gauge | job, ins, ip, instance, cls | Number of bytes in use by mspan structures. |
| go_memstats_mspan_sys_bytes | gauge | job, ins, ip, instance, cls | Number of bytes used for mspan structures obtained from system. |
| go_memstats_next_gc_bytes | gauge | job, ins, ip, instance, cls | Number of heap bytes when next garbage collection will take place. |
| go_memstats_other_sys_bytes | gauge | job, ins, ip, instance, cls | Number of bytes used for other system allocations. |
| go_memstats_stack_inuse_bytes | gauge | job, ins, ip, instance, cls | Number of bytes in use by the stack allocator. |
| go_memstats_stack_sys_bytes | gauge | job, ins, ip, instance, cls | Number of bytes obtained from system for stack allocator. |
| go_memstats_sys_bytes | gauge | job, ins, ip, instance, cls | Number of bytes obtained from system. |
| go_threads | gauge | job, ins, ip, instance, cls | Number of OS threads created. |
| ins:pressure1 | Unknown | job, ins, ip, cls | N/A |
| ins:pressure15 | Unknown | job, ins, ip, cls | N/A |
| ins:pressure5 | Unknown | job, ins, ip, cls | N/A |
| patroni_cluster_unlocked | gauge | job, ins, ip, instance, cls, scope | Value is 1 if the cluster is unlocked, 0 if locked. |
| patroni_dcs_last_seen | gauge | job, ins, ip, instance, cls, scope | Epoch timestamp when DCS was last contacted successfully by Patroni. |
| patroni_failsafe_mode_is_active | gauge | job, ins, ip, instance, cls, scope | Value is 1 if failsafe mode is active, 0 if inactive. |
| patroni_is_paused | gauge | job, ins, ip, instance, cls, scope | Value is 1 if auto failover is disabled, 0 otherwise. |
| patroni_master | gauge | job, ins, ip, instance, cls, scope | Value is 1 if this node is the leader, 0 otherwise. |
| patroni_pending_restart | gauge | job, ins, ip, instance, cls, scope | Value is 1 if the node needs a restart, 0 otherwise. |
| patroni_postgres_in_archive_recovery | gauge | job, ins, ip, instance, cls, scope | Value is 1 if Postgres is replicating from archive, 0 otherwise. |
| patroni_postgres_running | gauge | job, ins, ip, instance, cls, scope | Value is 1 if Postgres is running, 0 otherwise. |
| patroni_postgres_server_version | gauge | job, ins, ip, instance, cls, scope | Version of Postgres (if running), 0 otherwise. |
| patroni_postgres_streaming | gauge | job, ins, ip, instance, cls, scope | Value is 1 if Postgres is streaming, 0 otherwise. |
| patroni_postgres_timeline | counter | job, ins, ip, instance, cls, scope | Postgres timeline of this node (if running), 0 otherwise. |
| patroni_postmaster_start_time | gauge | job, ins, ip, instance, cls, scope | Epoch seconds since Postgres started. |
| patroni_primary | gauge | job, ins, ip, instance, cls, scope | Value is 1 if this node is the leader, 0 otherwise. |
| patroni_replica | gauge | job, ins, ip, instance, cls, scope | Value is 1 if this node is a replica, 0 otherwise. |
| patroni_standby_leader | gauge | job, ins, ip, instance, cls, scope | Value is 1 if this node is the standby_leader, 0 otherwise. |
| patroni_sync_standby | gauge | job, ins, ip, instance, cls, scope | Value is 1 if this node is a sync standby replica, 0 otherwise. |
| patroni_up | Unknown | job, ins, ip, instance, cls | N/A |
| patroni_version | gauge | job, ins, ip, instance, cls, scope | Patroni semver without periods. |
| patroni_xlog_location | counter | job, ins, ip, instance, cls, scope | Current location of the Postgres transaction log, 0 if this node is not the leader. |
| patroni_xlog_paused | gauge | job, ins, ip, instance, cls, scope | Value is 1 if the Postgres xlog is paused, 0 otherwise. |
| patroni_xlog_received_location | counter | job, ins, ip, instance, cls, scope | Current location of the received Postgres transaction log, 0 if this node is not a replica. |
| patroni_xlog_replayed_location | counter | job, ins, ip, instance, cls, scope | Current location of the replayed Postgres transaction log, 0 if this node is not a replica. |
| patroni_xlog_replayed_timestamp | gauge | job, ins, ip, instance, cls, scope | Current timestamp of the replayed Postgres transaction log, 0 if null. |
| pg:cls:active_backends | Unknown | job, cls | N/A |
| pg:cls:active_time_rate15m | Unknown | job, cls | N/A |
| pg:cls:active_time_rate1m | Unknown | job, cls | N/A |
| pg:cls:active_time_rate5m | Unknown | job, cls | N/A |
| pg:cls:age | Unknown | job, cls | N/A |
| pg:cls:buf_alloc_rate1m | Unknown | job, cls | N/A |
| pg:cls:buf_clean_rate1m | Unknown | job, cls | N/A |
| pg:cls:buf_flush_backend_rate1m | Unknown | job, cls | N/A |
| pg:cls:buf_flush_checkpoint_rate1m | Unknown | job, cls | N/A |
| pg:cls:cpu_count | Unknown | job, cls | N/A |
| pg:cls:cpu_usage | Unknown | job, cls | N/A |
| pg:cls:cpu_usage_15m | Unknown | job, cls | N/A |
| pg:cls:cpu_usage_1m | Unknown | job, cls | N/A |
| pg:cls:cpu_usage_5m | Unknown | job, cls | N/A |
| pg:cls:db_size | Unknown | job, cls | N/A |
| pg:cls:file_size | Unknown | job, cls | N/A |
| pg:cls:ixact_backends | Unknown | job, cls | N/A |
| pg:cls:ixact_time_rate1m | Unknown | job, cls | N/A |
| pg:cls:lag_bytes | Unknown | job, cls | N/A |
| pg:cls:lag_seconds | Unknown | job, cls | N/A |
| pg:cls:leader | Unknown | job, ins, ip, instance, cls | N/A |
| pg:cls:load1 | Unknown | job, cls | N/A |
| pg:cls:load15 | Unknown | job, cls | N/A |
| pg:cls:load5 | Unknown | job, cls | N/A |
| pg:cls:lock_count | Unknown | job, cls | N/A |
| pg:cls:locks | Unknown | job, cls, mode | N/A |
| pg:cls:log_size | Unknown | job, cls | N/A |
| pg:cls:lsn_rate1m | Unknown | job, cls | N/A |
| pg:cls:members | Unknown | job, ins, ip, cls | N/A |
| pg:cls:num_backends | Unknown | job, cls | N/A |
| pg:cls:partition | Unknown | job, cls | N/A |
| pg:cls:receiver | Unknown | state, slot_name, job, appname, ip, cls, sender_host, sender_port | N/A |
| pg:cls:rlock_count | Unknown | job, cls | N/A |
| pg:cls:saturation1 | Unknown | job, cls | N/A |
| pg:cls:saturation15 | Unknown | job, cls | N/A |
| pg:cls:saturation5 | Unknown | job, cls | N/A |
| pg:cls:sender | Unknown | pid, usename, address, job, ins, appname, ip, cls | N/A |
| pg:cls:session_time_rate1m | Unknown | job, cls | N/A |
| pg:cls:size | Unknown | job, cls | N/A |
| pg:cls:slot_count | Unknown | job, cls | N/A |
| pg:cls:slot_retained_bytes | Unknown | job, cls | N/A |
| pg:cls:standby_count | Unknown | job, cls | N/A |
| pg:cls:sync_state | Unknown | job, cls | N/A |
| pg:cls:timeline | Unknown | job, cls | N/A |
| pg:cls:tup_deleted_rate1m | Unknown | job, cls | N/A |
| pg:cls:tup_fetched_rate1m | Unknown | job, cls | N/A |
| pg:cls:tup_inserted_rate1m | Unknown | job, cls | N/A |
| pg:cls:tup_modified_rate1m | Unknown | job, cls | N/A |
| pg:cls:tup_returned_rate1m | Unknown | job, cls | N/A |
| pg:cls:wal_size | Unknown | job, cls | N/A |
| pg:cls:xact_commit_rate15m | Unknown | job, cls | N/A |
| pg:cls:xact_commit_rate1m | Unknown | job, cls | N/A |
| pg:cls:xact_commit_rate5m | Unknown | job, cls | N/A |
| pg:cls:xact_rollback_rate15m | Unknown | job, cls | N/A |
| pg:cls:xact_rollback_rate1m | Unknown | job, cls | N/A |
| pg:cls:xact_rollback_rate5m | Unknown | job, cls | N/A |
| pg:cls:xact_total_rate15m | Unknown | job, cls | N/A |
| pg:cls:xact_total_rate1m | Unknown | job, cls | N/A |
| pg:cls:xact_total_sigma15m | Unknown | job, cls | N/A |
| pg:cls:xlock_count | Unknown | job, cls | N/A |
| pg:db:active_backends | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:active_time_rate15m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:active_time_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:active_time_rate5m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:age | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:age_deriv1h | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:age_exhaust | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:blk_io_time_seconds_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:blk_read_time_seconds_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:blk_write_time_seconds_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:blks_access_1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:blks_hit_1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:blks_hit_ratio1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:blks_read_1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:conn_limit | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:conn_usage | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:db_size | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:ixact_backends | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:ixact_time_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:lock_count | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:num_backends | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:rlock_count | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:session_time_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:temp_bytes_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:temp_files_1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:tup_deleted_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:tup_fetched_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:tup_inserted_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:tup_modified_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:tup_returned_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:wlock_count | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_commit_rate15m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_commit_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_commit_rate5m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_rollback_rate15m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_rollback_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_rollback_rate5m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_total_rate15m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_total_rate1m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_total_rate5m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xact_total_sigma15m | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:db:xlock_count | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg:env:active_backends | Unknown | job | N/A |
| pg:env:active_time_rate15m | Unknown | job | N/A |
| pg:env:active_time_rate1m | Unknown | job | N/A |
| pg:env:active_time_rate5m | Unknown | job | N/A |
| pg:env:age | Unknown | job | N/A |
| pg:env:cpu_count | Unknown | job | N/A |
| pg:env:cpu_usage | Unknown | job | N/A |
| pg:env:cpu_usage_15m | Unknown | job | N/A |
| pg:env:cpu_usage_1m | Unknown | job | N/A |
| pg:env:cpu_usage_5m | Unknown | job | N/A |
| pg:env:ixact_backends | Unknown | job | N/A |
| pg:env:ixact_time_rate1m | Unknown | job | N/A |
| pg:env:lag_bytes | Unknown | job | N/A |
| pg:env:lag_seconds | Unknown | job | N/A |
| pg:env:lsn_rate1m | Unknown | job | N/A |
| pg:env:session_time_rate1m | Unknown | job | N/A |
| pg:env:tup_deleted_rate1m | Unknown | job | N/A |
| pg:env:tup_fetched_rate1m | Unknown | job | N/A |
| pg:env:tup_inserted_rate1m | Unknown | job | N/A |
| pg:env:tup_modified_rate1m | Unknown | job | N/A |
| pg:env:tup_returned_rate1m | Unknown | job | N/A |
| pg:env:xact_commit_rate15m | Unknown | job | N/A |
| pg:env:xact_commit_rate1m | Unknown | job | N/A |
| pg:env:xact_commit_rate5m | Unknown | job | N/A |
| pg:env:xact_rollback_rate15m | Unknown | job | N/A |
| pg:env:xact_rollback_rate1m | Unknown | job | N/A |
| pg:env:xact_rollback_rate5m | Unknown | job | N/A |
| pg:env:xact_total_rate15m | Unknown | job | N/A |
| pg:env:xact_total_rate1m | Unknown | job | N/A |
| pg:env:xact_total_sigma15m | Unknown | job | N/A |
| pg:ins:active_backends | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:active_time_rate15m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:active_time_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:active_time_rate5m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:age | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:blks_hit_ratio1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:buf_alloc_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:buf_clean_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:buf_flush_backend_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:buf_flush_checkpoint_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:ckpt_1h | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:ckpt_req_1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:ckpt_timed_1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:conn_limit | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:conn_usage | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:cpu_count | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:cpu_usage | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:cpu_usage_15m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:cpu_usage_1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:cpu_usage_5m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:db_size | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:file_size | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:fs_size | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:is_leader | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:ixact_backends | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:ixact_time_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:lag_bytes | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:lag_seconds | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:load1 | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:load15 | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:load5 | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:lock_count | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:locks | Unknown | job, ins, ip, mode, instance, cls | N/A |
| pg:ins:log_size | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:lsn_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:mem_size | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:num_backends | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:rlock_count | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:saturation1 | Unknown | job, ins, ip, cls | N/A |
| pg:ins:saturation15 | Unknown | job, ins, ip, cls | N/A |
| pg:ins:saturation5 | Unknown | job, ins, ip, cls | N/A |
| pg:ins:session_time_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:slot_retained_bytes | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:space_usage | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:status | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:sync_state | Unknown | job, ins, instance, cls | N/A |
| pg:ins:target_count | Unknown | job, cls, ins | N/A |
| pg:ins:timeline | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:tup_deleted_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:tup_fetched_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:tup_inserted_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:tup_modified_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:tup_returned_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:wal_size | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:wlock_count | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_commit_rate15m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_commit_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_commit_rate5m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_rollback_rate15m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_rollback_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_rollback_rate5m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_total_rate15m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_total_rate1m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_total_rate5m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xact_total_sigma15m | Unknown | job, ins, ip, instance, cls | N/A |
| pg:ins:xlock_count | Unknown | job, ins, ip, instance, cls | N/A |
| pg:query:call_rate1m | Unknown | datname, query, job, ins, ip, instance, cls | N/A |
| pg:query:rt_1m | Unknown | datname, query, job, ins, ip, instance, cls | N/A |
| pg:table:scan_rate1m | Unknown | datname, relname, job, ins, ip, instance, cls | N/A |
| pg_activity_count | gauge | datname, state, job, ins, ip, instance, cls | Count of connection among (datname,state) |
| pg_activity_max_conn_duration | gauge | datname, state, job, ins, ip, instance, cls | Max backend session duration since state change among (datname, state) |
| pg_activity_max_duration | gauge | datname, state, job, ins, ip, instance, cls | Max duration since last state change among (datname, state) |
| pg_activity_max_tx_duration | gauge | datname, state, job, ins, ip, instance, cls | Max transaction duration since state change among (datname, state) |
| pg_archiver_failed_count | counter | job, ins, ip, instance, cls | Number of failed attempts for archiving WAL files |
| pg_archiver_finish_count | counter | job, ins, ip, instance, cls | Number of WAL files that have been successfully archived |
| pg_archiver_last_failed_time | counter | job, ins, ip, instance, cls | Time of the last failed archival operation |
| pg_archiver_last_finish_time | counter | job, ins, ip, instance, cls | Time of the last successful archive operation |
| pg_archiver_reset_time | gauge | job, ins, ip, instance, cls | Time at which archive statistics were last reset |
| pg_backend_count | gauge | type, job, ins, ip, instance, cls | Database backend process count by backend_type |
| pg_bgwriter_buffers_alloc | counter | job, ins, ip, instance, cls | Number of buffers allocated |
| pg_bgwriter_buffers_backend | counter | job, ins, ip, instance, cls | Number of buffers written directly by a backend |
| pg_bgwriter_buffers_backend_fsync | counter | job, ins, ip, instance, cls | Number of times a backend had to execute its own fsync call |
| pg_bgwriter_buffers_checkpoint | counter | job, ins, ip, instance, cls | Number of buffers written during checkpoints |
| pg_bgwriter_buffers_clean | counter | job, ins, ip, instance, cls | Number of buffers written by the background writer |
| pg_bgwriter_checkpoint_sync_time | counter | job, ins, ip, instance, cls | Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in seconds |
| pg_bgwriter_checkpoint_write_time | counter | job, ins, ip, instance, cls | Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in seconds |
| pg_bgwriter_checkpoints_req | counter | job, ins, ip, instance, cls | Number of requested checkpoints that have been performed |
| pg_bgwriter_checkpoints_timed | counter | job, ins, ip, instance, cls | Number of scheduled checkpoints that have been performed |
| pg_bgwriter_maxwritten_clean | counter | job, ins, ip, instance, cls | Number of times the background writer stopped a cleaning scan because it had written too many buffers |
| pg_bgwriter_reset_time | counter | job, ins, ip, instance, cls | Time at which bgwriter statistics were last reset |
| pg_boot_time | gauge | job, ins, ip, instance, cls | unix timestamp when postmaster boot |
| pg_checkpoint_checkpoint_lsn | counter | job, ins, ip, instance, cls | Latest checkpoint location |
| pg_checkpoint_elapse | gauge | job, ins, ip, instance, cls | Seconds elapsed since latest checkpoint in seconds |
| pg_checkpoint_full_page_writes | gauge | job, ins, ip, instance, cls | Latest checkpoint’s full_page_writes enabled |
| pg_checkpoint_newest_commit_ts_xid | counter | job, ins, ip, instance, cls | Latest checkpoint’s newestCommitTsXid |
| pg_checkpoint_next_multi_offset | counter | job, ins, ip, instance, cls | Latest checkpoint’s NextMultiOffset |
| pg_checkpoint_next_multixact_id | counter | job, ins, ip, instance, cls | Latest checkpoint’s NextMultiXactId |
| pg_checkpoint_next_oid | counter | job, ins, ip, instance, cls | Latest checkpoint’s NextOID |
| pg_checkpoint_next_xid | counter | job, ins, ip, instance, cls | Latest checkpoint’s NextXID xid |
| pg_checkpoint_next_xid_epoch | counter | job, ins, ip, instance, cls | Latest checkpoint’s NextXID epoch |
| pg_checkpoint_oldest_active_xid | counter | job, ins, ip, instance, cls | Latest checkpoint’s oldestActiveXID |
| pg_checkpoint_oldest_commit_ts_xid | counter | job, ins, ip, instance, cls | Latest checkpoint’s oldestCommitTsXid |
| pg_checkpoint_oldest_multi_dbid | gauge | job, ins, ip, instance, cls | Latest checkpoint’s oldestMulti’s DB OID |
| pg_checkpoint_oldest_multi_xid | counter | job, ins, ip, instance, cls | Latest checkpoint’s oldestMultiXid |
| pg_checkpoint_oldest_xid | counter | job, ins, ip, instance, cls | Latest checkpoint’s oldestXID |
| pg_checkpoint_oldest_xid_dbid | gauge | job, ins, ip, instance, cls | Latest checkpoint’s oldestXID’s DB OID |
| pg_checkpoint_prev_tli | counter | job, ins, ip, instance, cls | Latest checkpoint’s PrevTimeLineID |
| pg_checkpoint_redo_lsn | counter | job, ins, ip, instance, cls | Latest checkpoint’s REDO location |
| pg_checkpoint_time | counter | job, ins, ip, instance, cls | Time of latest checkpoint |
| pg_checkpoint_tli | counter | job, ins, ip, instance, cls | Latest checkpoint’s TimeLineID |
| pg_conf_reload_time | gauge | job, ins, ip, instance, cls | seconds since last configuration reload |
| pg_db_active_time | counter | datname, job, ins, ip, instance, cls | Time spent executing SQL statements in this database, in seconds |
| pg_db_age | gauge | datname, job, ins, ip, instance, cls | Age of database calculated from datfrozenxid |
| pg_db_allow_conn | gauge | datname, job, ins, ip, instance, cls | If false(0) then no one can connect to this database. |
| pg_db_blk_read_time | counter | datname, job, ins, ip, instance, cls | Time spent reading data file blocks by backends in this database, in seconds |
| pg_db_blk_write_time | counter | datname, job, ins, ip, instance, cls | Time spent writing data file blocks by backends in this database, in seconds |
| pg_db_blks_access | counter | datname, job, ins, ip, instance, cls | Number of times disk blocks that accessed read+hit |
| pg_db_blks_hit | counter | datname, job, ins, ip, instance, cls | Number of times disk blocks were found already in the buffer cache |
| pg_db_blks_read | counter | datname, job, ins, ip, instance, cls | Number of disk blocks read in this database |
| pg_db_cks_fail_time | gauge | datname, job, ins, ip, instance, cls | Time at which the last data page checksum failure was detected in this database |
| pg_db_cks_fails | counter | datname, job, ins, ip, instance, cls | Number of data page checksum failures detected in this database, -1 for not enabled |
| pg_db_confl_confl_bufferpin | counter | datname, job, ins, ip, instance, cls | Number of queries in this database that have been canceled due to pinned buffers |
| pg_db_confl_confl_deadlock | counter | datname, job, ins, ip, instance, cls | Number of queries in this database that have been canceled due to deadlocks |
| pg_db_confl_confl_lock | counter | datname, job, ins, ip, instance, cls | Number of queries in this database that have been canceled due to lock timeouts |
| pg_db_confl_confl_snapshot | counter | datname, job, ins, ip, instance, cls | Number of queries in this database that have been canceled due to old snapshots |
| pg_db_confl_confl_tablespace | counter | datname, job, ins, ip, instance, cls | Number of queries in this database that have been canceled due to dropped tablespaces |
| pg_db_conflicts | counter | datname, job, ins, ip, instance, cls | Number of queries canceled due to conflicts with recovery in this database |
| pg_db_conn_limit | gauge | datname, job, ins, ip, instance, cls | Sets maximum number of concurrent connections that can be made to this database. -1 means no limit. |
| pg_db_datid | gauge | datname, job, ins, ip, instance, cls | OID of the database |
| pg_db_deadlocks | counter | datname, job, ins, ip, instance, cls | Number of deadlocks detected in this database |
| pg_db_frozen_xid | gauge | datname, job, ins, ip, instance, cls | All transaction IDs before this one have been frozened |
| pg_db_is_template | gauge | datname, job, ins, ip, instance, cls | If true(1), then this database can be cloned by any user with CREATEDB privileges |
| pg_db_ixact_time | counter | datname, job, ins, ip, instance, cls | Time spent idling while in a transaction in this database, in seconds |
| pg_db_numbackends | gauge | datname, job, ins, ip, instance, cls | Number of backends currently connected to this database |
| pg_db_reset_time | counter | datname, job, ins, ip, instance, cls | Time at which database statistics were last reset |
| pg_db_session_time | counter | datname, job, ins, ip, instance, cls | Time spent by database sessions in this database, in seconds |
| pg_db_sessions | counter | datname, job, ins, ip, instance, cls | Total number of sessions established to this database |
| pg_db_sessions_abandoned | counter | datname, job, ins, ip, instance, cls | Number of database sessions to this database that were terminated because connection to the client was lost |
| pg_db_sessions_fatal | counter | datname, job, ins, ip, instance, cls | Number of database sessions to this database that were terminated by fatal errors |
| pg_db_sessions_killed | counter | datname, job, ins, ip, instance, cls | Number of database sessions to this database that were terminated by operator intervention |
| pg_db_temp_bytes | counter | datname, job, ins, ip, instance, cls | Total amount of data written to temporary files by queries in this database. |
| pg_db_temp_files | counter | datname, job, ins, ip, instance, cls | Number of temporary files created by queries in this database |
| pg_db_tup_deleted | counter | datname, job, ins, ip, instance, cls | Number of rows deleted by queries in this database |
| pg_db_tup_fetched | counter | datname, job, ins, ip, instance, cls | Number of rows fetched by queries in this database |
| pg_db_tup_inserted | counter | datname, job, ins, ip, instance, cls | Number of rows inserted by queries in this database |
| pg_db_tup_modified | counter | datname, job, ins, ip, instance, cls | Number of rows modified by queries in this database |
| pg_db_tup_returned | counter | datname, job, ins, ip, instance, cls | Number of rows returned by queries in this database |
| pg_db_tup_updated | counter | datname, job, ins, ip, instance, cls | Number of rows updated by queries in this database |
| pg_db_xact_commit | counter | datname, job, ins, ip, instance, cls | Number of transactions in this database that have been committed |
| pg_db_xact_rollback | counter | datname, job, ins, ip, instance, cls | Number of transactions in this database that have been rolled back |
| pg_db_xact_total | counter | datname, job, ins, ip, instance, cls | Number of transactions in this database |
| pg_downstream_count | gauge | state, job, ins, ip, instance, cls | Count of corresponding state |
| pg_exporter_agent_up | Unknown | job, ins, ip, instance, cls | N/A |
| pg_exporter_last_scrape_time | gauge | job, ins, ip, instance, cls | seconds exporter spending on scrapping |
| pg_exporter_query_cache_ttl | gauge | datname, query, job, ins, ip, instance, cls | times to live of query cache |
| pg_exporter_query_scrape_duration | gauge | datname, query, job, ins, ip, instance, cls | seconds query spending on scrapping |
| pg_exporter_query_scrape_error_count | gauge | datname, query, job, ins, ip, instance, cls | times the query failed |
| pg_exporter_query_scrape_hit_count | gauge | datname, query, job, ins, ip, instance, cls | numbers been scrapped from this query |
| pg_exporter_query_scrape_metric_count | gauge | datname, query, job, ins, ip, instance, cls | numbers of metrics been scrapped from this query |
| pg_exporter_query_scrape_total_count | gauge | datname, query, job, ins, ip, instance, cls | times exporter server was scraped for metrics |
| pg_exporter_scrape_duration | gauge | job, ins, ip, instance, cls | seconds exporter spending on scrapping |
| pg_exporter_scrape_error_count | counter | job, ins, ip, instance, cls | times exporter was scraped for metrics and failed |
| pg_exporter_scrape_total_count | counter | job, ins, ip, instance, cls | times exporter was scraped for metrics |
| pg_exporter_server_scrape_duration | gauge | datname, job, ins, ip, instance, cls | seconds exporter server spending on scrapping |
| pg_exporter_server_scrape_error_count | Unknown | datname, job, ins, ip, instance, cls | N/A |
| pg_exporter_server_scrape_total_count | gauge | datname, job, ins, ip, instance, cls | times exporter server was scraped for metrics |
| pg_exporter_server_scrape_total_seconds | gauge | datname, job, ins, ip, instance, cls | seconds exporter server spending on scrapping |
| pg_exporter_up | gauge | job, ins, ip, instance, cls | always be 1 if your could retrieve metrics |
| pg_exporter_uptime | gauge | job, ins, ip, instance, cls | seconds since exporter primary server inited |
| pg_flush_lsn | counter | job, ins, ip, instance, cls | primary only, location of current wal syncing |
| pg_func_calls | counter | datname, funcname, job, ins, ip, instance, cls | Number of times this function has been called |
| pg_func_self_time | counter | datname, funcname, job, ins, ip, instance, cls | Total time spent in this function itself, not including other functions called by it, in ms |
| pg_func_total_time | counter | datname, funcname, job, ins, ip, instance, cls | Total time spent in this function and all other functions called by it, in ms |
| pg_in_recovery | gauge | job, ins, ip, instance, cls | server is in recovery mode? 1 for yes 0 for no |
| pg_index_idx_blks_hit | counter | datname, relname, job, ins, relid, ip, instance, cls, idxname | Number of buffer hits in this index |
| pg_index_idx_blks_read | counter | datname, relname, job, ins, relid, ip, instance, cls, idxname | Number of disk blocks read from this index |
| pg_index_idx_scan | counter | datname, relname, job, ins, relid, ip, instance, cls, idxname | Number of index scans initiated on this index |
| pg_index_idx_tup_fetch | counter | datname, relname, job, ins, relid, ip, instance, cls, idxname | Number of live table rows fetched by simple index scans using this index |
| pg_index_idx_tup_read | counter | datname, relname, job, ins, relid, ip, instance, cls, idxname | Number of index entries returned by scans on this index |
| pg_index_relpages | gauge | datname, relname, job, ins, relid, ip, instance, cls, idxname | Size of the on-disk representation of this index in pages |
| pg_index_reltuples | gauge | datname, relname, job, ins, relid, ip, instance, cls, idxname | Estimate relation tuples |
| pg_insert_lsn | counter | job, ins, ip, instance, cls | primary only, location of current wal inserting |
| pg_io_evictions | counter | type, job, ins, object, ip, context, instance, cls | Number of times a block has been written out from a shared or local buffer |
| pg_io_extend_time | counter | type, job, ins, object, ip, context, instance, cls | Time spent in extend operations in seconds |
| pg_io_extends | counter | type, job, ins, object, ip, context, instance, cls | Number of relation extend operations, each of the size specified in op_bytes. |
| pg_io_fsync_time | counter | type, job, ins, object, ip, context, instance, cls | Time spent in fsync operations in seconds |
| pg_io_fsyncs | counter | type, job, ins, object, ip, context, instance, cls | Number of fsync calls. These are only tracked in context normal |
| pg_io_hits | counter | type, job, ins, object, ip, context, instance, cls | The number of times a desired block was found in a shared buffer. |
| pg_io_op_bytes | gauge | type, job, ins, object, ip, context, instance, cls | The number of bytes per unit of I/O read, written, or extended. 8192 by default |
| pg_io_read_time | counter | type, job, ins, object, ip, context, instance, cls | Time spent in read operations in seconds |
| pg_io_reads | counter | type, job, ins, object, ip, context, instance, cls | Number of read operations, each of the size specified in op_bytes. |
| pg_io_reset_time | gauge | type, job, ins, object, ip, context, instance, cls | Timestamp at which these statistics were last reset |
| pg_io_reuses | counter | type, job, ins, object, ip, context, instance, cls | The number of times an existing buffer in reused |
| pg_io_write_time | counter | type, job, ins, object, ip, context, instance, cls | Time spent in write operations in seconds |
| pg_io_writeback_time | counter | type, job, ins, object, ip, context, instance, cls | Time spent in writeback operations in seconds |
| pg_io_writebacks | counter | type, job, ins, object, ip, context, instance, cls | Number of units of size op_bytes which the process requested the kernel write out to permanent storage. |
| pg_io_writes | counter | type, job, ins, object, ip, context, instance, cls | Number of write operations, each of the size specified in op_bytes. |
| pg_is_in_recovery | gauge | job, ins, ip, instance, cls | 1 if in recovery mode |
| pg_is_wal_replay_paused | gauge | job, ins, ip, instance, cls | 1 if wal play paused |
| pg_lag | gauge | job, ins, ip, instance, cls | replica only, replication lag in seconds |
| pg_last_replay_time | gauge | job, ins, ip, instance, cls | time when last transaction been replayed |
| pg_lock_count | gauge | datname, job, ins, ip, mode, instance, cls | Number of locks of corresponding mode and database |
| pg_lsn | counter | job, ins, ip, instance, cls | log sequence number, current write location |
| pg_meta_info | gauge | cls, extensions, version, job, ins, primary_conninfo, conf_path, hba_path, ip, cluster_id, instance, listen_port, wal_level, ver_num, cluster_name, data_dir | constant 1 |
| pg_query_calls | counter | datname, query, job, ins, ip, instance, cls | Number of times the statement was executed |
| pg_query_exec_time | counter | datname, query, job, ins, ip, instance, cls | Total time spent executing the statement, in seconds |
| pg_query_io_time | counter | datname, query, job, ins, ip, instance, cls | Total time the statement spent reading and writing blocks, in seconds |
| pg_query_rows | counter | datname, query, job, ins, ip, instance, cls | Total number of rows retrieved or affected by the statement |
| pg_query_sblk_dirtied | counter | datname, query, job, ins, ip, instance, cls | Total number of shared blocks dirtied by the statement |
| pg_query_sblk_hit | counter | datname, query, job, ins, ip, instance, cls | Total number of shared block cache hits by the statement |
| pg_query_sblk_read | counter | datname, query, job, ins, ip, instance, cls | Total number of shared blocks read by the statement |
| pg_query_sblk_written | counter | datname, query, job, ins, ip, instance, cls | Total number of shared blocks written by the statement |
| pg_query_wal_bytes | counter | datname, query, job, ins, ip, instance, cls | Total amount of WAL bytes generated by the statement |
| pg_receive_lsn | counter | job, ins, ip, instance, cls | replica only, location of wal synced to disk |
| pg_recovery_backup_end_lsn | counter | job, ins, ip, instance, cls | Backup end location |
| pg_recovery_backup_start_lsn | counter | job, ins, ip, instance, cls | Backup start location |
| pg_recovery_min_lsn | counter | job, ins, ip, instance, cls | Minimum recovery ending location |
| pg_recovery_min_timeline | counter | job, ins, ip, instance, cls | Min recovery ending loc’s timeline |
| pg_recovery_prefetch_block_distance | gauge | job, ins, ip, instance, cls | How many blocks ahead the prefetcher is looking |
| pg_recovery_prefetch_hit | counter | job, ins, ip, instance, cls | Number of blocks not prefetched because they were already in the buffer pool |
| pg_recovery_prefetch_io_depth | gauge | job, ins, ip, instance, cls | How many prefetches have been initiated but are not yet known to have completed |
| pg_recovery_prefetch_prefetch | counter | job, ins, ip, instance, cls | Number of blocks prefetched because they were not in the buffer pool |
| pg_recovery_prefetch_reset_time | counter | job, ins, ip, instance, cls | Time at which these recovery prefetch statistics were last reset |
| pg_recovery_prefetch_skip_fpw | gauge | job, ins, ip, instance, cls | Number of blocks not prefetched because a full page image was included in the WAL |
| pg_recovery_prefetch_skip_init | counter | job, ins, ip, instance, cls | Number of blocks not prefetched because they would be zero-initialized |
| pg_recovery_prefetch_skip_new | counter | job, ins, ip, instance, cls | Number of blocks not prefetched because they didn’t exist yet |
| pg_recovery_prefetch_skip_rep | counter | job, ins, ip, instance, cls | Number of blocks not prefetched because they were already recently prefetched |
| pg_recovery_prefetch_wal_distance | gauge | job, ins, ip, instance, cls | How many bytes ahead the prefetcher is looking |
| pg_recovery_require_record | gauge | job, ins, ip, instance, cls | End-of-backup record required |
| pg_recv_flush_lsn | counter | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | Last write-ahead log location already received and flushed to disk |
| pg_recv_flush_tli | counter | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | Timeline number of last write-ahead log location received and flushed to disk |
| pg_recv_init_lsn | counter | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | First write-ahead log location used when WAL receiver is started |
| pg_recv_init_tli | counter | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | First timeline number used when WAL receiver is started |
| pg_recv_msg_recv_time | gauge | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | Receipt time of last message received from origin WAL sender |
| pg_recv_msg_send_time | gauge | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | Send time of last message received from origin WAL sender |
| pg_recv_pid | gauge | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | Process ID of the WAL receiver process |
| pg_recv_reported_lsn | counter | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | Last write-ahead log location reported to origin WAL sender |
| pg_recv_reported_time | gauge | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | Time of last write-ahead log location reported to origin WAL sender |
| pg_recv_time | gauge | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | Time of current snapshot |
| pg_recv_write_lsn | counter | state, slot_name, job, ins, ip, instance, cls, sender_host, sender_port | Last write-ahead log location already received and written to disk, but not flushed. |
| pg_relkind_count | gauge | datname, job, ins, ip, instance, cls, relkind | Number of relations of corresponding relkind |
| pg_repl_backend_xmin | counter | pid, usename, address, job, ins, appname, ip, instance, cls | This standby’s xmin horizon reported by hot_standby_feedback. |
| pg_repl_client_port | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | TCP port number that the client is using for communication with this WAL sender, or -1 if a Unix socket is used |
| pg_repl_flush_diff | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Last log position flushed to disk by this standby server diff with current lsn |
| pg_repl_flush_lag | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Time elapsed between flushing recent WAL locally and receiving notification that this standby server has written and flushed it |
| pg_repl_flush_lsn | counter | pid, usename, address, job, ins, appname, ip, instance, cls | Last write-ahead log location flushed to disk by this standby server |
| pg_repl_launch_time | counter | pid, usename, address, job, ins, appname, ip, instance, cls | Time when this process was started, i.e., when the client connected to this WAL sender |
| pg_repl_lsn | counter | pid, usename, address, job, ins, appname, ip, instance, cls | Current log position on this server |
| pg_repl_replay_diff | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Last log position replayed into the database on this standby server diff with current lsn |
| pg_repl_replay_lag | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Time elapsed between flushing recent WAL locally and receiving notification that this standby server has written, flushed and applied it |
| pg_repl_replay_lsn | counter | pid, usename, address, job, ins, appname, ip, instance, cls | Last write-ahead log location replayed into the database on this standby server |
| pg_repl_reply_time | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Send time of last reply message received from standby server |
| pg_repl_sent_diff | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Last log position sent to this standby server diff with current lsn |
| pg_repl_sent_lsn | counter | pid, usename, address, job, ins, appname, ip, instance, cls | Last write-ahead log location sent on this connection |
| pg_repl_state | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Current WAL sender encoded state 0-4 for streaming startup catchup backup stopping |
| pg_repl_sync_priority | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Priority of this standby server for being chosen as the synchronous standby |
| pg_repl_sync_state | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Encoded synchronous state of this standby server, 0-3 for async potential sync quorum |
| pg_repl_time | counter | pid, usename, address, job, ins, appname, ip, instance, cls | Current timestamp in unix epoch |
| pg_repl_write_diff | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Last log position written to disk by this standby server diff with current lsn |
| pg_repl_write_lag | gauge | pid, usename, address, job, ins, appname, ip, instance, cls | Time elapsed between flushing recent WAL locally and receiving notification that this standby server has written it |
| pg_repl_write_lsn | counter | pid, usename, address, job, ins, appname, ip, instance, cls | Last write-ahead log location written to disk by this standby server |
| pg_replay_lsn | counter | job, ins, ip, instance, cls | replica only, location of wal applied |
| pg_seq_blks_hit | counter | datname, job, ins, ip, instance, cls, seqname | Number of buffer hits in this sequence |
| pg_seq_blks_read | counter | datname, job, ins, ip, instance, cls, seqname | Number of disk blocks read from this sequence |
| pg_seq_last_value | counter | datname, job, ins, ip, instance, cls, seqname | The last sequence value written to disk |
| pg_setting_block_size | gauge | job, ins, ip, instance, cls | pg page block size, 8192 by default |
| pg_setting_data_checksums | gauge | job, ins, ip, instance, cls | whether data checksum is enabled, 1 enabled 0 disabled |
| pg_setting_max_connections | gauge | job, ins, ip, instance, cls | number of concurrent connections to the database server |
| pg_setting_max_locks_per_transaction | gauge | job, ins, ip, instance, cls | no more than this many distinct objects can be locked at any one time |
| pg_setting_max_prepared_transactions | gauge | job, ins, ip, instance, cls | maximum number of transactions that can be in the prepared state simultaneously |
| pg_setting_max_replication_slots | gauge | job, ins, ip, instance, cls | maximum number of replication slots |
| pg_setting_max_wal_senders | gauge | job, ins, ip, instance, cls | maximum number of concurrent connections from standby servers |
| pg_setting_max_worker_processes | gauge | job, ins, ip, instance, cls | maximum number of background processes that the system can support |
| pg_setting_wal_log_hints | gauge | job, ins, ip, instance, cls | whether wal_log_hints is enabled, 1 enabled 0 disabled |
| pg_size_bytes | gauge | datname, job, ins, ip, instance, cls | File size in bytes |
| pg_slot_active | gauge | slot_name, job, ins, ip, instance, cls | True(1) if this slot is currently actively being used |
| pg_slot_catalog_xmin | counter | slot_name, job, ins, ip, instance, cls | The oldest transaction affecting the system catalogs that this slot needs the database to retain. |
| pg_slot_confirm_lsn | counter | slot_name, job, ins, ip, instance, cls | The address (LSN) up to which the logical slot’s consumer has confirmed receiving data. |
| pg_slot_reset_time | counter | slot_name, job, ins, ip, instance, cls | When statistics were last reset |
| pg_slot_restart_lsn | counter | slot_name, job, ins, ip, instance, cls | The address (LSN) of oldest WAL which still might be required by the consumer of this slot |
| pg_slot_retained_bytes | gauge | slot_name, job, ins, ip, instance, cls | Size of bytes that retained for this slot |
| pg_slot_safe_wal_size | gauge | slot_name, job, ins, ip, instance, cls | bytes that can be written to WAL which will not make slot into lost |
| pg_slot_spill_bytes | counter | slot_name, job, ins, ip, instance, cls | Bytes that spilled to disk due to logical decode mem exceeding |
| pg_slot_spill_count | counter | slot_name, job, ins, ip, instance, cls | Xacts that spilled to disk due to logical decode mem exceeding (a xact can be spilled multiple times) |
| pg_slot_spill_txns | counter | slot_name, job, ins, ip, instance, cls | Xacts that spilled to disk due to logical decode mem exceeding (subtrans included) |
| pg_slot_stream_bytes | counter | slot_name, job, ins, ip, instance, cls | Bytes that streamed to decoding output plugin after mem exceed |
| pg_slot_stream_count | counter | slot_name, job, ins, ip, instance, cls | Xacts that streamed to decoding output plugin after mem exceed (a xact can be streamed multiple times) |
| pg_slot_stream_txns | counter | slot_name, job, ins, ip, instance, cls | Xacts that streamed to decoding output plugin after mem exceed |
| pg_slot_temporary | gauge | slot_name, job, ins, ip, instance, cls | True(1) if this is a temporary replication slot. |
| pg_slot_total_bytes | counter | slot_name, job, ins, ip, instance, cls | Number of decoded bytes sent to the decoding output plugin for this slot |
| pg_slot_total_txns | counter | slot_name, job, ins, ip, instance, cls | Number of decoded xacts sent to the decoding output plugin for this slot |
| pg_slot_wal_status | gauge | slot_name, job, ins, ip, instance, cls | WAL reserve status 0-3 means reserved,extended,unreserved,lost, -1 means other |
| pg_slot_xmin | counter | slot_name, job, ins, ip, instance, cls | The oldest transaction that this slot needs the database to retain. |
| pg_slru_blks_exists | counter | job, ins, ip, instance, cls | Number of blocks checked for existence for this SLRU |
| pg_slru_blks_hit | counter | job, ins, ip, instance, cls | Number of times disk blocks were found already in the SLRU, so that a read was not necessary |
| pg_slru_blks_read | counter | job, ins, ip, instance, cls | Number of disk blocks read for this SLRU |
| pg_slru_blks_written | counter | job, ins, ip, instance, cls | Number of disk blocks written for this SLRU |
| pg_slru_blks_zeroed | counter | job, ins, ip, instance, cls | Number of blocks zeroed during initializations |
| pg_slru_flushes | counter | job, ins, ip, instance, cls | Number of flushes of dirty data for this SLRU |
| pg_slru_reset_time | counter | job, ins, ip, instance, cls | Time at which these statistics were last reset |
| pg_slru_truncates | counter | job, ins, ip, instance, cls | Number of truncates for this SLRU |
| pg_ssl_disabled | gauge | job, ins, ip, instance, cls | Number of client connection that does not use ssl |
| pg_ssl_enabled | gauge | job, ins, ip, instance, cls | Number of client connection that use ssl |
| pg_sync_standby_enabled | gauge | job, ins, ip, names, instance, cls | Synchronous commit enabled, 1 if enabled, 0 if disabled |
| pg_table_age | gauge | datname, relname, job, ins, ip, instance, cls | Age of this table in vacuum cycles |
| pg_table_analyze_count | counter | datname, relname, job, ins, ip, instance, cls | Number of times this table has been manually analyzed |
| pg_table_autoanalyze_count | counter | datname, relname, job, ins, ip, instance, cls | Number of times this table has been analyzed by the autovacuum daemon |
| pg_table_autovacuum_count | counter | datname, relname, job, ins, ip, instance, cls | Number of times this table has been vacuumed by the autovacuum daemon |
| pg_table_frozenxid | counter | datname, relname, job, ins, ip, instance, cls | All txid before this have been frozen on this table |
| pg_table_heap_blks_hit | counter | datname, relname, job, ins, ip, instance, cls | Number of buffer hits in this table |
| pg_table_heap_blks_read | counter | datname, relname, job, ins, ip, instance, cls | Number of disk blocks read from this table |
| pg_table_idx_blks_hit | counter | datname, relname, job, ins, ip, instance, cls | Number of buffer hits in all indexes on this table |
| pg_table_idx_blks_read | counter | datname, relname, job, ins, ip, instance, cls | Number of disk blocks read from all indexes on this table |
| pg_table_idx_scan | counter | datname, relname, job, ins, ip, instance, cls | Number of index scans initiated on this table |
| pg_table_idx_tup_fetch | counter | datname, relname, job, ins, ip, instance, cls | Number of live rows fetched by index scans |
| pg_table_kind | gauge | datname, relname, job, ins, ip, instance, cls | Relation kind r/table/114 |
| pg_table_n_dead_tup | gauge | datname, relname, job, ins, ip, instance, cls | Estimated number of dead rows |
| pg_table_n_ins_since_vacuum | gauge | datname, relname, job, ins, ip, instance, cls | Estimated number of rows inserted since this table was last vacuumed |
| pg_table_n_live_tup | gauge | datname, relname, job, ins, ip, instance, cls | Estimated number of live rows |
| pg_table_n_mod_since_analyze | gauge | datname, relname, job, ins, ip, instance, cls | Estimated number of rows modified since this table was last analyzed |
| pg_table_n_tup_del | counter | datname, relname, job, ins, ip, instance, cls | Number of rows deleted |
| pg_table_n_tup_hot_upd | counter | datname, relname, job, ins, ip, instance, cls | Number of rows HOT updated (i.e with no separate index update required) |
| pg_table_n_tup_ins | counter | datname, relname, job, ins, ip, instance, cls | Number of rows inserted |
| pg_table_n_tup_mod | counter | datname, relname, job, ins, ip, instance, cls | Number of rows modified (insert + update + delete) |
| pg_table_n_tup_newpage_upd | counter | datname, relname, job, ins, ip, instance, cls | Number of rows updated where the successor version goes onto a new heap page |
| pg_table_n_tup_upd | counter | datname, relname, job, ins, ip, instance, cls | Number of rows updated (includes HOT updated rows) |
| pg_table_ncols | gauge | datname, relname, job, ins, ip, instance, cls | Number of columns in the table |
| pg_table_pages | gauge | datname, relname, job, ins, ip, instance, cls | Size of the on-disk representation of this table in pages |
| pg_table_relid | gauge | datname, relname, job, ins, ip, instance, cls | Relation oid of this table |
| pg_table_seq_scan | counter | datname, relname, job, ins, ip, instance, cls | Number of sequential scans initiated on this table |
| pg_table_seq_tup_read | counter | datname, relname, job, ins, ip, instance, cls | Number of live rows fetched by sequential scans |
| pg_table_size_bytes | gauge | datname, relname, job, ins, ip, instance, cls | Total bytes of this table (including toast, index, toast index) |
| pg_table_size_indexsize | gauge | datname, relname, job, ins, ip, instance, cls | Bytes of all related indexes of this table |
| pg_table_size_relsize | gauge | datname, relname, job, ins, ip, instance, cls | Bytes of this table itself (main, vm, fsm) |
| pg_table_size_toastsize | gauge | datname, relname, job, ins, ip, instance, cls | Bytes of toast tables of this table |
| pg_table_tbl_scan | counter | datname, relname, job, ins, ip, instance, cls | Number of scans initiated on this table |
| pg_table_tup_read | counter | datname, relname, job, ins, ip, instance, cls | Number of live rows fetched by scans |
| pg_table_tuples | counter | datname, relname, job, ins, ip, instance, cls | All txid before this have been frozen on this table |
| pg_table_vacuum_count | counter | datname, relname, job, ins, ip, instance, cls | Number of times this table has been manually vacuumed (not counting VACUUM FULL) |
| pg_timestamp | gauge | job, ins, ip, instance, cls | database current timestamp |
| pg_up | gauge | job, ins, ip, instance, cls | last scrape was able to connect to the server: 1 for yes, 0 for no |
| pg_uptime | gauge | job, ins, ip, instance, cls | seconds since postmaster start |
| pg_version | gauge | job, ins, ip, instance, cls | server version number |
| pg_wait_count | gauge | datname, job, ins, event, ip, instance, cls | Count of WaitEvent on target database |
| pg_wal_buffers_full | counter | job, ins, ip, instance, cls | Number of times WAL data was written to disk because WAL buffers became full |
| pg_wal_bytes | counter | job, ins, ip, instance, cls | Total amount of WAL generated in bytes |
| pg_wal_fpi | counter | job, ins, ip, instance, cls | Total number of WAL full page images generated |
| pg_wal_records | counter | job, ins, ip, instance, cls | Total number of WAL records generated |
| pg_wal_reset_time | counter | job, ins, ip, instance, cls | When statistics were last reset |
| pg_wal_sync | counter | job, ins, ip, instance, cls | Number of times WAL files were synced to disk via issue_xlog_fsync request |
| pg_wal_sync_time | counter | job, ins, ip, instance, cls | Total amount of time spent syncing WAL files to disk via issue_xlog_fsync request, in seconds |
| pg_wal_write | counter | job, ins, ip, instance, cls | Number of times WAL buffers were written out to disk via XLogWrite request. |
| pg_wal_write_time | counter | job, ins, ip, instance, cls | Total amount of time spent writing WAL buffers to disk via XLogWrite request in seconds |
| pg_write_lsn | counter | job, ins, ip, instance, cls | primary only, location of current wal writing |
| pg_xact_xmax | counter | job, ins, ip, instance, cls | First as-yet-unassigned txid. txid >= this are invisible. |
| pg_xact_xmin | counter | job, ins, ip, instance, cls | Earliest txid that is still active |
| pg_xact_xnum | gauge | job, ins, ip, instance, cls | Current active transaction count |
| pgbouncer:cls:load1 | Unknown | job, cls | N/A |
| pgbouncer:cls:load15 | Unknown | job, cls | N/A |
| pgbouncer:cls:load5 | Unknown | job, cls | N/A |
| pgbouncer:db:conn_usage | Unknown | datname, job, ins, ip, instance, host, cls, real_datname, port | N/A |
| pgbouncer:db:conn_usage_reserve | Unknown | datname, job, ins, ip, instance, host, cls, real_datname, port | N/A |
| pgbouncer:db:pool_current_conn | Unknown | datname, job, ins, ip, instance, host, cls, real_datname, port | N/A |
| pgbouncer:db:pool_disabled | Unknown | datname, job, ins, ip, instance, host, cls, real_datname, port | N/A |
| pgbouncer:db:pool_max_conn | Unknown | datname, job, ins, ip, instance, host, cls, real_datname, port | N/A |
| pgbouncer:db:pool_paused | Unknown | datname, job, ins, ip, instance, host, cls, real_datname, port | N/A |
| pgbouncer:db:pool_reserve_size | Unknown | datname, job, ins, ip, instance, host, cls, real_datname, port | N/A |
| pgbouncer:db:pool_size | Unknown | datname, job, ins, ip, instance, host, cls, real_datname, port | N/A |
| pgbouncer:ins:free_clients | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer:ins:free_servers | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer:ins:load1 | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer:ins:load15 | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer:ins:load5 | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer:ins:login_clients | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer:ins:pool_databases | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer:ins:pool_users | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer:ins:pools | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer:ins:used_clients | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer_database_current_connections | gauge | datname, job, ins, ip, instance, host, cls, real_datname, port | Current number of connections for this database |
| pgbouncer_database_disabled | gauge | datname, job, ins, ip, instance, host, cls, real_datname, port | True(1) if this database is currently disabled, else 0 |
| pgbouncer_database_max_connections | gauge | datname, job, ins, ip, instance, host, cls, real_datname, port | Maximum number of allowed connections for this database |
| pgbouncer_database_min_pool_size | gauge | datname, job, ins, ip, instance, host, cls, real_datname, port | Minimum number of server connections |
| pgbouncer_database_paused | gauge | datname, job, ins, ip, instance, host, cls, real_datname, port | True(1) if this database is currently paused, else 0 |
| pgbouncer_database_pool_size | gauge | datname, job, ins, ip, instance, host, cls, real_datname, port | Maximum number of server connections |
| pgbouncer_database_reserve_pool | gauge | datname, job, ins, ip, instance, host, cls, real_datname, port | Maximum number of additional connections for this database |
| pgbouncer_exporter_agent_up | Unknown | job, ins, ip, instance, cls | N/A |
| pgbouncer_exporter_last_scrape_time | gauge | job, ins, ip, instance, cls | seconds exporter spending on scrapping |
| pgbouncer_exporter_query_cache_ttl | gauge | datname, query, job, ins, ip, instance, cls | times to live of query cache |
| pgbouncer_exporter_query_scrape_duration | gauge | datname, query, job, ins, ip, instance, cls | seconds query spending on scrapping |
| pgbouncer_exporter_query_scrape_error_count | gauge | datname, query, job, ins, ip, instance, cls | times the query failed |
| pgbouncer_exporter_query_scrape_hit_count | gauge | datname, query, job, ins, ip, instance, cls | numbers been scrapped from this query |
| pgbouncer_exporter_query_scrape_metric_count | gauge | datname, query, job, ins, ip, instance, cls | numbers of metrics been scrapped from this query |
| pgbouncer_exporter_query_scrape_total_count | gauge | datname, query, job, ins, ip, instance, cls | times exporter server was scraped for metrics |
| pgbouncer_exporter_scrape_duration | gauge | job, ins, ip, instance, cls | seconds exporter spending on scrapping |
| pgbouncer_exporter_scrape_error_count | counter | job, ins, ip, instance, cls | times exporter was scraped for metrics and failed |
| pgbouncer_exporter_scrape_total_count | counter | job, ins, ip, instance, cls | times exporter was scraped for metrics |
| pgbouncer_exporter_server_scrape_duration | gauge | datname, job, ins, ip, instance, cls | seconds exporter server spending on scrapping |
| pgbouncer_exporter_server_scrape_total_count | gauge | datname, job, ins, ip, instance, cls | times exporter server was scraped for metrics |
| pgbouncer_exporter_server_scrape_total_seconds | gauge | datname, job, ins, ip, instance, cls | seconds exporter server spending on scrapping |
| pgbouncer_exporter_up | gauge | job, ins, ip, instance, cls | always be 1 if your could retrieve metrics |
| pgbouncer_exporter_uptime | gauge | job, ins, ip, instance, cls | seconds since exporter primary server inited |
| pgbouncer_in_recovery | gauge | job, ins, ip, instance, cls | server is in recovery mode? 1 for yes 0 for no |
| pgbouncer_list_items | gauge | job, ins, ip, instance, list, cls | Number of corresponding pgbouncer object |
| pgbouncer_pool_active_cancel_clients | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Client connections that have forwarded query cancellations to the server and are waiting for the server response. |
| pgbouncer_pool_active_cancel_servers | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Server connections that are currently forwarding a cancel request |
| pgbouncer_pool_active_clients | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Client connections that are linked to server connection and can process queries |
| pgbouncer_pool_active_servers | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Server connections that are linked to a client |
| pgbouncer_pool_cancel_clients | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Client connections that have not forwarded query cancellations to the server yet. |
| pgbouncer_pool_cancel_servers | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | cancel requests have completed that were sent to cancel a query on this server |
| pgbouncer_pool_idle_servers | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Server connections that are unused and immediately usable for client queries |
| pgbouncer_pool_login_servers | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Server connections currently in the process of logging in |
| pgbouncer_pool_maxwait | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | How long the first(oldest) client in the queue has waited, in seconds, key metric |
| pgbouncer_pool_maxwait_us | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Microsecond part of the maximum waiting time. |
| pgbouncer_pool_tested_servers | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Server connections that are currently running reset or check query |
| pgbouncer_pool_used_servers | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Server connections that have been idle for more than server_check_delay (means have to run check query) |
| pgbouncer_pool_waiting_clients | gauge | datname, job, ins, ip, instance, user, cls, pool_mode | Client connections that have sent queries but have not yet got a server connection |
| pgbouncer_stat_avg_query_count | gauge | datname, job, ins, ip, instance, cls | Average queries per second in last stat period |
| pgbouncer_stat_avg_query_time | gauge | datname, job, ins, ip, instance, cls | Average query duration, in seconds |
| pgbouncer_stat_avg_recv | gauge | datname, job, ins, ip, instance, cls | Average received (from clients) bytes per second |
| pgbouncer_stat_avg_sent | gauge | datname, job, ins, ip, instance, cls | Average sent (to clients) bytes per second |
| pgbouncer_stat_avg_wait_time | gauge | datname, job, ins, ip, instance, cls | Time spent by clients waiting for a server, in seconds (average per second). |
| pgbouncer_stat_avg_xact_count | gauge | datname, job, ins, ip, instance, cls | Average transactions per second in last stat period |
| pgbouncer_stat_avg_xact_time | gauge | datname, job, ins, ip, instance, cls | Average transaction duration, in seconds |
| pgbouncer_stat_total_query_count | gauge | datname, job, ins, ip, instance, cls | Total number of SQL queries pooled by pgbouncer |
| pgbouncer_stat_total_query_time | counter | datname, job, ins, ip, instance, cls | Total number of seconds spent when executing queries |
| pgbouncer_stat_total_received | counter | datname, job, ins, ip, instance, cls | Total volume in bytes of network traffic received by pgbouncer |
| pgbouncer_stat_total_sent | counter | datname, job, ins, ip, instance, cls | Total volume in bytes of network traffic sent by pgbouncer |
| pgbouncer_stat_total_wait_time | counter | datname, job, ins, ip, instance, cls | Time spent by clients waiting for a server, in seconds |
| pgbouncer_stat_total_xact_count | gauge | datname, job, ins, ip, instance, cls | Total number of SQL transactions pooled by pgbouncer |
| pgbouncer_stat_total_xact_time | counter | datname, job, ins, ip, instance, cls | Total number of seconds spent when in a transaction |
| pgbouncer_up | gauge | job, ins, ip, instance, cls | last scrape was able to connect to the server: 1 for yes, 0 for no |
| pgbouncer_version | gauge | job, ins, ip, instance, cls | server version number |
| process_cpu_seconds_total | counter | job, ins, ip, instance, cls | Total user and system CPU time spent in seconds. |
| process_max_fds | gauge | job, ins, ip, instance, cls | Maximum number of open file descriptors. |
| process_open_fds | gauge | job, ins, ip, instance, cls | Number of open file descriptors. |
| process_resident_memory_bytes | gauge | job, ins, ip, instance, cls | Resident memory size in bytes. |
| process_start_time_seconds | gauge | job, ins, ip, instance, cls | Start time of the process since unix epoch in seconds. |
| process_virtual_memory_bytes | gauge | job, ins, ip, instance, cls | Virtual memory size in bytes. |
| process_virtual_memory_max_bytes | gauge | job, ins, ip, instance, cls | Maximum amount of virtual memory available in bytes. |
| promhttp_metric_handler_requests_in_flight | gauge | job, ins, ip, instance, cls | Current number of scrapes being served. |
| promhttp_metric_handler_requests_total | counter | code, job, ins, ip, instance, cls | Total number of scrapes by HTTP status code. |
| scrape_duration_seconds | Unknown | job, ins, ip, instance, cls | N/A |
| scrape_samples_post_metric_relabeling | Unknown | job, ins, ip, instance, cls | N/A |
| scrape_samples_scraped | Unknown | job, ins, ip, instance, cls | N/A |
| scrape_series_added | Unknown | job, ins, ip, instance, cls | N/A |
| up | Unknown | job, ins, ip, instance, cls | N/A |