On Mon, Apr 12, 2021 at 03:26:33PM +0800, Julien Rouhaud wrote:
> On Mon, Apr 12, 2021 at 09:20:07AM +0200, Michael Banck wrote:
> >
> > What about log_statement_sample_rate ? Does compute_query_id have the
> > same problem with that?
>
> No, log_statement_sample_rate samples log_min_duration_statements, not
> log_statements so it works as expected.
While on that topic, it's probably worth mentioning that log_duration is now
way more useful if you have the queryid in you log_line_prefix. It avoids to
log the full query text while still being able to know what was the underlying
normalized query by dumping the content of pg_stat_statements.
