Yandex Managed Service for PostgreSQL metrics

Written by

Updated at March 28, 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 in 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, unit	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/s	Rate of data reads by the PostgreSQL process
`pg_backend_write_bytes` `DGAUGE`, bytes/s	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 specific 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/s	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/s	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/s	Rate of receiving data over the network
`net.bytes_sent` `DGAUGE`, bytes/s	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 it is not.
`can_write` `DGAUGE`, 0/1	Write access indicator. `1` if a cluster is available for writes, `0` if it is not.
`postgres-is_alive` `DGAUGE`, 0/1	Host health indicator. `1` if a DB host is alive, `0` if it is not.
`postgres-is_primary` `DGAUGE`, 0/1	Master host indicator. `1` if a DB host is a master, `0` if it is not.
`postgres-is_replica` `DGAUGE`, 0/1	Replica host indicator. `1` if a DB host is a replica, `0` if it is 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/s	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	DB size. Additional labels: `dbname`
`<DB_name>_tup_deleted` `DGAUGE`, number	Number of rows deleted by queries in this `<DB_name>`
`<DB_name>_tup_fetched` `DGAUGE`, number	Number of rows fetched by queries in this `<DB_name>`
`<DB_name>_tup_inserted` `DGAUGE`, number	Number of rows inserted by queries in this `<DB_name>`
`<DB_name>_tup_returned` `DGAUGE`, number	Number of rows returned by queries in this `<DB_name>`
`<DB_name>_tup_updated` `DGAUGE`, number	Number of rows updated by queries in this `<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	Query execution time for queries made by `<username>` through `<DB_name>`
`pooler-query_0.75` `DGAUGE`, seconds	Query execution time, 0.75 percentile
`pooler-query_0.75-<DB_name>-<username>` `DGAUGE`, seconds	Query execution time for queries made 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	Query execution time for queries made 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	Query execution time for queries made 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	Query execution time for queries made 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	Query execution time for queries made 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 TCP connections to each DB host established by `<username>` 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 handling time, median value
`pooler-transaction_0.5-<DB_name>-<username>` `DGAUGE`, seconds	Transaction handling time for transactions executed by `<username>` through `<DB_name>`, median value
`pooler-transaction_0.75` `DGAUGE`, seconds	Transaction handling time, 0.75 percentile
`pooler-transaction_0.75-<DB_name>-<username>` `DGAUGE`, seconds	Transaction handling time for transactions executed by `<username>` through `<DB_name>`, 0.75 percentile
`pooler-transaction_0.9` `DGAUGE`, seconds	Transaction handling time, 0.9 percentile
`pooler-transaction_0.9-<DB_name>-<username>` `DGAUGE`, seconds	Transaction handling time for transactions executed by `<username>` through `<DB_name>`, 0.9 percentile
`pooler-transaction_0.95` `DGAUGE`, seconds	Transaction handling time, 0.95 percentile
`pooler-transaction_0.95-<DB_name>-<username>` `DGAUGE`, seconds	Transaction handling time for transactions executed by `<username>` through `<DB_name>`, 0.95 percentile
`pooler-transaction_0.99` `DGAUGE`, seconds	Transaction handling time, 0.99 percentile
`pooler-transaction_0.99-<DB_name>-<username>` `DGAUGE`, seconds	Transaction handling time for transactions executed by `<username>` through `<DB_name>`, 0.99 percentile
`pooler-transaction_0.999` `DGAUGE`, seconds	Transaction handling time, 0.999 percentile
`pooler-transaction_0.999-<DB_name>-<username>` `DGAUGE`, seconds	Transaction handling 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

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

Was the article helpful?