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_sys_tables.last_seq_scan pg_stat_sys_tables

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

  1011121314151617181920
• pg_stat_sys_tables.last_vacuum pg_stat_sys_tables

  Last time at which this table was manually vacuumed (not counting VACUUM FULL)

  1011121314151617181920
• pg_stat_sys_tables.n_dead_tup pg_stat_sys_tables

  Estimated number of dead rows

  1011121314151617181920
• pg_stat_sys_tables.n_ins_since_vacuum pg_stat_sys_tables

  Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)

  1011121314151617181920
• pg_stat_sys_tables.n_live_tup pg_stat_sys_tables

  Estimated number of live rows

  1011121314151617181920
• pg_stat_sys_tables.n_mod_since_analyze pg_stat_sys_tables

  Estimated number of rows modified since this table was last analyzed

  1011121314151617181920
• pg_stat_sys_tables.n_tup_del pg_stat_sys_tables

  Total number of rows deleted

  1011121314151617181920
• pg_stat_sys_tables.n_tup_hot_upd pg_stat_sys_tables

  Number of rows HOT updated. These are updates where no successor versions are required in indexes.

  1011121314151617181920
• pg_stat_sys_tables.n_tup_ins pg_stat_sys_tables

  Total number of rows inserted

  1011121314151617181920
• pg_stat_sys_tables.n_tup_newpage_upd pg_stat_sys_tables

  Number of rows updated where the successor version goes onto a new heap page, leaving behind an original version with a t_ctid field that points to a different heap page. These are always non-HOT updates.

  1011121314151617181920
• pg_stat_sys_tables.n_tup_upd pg_stat_sys_tables

  Total number of rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.)

  1011121314151617181920
• pg_stat_sys_tables.relid pg_stat_sys_tables

  OID of a table

  1011121314151617181920
• pg_stat_sys_tables.relname pg_stat_sys_tables

  Name of this table

  1011121314151617181920
• pg_stat_sys_tables.schemaname pg_stat_sys_tables

  Name of the schema that this table is in

  1011121314151617181920
• pg_stat_sys_tables.seq_scan pg_stat_sys_tables

  Number of sequential scans initiated on this table

  1011121314151617181920
• pg_stat_sys_tables.seq_tup_read pg_stat_sys_tables

  Number of live rows fetched by sequential scans

  1011121314151617181920
• pg_stat_sys_tables.stats_reset pg_stat_sys_tables not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_sys_tables.total_analyze_time pg_stat_sys_tables

  Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  1011121314151617181920
• pg_stat_sys_tables.total_autoanalyze_time pg_stat_sys_tables

  Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  1011121314151617181920
• pg_stat_sys_tables.total_autovacuum_time pg_stat_sys_tables

  Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  1011121314151617181920
• pg_stat_sys_tables.total_vacuum_time pg_stat_sys_tables

  Total time this table has been manually vacuumed, in milliseconds (not counting VACUUM FULL). (This includes the time spent sleeping due to cost-based delays.)

  1011121314151617181920
• pg_stat_sys_tables.vacuum_count pg_stat_sys_tables

  Number of times this table has been manually vacuumed (not counting VACUUM FULL)

  1011121314151617181920
• pg_stat_user_functions.calls pg_stat_user_functions

  Number of times this function has been called

  1011121314151617181920
• pg_stat_user_functions.funcid pg_stat_user_functions

  OID of a function

  1011121314151617181920
• pg_stat_user_functions.funcname pg_stat_user_functions

  Name of this function

  1011121314151617181920
• pg_stat_user_functions.schemaname pg_stat_user_functions

  Name of the schema this function is in

  1011121314151617181920
• pg_stat_user_functions.self_time pg_stat_user_functions

  Total time spent in this function itself, not including other functions called by it, in milliseconds

  1011121314151617181920
• pg_stat_user_functions.stats_reset pg_stat_user_functions not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_user_functions.total_time pg_stat_user_functions

  Total time spent in this function and all other functions called by it, in milliseconds

  1011121314151617181920
• pg_stat_user_indexes.idx_scan pg_stat_user_indexes

  Number of index scans initiated on this index

  1011121314151617181920
• pg_stat_user_indexes.idx_tup_fetch pg_stat_user_indexes

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

  1011121314151617181920
• pg_stat_user_indexes.idx_tup_read pg_stat_user_indexes

  Number of index entries returned by scans on this index

  1011121314151617181920
• pg_stat_user_indexes.indexrelid pg_stat_user_indexes

  OID of this index

  1011121314151617181920
• pg_stat_user_indexes.indexrelname pg_stat_user_indexes

  Name of this index

  1011121314151617181920
• pg_stat_user_indexes.last_idx_scan pg_stat_user_indexes

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

  1011121314151617181920
• pg_stat_user_indexes.relid pg_stat_user_indexes

  OID of the table for this index

  1011121314151617181920
• pg_stat_user_indexes.relname pg_stat_user_indexes

  Name of the table for this index

  1011121314151617181920
• pg_stat_user_indexes.schemaname pg_stat_user_indexes

  Name of the schema this index is in

  1011121314151617181920
• pg_stat_user_indexes.stats_reset pg_stat_user_indexes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_user_tables.analyze_count pg_stat_user_tables

  Number of times this table has been manually analyzed

  1011121314151617181920
• pg_stat_user_tables.autoanalyze_count pg_stat_user_tables

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

  1011121314151617181920
• pg_stat_user_tables.autovacuum_count pg_stat_user_tables

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

  1011121314151617181920
• pg_stat_user_tables.idx_scan pg_stat_user_tables

  Number of index scans initiated on this table

  1011121314151617181920
• pg_stat_user_tables.idx_tup_fetch pg_stat_user_tables

  Number of live rows fetched by index scans

  1011121314151617181920
• pg_stat_user_tables.last_analyze pg_stat_user_tables

  Last time at which this table was manually analyzed

  1011121314151617181920
• pg_stat_user_tables.last_autoanalyze pg_stat_user_tables

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

  1011121314151617181920
• pg_stat_user_tables.last_autovacuum pg_stat_user_tables

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

  1011121314151617181920
• pg_stat_user_tables.last_idx_scan pg_stat_user_tables

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

  1011121314151617181920
• pg_stat_user_tables.last_seq_scan pg_stat_user_tables

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

  1011121314151617181920
• pg_stat_user_tables.last_vacuum pg_stat_user_tables

  Last time at which this table was manually vacuumed (not counting VACUUM FULL)

  1011121314151617181920
• pg_stat_user_tables.n_dead_tup pg_stat_user_tables

  Estimated number of dead rows

  1011121314151617181920
• pg_stat_user_tables.n_ins_since_vacuum pg_stat_user_tables

  Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)

  1011121314151617181920
• pg_stat_user_tables.n_live_tup pg_stat_user_tables

  Estimated number of live rows

  1011121314151617181920
• pg_stat_user_tables.n_mod_since_analyze pg_stat_user_tables

  Estimated number of rows modified since this table was last analyzed

  1011121314151617181920
• pg_stat_user_tables.n_tup_del pg_stat_user_tables

  Total number of rows deleted

  1011121314151617181920
• pg_stat_user_tables.n_tup_hot_upd pg_stat_user_tables

  Number of rows HOT updated. These are updates where no successor versions are required in indexes.

  1011121314151617181920
• pg_stat_user_tables.n_tup_ins pg_stat_user_tables

  Total number of rows inserted

  1011121314151617181920
• pg_stat_user_tables.n_tup_newpage_upd pg_stat_user_tables

  Number of rows updated where the successor version goes onto a new heap page, leaving behind an original version with a t_ctid field that points to a different heap page. These are always non-HOT updates.

  1011121314151617181920
• pg_stat_user_tables.n_tup_upd pg_stat_user_tables

  Total number of rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.)

  1011121314151617181920
• pg_stat_user_tables.relid pg_stat_user_tables

  OID of a table

  1011121314151617181920
• pg_stat_user_tables.relname pg_stat_user_tables

  Name of this table

  1011121314151617181920
• pg_stat_user_tables.schemaname pg_stat_user_tables

  Name of the schema that this table is in

  1011121314151617181920
• pg_stat_user_tables.seq_scan pg_stat_user_tables

  Number of sequential scans initiated on this table

  1011121314151617181920
• pg_stat_user_tables.seq_tup_read pg_stat_user_tables

  Number of live rows fetched by sequential scans

  1011121314151617181920
• pg_stat_user_tables.stats_reset pg_stat_user_tables not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_user_tables.total_analyze_time pg_stat_user_tables

  Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  1011121314151617181920
• pg_stat_user_tables.total_autoanalyze_time pg_stat_user_tables

  Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  1011121314151617181920
• pg_stat_user_tables.total_autovacuum_time pg_stat_user_tables

  Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  1011121314151617181920
• pg_stat_user_tables.total_vacuum_time pg_stat_user_tables

  Total time this table has been manually vacuumed, in milliseconds (not counting VACUUM FULL). (This includes the time spent sleeping due to cost-based delays.)

  1011121314151617181920
• pg_stat_user_tables.vacuum_count pg_stat_user_tables

  Number of times this table has been manually vacuumed (not counting VACUUM FULL)

  1011121314151617181920
• pg_stat_wal.stats_reset pg_stat_wal

  Time at which these statistics were last reset

  1011121314151617181920
• pg_stat_wal.wal_buffers_full pg_stat_wal

  Number of times WAL data was written to disk because WAL buffers became full

  1011121314151617181920
• pg_stat_wal.wal_bytes pg_stat_wal

  Total amount of WAL generated in bytes

  1011121314151617181920
• pg_stat_wal.wal_fpi pg_stat_wal

  Total number of WAL full page images generated

  1011121314151617181920
• pg_stat_wal.wal_fpi_bytes pg_stat_wal not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_wal.wal_records pg_stat_wal

  Total number of WAL records generated

  1011121314151617181920
• pg_stat_wal.wal_sync pg_stat_wal not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_wal.wal_sync_time pg_stat_wal not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_wal.wal_write pg_stat_wal not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_wal.wal_write_time pg_stat_wal not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_wal_receiver.conninfo pg_stat_wal_receiver

  Connection string used by this WAL receiver, with security-sensitive fields obfuscated.

  1011121314151617181920
• pg_stat_wal_receiver.flushed_lsn pg_stat_wal_receiver

  Last write-ahead log location already received and flushed to disk, the initial value of this field being the first log location used when WAL receiver is started

  1011121314151617181920
• pg_stat_wal_receiver.last_msg_receipt_time pg_stat_wal_receiver

  Receipt time of last message received from origin WAL sender

  1011121314151617181920
• pg_stat_wal_receiver.last_msg_send_time pg_stat_wal_receiver

  Send time of last message received from origin WAL sender

  1011121314151617181920
• pg_stat_wal_receiver.latest_end_lsn pg_stat_wal_receiver

  Last write-ahead log location reported to origin WAL sender

  1011121314151617181920
• pg_stat_wal_receiver.latest_end_time pg_stat_wal_receiver

  Time of last write-ahead log location reported to origin WAL sender

  1011121314151617181920
• pg_stat_wal_receiver.pid pg_stat_wal_receiver

  Process ID of the WAL receiver process

  1011121314151617181920
• pg_stat_wal_receiver.receive_start_lsn pg_stat_wal_receiver

  First write-ahead log location used when WAL receiver is started

  1011121314151617181920
• pg_stat_wal_receiver.receive_start_tli pg_stat_wal_receiver

  First timeline number used when WAL receiver is started

  1011121314151617181920
• pg_stat_wal_receiver.received_lsn pg_stat_wal_receiver not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_wal_receiver.received_tli pg_stat_wal_receiver

  Timeline number of last write-ahead log location received and flushed to disk, the initial value of this field being the timeline number of the first log location used when WAL receiver is started

  1011121314151617181920
• pg_stat_wal_receiver.sender_host pg_stat_wal_receiver

  Host of the PostgreSQL instance this WAL receiver is connected to. This can be a host name, an IP address, or a directory path if the connection is via Unix socket. (The path case can be distinguished because it will always be an absolute path, begi…

  1011121314151617181920
• pg_stat_wal_receiver.sender_port pg_stat_wal_receiver

  Port number of the PostgreSQL instance this WAL receiver is connected to.

  1011121314151617181920
• pg_stat_wal_receiver.slot_name pg_stat_wal_receiver

  Replication slot name used by this WAL receiver

  1011121314151617181920
• pg_stat_wal_receiver.status pg_stat_wal_receiver

  Activity status of the WAL receiver process

  1011121314151617181920
• pg_stat_wal_receiver.written_lsn pg_stat_wal_receiver

  Last write-ahead log location already received and written to disk, but not flushed. This should not be used for data integrity checks.

  1011121314151617181920
• pg_stat_xact_all_tables.idx_scan pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.idx_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.

  1011121314151617181920
• pg_stat_xact_all_tables.idx_tup_fetch pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.idx_tup_fetch. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.

  1011121314151617181920
• pg_stat_xact_all_tables.n_tup_del pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.n_tup_del. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.

  1011121314151617181920
• pg_stat_xact_all_tables.n_tup_hot_upd pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.

  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.