Wiki / Configuration Parameters

Enables in-core computation of a query identifier. Query identifiers can be displayed in the pg_stat_activity view, using EXPLAIN, or emitted in the log if configured via the log_line_prefix parameter. The pg_stat_statements extension also requires a query identifier to be computed. Note that an external module can alternatively be used if the in-core query identifier computation method is not acceptable. In this case, in-core computation must be always disabled. Valid values are off (always disabled), on (always enabled), auto, which lets modules such as pg_stat_statements automatically enable it, and regress which has the same effect as auto, except that the query identifier is not shown in the EXPLAIN output in order to facilitate automated regression testing. The default is auto. Note To ensure that only one query identifier is calculated and displayed, extensions that calculate query identifiers should throw an error if a query identifier has already been computed.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

auto

category

Statistics / Monitoring

context

superuser

documented

true

enumvals

auto, regress, on, off

extra desc

Unknown

lang

en

max val

Unknown

metadata version

18

min val

Unknown

name

compute_query_id

short desc

Enables in-core computation of query identifiers.

source

pg-settings-source-snapshot

unit

Unknown

vartype

enum