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 jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461