pgbadger icon indicating copy to clipboard operation
pgbadger copied to clipboard

question: Set log_min_duration_statement = '-1' and auto_explain.log_min_duration='2s' will report slowest queries ?

Open bagafoot opened this issue 2 years ago • 1 comments

Hello, I am using auto_explain extension and realize that auto_explain reporting queries as "Query Text" so there were duplicate log entries for one specific query . So I set log_min_duration_statement = '-1' to eliminate duplicate logging and set auto_explain.log_min_duration='2s'. So in this case pgbadger will report slowest queries anyway ?

bagafoot avatar Jan 19 '24 13:01 bagafoot

I don't think so, but I have never tested. Can you update the issue if you have given a try?

darold avatar Feb 07 '24 18:02 darold