Wiki / Statistics & Metrics

Individually addressable statistics and progress fields, definitions, units and reset context.

Reading PostgreSQL 18.6.

Find an entry GroupAll groupspg_stat_activity (22)pg_stat_all_indexes (10)pg_stat_all_tables (31)pg_stat_archiver (7)pg_stat_autovacuum_scores (12)pg_stat_bgwriter (11)pg_stat_checkpointer (11)pg_stat_database (30)pg_stat_database_conflicts (9)pg_stat_gssapi (5)pg_stat_io (21)pg_stat_kind_info (7)pg_stat_lock (5)pg_stat_progress_analyze (14)pg_stat_progress_basebackup (7)pg_stat_progress_cluster (12)pg_stat_progress_copy (11)pg_stat_progress_create_index (16)pg_stat_progress_data_checksums (10)pg_stat_progress_repack (14)pg_stat_progress_vacuum (19)pg_stat_recovery (9)pg_stat_recovery_prefetch (10)pg_stat_replication (20)pg_stat_replication_slots (13)pg_stat_slru (9)pg_stat_ssl (10)pg_stat_subscription (11)pg_stat_subscription_stats (15)pg_stat_sys_indexes (10)pg_stat_sys_tables (31)pg_stat_user_functions (7)pg_stat_user_indexes (10)pg_stat_user_tables (31)pg_stat_wal (10)pg_stat_wal_receiver (16)pg_stat_xact_all_tables (12)pg_stat_xact_sys_tables (12)pg_stat_xact_user_functions (6)pg_stat_xact_user_tables (12)pg_statio_all_indexes (8)pg_statio_all_sequences (6)pg_statio_all_tables (12)pg_statio_sys_indexes (8)pg_statio_sys_sequences (6)pg_statio_sys_tables (12)pg_statio_user_indexes (8)pg_statio_user_sequences (6)pg_statio_user_tables (12) Apply

616 entries; 514 recorded in PostgreSQL 18.6.

• pg_stat_recovery_prefetch.skip_rep pg_stat_recovery_prefetch

  Number of blocks not prefetched because they were already recently prefetched

  1011121314151617181920
• pg_stat_recovery_prefetch.stats_reset pg_stat_recovery_prefetch

  Time at which these statistics were last reset

  1011121314151617181920
• pg_stat_recovery_prefetch.wal_distance pg_stat_recovery_prefetch

  How many bytes ahead the prefetcher is looking

  1011121314151617181920
• pg_stat_replication.application_name pg_stat_replication

  Name of the application that is connected to this WAL sender

  1011121314151617181920
• pg_stat_replication.backend_start pg_stat_replication

  Time when this process was started, i.e., when the client connected to this WAL sender

  1011121314151617181920
• pg_stat_replication.backend_xmin pg_stat_replication

  This standby's xmin horizon reported by hot_standby_feedback.

  1011121314151617181920
• pg_stat_replication.client_addr pg_stat_replication

  IP 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.

  1011121314151617181920
• pg_stat_replication.client_hostname pg_stat_replication

  Host 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.

  1011121314151617181920
• pg_stat_replication.client_port pg_stat_replication

  TCP port number that the client is using for communication with this WAL sender, or -1 if a Unix socket is used

  1011121314151617181920
• pg_stat_replication.flush_lag pg_stat_replication

  Time 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 that synchronous_commit level on incurred while committing …

  1011121314151617181920
• pg_stat_replication.flush_lsn pg_stat_replication

  Last write-ahead log location flushed to disk by this standby server

  1011121314151617181920
• pg_stat_replication.pid pg_stat_replication

  Process ID of a WAL sender process

  1011121314151617181920
• pg_stat_replication.replay_lag pg_stat_replication

  Time 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_commit level remote_apply incurred while committing if thi…

  1011121314151617181920
• pg_stat_replication.replay_lsn pg_stat_replication

  Last write-ahead log location replayed into the database on this standby server

  1011121314151617181920
• pg_stat_replication.reply_time pg_stat_replication

  Send time of last reply message received from standby server

  1011121314151617181920
• pg_stat_replication.sent_lsn pg_stat_replication

  Last write-ahead log location sent on this connection

  1011121314151617181920
• pg_stat_replication.state pg_stat_replication

  Current 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 sender is streaming changes after its connected standby server…

  1011121314151617181920
• pg_stat_replication.sync_priority pg_stat_replication

  Priority 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.

  1011121314151617181920
• pg_stat_replication.sync_state pg_stat_replication

  Synchronous 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 synchronous if one of current synchronous ones fails. sync: Th…

  1011121314151617181920
• pg_stat_replication.usename pg_stat_replication

  Name of the user logged into this WAL sender process

  1011121314151617181920
• pg_stat_replication.usesysid pg_stat_replication

  OID of the user logged into this WAL sender process

  1011121314151617181920
• pg_stat_replication.write_lag pg_stat_replication

  Time 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 delay that synchronous_commit level remote_write incurred while…

  1011121314151617181920
• pg_stat_replication.write_lsn pg_stat_replication

  Last write-ahead log location written to disk by this standby server

  1011121314151617181920
• pg_stat_replication_slots.mem_exceeded_count pg_stat_replication_slots not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_replication_slots.slot_name pg_stat_replication_slots

  A unique, cluster-wide identifier for the replication slot

  1011121314151617181920
• pg_stat_replication_slots.slotsync_last_skip pg_stat_replication_slots not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_replication_slots.slotsync_skip_count pg_stat_replication_slots not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_replication_slots.spill_bytes pg_stat_replication_slots

  Amount 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 during logical decoding and allow tuning logical_decoding_work_…

  1011121314151617181920
• pg_stat_replication_slots.spill_count pg_stat_replication_slots

  Number 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 be spilled multiple times.

  1011121314151617181920
• pg_stat_replication_slots.spill_txns pg_stat_replication_slots

  Number 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-level transactions and subtransactions.

  1011121314151617181920
• pg_stat_replication_slots.stats_reset pg_stat_replication_slots

  Time at which these statistics were last reset

  1011121314151617181920
• pg_stat_replication_slots.stream_bytes pg_stat_replication_slots

  Amount 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 this slot can be used to tune logical_decoding_work_mem.

  1011121314151617181920
• pg_stat_replication_slots.stream_count pg_stat_replication_slots

  Number 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 streamed, and the same transaction may be streamed multiple ti…

  1011121314151617181920
• pg_stat_replication_slots.stream_txns pg_stat_replication_slots

  Number 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_work_mem. Streaming only works with top-level transactions (su…

  1011121314151617181920
• pg_stat_replication_slots.total_bytes pg_stat_replication_slots

  Amount 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 spilled.

  1011121314151617181920
• pg_stat_replication_slots.total_txns pg_stat_replication_slots

  Number 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 the transactions that are streamed and/or spilled.

  1011121314151617181920
• pg_stat_slru.blks_exists pg_stat_slru

  Number of blocks checked for existence for this SLRU

  1011121314151617181920
• pg_stat_slru.blks_hit pg_stat_slru

  Number 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)

  1011121314151617181920
• pg_stat_slru.blks_read pg_stat_slru

  Number of disk blocks read for this SLRU

  1011121314151617181920
• pg_stat_slru.blks_written pg_stat_slru

  Number of disk blocks written for this SLRU

  1011121314151617181920
• pg_stat_slru.blks_zeroed pg_stat_slru

  Number of blocks zeroed during initializations

  1011121314151617181920
• pg_stat_slru.flushes pg_stat_slru

  Number of flushes of dirty data for this SLRU

  1011121314151617181920
• pg_stat_slru.name pg_stat_slru

  Name of the SLRU

  1011121314151617181920
• pg_stat_slru.stats_reset pg_stat_slru

  Time at which these statistics were last reset

  1011121314151617181920
• pg_stat_slru.truncates pg_stat_slru

  Number of truncates for this SLRU

  1011121314151617181920
• pg_stat_ssl.bits pg_stat_ssl

  Number of bits in the encryption algorithm used, or NULL if SSL is not used on this connection

  1011121314151617181920
• pg_stat_ssl.cipher pg_stat_ssl

  Name of SSL cipher in use, or NULL if SSL is not in use on this connection

  1011121314151617181920
• pg_stat_ssl.client_dn pg_stat_ssl

  Distinguished 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 field is longer than NAMEDATALEN (64 characters in a standard…

  1011121314151617181920
• pg_stat_ssl.client_serial pg_stat_ssl

  Serial 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 certificate issuer uniquely identifies a certificate (unless the issu…

  1011121314151617181920
• pg_stat_ssl.clientdn pg_stat_ssl not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_ssl.compression pg_stat_ssl not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_ssl.issuer_dn pg_stat_ssl

  DN 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.

  1011121314151617181920
• pg_stat_ssl.pid pg_stat_ssl

  Process ID of a backend or WAL sender process

  1011121314151617181920
• pg_stat_ssl.ssl pg_stat_ssl

  True if SSL is used on this connection

  1011121314151617181920
• pg_stat_ssl.version pg_stat_ssl

  Version of SSL in use, or NULL if SSL is not in use on this connection

  1011121314151617181920
• pg_stat_subscription.last_msg_receipt_time pg_stat_subscription

  Receipt time of last message received from origin WAL sender; NULL for parallel apply workers

  1011121314151617181920
• pg_stat_subscription.last_msg_send_time pg_stat_subscription

  Send time of last message received from origin WAL sender; NULL for parallel apply workers

  1011121314151617181920
• pg_stat_subscription.latest_end_lsn pg_stat_subscription

  Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers

  1011121314151617181920
• pg_stat_subscription.latest_end_time pg_stat_subscription

  Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers

  1011121314151617181920
• pg_stat_subscription.leader_pid pg_stat_subscription

  Process ID of the leader apply worker if this process is a parallel apply worker; NULL if this process is a leader apply worker or a table synchronization worker

  1011121314151617181920
• pg_stat_subscription.pid pg_stat_subscription

  Process ID of the subscription worker process

  1011121314151617181920
• pg_stat_subscription.received_lsn pg_stat_subscription

  Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers

  1011121314151617181920
• pg_stat_subscription.relid pg_stat_subscription

  OID of the relation that the worker is synchronizing; NULL for the leader apply worker and parallel apply workers

  1011121314151617181920
• pg_stat_subscription.subid pg_stat_subscription

  OID of the subscription

  1011121314151617181920
• pg_stat_subscription.subname pg_stat_subscription

  Name of the subscription

  1011121314151617181920
• pg_stat_subscription.worker_type pg_stat_subscription

  Type of the subscription worker process. Possible types are apply, parallel apply, and table synchronization.

  1011121314151617181920
• pg_stat_subscription_stats.apply_error_count pg_stat_subscription_stats

  Number of times an error occurred while applying changes. Note that any conflict resulting in an apply error will be counted in both apply_error_count and the corresponding conflict count (e.g., confl_*).

  1011121314151617181920
• pg_stat_subscription_stats.confl_delete_missing pg_stat_subscription_stats

  Number of times the tuple to be deleted was not found during the application of changes. See delete_missing for details about this conflict.

  1011121314151617181920
• pg_stat_subscription_stats.confl_delete_origin_differs pg_stat_subscription_stats

  Number of times a delete operation was applied to row that had been previously modified by another source during the application of changes. See delete_origin_differs for details about this conflict.

  1011121314151617181920
• pg_stat_subscription_stats.confl_insert_exists pg_stat_subscription_stats

  Number of times a row insertion violated a NOT DEFERRABLE unique constraint during the application of changes. See insert_exists for details about this conflict.

  1011121314151617181920
• pg_stat_subscription_stats.confl_multiple_unique_conflicts pg_stat_subscription_stats

  Number of times a row insertion or an updated row values violated multiple NOT DEFERRABLE unique constraints during the application of changes. See multiple_unique_conflicts for details about this conflict.

  1011121314151617181920
• pg_stat_subscription_stats.confl_update_deleted pg_stat_subscription_stats not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_subscription_stats.confl_update_exists pg_stat_subscription_stats

  Number of times that an updated row value violated a NOT DEFERRABLE unique constraint during the application of changes. See update_exists for details about this conflict.

  1011121314151617181920
• pg_stat_subscription_stats.confl_update_missing pg_stat_subscription_stats

  Number of times the tuple to be updated was not found during the application of changes. See update_missing for details about this conflict.

  1011121314151617181920
• pg_stat_subscription_stats.confl_update_origin_differs pg_stat_subscription_stats

  Number of times an update was applied to a row that had been previously modified by another source during the application of changes. See update_origin_differs for details about this conflict.

  1011121314151617181920
• pg_stat_subscription_stats.stats_reset pg_stat_subscription_stats

  Time at which these statistics were last reset

  1011121314151617181920
• pg_stat_subscription_stats.subid pg_stat_subscription_stats

  OID of the subscription

  1011121314151617181920
• pg_stat_subscription_stats.subname pg_stat_subscription_stats

  Name of the subscription

  1011121314151617181920
• pg_stat_subscription_stats.sync_error_count pg_stat_subscription_stats

  Number of times an error occurred during the initial table synchronization

  1011121314151617181920
• pg_stat_subscription_stats.sync_seq_error_count pg_stat_subscription_stats not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_subscription_stats.sync_table_error_count pg_stat_subscription_stats not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_sys_indexes.idx_scan pg_stat_sys_indexes

  Number of index scans initiated on this index

  1011121314151617181920
• pg_stat_sys_indexes.idx_tup_fetch pg_stat_sys_indexes

  Number of live table rows fetched by simple index scans using this index

  1011121314151617181920
• pg_stat_sys_indexes.idx_tup_read pg_stat_sys_indexes

  Number of index entries returned by scans on this index

  1011121314151617181920
• pg_stat_sys_indexes.indexrelid pg_stat_sys_indexes

  OID of this index

  1011121314151617181920
• pg_stat_sys_indexes.indexrelname pg_stat_sys_indexes

  Name of this index

  1011121314151617181920
• pg_stat_sys_indexes.last_idx_scan pg_stat_sys_indexes

  The time of the last scan on this index, based on the most recent transaction stop time

  1011121314151617181920
• pg_stat_sys_indexes.relid pg_stat_sys_indexes

  OID of the table for this index

  1011121314151617181920
• pg_stat_sys_indexes.relname pg_stat_sys_indexes

  Name of the table for this index

  1011121314151617181920
• pg_stat_sys_indexes.schemaname pg_stat_sys_indexes

  Name of the schema this index is in

  1011121314151617181920
• pg_stat_sys_indexes.stats_reset pg_stat_sys_indexes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_sys_tables.analyze_count pg_stat_sys_tables

  Number of times this table has been manually analyzed

  1011121314151617181920
• pg_stat_sys_tables.autoanalyze_count pg_stat_sys_tables

  Number of times this table has been analyzed by the autovacuum daemon

  1011121314151617181920
• pg_stat_sys_tables.autovacuum_count pg_stat_sys_tables

  Number of times this table has been vacuumed by the autovacuum daemon

  1011121314151617181920
• pg_stat_sys_tables.idx_scan pg_stat_sys_tables

  Number of index scans initiated on this table

  1011121314151617181920
• pg_stat_sys_tables.idx_tup_fetch pg_stat_sys_tables

  Number of live rows fetched by index scans

  1011121314151617181920
• pg_stat_sys_tables.last_analyze pg_stat_sys_tables

  Last time at which this table was manually analyzed

  1011121314151617181920
• pg_stat_sys_tables.last_autoanalyze pg_stat_sys_tables

  Last time at which this table was analyzed by the autovacuum daemon

  1011121314151617181920
• pg_stat_sys_tables.last_autovacuum pg_stat_sys_tables

  Last time at which this table was vacuumed by the autovacuum daemon

  1011121314151617181920
• pg_stat_sys_tables.last_idx_scan pg_stat_sys_tables

  The time of the last index scan on this table, based on the most recent transaction stop time

  1011121314151617181920

RecordedFirst recordedInterface or attribute changeNo longer recorded

Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.

Changes in PostgreSQL 18.6 · Export JSON

Reading this collection

Each field retains its view and source context. Units, collection and reset behavior are recorded only where supported by evidence. Example queries do not assert measured values, and current-state fields must not be treated as cumulative counters.