Jim C. Nasby wrote: > Hrm... I was about to suggest that for timing just the query (and not > output/data transfer time) using explain analyze, but then I remembered > that explain analyze can incur some non-trivial overhead with the timing > calls. Is there a way to run the query but have psql ignore the output? > If so, you could use \timing.
Would timing "SELECT COUNT(*) FROM (query)" work? -- Kevin Brown [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster