pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql query runtime
7+ messages / 4 participants
[nested] [flat]
* postgresql query runtime
@ 2011-10-11 19:08 Radhya sahal <rad_cs_2006@yahoo.com>
2011-10-11 19:11 ` Re: postgresql query runtime Pavel Stehule <pavel.stehule@gmail.com>
2011-10-11 19:13 ` Re: postgresql query runtime Szymon Guz <mabewlun@gmail.com>
2011-10-11 19:15 ` Re: postgresql query runtime Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 3 replies; 7+ messages in thread
From: Radhya sahal @ 2011-10-11 19:08 UTC (permalink / raw)
To: pgsql-performance
Hi
I want to know how can i measure runtime query in postgresql if i use command line psql?
not explain rutime for the query such as the runtime which appear in pgadmin ?
such as Total query runtime: 203 ms.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgresql query runtime
2011-10-11 19:08 postgresql query runtime Radhya sahal <rad_cs_2006@yahoo.com>
@ 2011-10-11 19:11 ` Pavel Stehule <pavel.stehule@gmail.com>
2 siblings, 0 replies; 7+ messages in thread
From: Pavel Stehule @ 2011-10-11 19:11 UTC (permalink / raw)
To: Radhya sahal <rad_cs_2006@yahoo.com>; +Cc: pgsql-performance
2011/10/11 Radhya sahal <rad_cs_2006@yahoo.com>:
> Hi
> I want to know how can i measure runtime query in postgresql if i use
> command line psql?
> not explain rutime for the query such as the runtime which appear in pgadmin
> ?
> such as Total query runtime: 203 ms.
>
Hello
use
\timing
\? is your friend :)
Regards
Pavel Stehule
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgresql query runtime
2011-10-11 19:08 postgresql query runtime Radhya sahal <rad_cs_2006@yahoo.com>
@ 2011-10-11 19:13 ` Szymon Guz <mabewlun@gmail.com>
2011-10-11 19:14 ` Re: postgresql query runtime Szymon Guz <mabewlun@gmail.com>
2 siblings, 1 reply; 7+ messages in thread
From: Szymon Guz @ 2011-10-11 19:13 UTC (permalink / raw)
To: Radhya sahal <rad_cs_2006@yahoo.com>; +Cc: pgsql-performance
On 11 October 2011 21:08, Radhya sahal <rad_cs_2006@yahoo.com> wrote:
> Hi
> I want to know how can i measure runtime query in postgresql if i use
> command line psql?
> not explain rutime for the query such as the runtime which appear in
> pgadmin ?
> such as Total query runtime: 203 ms.
>
run this in psql:
\t
regards
Szymon
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgresql query runtime
2011-10-11 19:08 postgresql query runtime Radhya sahal <rad_cs_2006@yahoo.com>
2011-10-11 19:13 ` Re: postgresql query runtime Szymon Guz <mabewlun@gmail.com>
@ 2011-10-11 19:14 ` Szymon Guz <mabewlun@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Szymon Guz @ 2011-10-11 19:14 UTC (permalink / raw)
To: Radhya sahal <rad_cs_2006@yahoo.com>; +Cc: pgsql-performance
On 11 October 2011 21:13, Szymon Guz <mabewlun@gmail.com> wrote:
>
>
> On 11 October 2011 21:08, Radhya sahal <rad_cs_2006@yahoo.com> wrote:
>
>> Hi
>> I want to know how can i measure runtime query in postgresql if i use
>> command line psql?
>> not explain rutime for the query such as the runtime which appear in
>> pgadmin ?
>> such as Total query runtime: 203 ms.
>>
>
>
> run this in psql:
>
> \t
>
> regards
> Szymon
>
yes... \timing of course... I think I shouldn't send emails when I've got a
fever :)
- Szymon
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgresql query runtime
2011-10-11 19:08 postgresql query runtime Radhya sahal <rad_cs_2006@yahoo.com>
@ 2011-10-11 19:15 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-10-11 21:29 ` Re: postgresql query runtime Radhya sahal <rad_cs_2006@yahoo.com>
2 siblings, 1 reply; 7+ messages in thread
From: Kevin Grittner @ 2011-10-11 19:15 UTC (permalink / raw)
To: pgsql-performance; Radhya sahal <rad_cs_2006@yahoo.com>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgresql query runtime
2011-10-11 19:08 postgresql query runtime Radhya sahal <rad_cs_2006@yahoo.com>
2011-10-11 19:15 ` Re: postgresql query runtime Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2011-10-11 21:29 ` Radhya sahal <rad_cs_2006@yahoo.com>
2011-10-11 21:43 ` Re: postgresql query runtime Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 7+ messages in thread
From: Radhya sahal @ 2011-10-11 21:29 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgresql query runtime
2011-10-11 19:08 postgresql query runtime Radhya sahal <rad_cs_2006@yahoo.com>
2011-10-11 19:15 ` Re: postgresql query runtime Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-10-11 21:29 ` Re: postgresql query runtime Radhya sahal <rad_cs_2006@yahoo.com>
@ 2011-10-11 21:43 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 7+ messages in thread
From: Kevin Grittner @ 2011-10-11 21:43 UTC (permalink / raw)
To: Radhya sahal <rad_cs_2006@yahoo.com>; +Cc: pgsql-performance
Radhya sahal <rad_cs_2006@yahoo.com> wrote:
> how i can read query runtime if i want to run query from java ?
Personally, I capture System.currentTimeInMillis() before and after
the query, and subtract. In our framework, we have a monitor class
to encapsulate that.
-Kevin
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2011-10-11 21:43 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-10-11 19:08 postgresql query runtime Radhya sahal <rad_cs_2006@yahoo.com>
2011-10-11 19:11 ` Re: postgresql query runtime Pavel Stehule <pavel.stehule@gmail.com>
2011-10-11 19:13 ` Re: postgresql query runtime Szymon Guz <mabewlun@gmail.com>
2011-10-11 19:14 ` Re: postgresql query runtime Szymon Guz <mabewlun@gmail.com>
2011-10-11 19:15 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-10-11 21:29 ` Radhya sahal <rad_cs_2006@yahoo.com>
2011-10-11 21:43 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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