On Thu, Jan 19, 2006 at 11:46:29PM +0200, Hannu Krosing wrote: > ??hel kenal p??eval, K, 2006-01-18 kell 22:35, kirjutas uwcssa: > > I am testing the performance of postgresql on a set of workloads. > > However, > > the output significantly affects the performance evaluation. Is there > > a way > > to by-pass all output of select statements so the timing reflects only > > the > > query evaluation process? > > If you do EXPLAIN ANALYSE QUERY instead of just QUERY, then the backend > discards all rows returned and just gives back performance data
The flipside is that EXPLAIN ANALYZE adds it's own (non-trivial) overhead to the query. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
