Re: Customizing psql console to show execution times

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
Cc: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Customizing psql console to show execution times
Date: 2007-08-15 15:43:53
Message-ID: 5902.1187192633@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Decibel! 2007-08-15 15:47:47 Re: [GENERAL] Permission ALTER PASSWORD
Previous Message Andrew Armstrong 2007-08-15 15:40:18 Re: Yet Another COUNT(*)...WHERE...question