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