Yandex Managed Service for PostgreSQL metrics

Written by

Updated at November 21, 2024

CPU metrics
Disk metrics
Disk operation metrics
RAM metrics
Network metrics
Service metrics

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

The name of the metric is written to the name label.

Common labels for all Managed Service for PostgreSQL metrics:

Label	Value
service	Service ID: `managed-postgresql`
resource_type	Resource type: `cluster`
resource_id	Cluster ID
host	host FQDN
node	Host type: `primary`, `replica`
subcluster_name	Subcluster name

CPU metrics

Processor core workload.

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 1 minute
`load.avg_5min` `DGAUGE`, %	Average load over 5 minutes
`pg_backend_cpu` `DGAUGE`, %	CPU usage by the PostgreSQL process

Disk metrics

Name Type, units	Description
`disk.free_bytes` `DGAUGE`, bytes	Free space
`disk.free_inodes` `DGAUGE`, number	Number of free inodes
`disk.temp_files_size` `DGAUGE`, bytes	Size of temporary files
`disk.total_bytes` `DGAUGE`, bytes	Available space
`disk.total_inodes` `DGAUGE`, number	Available inodes
`disk.used_bytes` `DGAUGE`, bytes	Used space
`disk.used_inodes` `DGAUGE`, number	Used inodes
`disk.wal_size` `DGAUGE`, bytes	Write-ahead log (WAL) size
`pg_backend_read_bytes` `DGAUGE`, bytes per second	Rate of data reads by the PostgreSQL process
`pg_backend_write_bytes` `DGAUGE`, bytes per second	Rate of data writes by the PostgreSQL process

Disk operation metrics

Name Type, units	Description
`io.avg_read_time` `DGAUGE`, ms	Average disk read time
`io.avg_write_time` `DGAUGE`, ms	Average disk write time
`io.disk*.avg_read_time` `DGAUGE`, ms	Average read time for a specific disk
`io.disk*.avg_write_time` `DGAUGE`, ms	Average write time for a specific disk
`io.disk*.read_bytes` `DGAUGE`, bytes per second	Read speed for a specific disk
`io.disk*.read_count` `DGAUGE`, operations per second	Read operations per second for a given disk
`io.disk*.read_merged_count` `DGAUGE`, operations per second	Merged read operations per second for a specific disk
`io.disk*.utilization` `DGAUGE`, %	Utilization of a specific disk; disabled for network drives
`io.disk*.write_bytes` `DGAUGE`, bytes per second	Write speed for a specific disk
`io.disk*.write_count` `DGAUGE`, operations per second	Number of write operations per second for a specific disk
`io.disk*.write_merged_count` `DGAUGE`, operations per second	Number of merged write operations per second for a specific disk
`io.read_bytes` `DGAUGE`, bytes per second	Disk read speed
`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
`io.write_bytes` `DGAUGE`, bytes per second	Disk write speed
`io.write_count` `DGAUGE`, operations per second	Number of write operations per second
`io.write_merged_count` `DGAUGE`, operations per second	Number of merged write operations per second

RAM metrics

Name Type, units	Description
`mem.active_bytes` `DGAUGE`, bytes	Amount of RAM used most often and only freed up 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 the running processes
`oom_count` `DGAUGE`, number	Number of out-of-memory (OOM) events

Network metrics

Name Type, units	Description
`net.bytes_recv` `DGAUGE`, bytes per second	Rate of receiving data over the network
`net.bytes_sent` `DGAUGE`, bytes per second	Rate of sending data over the network
`net.dropin` `DGAUGE`, number	Packets dropped upon receipt
`net.dropout` `DGAUGE`, number	Packets dropped when being sent
`net.errin` `DGAUGE`, number	Number of errors upon receipt
`net.errout` `DGAUGE`, number	Number of errors at sending
`net.packets_recv` `DGAUGE`, packets per second	Rate of receiving packets over the network
`net.packets_sent` `DGAUGE`, packets per second	Rate of sending packets over the network

Service metrics

Cluster metrics

Name Type, units	Description
`can_read` `DGAUGE`, 0/1	Read access indicator. `1` if a cluster is available for reads, `0` if not.
`can_write` `DGAUGE`, 0/1	Write access indicator. `1` if a cluster is available for writes, `0` if not.
`postgres-is_alive` `DGAUGE`, 0/1	Host health indicator. `1` if a DB host is alive, `0` if not.
`postgres-is_primary` `DGAUGE`, 0/1	Master host indicator. `1` if a DB host is a master, `0` if not.
`postgres-is_replica` `DGAUGE`, 0/1	Replica host indicator. `1` if a DB 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-replication_lag` `DGAUGE`, seconds	Replication lag
`postgres_max_connections` `DGAUGE`, number	Maximum number of connections
`postgres-oldest_inactive_replication_slot_duration` `DGAUGE`, seconds	Duration of the oldest inactive replication slot
`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_role_conn_limit` `DGAUGE`, number	Maximum allowed number of concurrent user sessions
`postgres_role_total_conn_limit` `DGAUGE`, number	Maximum allowed number of concurrent sessions of all users
`postgres_total_connections` `DGAUGE`, number	Number of connections
`postgres_wal_rate_bytes` `DGAUGE`, bytes per second	Write-ahead logging rate
`postgres_xid_left` `DGAUGE`, number	Number of transaction counters left
`postgres_xid_left_percent` `DGAUGE`, %	Percentage of transaction counters left
`postgres_xid_used_percent` `DGAUGE`, %	Percentage of transaction counters used

DB metrics

Name Type, units	Description
`_pg_database_size` `DGAUGE`, bytes	Database size. Additional labels: `dbname`
`<DB_name>_tup_deleted` `DGAUGE`, number	Number of rows deleted by queries in `<DB_name>`
`<DB_name>_tup_fetched` `DGAUGE`, number	Number of rows fetched by queries in `<DB_name>`
`<DB_name>_tup_inserted` `DGAUGE`, number	Number of rows inserted by queries in `<DB_name>`
`<DB_name>_tup_returned` `DGAUGE`, number	Number of rows returned by queries in `<DB_name>`
`<DB_name>_tup_updated` `DGAUGE`, number	Number of rows updated by queries in `<DB_name>`

Connection pooler metrics

Name Type, units	Description
`pooler-avg_query_time` `DGAUGE`, ms	Average query execution time per DB host
`pooler-avg_xact_time` `DGAUGE`, ms	Average execution time per transaction per DB host
`pooler-bytes_recieved` `DGAUGE`, bytes	Bytes received
`pooler-bytes_recieved-<DB_name>-<username>` `DGAUGE`, bytes	Amount of data received by `<username>` through `<DB_name>`.
`pooler-bytes_sent` `DGAUGE`, bytes	Bytes sent
`pooler-bytes_sent-<DB_name>-<username>` `DGAUGE`, bytes	Amount of data sent by `<username>` through `<DB_name>`.
`pooler-free_clients` `DGAUGE`, number	Number of client connections left in the connection pooler
`pooler-free_servers` `DGAUGE`, number	Number of server connections left in the connection pooler
`pooler-is_alive` `DGAUGE`, 0/1	Connection pooler health for each host either as a master or as a replica
`pooler-login_clients` `DGAUGE`, number	Number of client connections established in the connection pooler
`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`, seconds	Query execution time, median value
`pooler-query_0.5-<DB_name>-<username>` `DGAUGE`, seconds	Execution time for queries run by `<username>` through `<DB_name>`, median value
`pooler-query_0.75` `DGAUGE`, seconds	Query execution time, 0.75 percentile
`pooler-query_0.75-<DB_name>-<username>` `DGAUGE`, seconds	Execution time for queries run by `<username>` through `<DB_name>`, 0.75 percentile
`pooler-query_0.9` `DGAUGE`, seconds	Query execution time, 0.9 percentile
`pooler-query_0.9-<DB_name>-<username>` `DGAUGE`, seconds	Execution time for queries run by `<username>` through `<DB_name>`, 0.9 percentile
`pooler-query_0.95` `DGAUGE`, seconds	Query execution time, 0.95 percentile
`pooler-query_0.95-<DB_name>-<username>` `DGAUGE`, seconds	Execution time for queries run by `<username>` through `<DB_name>`, 0.95 percentile
`pooler-query_0.99` `DGAUGE`, seconds	Query execution time, 0.99 percentile
`pooler-query_0.99-<DB_name>-<username>` `DGAUGE`, seconds	Execution time for queries run by `<username>` through `<DB_name>`, 0.99 percentile
`pooler-query_0.999` `DGAUGE`, seconds	Query execution time, 0.999 percentile
`pooler-query_0.999-<DB_name>-<username>` `DGAUGE`, seconds	Execution time for queries run by `<username>` through `<DB_name>`, 0.999 percentile
`pooler-query_count` `DGAUGE`, number	Number of queries executed on each DB host
`pooler-tcp_conn_count` `DGAUGE`, number	Number of TCP connections to each database host
`pooler-tcp_conn_count-<DB_name>-<username>` `DGAUGE`, number	Number of `<username>` TCP connections to each DB host through `<DB_name>`
`pooler-total_tcp_connections` `DGAUGE`, connections per second	Number of PostgreSQL and PgBouncer TCP connections
`pooler-transaction_0.5` `DGAUGE`, seconds	Transaction processing time, median value
`pooler-transaction_0.5-<DB_name>-<username>` `DGAUGE`, seconds	Processing time for transactions executed by `<username>` through `<DB_name>`, median value
`pooler-transaction_0.75` `DGAUGE`, seconds	Transaction processing time, 0.75 percentile
`pooler-transaction_0.75-<DB_name>-<username>` `DGAUGE`, seconds	Processing time for transactions executed by `<username>` through `<DB_name>`, 0.75 percentile
`pooler-transaction_0.9` `DGAUGE`, seconds	Transaction processing time, 0.9 percentile
`pooler-transaction_0.9-<DB_name>-<username>` `DGAUGE`, seconds	Processing time for transactions executed by `<username>` through `<DB_name>`, 0.9 percentile
`pooler-transaction_0.95` `DGAUGE`, seconds	Transaction processing time, 0.95 percentile
`pooler-transaction_0.95-<DB_name>-<username>` `DGAUGE`, seconds	Processing time for transactions executed by `<username>` through `<DB_name>`, 0.95 percentile
`pooler-transaction_0.99` `DGAUGE`, seconds	Transaction processing time, 0.99 percentile
`pooler-transaction_0.99-<DB_name>-<username>` `DGAUGE`, seconds	Processing time for transactions executed by `<username>` through `<DB_name>`, 0.99 percentile
`pooler-transaction_0.999` `DGAUGE`, seconds	Transaction processing time, 0.999 percentile
`pooler-transaction_0.999-<DB_name>-<username>` `DGAUGE`, seconds	Processing time for transactions executed by `<username>` through `<DB_name>`, 0.999 percentile
`pooler-used_clients` `DGAUGE`, number	Number of client connections in the connection pooler
`pooler-used_servers` `DGAUGE`, number	Number of server connections in the connection pooler
`pooler-xact_count` `DGAUGE`, number	Number of transactions executed on each DB host

Vacuum metrics

Name Type, units	Description
`postgres_autovacuum.autovacuum_max_workers` `DGAUGE`, number	Maximum number of autovacuum processes. This value is controlled by the `autovacuum_max_workers` setting.
`postgres_autovacuum.total_regular_workers` `DGAUGE`, number	Number of active autovacuum processes
`postgres_autovacuum.total_user_workers` `DGAUGE`, number	Number of active autovacuum processes manually started by a user
`postgres_autovacuum.total_wraparound_workers` `DGAUGE`, number	Number of active autovacuum processes started to prevent wraparound
`postgres_autovacuum.scanned_pct` `DGAUGE`, %	Percentage of table rows scanned by an autovacuum process
`postgres_autovacuum.vacuumed_pct` `DGAUGE`, %	Percentage of table rows vacuumed by an autovacuum process

Yandex Managed Service for PostgreSQL metrics

CPU metricsCPU metrics

Disk metricsDisk metrics

Disk operation metricsDisk operation metrics

RAM metricsRAM metrics

Network metricsNetwork metrics

Service metricsService metrics

Cluster metricsCluster metrics

DB metricsDB metrics

Connection pooler metricsConnection pooler metrics

Vacuum metricsVacuum metrics

Was the article helpful?