search

darold / pgbadger

A fast PostgreSQL Log Analyzer
http://pgbadger.darold.net/
PostgreSQL License
3.49k stars 349 forks source link

exclude query not respected for Time consuming prepare / bind reports #738

Closed alecl closed 2 years ago

alecl commented 2 years ago

Using pgBadger 11.8 latest and Postgres 14.2

2022-07-09 23:52:57 UTC [711397]: db=smdb,user=successmaker,app=PostgreSQL JDBC Driver,client=127.0.0.1,session=62c751ee.adae5,sessionstart=2022-07-07 21:36:46 UTC,tx=0LOG: duration: 0.022 ms parse : SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 2022-07-09 23:52:57 UTC [711397]: db=smdb,user=successmaker,app=PostgreSQL JDBC Driver,client=127.0.0.1,session=62c751ee.adae5,sessionstart=2022-07-07 21:36:46 UTC,tx=0LOG: duration: 0.004 ms bind : SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 2022-07-09 23:52:57 UTC [711397]: db=smdb,user=successmaker,app=PostgreSQL JDBC Driver,client=127.0.0.1,session=62c751ee.adae5,sessionstart=2022-07-07 21:36:46 UTC,tx=0LOG: execute : SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

--exclude_query="^(SET|SHOW")

Note that the HTML report in the "Top" menu exclude these except for "Time consuming prepare" and "Time consuming bind" which include them.

Expected behavior is --exclude_query should apply to Time consuming prepare and bind as well

darold commented 2 years ago

Commit e4da5f2 fixes this issue.