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



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.