Yandex Monitoring metric reference
Written by
Updated at April 28, 2025
This section describes Managed Service for PostgreSQL metrics delivered to Monitoring.
The name
label stores the metric name.
Labels shared by 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 or replica |
subcluster_name | Subcluster name |
CPU metrics
These metrics show 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 one minute |
load.avg_5min DGAUGE , % |
Average load over five minutes |
pg_backend_cpu DGAUGE , % |
PostgreSQL process CPU utilization |
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 |
pg_backend_write_bytes DGAUGE , bytes per second |
PostgreSQL process data write rate |
Disk I/O 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 |
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 |
RAM metrics
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 |
---|---|
can_read DGAUGE , 0/1 |
Read access indicator. It can be either 1 if a cluster is available for reads or 0 if it is not. |
can_write DGAUGE , 0/1 |
Write access indicator. It can be either 1 if a cluster is available for writes or 0 if it is not. |
postgres-is_alive DGAUGE , 0/1 |
Host health indicator. It can be either 1 if a DB host is healthy or 0 if it is not. |
postgres-is_primary DGAUGE , 0/1 |
Master host indicator. It can be either 1 if a DB host is a master or 0 if it is not. |
postgres-is_replica DGAUGE , 0/1 |
Replica host indicator. It can be either 1 if a DB host is a replica or 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 , count |
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 , count |
Maximum possible number of concurrent sessions per user |
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_wal_rate_bytes DGAUGE , bytes per second |
Write-ahead logging rate |
postgres_xid_left DGAUGE , count |
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 , 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
Name Type, units |
Description |
---|---|
pooler-avg_query_time DGAUGE , milliseconds |
Average query execution time per DB host |
pooler-avg_xact_time DGAUGE , milliseconds |
Average execution time per transaction per DB 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 |
Size of data sent |
pooler-bytes_sent-<DB_name>-<username> DGAUGE , bytes |
Size of data sent by <username> through <DB_name> |
pooler-free_clients DGAUGE , count |
Number of client connections left in the connection pooler |
pooler-free_servers DGAUGE , count |
Number of server connections left 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-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 |
Query execution time, median value |
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 |
Query execution time, 75th percentile |
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 |
Query execution time, 95th percentile |
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 |
Query execution time, 99th percentile |
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_count DGAUGE , count |
Number of running queries per DB host |
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_tcp_connections DGAUGE , connections per second |
Number of PostgreSQL and PgBouncer TCP connections |
pooler-transaction_0.5 DGAUGE , milliseconds |
Transaction processing time, median value |
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 . |
postgres_autovacuum.total_regular_workers DGAUGE , count |
Number of active autovacuum workers |
postgres_autovacuum.total_user_workers DGAUGE , count |
Number of active user-launched autovacuum workers |
postgres_autovacuum.total_wraparound_workers DGAUGE , count |
Number of active autovacuum workers launched to prevent wraparound |
postgres_autovacuum.scanned_pct DGAUGE , % |
Percentage of table rows scanned by an autovacuum worker |
postgres_autovacuum.vacuumed_pct DGAUGE , % |
Percentage of table rows vacuumed by an autovacuum worker |