On Thu, Jun 30, 2005 at 10:11:56AM -0400, Rod Taylor wrote:
> On Thu, 2005-06-30 at 23:02 +0900, Satoshi Nagayasu wrote:
> > > The TODO item is about counting all temporary files, not sorts in
> > > particular. Or at least that's what I thought it meant.
> >
> > If the DBA have to improve the performance,
> > DBA will need to know about:
> >
> > - Which SQL generate a disk sort?
>
> Good point. An EXPLAIN ANALYZE note about the disk usage for the sort
> would be really nice.
Even nicer would be a way to log queries that generate on-disk sorts.
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"