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_xact_all_tables.n_tup_ins pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.n_tup_ins. 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_newpage_upd pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.n_tup_newpage_upd. 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_upd pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.n_tup_upd. 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.relid pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.relid. 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.relname pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.relname. 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.schemaname pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.schemaname. 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.seq_scan pg_stat_xact_all_tables

  Source-defined field pg_stat_xact_all_tables.seq_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.seq_tup_read pg_stat_xact_all_tables

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

  1011121314151617181920
• pg_stat_xact_sys_tables.idx_scan pg_stat_xact_sys_tables

  Source-defined field pg_stat_xact_sys_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_sys_tables.idx_tup_fetch pg_stat_xact_sys_tables

  Source-defined field pg_stat_xact_sys_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_sys_tables.n_tup_del pg_stat_xact_sys_tables

  Source-defined field pg_stat_xact_sys_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_sys_tables.n_tup_hot_upd pg_stat_xact_sys_tables

  Source-defined field pg_stat_xact_sys_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
• pg_stat_xact_sys_tables.n_tup_ins pg_stat_xact_sys_tables

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

  1011121314151617181920
• pg_stat_xact_sys_tables.n_tup_newpage_upd pg_stat_xact_sys_tables

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

  1011121314151617181920
• pg_stat_xact_sys_tables.n_tup_upd pg_stat_xact_sys_tables

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

  1011121314151617181920
• pg_stat_xact_sys_tables.relid pg_stat_xact_sys_tables

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

  1011121314151617181920
• pg_stat_xact_sys_tables.relname pg_stat_xact_sys_tables

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

  1011121314151617181920
• pg_stat_xact_sys_tables.schemaname pg_stat_xact_sys_tables

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

  1011121314151617181920
• pg_stat_xact_sys_tables.seq_scan pg_stat_xact_sys_tables

  Source-defined field pg_stat_xact_sys_tables.seq_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_sys_tables.seq_tup_read pg_stat_xact_sys_tables

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

  1011121314151617181920
• pg_stat_xact_user_functions.calls pg_stat_xact_user_functions

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

  1011121314151617181920
• pg_stat_xact_user_functions.funcid pg_stat_xact_user_functions

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

  1011121314151617181920
• pg_stat_xact_user_functions.funcname pg_stat_xact_user_functions

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

  1011121314151617181920
• pg_stat_xact_user_functions.schemaname pg_stat_xact_user_functions

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

  1011121314151617181920
• pg_stat_xact_user_functions.self_time pg_stat_xact_user_functions

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

  1011121314151617181920
• pg_stat_xact_user_functions.total_time pg_stat_xact_user_functions

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

  1011121314151617181920
• pg_stat_xact_user_tables.idx_scan pg_stat_xact_user_tables

  Source-defined field pg_stat_xact_user_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_user_tables.idx_tup_fetch pg_stat_xact_user_tables

  Source-defined field pg_stat_xact_user_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_user_tables.n_tup_del pg_stat_xact_user_tables

  Source-defined field pg_stat_xact_user_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_user_tables.n_tup_hot_upd pg_stat_xact_user_tables

  Source-defined field pg_stat_xact_user_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
• pg_stat_xact_user_tables.n_tup_ins pg_stat_xact_user_tables

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

  1011121314151617181920
• pg_stat_xact_user_tables.n_tup_newpage_upd pg_stat_xact_user_tables

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

  1011121314151617181920
• pg_stat_xact_user_tables.n_tup_upd pg_stat_xact_user_tables

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

  1011121314151617181920
• pg_stat_xact_user_tables.relid pg_stat_xact_user_tables

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

  1011121314151617181920
• pg_stat_xact_user_tables.relname pg_stat_xact_user_tables

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

  1011121314151617181920
• pg_stat_xact_user_tables.schemaname pg_stat_xact_user_tables

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

  1011121314151617181920
• pg_stat_xact_user_tables.seq_scan pg_stat_xact_user_tables

  Source-defined field pg_stat_xact_user_tables.seq_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_user_tables.seq_tup_read pg_stat_xact_user_tables

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

  1011121314151617181920
• pg_statio_all_indexes.idx_blks_hit pg_statio_all_indexes

  Number of buffer hits in this index

  1011121314151617181920
• pg_statio_all_indexes.idx_blks_read pg_statio_all_indexes

  Number of disk blocks read from this index

  1011121314151617181920
• pg_statio_all_indexes.indexrelid pg_statio_all_indexes

  OID of this index

  1011121314151617181920
• pg_statio_all_indexes.indexrelname pg_statio_all_indexes

  Name of this index

  1011121314151617181920
• pg_statio_all_indexes.relid pg_statio_all_indexes

  OID of the table for this index

  1011121314151617181920
• pg_statio_all_indexes.relname pg_statio_all_indexes

  Name of the table for this index

  1011121314151617181920
• pg_statio_all_indexes.schemaname pg_statio_all_indexes

  Name of the schema this index is in

  1011121314151617181920
• pg_statio_all_indexes.stats_reset pg_statio_all_indexes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_statio_all_sequences.blks_hit pg_statio_all_sequences

  Number of buffer hits in this sequence

  1011121314151617181920
• pg_statio_all_sequences.blks_read pg_statio_all_sequences

  Number of disk blocks read from this sequence

  1011121314151617181920
• pg_statio_all_sequences.relid pg_statio_all_sequences

  OID of a sequence

  1011121314151617181920
• pg_statio_all_sequences.relname pg_statio_all_sequences

  Name of this sequence

  1011121314151617181920
• pg_statio_all_sequences.schemaname pg_statio_all_sequences

  Name of the schema this sequence is in

  1011121314151617181920
• pg_statio_all_sequences.stats_reset pg_statio_all_sequences not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_statio_all_tables.heap_blks_hit pg_statio_all_tables

  Number of buffer hits in this table

  1011121314151617181920
• pg_statio_all_tables.heap_blks_read pg_statio_all_tables

  Number of disk blocks read from this table

  1011121314151617181920
• pg_statio_all_tables.idx_blks_hit pg_statio_all_tables

  Number of buffer hits in all indexes on this table

  1011121314151617181920
• pg_statio_all_tables.idx_blks_read pg_statio_all_tables

  Number of disk blocks read from all indexes on this table

  1011121314151617181920
• pg_statio_all_tables.relid pg_statio_all_tables

  OID of a table

  1011121314151617181920
• pg_statio_all_tables.relname pg_statio_all_tables

  Name of this table

  1011121314151617181920
• pg_statio_all_tables.schemaname pg_statio_all_tables

  Name of the schema that this table is in

  1011121314151617181920
• pg_statio_all_tables.stats_reset pg_statio_all_tables not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_statio_all_tables.tidx_blks_hit pg_statio_all_tables

  Number of buffer hits in this table's TOAST table indexes (if any)

  1011121314151617181920
• pg_statio_all_tables.tidx_blks_read pg_statio_all_tables

  Number of disk blocks read from this table's TOAST table indexes (if any)

  1011121314151617181920
• pg_statio_all_tables.toast_blks_hit pg_statio_all_tables

  Number of buffer hits in this table's TOAST table (if any)

  1011121314151617181920
• pg_statio_all_tables.toast_blks_read pg_statio_all_tables

  Number of disk blocks read from this table's TOAST table (if any)

  1011121314151617181920
• pg_statio_sys_indexes.idx_blks_hit pg_statio_sys_indexes

  Number of buffer hits in this index

  1011121314151617181920
• pg_statio_sys_indexes.idx_blks_read pg_statio_sys_indexes

  Number of disk blocks read from this index

  1011121314151617181920
• pg_statio_sys_indexes.indexrelid pg_statio_sys_indexes

  OID of this index

  1011121314151617181920
• pg_statio_sys_indexes.indexrelname pg_statio_sys_indexes

  Name of this index

  1011121314151617181920
• pg_statio_sys_indexes.relid pg_statio_sys_indexes

  OID of the table for this index

  1011121314151617181920
• pg_statio_sys_indexes.relname pg_statio_sys_indexes

  Name of the table for this index

  1011121314151617181920
• pg_statio_sys_indexes.schemaname pg_statio_sys_indexes

  Name of the schema this index is in

  1011121314151617181920
• pg_statio_sys_indexes.stats_reset pg_statio_sys_indexes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_statio_sys_sequences.blks_hit pg_statio_sys_sequences

  Number of buffer hits in this sequence

  1011121314151617181920
• pg_statio_sys_sequences.blks_read pg_statio_sys_sequences

  Number of disk blocks read from this sequence

  1011121314151617181920
• pg_statio_sys_sequences.relid pg_statio_sys_sequences

  OID of a sequence

  1011121314151617181920
• pg_statio_sys_sequences.relname pg_statio_sys_sequences

  Name of this sequence

  1011121314151617181920
• pg_statio_sys_sequences.schemaname pg_statio_sys_sequences

  Name of the schema this sequence is in

  1011121314151617181920
• pg_statio_sys_sequences.stats_reset pg_statio_sys_sequences not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_statio_sys_tables.heap_blks_hit pg_statio_sys_tables

  Number of buffer hits in this table

  1011121314151617181920
• pg_statio_sys_tables.heap_blks_read pg_statio_sys_tables

  Number of disk blocks read from this table

  1011121314151617181920
• pg_statio_sys_tables.idx_blks_hit pg_statio_sys_tables

  Number of buffer hits in all indexes on this table

  1011121314151617181920
• pg_statio_sys_tables.idx_blks_read pg_statio_sys_tables

  Number of disk blocks read from all indexes on this table

  1011121314151617181920
• pg_statio_sys_tables.relid pg_statio_sys_tables

  OID of a table

  1011121314151617181920
• pg_statio_sys_tables.relname pg_statio_sys_tables

  Name of this table

  1011121314151617181920
• pg_statio_sys_tables.schemaname pg_statio_sys_tables

  Name of the schema that this table is in

  1011121314151617181920
• pg_statio_sys_tables.stats_reset pg_statio_sys_tables not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_statio_sys_tables.tidx_blks_hit pg_statio_sys_tables

  Number of buffer hits in this table's TOAST table indexes (if any)

  1011121314151617181920
• pg_statio_sys_tables.tidx_blks_read pg_statio_sys_tables

  Number of disk blocks read from this table's TOAST table indexes (if any)

  1011121314151617181920
• pg_statio_sys_tables.toast_blks_hit pg_statio_sys_tables

  Number of buffer hits in this table's TOAST table (if any)

  1011121314151617181920
• pg_statio_sys_tables.toast_blks_read pg_statio_sys_tables

  Number of disk blocks read from this table's TOAST table (if any)

  1011121314151617181920
• pg_statio_user_indexes.idx_blks_hit pg_statio_user_indexes

  Number of buffer hits in this index

  1011121314151617181920
• pg_statio_user_indexes.idx_blks_read pg_statio_user_indexes

  Number of disk blocks read from this index

  1011121314151617181920
• pg_statio_user_indexes.indexrelid pg_statio_user_indexes

  OID of this index

  1011121314151617181920
• pg_statio_user_indexes.indexrelname pg_statio_user_indexes

  Name of this index

  1011121314151617181920
• pg_statio_user_indexes.relid pg_statio_user_indexes

  OID of the table for this index

  1011121314151617181920
• pg_statio_user_indexes.relname pg_statio_user_indexes

  Name of the table for this index

  1011121314151617181920
• pg_statio_user_indexes.schemaname pg_statio_user_indexes

  Name of the schema this index is in

  1011121314151617181920
• pg_statio_user_indexes.stats_reset pg_statio_user_indexes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_statio_user_sequences.blks_hit pg_statio_user_sequences

  Number of buffer hits in this sequence

  1011121314151617181920
• pg_statio_user_sequences.blks_read pg_statio_user_sequences

  Number of disk blocks read from this sequence

  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.