Обсуждение: explain workload

Поиск
Список
Период
Сортировка

explain workload

От
Radhya sahal
Дата:
Hi there,,
How can use explain to estimate workload contains  more than one query in the same time.
such as
explain (q1,q2,q3)......i want the total cost for all queries in the workload using one explain ,,??
regards..

Re: explain workload

От
Robins Tharakan
Дата:
Hi Radhya,

Make multiple EXPLAIN requests, and add them up in your application, I
guess?

--
Robins
Sr. PGDBA
Comodo India

On 10/22/2011 06:41 AM, Radhya sahal wrote:
> such as
> explain (q1,q2,q3)......i want the total cost for all queries in the
> workload using one explain ,,??


Вложения

Re: explain workload

От
Tom Lane
Дата:
Robins Tharakan <robins.tharakan@comodo.com> writes:
> Hi Radhya,
> Make multiple EXPLAIN requests, and add them up in your application, I
> guess?

Or maybe contrib/auto_explain would help.

            regards, tom lane