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_activity.application_name pg_stat_activity

  Name of the application that is connected to this backend

  1011121314151617181920
• pg_stat_activity.backend_start pg_stat_activity

  Time when this process was started. For client backends, this is the time the client connected to the server.

  1011121314151617181920
• pg_stat_activity.backend_type pg_stat_activity

  Type of current backend. Possible types are autovacuum launcher, autovacuum worker, logical replication launcher, logical replication worker, parallel worker, background writer, client backend, checkpointer, archiver, standalone backend, startup, wa…

  1011121314151617181920
• pg_stat_activity.backend_xid pg_stat_activity

  Top-level transaction identifier of this backend, if any; see Section 67.1.

  1011121314151617181920
• pg_stat_activity.backend_xmin pg_stat_activity

  The current backend's xmin horizon.

  1011121314151617181920
• pg_stat_activity.client_addr pg_stat_activity

  IP address of the client connected to this backend. If this field is null, it indicates either that the client is connected via a Unix socket on the server machine or that this is an internal process such as autovacuum.

  1011121314151617181920
• pg_stat_activity.client_hostname pg_stat_activity

  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_activity.client_port pg_stat_activity

  TCP port number that the client is using for communication with this backend, or -1 if a Unix socket is used. If this field is null, it indicates that this is an internal server process.

  1011121314151617181920
• pg_stat_activity.datid pg_stat_activity

  OID of the database this backend is connected to

  1011121314151617181920
• pg_stat_activity.datname pg_stat_activity

  Name of the database this backend is connected to

  1011121314151617181920
• pg_stat_activity.leader_pid pg_stat_activity

  Process ID of the parallel group leader if this process is a parallel query worker, or process ID of the leader apply worker if this process is a parallel apply worker. NULL indicates that this process is a parallel group leader or leader apply work…

  1011121314151617181920
• pg_stat_activity.pid pg_stat_activity

  Process ID of this backend

  1011121314151617181920
• pg_stat_activity.query pg_stat_activity

  Text of this backend's most recent query. If state is active this field shows the currently executing query. In all other states, it shows the last query that was executed. By default the query text is truncated at 1024 bytes; this value can be chan…

  1011121314151617181920
• pg_stat_activity.query_id pg_stat_activity

  Identifier of this backend's most recent query. If state is active this field shows the identifier of the currently executing query. In all other states, it shows the identifier of last query that was executed. Query identifiers are not computed by …

  1011121314151617181920
• pg_stat_activity.query_start pg_stat_activity

  Time when the currently active query was started, or if state is not active, when the last query was started

  1011121314151617181920
• pg_stat_activity.state pg_stat_activity

  Current overall state of this backend. Possible values are: starting: The backend is in initial startup. Client authentication is performed during this phase. active: The backend is executing a query. idle: The backend is waiting for a new client c…

  1011121314151617181920
• pg_stat_activity.state_change pg_stat_activity

  Time when the state was last changed

  1011121314151617181920
• pg_stat_activity.usename pg_stat_activity

  Name of the user logged into this backend

  1011121314151617181920
• pg_stat_activity.usesysid pg_stat_activity

  OID of the user logged into this backend

  1011121314151617181920
• pg_stat_activity.wait_event pg_stat_activity

  Wait event name if backend is currently waiting, otherwise NULL. See Table 27.5 through Table 27.13.

  1011121314151617181920
• pg_stat_activity.wait_event_type pg_stat_activity

  The type of event for which the backend is waiting, if any; otherwise NULL. See Table 27.4.

  1011121314151617181920
• pg_stat_activity.xact_start pg_stat_activity

  Time when this process' current transaction was started, or null if no transaction is active. If the current query is the first of its transaction, this column is equal to the query_start column.

  1011121314151617181920
• pg_stat_all_indexes.idx_scan pg_stat_all_indexes

  Number of index scans initiated on this index

  1011121314151617181920
• pg_stat_all_indexes.idx_tup_fetch pg_stat_all_indexes

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

  1011121314151617181920
• pg_stat_all_indexes.idx_tup_read pg_stat_all_indexes

  Number of index entries returned by scans on this index

  1011121314151617181920
• pg_stat_all_indexes.indexrelid pg_stat_all_indexes

  OID of this index

  1011121314151617181920
• pg_stat_all_indexes.indexrelname pg_stat_all_indexes

  Name of this index

  1011121314151617181920
• pg_stat_all_indexes.last_idx_scan pg_stat_all_indexes

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

  1011121314151617181920
• pg_stat_all_indexes.relid pg_stat_all_indexes

  OID of the table for this index

  1011121314151617181920
• pg_stat_all_indexes.relname pg_stat_all_indexes

  Name of the table for this index

  1011121314151617181920
• pg_stat_all_indexes.schemaname pg_stat_all_indexes

  Name of the schema this index is in

  1011121314151617181920
• pg_stat_all_indexes.stats_reset pg_stat_all_indexes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_all_tables.analyze_count pg_stat_all_tables

  Number of times this table has been manually analyzed

  1011121314151617181920
• pg_stat_all_tables.autoanalyze_count pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_all_tables.autovacuum_count pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_all_tables.idx_scan pg_stat_all_tables

  Number of index scans initiated on this table

  1011121314151617181920
• pg_stat_all_tables.idx_tup_fetch pg_stat_all_tables

  Number of live rows fetched by index scans

  1011121314151617181920
• pg_stat_all_tables.last_analyze pg_stat_all_tables

  Last time at which this table was manually analyzed

  1011121314151617181920
• pg_stat_all_tables.last_autoanalyze pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_all_tables.last_autovacuum pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_all_tables.last_idx_scan pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_all_tables.last_seq_scan pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_all_tables.last_vacuum pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_all_tables.n_dead_tup pg_stat_all_tables

  Estimated number of dead rows

  1011121314151617181920
• pg_stat_all_tables.n_ins_since_vacuum pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_all_tables.n_live_tup pg_stat_all_tables

  Estimated number of live rows

  1011121314151617181920
• pg_stat_all_tables.n_mod_since_analyze pg_stat_all_tables

  Estimated number of rows modified since this table was last analyzed

  1011121314151617181920
• pg_stat_all_tables.n_tup_del pg_stat_all_tables

  Total number of rows deleted

  1011121314151617181920
• pg_stat_all_tables.n_tup_hot_upd pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_all_tables.n_tup_ins pg_stat_all_tables

  Total number of rows inserted

  1011121314151617181920
• pg_stat_all_tables.n_tup_newpage_upd pg_stat_all_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_all_tables.n_tup_upd pg_stat_all_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_all_tables.relid pg_stat_all_tables

  OID of a table

  1011121314151617181920
• pg_stat_all_tables.relname pg_stat_all_tables

  Name of this table

  1011121314151617181920
• pg_stat_all_tables.schemaname pg_stat_all_tables

  Name of the schema that this table is in

  1011121314151617181920
• pg_stat_all_tables.seq_scan pg_stat_all_tables

  Number of sequential scans initiated on this table

  1011121314151617181920
• pg_stat_all_tables.seq_tup_read pg_stat_all_tables

  Number of live rows fetched by sequential scans

  1011121314151617181920
• pg_stat_all_tables.stats_reset pg_stat_all_tables not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_all_tables.total_analyze_time pg_stat_all_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_all_tables.total_autoanalyze_time pg_stat_all_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_all_tables.total_autovacuum_time pg_stat_all_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_all_tables.total_vacuum_time pg_stat_all_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_all_tables.vacuum_count pg_stat_all_tables

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

  1011121314151617181920
• pg_stat_archiver.archived_count pg_stat_archiver

  Number of WAL files that have been successfully archived

  1011121314151617181920
• pg_stat_archiver.failed_count pg_stat_archiver

  Number of failed attempts for archiving WAL files

  1011121314151617181920
• pg_stat_archiver.last_archived_time pg_stat_archiver

  Time of the most recent successful archive operation

  1011121314151617181920
• pg_stat_archiver.last_archived_wal pg_stat_archiver

  Name of the WAL file most recently successfully archived

  1011121314151617181920
• pg_stat_archiver.last_failed_time pg_stat_archiver

  Time of the most recent failed archival operation

  1011121314151617181920
• pg_stat_archiver.last_failed_wal pg_stat_archiver

  Name of the WAL file of the most recent failed archival operation

  1011121314151617181920
• pg_stat_archiver.stats_reset pg_stat_archiver

  Time at which these statistics were last reset

  1011121314151617181920
• pg_stat_autovacuum_scores.analyze_score pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.do_analyze pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.do_vacuum pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.for_wraparound pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.mxid_score pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.relid pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.relname pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.schemaname pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.score pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.vacuum_insert_score pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.vacuum_score pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_autovacuum_scores.xid_score pg_stat_autovacuum_scores not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_bgwriter.buffers_alloc pg_stat_bgwriter

  Number of buffers allocated

  1011121314151617181920
• pg_stat_bgwriter.buffers_backend pg_stat_bgwriter not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_bgwriter.buffers_backend_fsync pg_stat_bgwriter not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_bgwriter.buffers_checkpoint pg_stat_bgwriter not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_bgwriter.buffers_clean pg_stat_bgwriter

  Number of buffers written by the background writer

  1011121314151617181920
• pg_stat_bgwriter.checkpoint_sync_time pg_stat_bgwriter not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_bgwriter.checkpoint_write_time pg_stat_bgwriter not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_bgwriter.checkpoints_req pg_stat_bgwriter not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_bgwriter.checkpoints_timed pg_stat_bgwriter not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_stat_bgwriter.maxwritten_clean pg_stat_bgwriter

  Number of times the background writer stopped a cleaning scan because it had written too many buffers

  1011121314151617181920
• pg_stat_bgwriter.stats_reset pg_stat_bgwriter

  Time at which these statistics were last reset

  1011121314151617181920
• pg_stat_checkpointer.buffers_written pg_stat_checkpointer

  Number of shared buffers written during checkpoints and restartpoints

  1011121314151617181920
• pg_stat_checkpointer.num_done pg_stat_checkpointer

  Number of checkpoints that have been performed

  1011121314151617181920
• pg_stat_checkpointer.num_requested pg_stat_checkpointer

  Number of requested checkpoints

  1011121314151617181920
• pg_stat_checkpointer.num_timed pg_stat_checkpointer

  Number of scheduled checkpoints due to timeout

  1011121314151617181920
• pg_stat_checkpointer.restartpoints_done pg_stat_checkpointer

  Number of restartpoints that have been performed

  1011121314151617181920
• pg_stat_checkpointer.restartpoints_req pg_stat_checkpointer

  Number of requested restartpoints

  1011121314151617181920
• pg_stat_checkpointer.restartpoints_timed pg_stat_checkpointer

  Number of scheduled restartpoints due to timeout or after a failed attempt to perform it

  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.