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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
