Configuration Metrics News About

Metrics

Core

The core metrics available to the "pg_monitor" user.

General

• pgexporter_state
• pgexporter_version
• pgexporter_postgresql_active (server)
• pgexporter_postgresql_version (server)
• pgexporter_postgresql_uptime (server)
• pgexporter_postgresql_primary (server)

pg_database

• pgexporter_pg_database_size (server, database)

pg_locks

• pgexporter_pg_locks_count (server, database, mode)

pg_replication_slots

• pgexporter_pg_replication_slots_active (server, slot)

pg_stat_bgwriter

• pgexporter_pg_stat_bgwriter_buffers_alloc (server)
• pgexporter_pg_stat_bgwriter_buffers_backend (server)
• pgexporter_pg_stat_bgwriter_buffers_backend_fsync (server)
• pgexporter_pg_stat_bgwriter_buffers_checkpoint (server)
• pgexporter_pg_stat_bgwriter_buffers_clean (server)
• pgexporter_pg_stat_bgwriter_checkpoint_sync_time (server)
• pgexporter_pg_stat_bgwriter_checkpoint_write_time (server)
• pgexporter_pg_stat_bgwriter_checkpoints_req (server)
• pgexporter_pg_stat_bgwriter_checkpoints_timed (server)
• pgexporter_pg_stat_bgwriter_maxwritten_clean (server)

pg_stat_database

• pgexporter_pg_stat_database_blk_read_time (server, database)
• pgexporter_pg_stat_database_blk_write_time (server, database)
• pgexporter_pg_stat_database_blks_hit (server, database)
• pgexporter_pg_stat_database_blks_read (server, database)
• pgexporter_pg_stat_database_checksum_failures (server, database)
• pgexporter_pg_stat_database_deadlocks (server, database)
• pgexporter_pg_stat_database_temp_files (server, database)
• pgexporter_pg_stat_database_temp_bytes (server, database)
• pgexporter_pg_stat_database_tup_returned (server, database)
• pgexporter_pg_stat_database_tup_fetched (server, database)
• pgexporter_pg_stat_database_tup_inserted (server, database)
• pgexporter_pg_stat_database_tup_updated (server, database)
• pgexporter_pg_stat_database_tup_deleted (server, database)
• pgexporter_pg_stat_database_xact_commit (server, database)
• pgexporter_pg_stat_database_xact_rollback (server, database)
• pgexporter_pg_stat_database_conflicts (server, database)
• pgexporter_pg_stat_database_numbackends (server, database)

pg_stat_database_conflicts

• pgexporter_pg_stat_database_conflicts_confl_tablespace (server, database)
• pgexporter_pg_stat_database_conflicts_confl_lock (server, database)
• pgexporter_pg_stat_database_conflicts_confl_snapshot (server, database)
• pgexporter_pg_stat_database_conflicts_confl_bufferpin (server, database)
• pgexporter_pg_stat_database_conflicts_confl_deadlock (server, database)

pg_settings

• All settings available (server)

Extended

The extended metrics requires the pgexporter_ext extension.

• pgexporter_version_ext (server)

• pgexporter_os_info (server)
• pgexporter_cpu_info (server)
• pgexporter_memory_info (server)
• pgexporter_network_info (server)
• pgexporter_load_avg (server)

• pgexporter_used_disk_space_data (server)
• pgexporter_free_disk_space_data (server)
• pgexporter_total_disk_space_data (server)
• pgexporter_used_disk_space_wal (server)
• pgexporter_free_disk_space_wal (server)
• pgexporter_total_disk_space_wal (server)

Custom metrics

You can define your own custom metrics by using the

metrics_path

configuration setting, or using the

-Y

command line argument to point to a YAML file.

The General metrics will always be included.