Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4A2ECB5DCC7 for ; Tue, 11 Oct 2011 18:36:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 11487-03-7 for ; Tue, 11 Oct 2011 21:36:26 +0000 (UTC) X-Greylist: delayed 00:06:51.378727 by SQLgrey-1.8.0-rc2 Received: from nm11-vm0.bullet.mail.ac4.yahoo.com (nm11-vm0.bullet.mail.ac4.yahoo.com [98.139.53.196]) by mail.postgresql.org (Postfix) with SMTP id 0BB9CB5DBD8 for ; Tue, 11 Oct 2011 18:36:16 -0300 (ADT) Received: from [98.139.52.194] by nm11.bullet.mail.ac4.yahoo.com with NNFMP; 11 Oct 2011 21:29:24 -0000 Received: from [98.139.52.152] by tm7.bullet.mail.ac4.yahoo.com with NNFMP; 11 Oct 2011 21:29:24 -0000 Received: from [127.0.0.1] by omp1035.mail.ac4.yahoo.com with NNFMP; 11 Oct 2011 21:29:24 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 333392.45775.bm@omp1035.mail.ac4.yahoo.com Received: (qmail 47105 invoked by uid 60001); 11 Oct 2011 21:29:23 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1318368563; bh=KDUOn3WQ+WDjVBR7Wlt0jhGVcSbm54DJBkKhUhgVn9o=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=xqnuHvg9hOnC+V4axMUNaRKBh5Qug1r1vPiU3Pak6ely/+VKz9dlekV7BU3jA8879MuSwObS4ijpxBbsUkX15agj5QVeirJaliuqTumuUfVwSeGiJZTX1WcOoMJDf6KfzLSeF/tsM8rmiPiXrVVKl6oUlkYvJYK825u0YKjgm5A= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=5IqiOpkfE9RAs8+eGHeKJILjQ7MPyVXAl2Tam9dN7CHnCWYFp0ZE7wgk/Xh9ygr3j+i07UgG/88kSt07sIlywPSC/hfJP+tKXQ8tuqNCEmp+PP5VnoD5UEJhpHT16n04HbUohJEukqeQVoCOK4r332MpMIeo38WkBz74iaPesUs=; X-YMail-OSG: is_69dcVM1nHfxJcZV1Hz5WDKKwTDjUaoHATUf2lyPx3OqP _6B3AxAcMhgQNzCiumW1Ty.7ky73WfAC84R6Z0eAeNBNF8EzRBhSCSCfv.5I JayKyBvRT0jGbxS1npGZz5JKk2FZzE0nlp5ING2LPuEpBLZCD_8Qn8bssuYo N0R_hepIxJ9FWEXK.1r0G7xRW2lJQz2CXAXa86enLS4G4OPsplYPfEE9usu8 _0dhCIqjtYu4y6fB8OSs8ZxRYaVLSiAkkyRXArY8yjCClchq5m2X8jB8fBcn EylGlDvG9pW04NyDtukMb0ajRqjrYpxe6yoPMjxivXGI85.xtc2jyjZxhhZj Jg0NZFaPECco0S0UuUsFu5H.TzcANLfhB1wc_XQc9aZl7rn1lgC7nhZkDv3y ELa6jFjAaopkvGe1C1Yia64DhCHLYBwls3eF6i_31QuVzw5yUdbVBO1CZbYY f5.urNz4GRg-- Received: from [41.239.67.14] by web38601.mail.mud.yahoo.com via HTTP; Tue, 11 Oct 2011 14:29:23 PDT X-Mailer: YahooMailWebService/0.8.114.317681 References: <1318360111.86763.YahooMailNeo@web38602.mail.mud.yahoo.com> <4E944F9E0200002500041E01@gw.wicourts.gov> Message-ID: <1318368563.46146.YahooMailNeo@web38601.mail.mud.yahoo.com> Date: Tue, 11 Oct 2011 14:29:23 -0700 (PDT) From: Radhya sahal Reply-To: Radhya sahal Subject: Re: postgresql query runtime To: Kevin Grittner Cc: pgsql-performance group In-Reply-To: <4E944F9E0200002500041E01@gw.wicourts.gov> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-2114655128-951785186-1318368563=:46146" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.151 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001, FREEMAIL_REPLYTO_END_DIGIT=1.151, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201110/120 X-Sequence-Number: 45342 ---2114655128-951785186-1318368563=:46146 Content-Type: text/plain; charset=us-ascii thank's Kevin how i can read query runtime if i want to run query from java ? regards,,, ________________________________ From: Kevin Grittner To: pgsql-performance group ; Radhya sahal Sent: Tuesday, October 11, 2011 12:15 PM Subject: Re: [PERFORM] postgresql query runtime Radhya sahal wrote: > I want to know how can i measure runtime query in postgresql if i > use command line psql? \timing on -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ---2114655128-951785186-1318368563=:46146 Content-Type: text/html; charset=us-ascii
thank's Kevin
how i can read query runtime if i want to run query from java ?
regards,,,

From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-performance group <pgsql-performance@postgresql.org>; Radhya sahal <rad_cs_2006@yahoo.com>
Sent: Tuesday, October 11, 2011 12:15 PM
Subject: Re: [PERFORM] postgresql query runtime

Radhya sahal <rad_cs_2006@yahoo.com> wrote:

> I want to know how can i measure runtime query in postgresql if i
> use command line psql?

\timing on

-Kevin

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


---2114655128-951785186-1318368563=:46146--