Re: show time consumed by query in psql

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