Benching Queries

Поиск
Список
Период
Сортировка
Искать
От
Jonathan Vanasco
Тема
Benching Queries
Дата
Msg-id
78B2522B-7B2C-4C92-ABB2-4DE079FFACCC@2xlp.com
Ответ на
Список
Дерево обсуждения
Postgres tcp_keepalive_xxxx parameters. jlrando <jose.luis.rando.calvo@ericsson.com>
Re: Postgres tcp_keepalive_xxxx parameters. Tom Lane <tgl@sss.pgh.pa.us>
Re: Postgres tcp_keepalive_xxxx parameters. José Luis Rando Calvo<jose.luis.rando.calvo@ericsson.com>
Benching Queries Jonathan Vanasco <postgres@2xlp.com>

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).  


В списке pgsql-general по дате отправления
От: José Luis Rando Calvo
Дата:
От: Andrus
Дата:
FAQ