Search PostgreSQL documentation

pg_stat_progress_vacuum.phaseStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumCurrent processing phase of vacuum. See Table 27.52. pg_stat_progress_vacuum Current processing phase of vacuum. See Table 28.22. SELECT phase FROM pg_catalog.pg_stat_progress_vacuum; View … pg_stat_progress_vacuum.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumProcess ID of backend. pg_stat_progress_vacuum SELECT pid FROM pg_catalog.pg_stat_progress_vacuum; View pg_stat_progress_vacuum Field pid SQL type integer Units named in the field definitio… pg_stat_progress_vacuum.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumOID of the table being vacuumed. pg_stat_progress_vacuum SELECT relid FROM pg_catalog.pg_stat_progress_vacuum; View pg_stat_progress_vacuum Field relid SQL type oid Units named in the field… pg_stat_progress_vacuum.started_byStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumShows what caused the current VACUUM operation to be started. Possible values are: manual: The vacuum was started by an explicit VACUUM command. autovacuum: The vacuum was started by an aut… pg_stat_recovery.current_chunk_start_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_recoveryTime when the startup process observed that replay had caught up with the latest WAL chunk received from streaming replication. Used in recovery-conflict timing and replay/apply-lag diagnost… pg_stat_recovery.last_replayed_end_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_recoveryEnd write-ahead log location, plus one, of the last successfully replayed WAL record. pg_stat_recovery SELECT last_replayed_end_lsn FROM pg_catalog.pg_stat_recovery; View pg_stat_recovery F… pg_stat_recovery.last_replayed_read_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_recoveryStart write-ahead log location of the last successfully replayed WAL record. pg_stat_recovery SELECT last_replayed_read_lsn FROM pg_catalog.pg_stat_recovery; View pg_stat_recovery Field las… pg_stat_recovery.last_replayed_tliStatistics & MetricsWikiStatistics & Metrics · pg_stat_recoveryTimeline of the last successfully replayed WAL record. pg_stat_recovery SELECT last_replayed_tli FROM pg_catalog.pg_stat_recovery; View pg_stat_recovery Field last_replayed_tli SQL type int… pg_stat_recovery.pause_stateStatistics & MetricsWikiStatistics & Metrics · pg_stat_recoveryRecovery pause state. Possible values are: not paused: Recovery is proceeding normally. pause requested: A pause has been requested but recovery has not yet paused. paused: Recovery is paus… pg_stat_recovery.promote_triggeredStatistics & MetricsWikiStatistics & Metrics · pg_stat_recoveryTrue if a promotion has been triggered. pg_stat_recovery SELECT promote_triggered FROM pg_catalog.pg_stat_recovery; View pg_stat_recovery Field promote_triggered SQL type boolean Units name… pg_stat_recovery.recovery_last_xact_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_recoveryTimestamp of the last transaction commit or abort record replayed during recovery. This is the time at which the commit or abort WAL record for that transaction was generated on the primary.… pg_stat_recovery.replay_end_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_recoveryWrite-ahead log location of the record currently being replayed (end position plus one). When no record is being actively replayed, equals last_replayed_end_lsn. pg_stat_recovery SELECT rep… pg_stat_recovery.replay_end_tliStatistics & MetricsWikiStatistics & Metrics · pg_stat_recoveryTimeline of the WAL record currently being replayed. When no record is being actively replayed, equals last_replayed_tli. pg_stat_recovery SELECT replay_end_tli FROM pg_catalog.pg_stat_reco… pg_stat_recovery_prefetch.block_distanceStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchHow many blocks ahead the prefetcher is looking pg_stat_recovery_prefetch SELECT block_distance FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_prefetch Field block_distanc… pg_stat_recovery_prefetch.hitStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchNumber of blocks not prefetched because they were already in the buffer pool pg_stat_recovery_prefetch SELECT hit FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_prefetch F… pg_stat_recovery_prefetch.io_depthStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchHow many prefetches have been initiated but are not yet known to have completed pg_stat_recovery_prefetch SELECT io_depth FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_pr… pg_stat_recovery_prefetch.prefetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchNumber of blocks prefetched because they were not in the buffer pool pg_stat_recovery_prefetch SELECT prefetch FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_prefetch Fiel… pg_stat_recovery_prefetch.skip_fpwStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchNumber of blocks not prefetched because a full page image was included in the WAL pg_stat_recovery_prefetch SELECT skip_fpw FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_… pg_stat_recovery_prefetch.skip_initStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchNumber of blocks not prefetched because they would be zero-initialized pg_stat_recovery_prefetch SELECT skip_init FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_prefetch F… pg_stat_recovery_prefetch.skip_newStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchNumber of blocks not prefetched because they didn't exist yet pg_stat_recovery_prefetch SELECT skip_new FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_prefetch Field skip_… pg_stat_recovery_prefetch.skip_repStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchNumber of blocks not prefetched because they were already recently prefetched pg_stat_recovery_prefetch SELECT skip_rep FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_pref… pg_stat_recovery_prefetch.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchTime at which these statistics were last reset pg_stat_recovery_prefetch SELECT stats_reset FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_prefetch Field stats_reset SQL t… pg_stat_recovery_prefetch.wal_distanceStatistics & MetricsWikiStatistics & Metrics · pg_stat_recovery_prefetchHow many bytes ahead the prefetcher is looking pg_stat_recovery_prefetch SELECT wal_distance FROM pg_catalog.pg_stat_recovery_prefetch; View pg_stat_recovery_prefetch Field wal_distance SQL… pg_stat_replication.application_nameStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationName of the application that is connected to this WAL sender pg_stat_replication SELECT application_name FROM pg_catalog.pg_stat_replication; View pg_stat_replication Field application_name… pg_stat_replication.backend_startStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationTime when this process was started, i.e., when the client connected to this WAL sender pg_stat_replication SELECT backend_start FROM pg_catalog.pg_stat_replication; View pg_stat_replication… pg_stat_replication.backend_xminStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationThis standby's xmin horizon reported by hot_standby_feedback. This field will be null if a replication slot is used (in this case, the standby's xmin is shown in pg_replication_slots) or if … pg_stat_replication.client_addrStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationIP address of the client connected to this WAL sender. If this field is null, it indicates that the client is connected via a Unix socket on the server machine. pg_stat_replication SELECT c… pg_stat_replication.client_hostnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationHost name of the connected client, as reported by a reverse DNS lookup of client_addr. This field will only be non-null for IP connections, and only when log_hostname is enabled. pg_stat_re… pg_stat_replication.client_portStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationTCP port number that the client is using for communication with this WAL sender, or -1 if a Unix socket is used pg_stat_replication SELECT client_port FROM pg_catalog.pg_stat_replication; V… pg_stat_replication.flush_lagStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationTime elapsed between flushing recent WAL locally and receiving notification that this standby server has written and flushed it (but not yet applied it). This can be used to gauge the delay … pg_stat_replication.flush_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationLast write-ahead log location flushed to disk by this standby server pg_stat_replication SELECT flush_lsn FROM pg_catalog.pg_stat_replication; View pg_stat_replication Field flush_lsn SQL t… pg_stat_replication.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationProcess ID of a WAL sender process pg_stat_replication SELECT pid FROM pg_catalog.pg_stat_replication; View pg_stat_replication Field pid SQL type integer Units named in the field definitio… pg_stat_replication.replay_lagStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationTime elapsed between flushing recent WAL locally and receiving notification that this standby server has written, flushed and applied it. This can be used to gauge the delay that synchronous… pg_stat_replication.replay_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationLast write-ahead log location replayed into the database on this standby server pg_stat_replication SELECT replay_lsn FROM pg_catalog.pg_stat_replication; View pg_stat_replication Field rep… pg_stat_replication.reply_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationSend time of last reply message received from standby server pg_stat_replication SELECT reply_time FROM pg_catalog.pg_stat_replication; View pg_stat_replication Field reply_time SQL type ti… pg_stat_replication.sent_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationLast write-ahead log location sent on this connection pg_stat_replication SELECT sent_lsn FROM pg_catalog.pg_stat_replication; View pg_stat_replication Field sent_lsn SQL type pg_lsn Units … pg_stat_replication.stateStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationCurrent WAL sender state. Possible values are: startup: This WAL sender is starting up. catchup: This WAL sender's connected standby is catching up with the primary. streaming: This WAL sen… pg_stat_replication.sync_priorityStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationPriority of this standby server for being chosen as the synchronous standby in a priority-based synchronous replication. This has no effect in a quorum-based synchronous replication. pg_sta… pg_stat_replication.sync_stateStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationSynchronous state of this standby server. Possible values are: async: This standby server is asynchronous. potential: This standby server is now asynchronous, but can potentially become syn… pg_stat_replication.usenameStatistics & MetricsWikiStatistics & Metrics · pg_stat_replicationName of the user logged into this WAL sender process pg_stat_replication SELECT usename FROM pg_catalog.pg_stat_replication; View pg_stat_replication Field usename SQL type name Units named…