On Tue, Apr 27, 2021 at 12:56 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > > Stephen Frost <sfr...@snowman.net> writes: > > * Bruce Momjian (br...@momjian.us) 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.
