Does anyone have a good solution for benching queries under various conditions, and collecting the EXPLAIN data ?
I looked at pgbench, but it doesn't seem to be what I want.
My situation is this-
- For a given query, there are 3-5 different ways that I can run it.
- Each form of the query has a completely different execution plan and query time, often using different indexes.
- The same query runs differently on first query, vs subsequent queries (when the indexes/tables are already in
memory).
My goal is to find an overall balance of query time (cold-start vs in-memory) and indexes (number of).