How to exclude queries?

[jonluca]

Two of our most common queries are skewing our database query stats - they both are empty selects, but they occur so frequently they make the rest of our queries look very performant. Is there a way to exclude specific queries by fingerprint, or even just that match a regex?

[lfittl]

@jonluca Thanks for the request!

Since you opened this on the collector repository, answering in the context of the data collection:

You can exclude queries from being tracked by Postgres by running "SET pg_stat_statements.track = none" on the connection where you run the query (and then reset it again with "RESET pg_stat_statements.track"). This also excludes them from showing up in the pganalyze query overview.

We don't currently have plans to add other methods to filter out queries in the collector or within the UI, but feedback is of course welcome.