Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql query runtime - Mailing list pgsql-performance

From Szymon Guz
Subject Re: postgresql query runtime
Date
Msg-id CAFjNrYtYc0xKssKm+WEVZ7xx0f9gvOCo-bwGjjt5kuUh5NDwaA@mail.gmail.com
Whole thread Raw
In response to Re: postgresql query runtime  (Szymon Guz <mabewlun@gmail.com>)
List pgsql-performance
Tree view


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

pgsql-performance by date:

Previous
From: Szymon Guz
Date:
Subject: Re: postgresql query runtime
Next
From: "Kevin Grittner"
Date:
Subject: Re: postgresql query runtime