Re: Customizing psql console to show execution times - Mailing list pgsql-general

From Tom Lane
Subject Re: Customizing psql console to show execution times
Date
Msg-id 5902.1187192633@sss.pgh.pa.us
Whole thread Raw
In response to Customizing psql console to show execution times  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Responses Re: Customizing psql console to show execution times  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
List pgsql-general
"Phoenix Kiula" <phoenix.kiula@gmail.com> writes:
> In some examples posted to this forum, it seems to me that when people
> execute queries in the psql window, they also see "90 ms taken"
> (milliseconds), which denotes the time taken to execute the query.
> Where can I set this option because I'm not seeing it in my psql
> window on both Win XP and Linux. Thanks!

I think you're looking for the \timing command?
http://www.postgresql.org/docs/8.2/static/app-psql.html
(under meta-commands, about halfway down the page)

            regards, tom lane

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Customizing psql console to show execution times
Next
From: Decibel!
Date:
Subject: Re: Permission ALTER PASSWORD