Skip to content

Statistics

Complete dossiers for 14 core PostgreSQL settings in Statistics.

Dossier URLs remain flat; this category exists only to organize browsing and the sidebar.

compute_query_id

compute_query_id — Enables in-core computation of query identifiers. Observed in PG14–19 Beta 3; its last measured boot default is auto in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

log_executor_stats

log_executor_stats — Writes executor performance statistics to the server log. Observed in PG9.0–19 Beta 3; its last measured boot default is off in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

log_parser_stats

log_parser_stats — Writes parser performance statistics to the server log. Observed in PG9.0–19 Beta 3; its last measured boot default is off in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

log_planner_stats

log_planner_stats — Writes planner performance statistics to the server log. Observed in PG9.0–19 Beta 3; its last measured boot default is off in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

log_statement_stats

log_statement_stats — Writes cumulative performance statistics to the server log. Observed in PG9.0–19 Beta 3; its last measured boot default is off in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

stats_fetch_consistency

stats_fetch_consistency — Sets the consistency of accesses to statistics data. Observed in PG15–19 Beta 3; its last measured boot default is cache in PG19 Beta 3, with user context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

stats_temp_directory

stats_temp_directory — Writes temporary statistics files to the specified directory. Observed in PG9.0–14; its last measured boot default is pg_stat_tmp in PG14, with sighup context. It was removed in PG15.

track_activities

track_activities — Collects information about executing commands. Observed in PG9.0–19 Beta 3; its last measured boot default is on in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

track_activity_query_size

track_activity_query_size — Sets the size reserved for pg_stat_activity.query, in bytes. Observed in PG9.0–19 Beta 3; its last measured boot default is 1 KiB in PG19 Beta 3, with postmaster context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

track_cost_delay_timing

track_cost_delay_timing — Collects timing statistics for cost-based vacuum delay. Observed in PG18–19 Beta 3; its last measured boot default is off in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

track_counts

track_counts — Collects statistics on database activity. Observed in PG9.0–19 Beta 3; its last measured boot default is on in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

track_functions

track_functions — Collects function-level statistics on database activity. Observed in PG9.0–19 Beta 3; its last measured boot default is none in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

track_io_timing

track_io_timing — Collects timing statistics for database I/O activity. Observed in PG9.2–19 Beta 3; its last measured boot default is off in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.

track_wal_io_timing

track_wal_io_timing — Collects timing statistics for WAL I/O activity. Observed in PG14–19 Beta 3; its last measured boot default is off in PG19 Beta 3, with superuser context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA.