Re: postgresql query runtime - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: postgresql query runtime
Date
Msg-id CAFj8pRDTiuXx2QeTKG4QGfkXCpjEGCW-StXCNz6Wyz=qO-EwKg@mail.gmail.com
Whole thread Raw
In response to postgresql query runtime  (Radhya sahal <rad_cs_2006@yahoo.com>)
List 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

pgsql-performance by date:

Previous
From: Radhya sahal
Date:
Subject: postgresql query runtime
Next
From: Szymon Guz
Date:
Subject: Re: postgresql query runtime