Re: [PERFORM] explain workload

2011-10-23 Thread Tom Lane
Robins Tharakan 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make chan

Re: [PERFORM] explain workload

2011-10-23 Thread 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 ,,?? smime.p7s Des

[PERFORM] explain workload

2011-10-21 Thread 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..