Yandex Managed Service for PostgreSQL metrics
Written by
Updated at March 28, 2024
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 |