Query timing
Using EXPLAIN ANALYZE I can get the execution time of a query. Is there
a command I can use to get the execution time without the planning
information? I just need to time lots of queries that have complex plans
and it'd be easier if I didn't have pages and pages of planning info
between tries. The queries themselves are one line each, but refer to
views, which make the plans pretty complex. Being able to see several
times in one terminal window would be easier.
Thanks,
- Naz.
Naz Gassiep <naz@mira.net> writes:
Using EXPLAIN ANALYZE I can get the execution time of a query. Is there a
command I can use to get the execution time without the planning information?
I just need to time lots of queries that have complex plans and it'd be easier
if I didn't have pages and pages of planning info between tries. The queries
themselves are one line each, but refer to views, which make the plans pretty
complex. Being able to see several times in one terminal window would be
easier.
Write the queries in a file, run them with psql -f and grep for the desired
lines only.
--
Jorge Godoy <jgodoy@gmail.com>
am Mon, dem 05.03.2007, um 15:28:29 +1100 mailte Naz Gassiep folgendes:
Using EXPLAIN ANALYZE I can get the execution time of a query. Is there
a command I can use to get the execution time without the planning
Within psql, the command-line-interface, you can use \timing to switch
on/off reporting the execution time.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
That's not quite as fast as I would like to do it, that throws in a few
more steps which slow down the development process. However if there is
no way I will persevere with the method I have now.
Thanks,
- Naz.
Jorge Godoy wrote:
Show quoted text
Naz Gassiep <naz@mira.net> writes:
Using EXPLAIN ANALYZE I can get the execution time of a query. Is there a
command I can use to get the execution time without the planning information?
I just need to time lots of queries that have complex plans and it'd be easier
if I didn't have pages and pages of planning info between tries. The queries
themselves are one line each, but refer to views, which make the plans pretty
complex. Being able to see several times in one terminal window would be
easier.Write the queries in a file, run them with psql -f and grep for the desired
lines only.
On Monday 05 March 2007 02:38, Naz Gassiep wrote:
That's not quite as fast as I would like to do it, that throws in a few
more steps which slow down the development process. However if there is
no way I will persevere with the method I have now.
Thanks,
- Naz.
There are several logging parameters in the postgresql.conf, including
log_duration. Logging to a file also has a bonus that you can feed it into a
query analyzing program like pgfouine or pqa.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL