On Tue, Apr 27, 2021 at 12:56 AM Tom Lane <[email protected]> wrote: > > Stephen Frost <[email protected]> writes: > > * Bruce Momjian ([email protected]) wrote: > >> Techically, pg_stat_statements can turn on compute_query_id when it is > >> loaded, even if it is 'off' in postgresql.conf, right? And > >> pg_stat_statements would know if an alternate hash method is being used, > >> right? > > > +1 on this approach. > > That'd make it impossible to turn off or adjust afterwards, wouldn't it?
I think so, which would also make it impossible to use an external query_id plugin. Enabling compute_query_id by default or raising a WARNING in pg_stat_statements' PG_INIT seems like the only 2 sensible options.
