[Yandex Cloud documentation](../index.md) > [Yandex Managed Service for Sharded PostgreSQL](index.md) > Metrics Monitoring
# Yandex Monitoring metric reference
This section describes the Managed Service for Sharded PostgreSQL metrics delivered to [Monitoring](../monitoring/concepts/index.md).
The `name` label contains the metric name.
Labels shared by all Managed Service for Sharded PostgreSQL metrics:
Label | Value
----|----
cid | Cluster ID
dc | [Availability zone](../overview/concepts/geo-scope.md)
fqdn | Host FQDN
host | Host FQDN
resource_id | Cluster ID
resource_type | Resource type: `cluster`
service | Service ID: `managed-spqr`
shard | Shard ID
subcluster_name | Subcluster name
## CPU metrics {#managed-spqr-cpu-metrics}
These metrics show the processor core workload.
The `cpu` label contains the vCPU ID.
| Name
Type, units | Description |
| ----- | ----- |
| `cpu.usage_guest`
`DGAUGE`, % | CPU core usage, `guest` usage type |
| `cpu.usage_guest_nice`
`DGAUGE`, % | CPU core usage, `guest_nice` usage type |
| `cpu.usage_idle`
`DGAUGE`, % | CPU core usage, `idle` usage type |
| `cpu.usage_iowait`
`DGAUGE`, % | CPU core usage, `iowait` usage type |
| `cpu.usage_irq`
`DGAUGE`, % | CPU core usage, `irq` usage type |
| `cpu.usage_nice`
`DGAUGE`, % | CPU core usage, `nice` usage type |
| `cpu.usage_softirq`
`DGAUGE`, % | CPU core usage, `softirq` usage type |
| `cpu.usage_steal`
`DGAUGE`, % | CPU core usage, `steal` usage type |
| `cpu.usage_system`
`DGAUGE`, % | CPU core usage, `system` usage type |
| `cpu.usage_user`
`DGAUGE`, % | CPU core usage, `user` usage type |
## Disk metrics {#managed-spqr-disk-metrics}
| Name
Type, units | Description |
| ----- | ----- |
| `vd*`
`DGAUGE`, bytes | Virtual disk size |
| `vd**`
`DGAUGE`, bytes | Virtual disk partition size |
## RAM metrics {#managed-spqr-ram-metrics}
| Name
Type, units | Description |
| ----- | ----- |
| `mem.active`
`DGAUGE`, bytes | RAM usage, `active` usage type |
| `mem.available`
`DGAUGE`, bytes | RAM usage, `available` usage type |
| `mem.available_percent`
`DGAUGE`, % | Percentage of available RAM |
| `mem.buffered`
`DGAUGE`, bytes | RAM usage, `buffered` usage type |
| `mem.cached`
`DGAUGE`, bytes | RAM usage, `cached` usage type |
| `mem.commit_limit`
`DGAUGE`, bytes | RAM usage, `commit_limit` usage type |
| `mem.committed_as`
`DGAUGE`, bytes | RAM usage, `committed_as` usage type |
| `mem.dirty`
`DGAUGE`, bytes | RAM usage, `dirty` usage type |
| `mem.free`
`DGAUGE`, bytes | RAM usage, `free` usage type |
| `mem.high_free`
`DGAUGE`, bytes | RAM usage, `high_free` usage type |
| `mem.high_total`
`DGAUGE`, bytes | RAM usage, `high_total` usage type |
| `mem.huge_page_size`
`DGAUGE`, bytes | RAM usage, `huge_page_size` usage type |
| `mem.huge_pages_free`
`DGAUGE`, bytes | RAM usage, `huge_pages_free` usage type |
| `mem.huge_pages_total`
`DGAUGE`, bytes | RAM usage, `huge_pages_total` usage type |
| `mem.inactive`
`DGAUGE`, bytes | RAM usage, `inactive` usage type |
| `mem.low_free`
`DGAUGE`, bytes | RAM usage, `low_free` usage type |
| `mem.low_total`
`DGAUGE`, bytes | RAM usage, `low_total` usage type |
| `mem.mapped`
`DGAUGE`, bytes | RAM usage, `mapped` usage type |
| `mem.page_tables`
`DGAUGE`, bytes | RAM usage, `page_tables` usage type |
| `mem.shared`
`DGAUGE`, bytes | RAM usage, `shared` usage type |
| `mem.slab`
`DGAUGE`, bytes | RAM usage, `slab` usage type |
| `mem.sreclaimable`
`DGAUGE`, bytes | RAM usage, `sreclaimable` usage type |
| `mem.sunreclaim`
`DGAUGE`, bytes | RAM usage, `sunreclaim` usage type |
| `mem.swap_cached`
`DGAUGE`, bytes | RAM usage, `swap_cached` usage type |
| `mem.swap_free`
`DGAUGE`, bytes | RAM usage, `swap_free` usage type |
| `mem.swap_total`
`DGAUGE`, bytes | RAM usage, `swap_total` usage type |
| `mem.total`
`DGAUGE`, bytes | RAM usage, `total` usage type |
| `mem.used`
`DGAUGE`, bytes | RAM usage, `used` usage type |
| `mem.used_percent`
`DGAUGE`, % | Percentage of used RAM |
| `mem.vmalloc_chunk`
`DGAUGE`, bytes | RAM usage, `vmalloc_chunk` usage type |
| `mem.vmalloc_total`
`DGAUGE`, bytes | RAM usage, `vmalloc_total` usage type |
| `mem.vmalloc_used`
`DGAUGE`, bytes | RAM usage, `vmalloc_used` usage type |
| `mem.write_back`
`DGAUGE`, bytes | RAM usage, `write_back` usage type |
| `mem.write_back_tmp`
`DGAUGE`, bytes | RAM usage, `write_back_tmp` usage type |
## Network metrics {#managed-spqr-net-metrics}
The `interface` label contains the network interface ID.
| 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.drop_in`
`DGAUGE`, count | Dropped receive packets |
| `net.drop_out`
`DGAUGE`, count | Dropped transmit packets |
| `net.err_in`
`DGAUGE`, count | Receive error count |
| `net.err_out`
`DGAUGE`, count | Transmit error count |
| `net.icmp_inaddrmaskreps`
`DGAUGE`, count | Number of ICMP address mask reply messages received from the polled node |
| `net.icmp_inaddrmasks`
`DGAUGE`, count | Number of ICMP address mask request messages received |
| `net.icmp_incsumerrors`
`DGAUGE`, count | Total IP packets with checksum errors |
| `net.icmp_indestunreachs`
`DGAUGE`, count | Number of ICMP destination unreachable messages received |
| `net.icmp_inechoreps`
`DGAUGE`, count | Number of ICMP echo reply messages received |
| `net.icmp_inechos`
`DGAUGE`, count | Number of ICMP echo request messages received |
| `net.icmp_inerrors`
`DGAUGE`, count | Number of bad ICMP packets received, excluding those with checksum errors |
| `net.icmp_inmsgs`
`DGAUGE`, count | Total ICMP messages received |
| `net.icmp_inparmprobs`
`DGAUGE`, count | Number of ICMP parameter problem messages received |
| `net.icmp_inredirects`
`DGAUGE`, count | Number of ICMP redirect messages received |
| `net.icmp_insrcquenchs`
`DGAUGE`, count | Number of ICMP source quench messages received |
| `net.icmp_intimeexcds`
`DGAUGE`, count | Number of ICMP time exceeded messages received |
| `net.icmp_intimestampreps`
`DGAUGE`, count | Number of ICMP timestamp reply messages received |
| `net.icmp_intimestamps`
`DGAUGE`, count | Number of ICMP timestamp (request) messages received |
| `net.icmp_outaddrmaskreps`
`DGAUGE`, count | Number of ICMP address mask reply messages sent |
| `net.icmp_outaddrmasks`
`DGAUGE`, count | Number of ICMP address mask request messages sent |
| `net.icmp_outdestunreachs`
`DGAUGE`, count | Number of ICMP destination unreachable messages sent |
| `net.icmp_outechoreps`
`DGAUGE`, count | Number of ICMP echo reply messages sent |
| `net.icmp_outechos`
`DGAUGE`, count | Number of ICMP echo request messages sent |
| `net.icmp_outerrors`
`DGAUGE`, count | Number of ICMP messages not sent due to ICMP errors, such as buffer shortages |
| `net.icmp_outmsgs`
`DGAUGE`, count | Total ICMP messages the object in question attempted to send. This includes all messages counted by `icmp_outerrors`. |
| `net.icmp_outparmprobs`
`DGAUGE`, count | Number of ICMP parameter problem messages sent |
| `net.packets_recv`
`DGAUGE`, packets per second | Network packet receive rate |
| `net.packets_sent`
`DGAUGE`, packets per second | Network packet transmit rate |
| `icmp_outratelimitglobal`
`DGAUGE`, count | Number of ICMP messages throttled by global rate limits |
| `icmp_outratelimithost`
`DGAUGE`, count | Number of ICMP messages throttled by host-specific rate limits |
| `icmp_outredirects`
`DGAUGE`, count | Number of ICMP redirect messages sent |
| `icmp_outsrcquenchs`
`DGAUGE`, count | Number of ICMP source quench messages sent |
| `icmp_outtimeexcds`
`DGAUGE`, count | Number of ICMP time exceeded messages sent |
| `icmp_outtimestampreps`
`DGAUGE`, count | Number of ICMP timestamp reply messages sent |
| `icmp_outtimestamps`
`DGAUGE`, count | Number of ICMP timestamp (request) messages sent |
| `net.icmpmsg_intype5`
`DGAUGE`, count | Number of ICMP type 5 (redirect) messages received. |
| `net.icmpmsg_intype8`
`DGAUGE`, count | Number of ICMP type 8 (echo request) messages received |
| `net.icmpmsg_intype13`
`DGAUGE`, count | Number of ICMP type 13 (timestamp request) messages received. |
| `net.icmpmsg_outtype0`
`DGAUGE`, count | Number of ICMP type 0 (echo reply) messages sent |
| `net.icmpmsg_outtype3`
`DGAUGE`, count | Number of ICMP type 3 (destination unreachable) messages sent |
| `net.ip_defaultttl`
`DGAUGE`, string | Default TTL value inserted into the IP header for IP packets generated in this object when the transport layer protocol does not provide a TTL. |
| `net.ip_forwarding`
`DGAUGE` | IP forwarding status (SNMP): `0` for disabled, `1` for enabled. |
| `net.ip_forwdatagrams`
`DGAUGE`, count | Number of inbound packets not destined for this object, triggering an attempt to find a forwarding route to the final IP destination. For objects not acting as IP gateways, this count includes only those packets that were source-routed through them and where the source route option was successfully processed. |
| `net.ip_fragcreates`
`DGAUGE`, count | Number of IP packet fragments generated due to fragmentation in the object in question |
| `net.ip_fragfails`
`DGAUGE`, count | Number of IP packets dropped due to failed fragmentation which was required in this object, e.g., because of the `Do not fragment` flag being set. |
| `net.ip_fragoks`
`DGAUGE`, count | Number of successfully fragmented IP packets |
| `net.ip_inaddrerrors`
`DGAUGE`, count | Number of inbound packets dropped due to an invalid destination IP address in the IP header for the object in question. This count includes invalid addresses, such as `0.0.0.0`, and addresses of unsupported classes, e.g., Class E. For objects that do not act as IP gateways and therefore do not forward packets, this counter includes packets dropped because the destination address was not a local one. |
| `net.ip_indelivers`
`DGAUGE`, count | Total IP packets delivered |
| `net.ip_indiscards`
`DGAUGE`, count | Number of inbound IP packets encountering no issues preventing their further processing but still dropped, e.g., due to lack of buffer space. This counter does not include packets dropped while awaiting reassembly. |
| `net.ip_inhdrerrors`
`DGAUGE`, count | Number of inbound packets with header errors |
| `net.ip_inreceives`
`DGAUGE`, count | Total inbound packets received from interfaces, including those received in error |
| `net.ip_inunknownprotos`
`DGAUGE`, count | Number of unknown protocol packets received |
| `net.ip_outdiscards`
`DGAUGE`, count | Number of outgoing IP packets encountering no issues preventing their transmission to the destination but still dropped, e.g., due to lack of buffer space. Note that the counter would include packets counted in `ip_forwdatagrams` if they met this (discretionary) drop criterion. |
| `net.ip_outnoroutes`
`DGAUGE`, count | Number of IP packets dropped because no route to their destination was found. This metric tracks all packets counted in `ip_forwdatagrams` that meet this no-route criterion. This includes any packets a host cannot redirect because all its default gateways are down. |
| `net.ip_outrequests`
`DGAUGE`, count | Total IP packets provided by local IP user-level protocols (including ICMP) to IP in requests for transmission. This metric does not include the packets counted in `ip_forwdatagrams`. |
| `net.ip_reasmfails`
`DGAUGE`, count | Number of failures detected by the IP reassembly algorithm due to reasons, such as timeouts, errors, etc. This is not necessarily a count of dropped IP fragments, since certain algorithms, like the one in RFC 815, may lose count of fragments while reassembling them as they are received. |
| `net.ip_reasmoks`
`DGAUGE`, count | Number of IP packets successfully reassembled |
| `net.ip_reasmreqds`
`DGAUGE`, count | Number of received IP fragments requiring reassembly in the object in question |
| `net.ip_reasmtimeout`
`DGAUGE`, seconds | Maximum time, in seconds, received fragments are kept while awaiting reassembly in the object in question. |
| `net.speed`
`DGAUGE`, bits per second | Maximum network data transfer rate for this interface |
| `net.tcp_activeopens`
`DGAUGE`, count | Number of times TCP connections have made a direct transition from the `CLOSED` state to `SYN-SENT`. |
| `net.tcp_attemptfails`
`DGAUGE`, count | Number of times TCP connections have made a direct transition to the `CLOSED` state from either the `SYN-SENT` or `SYN-RCVD` state, plus the number of direct TCP connection transitions. |
| `net.tcp_currestab`
`DGAUGE`, count | Current number of TCP connections for the `ESTABLISHED` or `CLOSE WAIT` state |
| `net.tcp_estabresets`
`DGAUGE`, count | Number of times TCP connections have made a direct transition to the `CLOSED` state from either the `ESTABLISHED` or `CLOSE-WAIT` state. |
| `net.tcp_incsumerrors`
`DGAUGE`, count | This value increases when a received TCP packet has an invalid checksum. |
| `net.tcp_inerrs`
`DGAUGE`, count | Total segments received with an error, such as invalid TCP checksums |
| `net.tcp_insegs`
`DGAUGE`, count | Total segments received, including those received in error |
| `net.tcp_maxconn`
`DGAUGE`, count | Maximum allowed number of TCP connections |
| `net.tcp_outrsts`
`DGAUGE`, count | Number of TCP segments sent with the `RST` flag |
| `net.tcp_outsegs`
`DGAUGE`, count | Total TCP segments sent |
| `net.tcp_passiveopens`
`DGAUGE`, count | Number of times TCP connections have made a direct transition to the `SYN-RCVD` state from `LISTEN` |
| `net.tcp_retranssegs`
`DGAUGE`, count | Total segments retransmitted, i.e., number of TCP segments sent containing one or more previously transmitted octets. |
| `net.tcp_rtoalgorithm`
`DGAUGE` | Algorithm used to determine the timeout for retransmitting unacknowledged octets |
| `net.tcp_rtomax`
`DGAUGE`, milliseconds | Maximum TCP retransmission timeout, in milliseconds |
| `net.tcp_rtomin`
`DGAUGE`, milliseconds | Minimum TCP retransmission timeout, in milliseconds |
| `net.udp_ignoredmulti`
`DGAUGE`, count | Number of UDP multicast packets ignored |
| `net.udp_incsumerrors`
`DGAUGE`, count | This value increases when a received UDP packet contains an invalid kernel code checksum. |
| `net.udp_indatagrams`
`DGAUGE`, count | Total UDP packets received |
| `net.udp_inerrors`
`DGAUGE`, count | Number of bad UDP packets received, excluding those with checksum errors |
| `net.udp_memerrors`
`DGAUGE`, errors | Number of UDP out-of-memory errors |
| `net.udp_noports`
`DGAUGE`, count | Total UDP packets received with no application on the destination port |
| `net.udp_outdatagrams`
`DGAUGE`, count | Total UDP packets sent from the object in question |
| `net.udp_rcvbuferrors`
`DGAUGE`, count | Number of UDP receive buffer errors |
| `net.udp_sndbuferrors`
`DGAUGE`, count | Number of UDP send buffer errors |
| `net.udplite_ignoredmulti`
`DGAUGE`, count | Number of UDP-Lite multicast packets ignored |
| `net.udplite_incsumerrors`
`DGAUGE`, count | This value increases when a received UDP-Lite packet contains an invalid kernel code checksum. |
| `net.udplite_indatagrams`
`DGAUGE`, count | Total UDP-Lite packets received |
| `net.udplite_inerrors`
`DGAUGE`, count | Total UDP-Lite packet receive errors |
| `net.udplite_memerrors`
`DGAUGE`, errors | Number of UDP-Lite out-of-memory errors |
| `net.udplite_noports`
`DGAUGE`, count | Number of received UDP-Lite packets with no destination port found |
| `net.udplite_outdatagrams`
`DGAUGE`, count | Total UDP-Lite packets sent |
| `net.udplite_rcvbuferrors`
`DGAUGE`, count | Number of UDP-Lite receive buffer errors |
| `net.udplite_sndbuferrors`
`DGAUGE`, count | Number of UDP-Lite send buffer errors |
## Service metrics {#managed-spqr-metrics}
#### Cluster metrics {#managed-spqr-cluster-metrics}
| Name
Type, units | Description |
| ----- | ----- |
| `connections_to_host.`
`DGAUGE`, count | Number of active connections to the host with the specified FQDN |
| `core_dump.count`
`DGAUGE`, count | Number of core dumps |
| `dbaas_conf.cpu.fraction`
`DGAUGE`, fractions | Fraction of available CPU resources allocated by the service |
| `dbaas_conf.cpu.guarantee`
`DGAUGE`, fractions | Guaranteed fraction of CPU resources allocated by the service |
| `dbaas_conf.cpu.limit`
`DGAUGE`, fractions | Maximum allowed fraction of CPU resource usage |
| `dbaas_conf.hosts.ha`
`DGAUGE`, hosts | Number of hosts set up for high availability |
| `dbaas_conf.hosts.subcluster.spqr_coordinator.total`
`DGAUGE`, count | Number of hosts in the SPQR Coordinator subcluster |
| `dbaas_conf.hosts.subcluster.spqr_infra.total`
`DGAUGE`, count | Number of hosts in the SPQR Infra subcluster |
| `dbaas_conf.hosts.subcluster.spqr_router.total`
`DGAUGE`, count | Number of hosts in the SPQR Router subcluster |
| `dbaas_conf.hosts.total`
`DGAUGE`, count | Total hosts used by the service |
| `etcd_health.etcd-is_alive`
`DGAUGE`, count | `etcd` health status: `1` if it is enabled and operational, `0`, if unavailable or not responding. |
#### SPQR native metrics {#native-spqr-metrics}
| Name
Type, units | Description |
| ----- | ----- |
| `spqr_health.spqr_coordinator-is_alive`
`DGAUGE`, units | SPQR Coordinator health status: `1` if the host is active and operational, `0` if it is unavailable or not responding. |
| `spqr_health.spqr_router-is_alive`
`DGAUGE`, units | SPQR Router health status: `1` if the host is active and operational, `0` if it is unavailable or not responding. |
| `spqr_router_stats.active_connections`
`DGAUGE`, count | Number of active connections via SPQR Router |
| `spqr_router_stats.clients_count`
`DGAUGE`, count | Number of clients connected to SPQR Router |
| `spqr_router_stats.connections_count`
`DGAUGE`, count | Total number of connections processed by SPQR Router |
| `spqr_router_stats.connection_usage`
`DGAUGE`, fractions | Fraction of connections used by SPQR Router from the available limit |
| `spqr_router_stats.router_time_0.5`
`DGAUGE`, milliseconds | Median query processing time by SPQR Router, 50th percentile |
| `spqr_router_stats.router_time_0.75`
`DGAUGE`, milliseconds | Query processing time by SPQR Router, 75th percentile |
| `spqr_router_stats.router_time_0.9`
`DGAUGE`, milliseconds | Query processing time by SPQR Router, 90th percentile |
| `spqr_router_stats.router_time_0.95`
`DGAUGE`, milliseconds | Query processing time by SPQR Router, 95th percentile |
| `spqr_router_stats.router_time_0.99`
`DGAUGE`, milliseconds | Query processing time by SPQR Router, 99th percentile |
| `spqr_router_stats.router_time_0.999`
`DGAUGE`, milliseconds | Query processing time by SPQR Router, 99.9th percentile |
| `spqr_router_stats.router_time_0.9999`
`DGAUGE`, milliseconds | Query processing time by SPQR Router, 99.99th percentile |
| `spqr_router_stats.shard_time_0.5`
`DGAUGE`, milliseconds | Median query processing time on the shard, 50th percentile |
| `spqr_router_stats.shard_time_0.75`
`DGAUGE`, milliseconds | Query processing time on the shard, 75th percentile |
| `spqr_router_stats.shard_time_0.9`
`DGAUGE`, milliseconds | Query processing time on the shard, 90th percentile |
| `spqr_router_stats.shard_time_0.95`
`DGAUGE`, milliseconds | Query processing time on the shard, 95th percentile |
| `spqr_router_stats.shard_time_0.99`
`DGAUGE`, milliseconds | Query processing time on the shard, 99th percentile |
| `spqr_router_stats.shard_time_0.999`
`DGAUGE`, milliseconds | Query processing time on the shard, 99.9th percentile |
| `spqr_router_stats.shard_time_0.9999`
`DGAUGE`, milliseconds | Query processing time on the shard, 99.99th percentile |
| `spqr_router_stats.total_cancel_requests`
`DGAUGE`, count | Total number of canceled queries via SPQR Router. |
| `spqr_router_stats.total_connections_count`
`DGAUGE`, count | Total number of established connections via SPQR Router. |
#### System metrics {#managed-spqr-config-metrics}
| Name
Type, units | Description |
| ----- | ----- |
| `system.load.avg_1min`
`DGAUGE`, % | Average CPU load over one minute |
| `system.load.avg_5min`
`DGAUGE`, % | Average CPU load over five minutes |
| `system.load.avg_15min`
`DGAUGE`, % | Average CPU load over 15 minutes |
| `system.n_cpus`
`DGAUGE`, count | Maximum number of cores in use |
| `system.n_unique_users`
`DGAUGE`, users | Number of unique users or accounts engaging with the system |
| `system.n_users`
`DGAUGE`, count | Limit on the number of users |
| `system.uptime`
`DGAUGE`, % | Uptime percentage |