PostgreSQL

Statistics collection disabled prevents visibility into query performance

warning
configurationUpdated 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.