Обсуждение: 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
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