On Fri, Jan 13, 2006 at 04:49:02PM -0500, Jaime Casanova wrote: > There has been announce recently about a project for analizing slow queries: > http://archives.postgresql.org/pgsql-announce/2006-01/msg00007.php
Sure, but it still means installing an external tool, which requires PHP, which isn't trivial to install in it's own right. And afaik there's still no way to find out how much IO each query did, how much CPU was spent, if any sorts overflowed, etc., etc. -- 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 5: don't forget to increase your free space map settings
