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). -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
