Radhya sahal 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
--
Sent via pgsql-performance mailing li
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
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-pe
On 11 October 2011 21:13, Szymon Guz wrote:
>
>
> On 11 October 2011 21:08, Radhya sahal 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 T
On 11 October 2011 21:08, Radhya sahal 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
rega
2011/10/11 Radhya sahal :
> 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
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.
