Re: Query timing

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>