Thread: show time consumed by query in psql

Hi,

I´m on a slow internet connection, but i want to optimize a view on a server. I have console access, so psql seems the right way - pgAdmin from the client is just way biassed.
How can i make psql report the amount of time that was consumed in the query??
I´ve seen a couple of posts that refer to this, but everyone seems to solve it in some other way. Is this not a feature of psql? (it should be!)

thx

WBL

am  Wed, dem 13.02.2008, um 10:22:29 +0100 mailte Willy-Bas Loos folgendes:
> How can i make psql report the amount of time that was consumed in the query??
> IŽve seen a couple of posts that refer to this, but everyone seems to solve it
> in some other way. Is this not a feature of psql? (it should be!)

\timing



Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Willy-Bas Loos wrote:
> Hi,
>
> I´m on a slow internet connection, but i want to optimize a view on a
> server. I have console access, so psql seems the right way - pgAdmin from
> the client is just way biassed.
> How can i make psql report the amount of time that was consumed in the
> query??
> I´ve seen a couple of posts that refer to this, but everyone seems to solve
> it in some other way. Is this not a feature of psql? (it should be!)

\timing
SELECT * FROM my_table;

Of course, if you want the plan you'll need EXPLAIN ANALYSE

--
   Richard Huxton
   Archonet Ltd