On Fri, 2003-06-20 at 13:06, Yusuf wrote:
> [EMAIL PROTECTED] wrote:
> > 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.
> > 
> 
> That's what I thought at first, so I dropped the foreign key constraints.  The table 
> is referenced by 2 tables, one of 
> which has around 200 000 records and the other has 0 records.

Hmm... EXPLAIN ANALYZE your select again, but join both of those
referenced tables to the appropriate columns.

-- 
Rod Taylor <[EMAIL PROTECTED]>

PGP Key: http://www.rbt.ca/rbtpub.asc

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to