compute_query_id
No restart — reload (superuser)tuned by pgconfiguratorPostgreSQL 14+enum: auto / on / off / regress
Computes a stable query identifier so tools and logs can group identical queries.
What pgconfigurator would set
32 GB · 8 vCPU · NVMe · OLTP
Computing…
Tune for your exact server → /tunecomputed in your browser · nothing uploaded
What it does
When enabled, PostgreSQL computes a hash that identifies a query's shape (ignoring literal values). pg_stat_statements, log lines, and pg_stat_activity can then show and join on that query_id. The default 'auto' turns it on if a module like pg_stat_statements needs it.
How to tune it
Leave it at 'auto', or set 'on' if you want query_id in logs and pg_stat_activity even without pg_stat_statements loaded. There's negligible cost.