search

powa-team / powa

PostgreSQL Workload Analyzer
http://powa.readthedocs.io/
PostgreSQL License
777 stars 57 forks source link

powa related queries are visible under all databases #172

Closed sajiljosephs closed 1 year ago

sajiljosephs commented 1 year ago

I could see powa queries listed under other databases which makes it difficult for optimisation. Is there an option to exclude powa queries under other databases ?

rjuju commented 1 year ago

Do you mean the query automatically run when browsing powa-web (for instance when looking as possible missing indexes and things like that), or that the queries that are run for the snapshot are also showed in other databases?

For the former, it's currently not possible to hide them, as there's nothing that distinguish them from other queries. You can however set powa_servers.allow_ui_connection = false for the given server. Some features will be missing in the UI but you shouldn't have powa-related queries on non-powa databases anymore.