Naz Gassiep <naz(at)mira(dot)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(at)gmail(dot)com>