Search PostgreSQL documentation

pg_stat_replication.usesysidStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationOID of the user logged into this WAL sender process pg_stat_replication SELECT usesysid FROM pg_catalog.pg_stat_replication; View pg_stat_replication Field usesysid SQL type oid Units named… pg_stat_replication.write_lagStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationTime elapsed between flushing recent WAL locally and receiving notification that this standby server has written it (but not yet flushed it or applied it). This can be used to gauge the dela… pg_stat_replication.write_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationLast write-ahead log location written to disk by this standby server pg_stat_replication SELECT write_lsn FROM pg_catalog.pg_stat_replication; View pg_stat_replication Field write_lsn SQL t… pg_stat_replication_slots.mem_exceeded_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsNumber of times the memory used by logical decoding has exceeded logical_decoding_work_mem. pg_stat_replication_slots SELECT mem_exceeded_count FROM pg_catalog.pg_stat_replication_slots; Vi… pg_stat_replication_slots.slot_nameStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsA unique, cluster-wide identifier for the replication slot pg_stat_replication_slots SELECT slot_name FROM pg_catalog.pg_stat_replication_slots; View pg_stat_replication_slots Field slot_na… pg_stat_replication_slots.slotsync_last_skipStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsTime at which last slot synchronization was skipped. Slot synchronization occurs only on standby servers and thus this column has no meaning on the primary server. pg_stat_replication_slots… pg_stat_replication_slots.slotsync_skip_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsNumber of times the slot synchronization is skipped. Slot synchronization occurs only on standby servers and thus this column has no meaning on the primary server. pg_stat_replication_slots… pg_stat_replication_slots.spill_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsAmount of decoded transaction data spilled to disk while performing decoding of changes from WAL for this slot. This and other spill counters can be used to gauge the I/O which occurred duri… pg_stat_replication_slots.spill_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsNumber of times transactions were spilled to disk while decoding changes from WAL for this slot. This counter is incremented each time a transaction is spilled, and the same transaction may … pg_stat_replication_slots.spill_txnsStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsNumber of transactions spilled to disk once the memory used by logical decoding to decode changes from WAL has exceeded logical_decoding_work_mem. The counter gets incremented for both top-l… pg_stat_replication_slots.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsTime at which these statistics were last reset pg_stat_replication_slots SELECT stats_reset FROM pg_catalog.pg_stat_replication_slots; View pg_stat_replication_slots Field stats_reset SQL t… pg_stat_replication_slots.stream_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsAmount of transaction data decoded for streaming in-progress transactions to the decoding output plugin while decoding changes from WAL for this slot. This and other streaming counters for t… pg_stat_replication_slots.stream_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsNumber of times in-progress transactions were streamed to the decoding output plugin while decoding changes from WAL for this slot. This counter is incremented each time a transaction is str… pg_stat_replication_slots.stream_txnsStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsNumber of in-progress transactions streamed to the decoding output plugin after the memory used by logical decoding to decode changes from WAL for this slot has exceeded logical_decoding_wor… pg_stat_replication_slots.total_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsAmount of transaction data decoded for sending transactions to the decoding output plugin while decoding changes from WAL for this slot. Note that this includes data that is streamed and/or … pg_stat_replication_slots.total_txnsStatistics & MetricsWikiStatistics & Metrics · pg_stat_replication_slotsNumber of decoded transactions sent to the decoding output plugin for this slot. This counts top-level transactions only, and is not incremented for subtransactions. Note that this includes … pg_stat_slru.blks_existsStatistics & MetricsWikiStatistics & Metrics · pg_stat_slruNumber of blocks checked for existence for this SLRU pg_stat_slru SELECT blks_exists FROM pg_catalog.pg_stat_slru; View pg_stat_slru Field blks_exists SQL type bigint Units named in the fie… pg_stat_slru.blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_stat_slruNumber of times disk blocks were found already in the SLRU, so that a read was not necessary (this only includes hits in the SLRU, not the operating system's file system cache) pg_stat_slru… pg_stat_slru.blks_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_slruNumber of disk blocks read for this SLRU pg_stat_slru SELECT blks_read FROM pg_catalog.pg_stat_slru; View pg_stat_slru Field blks_read SQL type bigint Units named in the field definition bl… pg_stat_slru.blks_writtenStatistics & MetricsWikiStatistics & Metrics · pg_stat_slruNumber of disk blocks written for this SLRU pg_stat_slru SELECT blks_written FROM pg_catalog.pg_stat_slru; View pg_stat_slru Field blks_written SQL type bigint Units named in the field defi… pg_stat_slru.blks_zeroedStatistics & MetricsWikiStatistics & Metrics · pg_stat_slruNumber of blocks zeroed during initializations pg_stat_slru SELECT blks_zeroed FROM pg_catalog.pg_stat_slru; View pg_stat_slru Field blks_zeroed SQL type bigint Units named in the field def… pg_stat_slru.flushesStatistics & MetricsWikiStatistics & Metrics · pg_stat_slruNumber of flushes of dirty data for this SLRU pg_stat_slru SELECT flushes FROM pg_catalog.pg_stat_slru; View pg_stat_slru Field flushes SQL type bigint Units named in the field definition N… pg_stat_slru.nameStatistics & MetricsWikiStatistics & Metrics · pg_stat_slruName of the SLRU pg_stat_slru SELECT name FROM pg_catalog.pg_stat_slru; View pg_stat_slru Field name SQL type text Units named in the field definition Not specified Reset observation Time a… pg_stat_slru.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_slruTime at which these statistics were last reset pg_stat_slru SELECT stats_reset FROM pg_catalog.pg_stat_slru; View pg_stat_slru Field stats_reset SQL type timestamp with time zone Units name… pg_stat_slru.truncatesStatistics & MetricsWikiStatistics & Metrics · pg_stat_slruNumber of truncates for this SLRU pg_stat_slru SELECT truncates FROM pg_catalog.pg_stat_slru; View pg_stat_slru Field truncates SQL type bigint Units named in the field definition Not speci… pg_stat_ssl.bitsStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslNumber of bits in the encryption algorithm used, or NULL if SSL is not used on this connection pg_stat_ssl SELECT bits FROM pg_catalog.pg_stat_ssl; View pg_stat_ssl Field bits SQL type inte… pg_stat_ssl.cipherStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslName of SSL cipher in use, or NULL if SSL is not in use on this connection pg_stat_ssl SELECT cipher FROM pg_catalog.pg_stat_ssl; View pg_stat_ssl Field cipher SQL type text Units named in … pg_stat_ssl.client_dnStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslDistinguished Name (DN) field from the client certificate used, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated if the DN fi… pg_stat_ssl.client_serialStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslSerial number of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. The combination of certificate serial number and certificat… pg_stat_ssl.clientdnStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslDistinguished Name (DN) field from the client certificate used, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated if the DN fi… pg_stat_ssl.compressionStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslTrue if SSL compression is in use, false if not, or NULL if SSL is not in use on this connection pg_stat_ssl SELECT compression FROM pg_catalog.pg_stat_ssl; View pg_stat_ssl Field compressi… pg_stat_ssl.issuer_dnStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslDN of the issuer of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated like client_dn. pg_stat_ssl SEL… pg_stat_ssl.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslProcess ID of a backend or WAL sender process pg_stat_ssl SELECT pid FROM pg_catalog.pg_stat_ssl; View pg_stat_ssl Field pid SQL type integer Units named in the field definition Not specifi… pg_stat_ssl.sslStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslTrue if SSL is used on this connection pg_stat_ssl SELECT ssl FROM pg_catalog.pg_stat_ssl; View pg_stat_ssl Field ssl SQL type boolean Units named in the field definition Not specified Rese… pg_stat_ssl.versionStatistics & MetricsWikiStatistics & Metrics · pg_stat_sslVersion of SSL in use, or NULL if SSL is not in use on this connection pg_stat_ssl SELECT version FROM pg_catalog.pg_stat_ssl; View pg_stat_ssl Field version SQL type text Units named in th… pg_stat_subscription.last_msg_receipt_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionReceipt time of last message received from origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker pg_stat_subscription Receipt time of last message recei… pg_stat_subscription.last_msg_send_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionSend time of last message received from origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker pg_stat_subscription Send time of last message received fr… pg_stat_subscription.latest_end_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionLast write-ahead log location reported to origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker pg_stat_subscription Last write-ahead log location repor… pg_stat_subscription.latest_end_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionTime of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker pg_stat_subscription Time of last write-ahead lo… pg_stat_subscription.leader_pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionProcess ID of the leader apply worker if this process is a parallel apply worker; NULL if this process is a leader apply worker, a table synchronization worker or a sequence synchronization …