Statistics collection disabled prevents visibility into query performance
warningconfigurationUpdated Feb 26, 2026
Technologies:
How to detect:
When track_activities, track_counts, track_functions, track_io_timing, or track_wal_io_timing are disabled, corresponding statistics views show no data or incomplete data, preventing performance analysis and troubleshooting.
Recommended action:
Enable statistics collection in postgresql.conf by setting track_activities=on, track_counts=on, track_io_timing=on, and track_wal_io_timing=on. Restart PostgreSQL or reload configuration. Only superusers can change these via SET command in individual sessions.