# Yandex Monitoring metric reference
This section describes the Managed Service for PostgreSQL metrics delivered to [Monitoring](../monitoring/concepts/index.md).
The `name` label contains the metric name.
Labels shared by all Managed Service for PostgreSQL metrics:
Label | Value
----|----
dc | [Availability zone](../overview/concepts/geo-scope.md)
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 {#managed-postgresql-cpu-metrics}
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 {#managed-postgresql-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 I/O metrics {#managed-postgresql-diskio-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 given disk |
| `io.disk*.avg_write_time`
`DGAUGE`, ms | 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`
`DGAUGE`, % | Average percentage of disk quota usage |
| `monitoring_disk.io_quota_utilization_percentage_burst`
`DGAUGE`, % | Maximum percentage of disk quota usage |
| `monitoring_disk.read_bytes`
`DGAUGE`, bytes per second | Average number of bytes read from disk |
| `monitoring_disk.read_bytes_burst`
`DGAUGE`, bytes per second | Maximum number of bytes read from disk |
| `monitoring_disk.read_latency`
`DGAUGE`, ms | Distribution histogram for disk read request latency |
| `monitoring_disk.read_ops`
`DGAUGE`, operations per second | Average number of disk reads |
| `monitoring_disk.read_ops_burst`
`DGAUGE`, operations per second | Maximum number of disk reads |
| `monitoring_disk.read_throttler_delay`
`DGAUGE`, ms | Histogram of read latency due to exceeded disk quota |
| `monitoring_disk.write_bytes`
`DGAUGE`, bytes per second | Average number of bytes written to disk |
| `monitoring_disk.write_bytes_burst`
`DGAUGE`, bytes per second | Maximum number of bytes written to disk |
| `monitoring_disk.write_latency`
`DGAUGE`, ms | Distribution histogram for disk write request latency |
| `monitoring_disk.write_ops`
`DGAUGE`, operations per second | Average number of disk write operations |
| `monitoring_disk.write_ops_burst`
`DGAUGE`, operations per second | Maximum number of disk write operations |
| `monitoring_disk.write_throttler_delay`
`DGAUGE`, ms | Histogram of write latency due to exceeded disk quota |
## RAM metrics {#managed-postgresql-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 {#managed-postgresql-net-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 {#managed-postgresql-metrics}
#### Cluster metrics {#managed-postgresql-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..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 SLRU cache hits for the Clog page (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 SLRU cache hits for the CommitTs page (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 SLRU cache hits for the MultiXactMember page.
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 SLRU cache hits for the MultiXactOffset page.
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 SLRU cache hits for the notification queue page.
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 SLRU cache hits for sequence pages.
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 {#managed-postgresql-db-metrics}
| Name
Type, units | Description |
| ----- | ----- |
| `_pg_database_size`
`DGAUGE`, bytes | Database size.
The `dbname` special label is the database name. |
| `_tup_deleted`
`DGAUGE`, count | Number of rows deleted by queries in `` |
| `_tup_fetched`
`DGAUGE`, count | Number of rows fetched by queries in `` |
| `_tup_inserted`
`DGAUGE`, count | Number of rows inserted by queries in `` |
| `_tup_returned`
`DGAUGE`, count | Number of rows returned by queries in `` |
| `_tup_updated`
`DGAUGE`, count | Number of rows updated by queries in `` |
#### Connection pooler metrics {#managed-postgresql-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: |
| `odyssey.voluntary_context_switches`
`DGAUGE`, count | Number of Odyssey process voluntary context switches |
| `pooler-avg_query_time`
`DGAUGE`, ms | Average query execution time per database host |
| `pooler-avg_xact_time`
`DGAUGE`, ms | Average transaction execution time per database host |
| `pooler-bytes_recieved`
`DGAUGE`, bytes | Size of data received |
| `pooler-bytes_recieved--`
`DGAUGE`, bytes | Size of data received by `` through `` |
| `pooler-bytes_sent`
`DGAUGE`, bytes | Total sent data size |
| `pooler-bytes_sent--`
`DGAUGE`, bytes | Size of data sent by `` through `` |
| `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`, ms | 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`, ms | Median query execution time |
| `pooler-query_0.5--`
`DGAUGE`, milliseconds | Execution time for queries run by `` through ``, median value |
| `pooler-query_0.75`
`DGAUGE`, ms | 75th percentile query execution time |
| `pooler-query_0.75--`
`DGAUGE`, milliseconds | Execution time for queries run by `` through ``, 75th percentile |
| `pooler-query_0.9`
`DGAUGE`, ms | Query execution time, 90th percentile |
| `pooler-query_0.9--`
`DGAUGE`, milliseconds | Execution time for queries run by `` through ``, 90th percentile |
| `pooler-query_0.95`
`DGAUGE`, ms | 95th percentile query execution time |
| `pooler-query_0.95--`
`DGAUGE`, milliseconds | Execution time for queries run by `` through ``, 95th percentile |
| `pooler-query_0.99`
`DGAUGE`, ms | 99th percentile query execution time |
| `pooler-query_0.99--`
`DGAUGE`, milliseconds | Execution time for queries run by `` through ``, 99th percentile |
| `pooler-query_0.999`
`DGAUGE`, ms | Query execution time, 99.9th percentile |
| `pooler-query_0.999--`
`DGAUGE`, milliseconds | Execution time for queries run by `` through ``, 99.9th percentile |
| `pooler-query_0.9999`
`DGAUGE`, ms | 99.99th percentile query execution time |
| `pooler-query_0.9999--`
`DGAUGE`, milliseconds | Execution time for queries run by `` through ``, 99.99th percentile |
| `pooler-query_1`
`DGAUGE`, ms | 100th percentile query execution time |
| `pooler-query_1--`
`DGAUGE`, milliseconds | Execution time for queries run by `` through ``, 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--`
`DGAUGE`, count | Number of `` TCP connections per DB host through `` |
| `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`, ms | Median transaction processing time |
| `pooler-transaction_0.5--`
`DGAUGE`, milliseconds | Processing time for transactions executed by `` through ``, median value |
| `pooler-transaction_0.75`
`DGAUGE`, ms | Transaction processing time, 75th percentile |
| `pooler-transaction_0.75--`
`DGAUGE`, milliseconds | Processing time for transactions executed by `` through ``, 75th percentile |
| `pooler-transaction_0.9`
`DGAUGE`, ms | Transaction processing time, 90th percentile |
| `pooler-transaction_0.9--`
`DGAUGE`, milliseconds | Processing time for transactions executed by `` through ``, 90th percentile |
| `pooler-transaction_0.95`
`DGAUGE`, ms | Transaction processing time, 95th percentile |
| `pooler-transaction_0.95--`
`DGAUGE`, milliseconds | Processing time for transactions executed by `` through ``, 95th percentile |
| `pooler-transaction_0.99`
`DGAUGE`, ms | Transaction processing time, 99th percentile |
| `pooler-transaction_0.99--`
`DGAUGE`, milliseconds | Processing time for transactions executed by `` through ``, 99th percentile |
| `pooler-transaction_0.999`
`DGAUGE`, ms | Transaction processing time, 99.9th percentile |
| `pooler-transaction_0.999--`
`DGAUGE`, milliseconds | Processing time for transactions executed by `` through ``, 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 {#managed-postgresql-vacuum}
| 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](https://www.postgresql.org/docs/current/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND) |
| `postgres_autovacuum.vacuumed_pct`
`DGAUGE`, % | Percentage of table rows vacuumed by an autovacuum worker |
#### See also {#see-also}
[PostgreSQL cluster and host state monitoring](operations/monitoring.md)