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, privacy policy and cookie policy

Browse other questions tagged or ask your own question.