Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 1B0A6B5DCEC for ; Fri, 21 Oct 2011 22:11:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 31641-03 for ; Sat, 22 Oct 2011 01:11:42 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from nm2-vm0.bullet.mail.ne1.yahoo.com (nm2-vm0.bullet.mail.ne1.yahoo.com [98.138.91.39]) by mail.postgresql.org (Postfix) with SMTP id AEE58B5DCFA for ; Fri, 21 Oct 2011 22:11:42 -0300 (ADT) Received: from [98.138.90.50] by nm2.bullet.mail.ne1.yahoo.com with NNFMP; 22 Oct 2011 01:11:42 -0000 Received: from [98.138.86.156] by tm3.bullet.mail.ne1.yahoo.com with NNFMP; 22 Oct 2011 01:11:42 -0000 Received: from [127.0.0.1] by omp1014.mail.ne1.yahoo.com with NNFMP; 22 Oct 2011 01:11:42 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 172875.61669.bm@omp1014.mail.ne1.yahoo.com Received: (qmail 61667 invoked by uid 60001); 22 Oct 2011 01:11:41 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1319245901; bh=jp2irSBTHYQTsnnF+O1g3c3BqHfjJmH0WqRK8M1ifmk=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type; b=Tlzsvc0EHnmscLEU58mJT73iGRsFn+J9RZTaCpZia4kzrId98bMqNEOLcxYA3f9dsG7+duPOaZSJrPg30lKk9kb8zyFsCq0nrkUTSB8P20klfgUObSA3qEwCgq+fQXvrj7Y2a9zpt/tBlJJiH6W4mvtdbB4Y7D1F8vmuQLsijfM= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type; b=c/Ud9QkynS0dX41RHpg0LQWxDxyaY4CszbV/xxvxb3RLEBaAxiiuQCCDrOhGXOewQDgppxOlPF11eMbRuY8t+Z5RpyeqBx4BnjYSr4YmHxCnbaiXCcqz/DKPZgl3zL0H47EcQ2cwILThzWkdJYZ5Uoqyub1tXLhIFLNNk6+yIL8=; X-YMail-OSG: _mU5lx8VM1kWm_h.1Y1dyhdU24IHy9eXVO2lkb01jiCJ_zZ nDDLwOLUdG9GMU6m3OcDCin6V7ndlswAseDNDbKeeh9XhIf9YfkAWZgpkoEe xlvy4gPeyK.yFiK9tJ1n.cvOpeN5xXAYAXZqUlSWLHW3kJaLTPrXJyq9YXPD WQOEo9XbMrdILYqsRkEgBTVyJ8L6oFhzYdTjJTr2MQEoCteonhnPDnp52fhC NQPRx4oAU.EpVZ3Tg.s40A9lRI5yf7sj1IcitJNV2molx9h2ImceyOtkBoYL SRppxPj1Aw3TCZIHFaBSqCKIjfTx8LREu1ji9Ff4C0R66qy10IP.5lvEajpb 9jX9GnULCvpEw.p_HPQF4YTj2Xb99hME3nbN2_SHiTi3yp4PYIvFWL5gQ2XM NHy62598lXE3mmOx5mZPUVMxGDNP3l7dV.W4_LhABTcKQeqRm3rEX82vvXv3 yYvA- Received: from [41.235.80.82] by web38608.mail.mud.yahoo.com via HTTP; Fri, 21 Oct 2011 18:11:41 PDT X-Mailer: YahooMailClassic/14.0.10 YahooMailWebService/0.8.114.317681 Message-ID: <1319245901.61568.YahooMailClassic@web38608.mail.mud.yahoo.com> Date: Fri, 21 Oct 2011 18:11:41 -0700 (PDT) From: Radhya sahal Subject: explain workload To: pgsql-performance group MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-2114655128-1464352232-1319245901=:61568" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.302 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201110/179 X-Sequence-Number: 45401 ---2114655128-1464352232-1319245901=:61568 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi there,, How can use explain to estimate workload contains=A0 more than one query in= the same time. such as explain (q1,q2,q3)......i want the total cost for all queries in the worklo= ad using one explain ,,?? regards.. ---2114655128-1464352232-1319245901=:61568 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi there,,
How can use explain to estimate= workload contains  more than one query in the same time.
such asexplain (q1,q2,q3)......i want the total cost for all queries in the work= load using one explain ,,??
regards..
---2114655128-1464352232-1319245901=:61568--