Thread: explain workload

explain workload

From

Radhya sahal

Date:

22 October 2011, 01:11:49

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

From

Robins Tharakan

Date:

23 October 2011, 10:45:11

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 ,,??

Attachment

smime.p7s

Re: explain workload

From

Tom Lane

Date:

23 October 2011, 15:45:03

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