3

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

Improve this question
2

0

Reset to default

Your Answer

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