Contact UsGet started
© 2025 Direct Cursus Technology L.L.C.

Yandex Monitoring metric reference

Written by
Updated at December 2, 2025

This section describes the Managed Service for PostgreSQL metrics delivered to Monitoring.

The name label contains the metric name.

Labels shared by all Managed Service for PostgreSQL metrics:

Label Value
dc Availability zone
host Host FQDN
node Host type: primary, replica, or Unknown
resource_id Cluster ID
resource_type Resource type: cluster
service Service ID: managed-postgresql
shard Shard ID
subcluster_name Subcluster name

CPU metrics

These metrics show CPU core workload.

The consumption type goes into the systag label.

Name
Type, units		 Description
cpu.guest
DGAUGE, %		 CPU core usage, guest usage type
cpu.idle
DGAUGE, %		 CPU core usage, idle usage type
cpu.iowait
DGAUGE, %		 CPU core usage, iowait usage type
cpu.irq
DGAUGE, %		 CPU core usage, irq usage type
cpu.nice
DGAUGE, %		 CPU core usage, nice usage type
cpu.softirq
DGAUGE, %		 CPU core usage, softirq usage type
cpu.steal
DGAUGE, %		 CPU core usage, steal usage type
cpu.system
DGAUGE, %		 CPU core usage, system usage type
cpu.user
DGAUGE, %		 CPU core usage, user usage type
load.avg_15min
DGAUGE, %		 Average load over 15 minutes
load.avg_1min
DGAUGE, %		 Average load over one minute
load.avg_5min
DGAUGE, %		 Average load over five minutes
n_cpus
DGAUGE, count		 Maximum number of cores in use
pg_backend_cpu
DGAUGE, %		 PostgreSQL process CPU utilization.
Special labels:
  • backend_type: Backend type
  • database: Database name
  • user: Username

Disk metrics

Name
Type, units		 Description
disk.free_bytes
DGAUGE, bytes		 Free space
disk.free_inodes
DGAUGE, count		 Free inodes
disk.temp_files_size
DGAUGE, bytes		 Size of temporary files
disk.total_bytes
DGAUGE, bytes		 Available space
disk.total_inodes
DGAUGE, count		 Available inodes
disk.used_bytes
DGAUGE, bytes		 Used space
disk.used_inodes
DGAUGE, count		 Used inodes
disk.wal_size
DGAUGE, bytes		 Write-ahead log (WAL) size
pg_backend_read_bytes
DGAUGE, bytes per second		 PostgreSQL process data read rate.
Special labels:
  • backend_type: Backend type
  • database: Database name
  • user: Username
pg_backend_write_bytes
DGAUGE, bytes per second		 PostgreSQL process data write rate.
Special labels:
  • backend_type: Backend type
  • database: Database name
  • user: Username

Disk operation metrics

Name
Type, units		 Description
io.avg_read_time
DGAUGE, milliseconds		 Average disk read time
io.avg_write_time
DGAUGE, milliseconds		 Average disk write time
io.disk*.avg_read_time
DGAUGE, milliseconds		 Average read time for a given disk
io.disk*.avg_write_time
DGAUGE, milliseconds		 Average write time for a given disk
io.disk*.read_bytes
DGAUGE, bytes per second		 Read speed for a given disk
io.disk*.read_count
DGAUGE, operations per second		 Number of reads per second for a given disk
io.disk*.read_merged_count
DGAUGE, operations per second		 Number of merged read operations per second for a given disk
io.disk*.utilization
DGAUGE, %		 Utilization of a given disk; disabled for network drives.
io.disk*.write_bytes
DGAUGE, bytes per second		 Write speed for a given disk
io.disk*.write_count
DGAUGE, operations per second		 Number of writes per second for a given disk
io.disk*.write_merged_count
DGAUGE, operations per second		 Number of merged write operations per second for a given disk
io.read_bytes
DGAUGE, bytes per second		 Disk read rate
io.read_count
DGAUGE, operations per second		 Number of read operations per second
io.read_merged_count
DGAUGE, operations per second		 Number of merged read operations per second
io.utilization
DGAUGE, %		 Disk utilization disabled for network drives
io.write_bytes
DGAUGE, bytes per second		 Disk write speed
io.write_count
DGAUGE, operations per second		 Number of writes per second
io.write_merged_count
DGAUGE, operations per second		 Number of merged write operations per second
monitoring_disk.io_quota_utilization_percentage_burst
DGAUGE, %		 Maximum percentage of disk I/O quota usage (burst)
monitoring_disk.io_quota_utilization_percentage
DGAUGE, %		 Average percentage of disk I/O quota usage
monitoring_disk.read_bytes_burst
DGAUGE, bytes per second		 Maximum number of bytes read from disk per second
monitoring_disk.read_bytes
DGAUGE, bytes per second		 Average number of bytes read from disk per second
monitoring_disk.read_latency
DGAUGE, milliseconds		 Distribution histogram for disk read request latency
monitoring_disk.read_ops_burst
DGAUGE, operations per second		 Maximum number of disk reads
monitoring_disk.read_ops
DGAUGE, operations per second		 Average number of disk reads
monitoring_disk.read_throttler_delay
DGAUGE, milliseconds		 Histogram of read latency due to exceeded disk quota
monitoring_disk.write_bytes_burst
DGAUGE, bytes per second		 Maximum number of bytes written to disk per second
monitoring_disk.write_bytes
DGAUGE, bytes per second		 Average number of bytes written to disk per second
monitoring_disk.write_latency
DGAUGE, milliseconds		 Distribution histogram for disk write request latency
monitoring_disk.write_ops_burst
DGAUGE, operations per second		 Maximum number of disk write operations
monitoring_disk.write_ops
DGAUGE, operations per second		 Average number of disk write operations
monitoring_disk.write_throttler_delay
DGAUGE, milliseconds		 Histogram of write latency due to exceeded disk quota

RAM metrics

The consumption type goes into the systag label.

Name
Type, units		 Description
mem.active_bytes
DGAUGE, bytes		 Active resident memory (frequently accessed and released when absolutely necessary)
mem.available_bytes
DGAUGE, bytes		 RAM usage, available usage type
mem.buffers_bytes
DGAUGE, bytes		 RAM usage, buffers usage type
mem.cached_bytes
DGAUGE, bytes		 RAM usage, cached usage type
mem.free_bytes
DGAUGE, bytes		 Amount of free RAM available, excluding mem.buffers_bytes and mem.cached_bytes
mem.shared_bytes
DGAUGE, bytes		 RAM usage, shared usage type
mem.total_bytes
DGAUGE, bytes		 RAM usage, total usage type
mem.used_bytes
DGAUGE, bytes		 Amount of RAM currently used by running processes
oom_count
DGAUGE, count		 Number of out-of-memory events

Network metrics

Name
Type, units		 Description
net.bytes_recv
DGAUGE, bytes per second		 Network data receive rate
net.bytes_sent
DGAUGE, bytes per second		 Network data transmit rate
net.dropin
DGAUGE, count		 Dropped receive packets
net.dropout
DGAUGE, count		 Dropped transmit packets
net.errin
DGAUGE, count		 Receive error count
net.errout
DGAUGE, count		 Transmit error count
net.packets_recv
DGAUGE, packets per second		 Network packet receive rate
net.packets_sent
DGAUGE, packets per second		 Network packet transmit rate

Service metrics

Cluster metrics

Name
Type, units		 Description
backups_done.count
DGAUGE, count		 Number of successful backups.
The type special label is the backup type. The possible values are:
  • AUTOMATED: Automatic
  • MANUAL: Manual
can_read
DGAUGE, 0/1		 Host read access indicator.
1 if the host service is available for reads, 0 if not.
can_write
DGAUGE, 0/1		 Host write access idicator.
1 if the host service is available for writes, 0 if not.
core_dump.count
DGAUGE, count		 Number of core dumps.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
dbaas_conf.cpu.fraction
DGAUGE, fractions		 Fraction of available CPU resources allocated by the service.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
dbaas_conf.cpu.guarantee
DGAUGE, fractions		 Guaranteed fraction of CPU resources allocated by the service.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
dbaas_conf.cpu.limit
DGAUGE, fractions		 Maximum allowed fraction of CPU resource usage.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
dbaas_conf.hosts.ha
DGAUGE, hosts		 Number of hosts set up for high availability.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
dbaas_conf.hosts.subcluster.<subcluster_name>.total
DGAUGE, count		 Number of hosts in the subcluster.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
dbaas_conf.hosts.total
DGAUGE, count		 Total hosts used by the service.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
last_automated_backup.timestamp_in_seconds
DGAUGE, seconds		 Unix timestamp of the most recent automatic backup
n_unique_users
DGAUGE, count		 Number of unique users or accounts engaging with the system
n_users
DGAUGE, count		 Limit on the number of users
od_cores.count
DGAUGE, count		 Number of on-demand cores.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
pg_log_counter.error_duplicate_table
DGAUGE, count		 Number of PostgreSQL errors caused by attempts to create an existing table
pg_log_counter.error_query_canceled
DGAUGE, count		 Number of canceled PostgreSQL queries
pg_log_counter.fatal_connection_failure
DGAUGE, count		 Number of fatal PostgreSQL connection errors
pg_log_counter.fatal_invalid_password
DGAUGE, count		 Number of fatal PostgreSQL connection errors due to an invalid password
postgres.corruption_found
DGAUGE, 0/1		 Indicator of data corruption in the PostgreSQL cluster
1 if corruption is detected, 0 if not.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Clog_blks_hit
DGAUGE, count		 Number of Clog page SLRU cache hits (transaction commit log)
postgres.slru_Clog_blks_read
DGAUGE, count		 Number of Clog SLRU page reads from the disk
postgres.slru_Clog_blks_written
DGAUGE, count		 Number of Clog SLRU page writes to the disk
postgres.slru_CommitTs_blks_hit
DGAUGE, count		 Number of CommitTs page SLRU cache hits (transaction commit history).
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_CommitTs_blks_read
DGAUGE, count		 Number of CommitTs SLRU page reads from the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_CommitTs_blks_written
DGAUGE, count		 Number of CommitTs SLRU page writes to the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_MultiXactMember_blks_hit
DGAUGE, count		 Number of MultiXactMember page SLRU cache hits.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_MultiXactMember_blks_read
DGAUGE, count		 Number of MultiXactMember SLRU page reads from the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_MultiXactMember_blks_written
DGAUGE, count		 Number of MultiXactMember SLRU page writes to the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_MultiXactOffset_blks_hit
DGAUGE, count		 Number of MultiXactOffset page SLRU cache hits.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_MultiXactOffset_blks_read
DGAUGE, count		 Number of MultiXactOffset SLRU page reads from the disk
postgres.slru_MultiXactOffset_blks_written
DGAUGE, count		 Number of MultiXactOffset SLRU page writes to the disk
postgres.slru_Notify_blks_hit
DGAUGE, count		 Number of notification queue page SLRU cache hits.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Notify_blks_read
DGAUGE, count		 Number of Notify SLRU page reads from the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Notify_blks_written
DGAUGE, count		 Number of Notify SLRU page writes to the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_other_blks_hit
DGAUGE, count		 Number of SLRU cache hits for pages of other SLRU tables.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_other_blks_hit
DGAUGE, count		 Number of SLRU cache hits for pages of other SLRU tables.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_other_blks_read
DGAUGE, count		 Number of page reads from the disk for other SLRU tables
postgres.slru_other_blks_written
DGAUGE, count		 Number of page writes to the disk for other SLRU tables.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Serial_blks_hit
DGAUGE, count		 Number of sequence page SLRU cache hits.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Serial_blks_read
DGAUGE, count		 Number of Serial SLRU page reads from the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Serial_blks_written
DGAUGE, count		 Number of Serial SLRU page writes to the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Subtrans_blks_hit
DGAUGE, count		 Number of SLRU cache hits for subtransaction log data pages.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Subtrans_blks_read
DGAUGE, count		 Number of Subtrans SLRU page reads from the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Subtrans_blks_written
DGAUGE, count		 Number of Subtrans SLRU page writes to the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Xact_blks_hit
DGAUGE, count		 Number of SLRU cache hits for transaction log pages.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Xact_blks_read
DGAUGE, count		 Number of Xact SLRU page reads from the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres.slru_Xact_blks_written
DGAUGE, count		 Number of Xact SLRU page writes to the disk.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres_archive_lag.logid_lag
DGAUGE, count		 Lag in archiving WAL segments.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres_archive_lag.record_lag
DGAUGE, count		 Lag in archiving WAL records.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres_archive_lag.timeline_lag
DGAUGE, count		 Lag in archiving timelines.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres_archive_lag_bytes
DGAUGE, bytes		 WAL archive lag in bytes
postgres_archive_lag_seconds
DGAUGE, seconds		 WAL archive lag in seconds
postgres_conn_aborted
DGAUGE, count		 Number of crashed connections
postgres_conn_active
DGAUGE, count		 Number of active connections
postgres_conn_idle_in_transaction
DGAUGE, count		 Number of idle in transaction connections (pending within an open transaction)
postgres_conn_idle
DGAUGE, count		 Number of idle connections (waiting for new requests)
postgres_conn_waiting
DGAUGE, count		 Number of connections waiting for resources
postgres_max_connections
DGAUGE, count		 Maximum number of connections
postgres_oldest_prepared_xact_duration
DGAUGE, seconds		 Duration of the oldest prepared transaction
postgres_oldest_query_duration
DGAUGE, seconds		 Duration of the oldest query
postgres_oldest_transaction_duration
DGAUGE, seconds		 Duration of the oldest transaction
postgres_pg_total_databases_size
DGAUGE, bytes		 Total size of all databases
postgres_role_conn_limit
DGAUGE, count		 Maximum number of concurrent sessions per user.
Special labels:
  • database: Database name
  • user: Username
postgres_role_sessions
DGAUGE, count		 Number of active sessions per user.
Special labels:
  • database: Database name
  • user: Username
postgres_role_total_conn_limit
DGAUGE, count		 Maximum possible number of concurrent sessions for all users
postgres_total_connections
DGAUGE, count		 Number of connections
postgres_wait_event_CPU_CPU
DGAUGE, count		 Number of PostgreSQL processes waiting for CPU time.
Special labels:
  • database: Database name
  • user: Username
postgres_wait_event_IO_DataFileWrite
DGAUGE, count		 Number of processes waiting to write data to database files.
Special labels:
  • database: Database name
  • user: Username
postgres_wait_event_IO_WALInitSync
DGAUGE, count		 Number of processes waiting for WAL file initialization and synchronization.
Special labels:
  • database: Database name
  • user: Username
postgres_wait_event_IO_WALSync
DGAUGE, count		 Number of processes waiting for WAL file fsync/synchronization.
Special labels:
  • database: Database name
  • user: Username
postgres_wait_event_LWLock_WALWrite
DGAUGE, count		 Number of processes waiting for a WAL write LWLock.
Special labels:
  • database: Database name
  • user: Username
postgres_wal_rate_bytes
DGAUGE, bytes per second		 Write-ahead logging rate
postgres_xid_left_percent
DGAUGE, %		 Percentage of transaction counters left
postgres_xid_left
DGAUGE, count		 Number of transaction counters left
postgres_xid_used_percent
DGAUGE, %		 Percentage of transaction counters used
postgres-is_alive
DGAUGE, 0/1		 Host health indicator.
1 if the database host is operational, 0 if not.
postgres-is_primary
DGAUGE, 0/1		 Master host indicator.
1 if the database host is a master, 0 if not.
postgres-is_replica
DGAUGE, 0/1		 Replica host indicator.
1 if the database host is a replica, 0 if not.
postgres-log_errors
DGAUGE, messages per second		 Number of errors logged per second
postgres-log_fatals
DGAUGE, messages per second		 Number of fatal errors logged per second
postgres-log_slow_queries
DGAUGE, queries per second		 Number of slow queries logged per second
postgres-log_warnings
DGAUGE, messages per second		 Number of warnings logged per second
postgres-oldest_inactive_replication_slot_duration
DGAUGE, seconds		 Duration of the oldest inactive replication slot
postgres-replica_type
DGAUGE, count		 Current PostgreSQL replica type
postgres-replication_lag
DGAUGE, seconds		 Replication lag.
Calculated with one-second accuracy. A lag of less than one second cannot be tracked using this metric.
postgres-role
DGAUGE, count		 PostgreSQL instance role
postgres-some_writable
DGAUGE, 0/1		 Indicates if the database is available for writing
uptime
DGAUGE, %		 Uptime percentage

DB metrics

Name
Type, units		 Description
_pg_database_size
DGAUGE, bytes		 Database size.
The dbname special label is the database name.
<DB_name>_tup_deleted
DGAUGE, count		 Number of rows deleted by queries in <DB_name>
<DB_name>_tup_fetched
DGAUGE, count		 Number of rows fetched by queries in <DB_name>
<DB_name>_tup_inserted
DGAUGE, count		 Number of rows inserted by queries in <DB_name>
<DB_name>_tup_returned
DGAUGE, count		 Number of rows returned by queries in <DB_name>
<DB_name>_tup_updated
DGAUGE, count		 Number of rows updated by queries in <DB_name>

Connection pooler metrics

Special labels for Odyssey metrics:

  • fqdn: Host FQDN
  • cid: Cluster ID
Name
Type, units		 Description
odyssey.cpu_time_iowait
DGAUGE, seconds		 Odyssey process I/O wait time
odyssey.cpu_time_system
DGAUGE, seconds		 Odyssey process time in kernel mode
odyssey.cpu_time_user
DGAUGE, seconds		 Odyssey process time in user mode
odyssey.cpu_usage
DGAUGE, %		 Odyssey process CPU usage
odyssey.involuntary_context_switches
DGAUGE, count		 Number of Odyssey process forced context switches
odyssey.major_faults
DGAUGE, count		 Number of Odyssey process major memory page faults
odyssey.memory_rss
DGAUGE, bytes		 Odyssey process RAM usage (RSS)
odyssey.memory_usage
DGAUGE, %		 Total memory used by the Odyssey process
odyssey.memory_vms
DGAUGE, bytes		 Odyssey process virtual memory
odyssey.minor_faults
DGAUGE, count		 Number of Odyssey process minor memory page faults
odyssey.num_fds
DGAUGE, count		 Number of Odyssey process open file descriptors
odyssey.running
DGAUGE, 0/1		 Indicates a running Odyssey process.
Special labels:
  • pgrep
  • result
odyssey.voluntary_context_switches
DGAUGE, count		 Number of Odyssey process voluntary context switches
pooler-avg_query_time
DGAUGE, milliseconds		 Average query execution time per database host
pooler-avg_xact_time
DGAUGE, milliseconds		 Average transaction execution time per database host
pooler-bytes_recieved
DGAUGE, bytes		 Size of data received
pooler-bytes_recieved-<DB_name>-<username>
DGAUGE, bytes		 Size of data received by <username> through <DB_name>
pooler-bytes_sent
DGAUGE, bytes		 Total sent data size
pooler-bytes_sent-<DB_name>-<username>
DGAUGE, bytes		 Size of data sent by <username> through <DB_name>
pooler-cl_active
DGAUGE, count		 Number of active client connections
pooler-cl_waiting
DGAUGE, count		 Number of client connections waiting for a server connection release
pooler-free_clients
DGAUGE, count		 Remaining client connections in the connection pooler
pooler-free_servers
DGAUGE, count		 Remaining server connections in the connection pooler
pooler-is_alive
DGAUGE, 0/1		 Connection pooler health for each host both as a master and as a replica
pooler-login_clients
DGAUGE, count		 Number of client connections established in the connection pooler
pooler-maxwait
DGAUGE, milliseconds		 Maximum client connection wait time
pooler-pgbouncer_tcp_connections
DGAUGE, connections per second		 Number of PostgreSQL TCP connections
pooler-postgres_tcp_connections
DGAUGE, connections per second		 Number of PgBouncer TCP connections
pooler-query_0.5
DGAUGE, milliseconds		 Median query execution time
pooler-query_0.5-<DB_name>-<username>
DGAUGE, milliseconds		 Execution time for queries run by <username> through <DB_name>, median value
pooler-query_0.75
DGAUGE, milliseconds		 75th percentile query execution time
pooler-query_0.75-<DB_name>-<username>
DGAUGE, milliseconds		 Execution time for queries run by <username> through <DB_name>, 75th percentile
pooler-query_0.9
DGAUGE, milliseconds		 Query execution time, 90th percentile
pooler-query_0.9-<DB_name>-<username>
DGAUGE, milliseconds		 Execution time for queries run by <username> through <DB_name>, 90th percentile
pooler-query_0.95
DGAUGE, milliseconds		 95th percentile query execution time
pooler-query_0.95-<DB_name>-<username>
DGAUGE, milliseconds		 Execution time for queries run by <username> through <DB_name>, 95th percentile
pooler-query_0.99
DGAUGE, milliseconds		 99th percentile query execution time
pooler-query_0.99-<DB_name>-<username>
DGAUGE, milliseconds		 Execution time for queries run by <username> through <DB_name>, 99th percentile
pooler-query_0.999
DGAUGE, milliseconds		 Query execution time, 99.9th percentile
pooler-query_0.999-<DB_name>-<username>
DGAUGE, milliseconds		 Execution time for queries run by <username> through <DB_name>, 99.9th percentile
pooler-query_0.9999
DGAUGE, milliseconds		 99.99th percentile query execution time
pooler-query_0.9999-<DB_name>-<username>
DGAUGE, milliseconds		 Execution time for queries run by <username> through <DB_name>, 99.99th percentile
pooler-query_1
DGAUGE, milliseconds		 100th percentile query execution time
pooler-query_1-<DB_name>-<username>
DGAUGE, milliseconds		 Execution time for queries run by <username> through <DB_name>, 100th percentile
pooler-query_count
DGAUGE, count		 Number of running queries per DB host
pooler-sv_active
DGAUGE, count		 Number of active server connections
pooler-sv_idle
DGAUGE, count		 Number of idle server connections
pooler-sv_login
DGAUGE, count		 Number of server connections undergoing authentication
pooler-sv_tested
DGAUGE, count		 Number of verified server connections
pooler-tcp_conn_count
DGAUGE, count		 Number of TCP connections per DB host
pooler-tcp_conn_count-<DB_name>-<username>
DGAUGE, count		 Number of <username> TCP connections per DB host through <DB_name>
pooler-total_query_count
DGAUGE, count		 Number of executed queries
pooler-total_tcp_connections
DGAUGE, connections per second		 Number of PostgreSQL and PgBouncer TCP connections
pooler-total_xact_count
DGAUGE, count		 Number of executed transactions
pooler-transaction_0.5
DGAUGE, milliseconds		 Median transaction processing time
pooler-transaction_0.5-<DB_name>-<username>
DGAUGE, milliseconds		 Processing time for transactions executed by <username> through <DB_name>, median value
pooler-transaction_0.75
DGAUGE, milliseconds		 Transaction processing time, 75th percentile
pooler-transaction_0.75-<DB_name>-<username>
DGAUGE, milliseconds		 Processing time for transactions executed by <username> through <DB_name>, 75th percentile
pooler-transaction_0.9
DGAUGE, milliseconds		 Transaction processing time, 90th percentile
pooler-transaction_0.9-<DB_name>-<username>
DGAUGE, milliseconds		 Processing time for transactions executed by <username> through <DB_name>, 90th percentile
pooler-transaction_0.95
DGAUGE, milliseconds		 Transaction processing time, 95th percentile
pooler-transaction_0.95-<DB_name>-<username>
DGAUGE, milliseconds		 Processing time for transactions executed by <username> through <DB_name>, 95th percentile
pooler-transaction_0.99
DGAUGE, milliseconds		 Transaction processing time, 99th percentile
pooler-transaction_0.99-<DB_name>-<username>
DGAUGE, milliseconds		 Processing time for transactions executed by <username> through <DB_name>, 99th percentile
pooler-transaction_0.999
DGAUGE, milliseconds		 Transaction processing time, 99.9th percentile
pooler-transaction_0.999-<DB_name>-<username>
DGAUGE, milliseconds		 Processing time for transactions executed by <username> through <DB_name>, 99.9th percentile
pooler-used_clients
DGAUGE, count		 Number of client connections in the connection pooler
pooler-used_servers
DGAUGE, count		 Number of server connections in the connection pooler
pooler-xact_count
DGAUGE, count		 Number of running transactions per DB host

Vacuum metrics

Name
Type, units		 Description
postgres_autovacuum.autovacuum_max_workers
DGAUGE, count		 Maximum number of autovacuum workers, as defined by autovacuum_max_workers.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres_autovacuum.scanned_pct
DGAUGE, %		 Percentage of table rows scanned by an autovacuum worker
postgres_autovacuum.scanned_percent
DGAUGE, %		 Percentage of table rows scanned by an autovacuum worker.
Special labels:
  • dbname: Database name
  • cid: Cluster ID
  • fqdn: Host FQDN
  • mode: Execution mode
  • rel: Table name
postgres_autovacuum.total_regular_vacuums
DGAUGE, count		 Total number of executed regular autovacuum operations.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres_autovacuum.total_regular_workers
DGAUGE, count		 Number of active autovacuum workers
postgres_autovacuum.total_user_vacuums
DGAUGE, count		 Total number of custom autovacuum operations.
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres_autovacuum.total_user_workers
DGAUGE, count		 Number of active user-launched autovacuum workers
postgres_autovacuum.total_wraparound_vacuums
DGAUGE, count		 Total number of autovacuum operations to prevent wraparound (xid overflow).
Special labels:
  • cid: Cluster ID
  • fqdn: Host FQDN
postgres_autovacuum.total_wraparound_workers
DGAUGE, count		 Number of active autovacuum workers launched to prevent wraparound
postgres_autovacuum.vacuumed_pct
DGAUGE, %		 Percentage of table rows vacuumed by an autovacuum worker
Previous
RevokePermission
Next
Audit Trails events