From: | "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Customizing psql console to show execution times |
Date: | 2007-08-15 15:36:56 |
Message-ID: | 200708151736.56212.leif@solumslekt.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wednesday 15. August 2007, Phoenix Kiula wrote:
>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!
pgslekt=> select count(*) from persons;
count
-------
16704
(1 row)
pgslekt=> \timing
Timing is on.
pgslekt=> select count(*) from persons;
count
-------
16704
(1 row)
Time: 3,127 ms
pgslekt=> \timing
Timing is off.
pgslekt=>
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-08-15 15:38:28 | Re: Customizing psql console to show execution times |
Previous Message | Phoenix Kiula | 2007-08-15 15:36:52 | Re: Yet Another COUNT(*)...WHERE...question |