I want to check the performance of specific queries in a Postgres database on a regular basis. Also, I want to be able to check the change in performance of different queries with any change in my Postgres configuration or database schema/indexes.
So far I have tried
pgbench, but feel like I need to automate the process of passing the script
pgbench will use to test. But
pgbench tests my configuration by generating its own tables and those tables will not reflect the level of joins I might be using on real data.
I'm using Postgres 10.0