Postgres Pro
Downloads
Home   >   mailing lists

How do I see what triggers are called on cascade? - Mailing list pgsql-performance

From andrew@pillette.com
Subject How do I see what triggers are called on cascade?
Date
Msg-id 200408240002.i7O02Iq30466@pillette.com
Whole thread Raw
Responses Re: How do I see what triggers are called on cascade?
List pgsql-performance
Tree view 
I'm still having trouble with slow cascading DELETEs. What commands can I issue to see the sequence of events that
occursafter I execute  

DELETE FROM x WHERE p;

so that I can see if indexes being used correctly, or I have a constraint I don't want, etc.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql 8.0 beta - fail to collect statsistic
Next
From: Tom Lane
Date:
Subject: Re: How do I see what triggers are called on cascade?