On Fri, 2003-06-20 at 15:53, Yusuf wrote:
> Why would the following query take soo long to run? What does 28.12 msec represent, since the total running time is
> 16801.86 ms.
I'd hazard to guess that you have a whole slew of foreign keys cascading
to delete, update, or check many rows from other tables.
Those are not represented in the explains at the moment.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc