pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedexplain workload
3+ messages / 3 participants
[nested] [flat]
* explain workload
@ 2011-10-22 01:11 Radhya sahal <rad_cs_2006@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Radhya sahal @ 2011-10-22 01:11 UTC (permalink / raw)
To: pgsql-performance
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..
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: explain workload
@ 2011-10-23 10:38 Robins Tharakan <robins.tharakan@comodo.com>
parent: Radhya sahal <rad_cs_2006@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Robins Tharakan @ 2011-10-23 10:38 UTC (permalink / raw)
To: pgsql-performance
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 ,,??
Attachments:
smime.p7s (application/pkcs7-signature, 6.4K) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: explain workload
@ 2011-10-23 15:44 Tom Lane <tgl@sss.pgh.pa.us>
parent: Robins Tharakan <robins.tharakan@comodo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2011-10-23 15:44 UTC (permalink / raw)
To: Robins Tharakan <robins.tharakan@comodo.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-10-23 15:44 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-10-22 01:11 explain workload Radhya sahal <rad_cs_2006@yahoo.com>
2011-10-23 10:38 ` Robins Tharakan <robins.tharakan@comodo.com>
2011-10-23 15:44 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox