Naz Gassiep <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings