explain triggers

From: Ryan Mahoney <ryan(at)paymentalliance(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: explain triggers
Date: 2003-04-22 17:52:43
Message-ID: 1051033963.12082.8.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a simple way or ready built script to view the EXPLAIN output
of a query *and* the EXPLAIN output of the triggers that will be
executed due to the initial statement?

I have a few comlpex database schemas and I apply referential integrity
constraints throughout. Some delete statements have become
excruciatingly slow - I suspect this is due to some of the queries being
executed by triggers created by my referential integrity constraints
that currently use sequential scans where an index scan would be more
appropriate. If I could see the explain output of all of this is would
save a lot of time narrowing things down.

If no one knows how to do this / or it hasn't been done yet, maybe I'll
hack this together.

Thanks!

-r

--
Ryan Mahoney <ryan(at)paymentalliance(dot)net>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2003-04-22 18:06:35 Re: Documentation
Previous Message Steve Crawford 2003-04-22 17:46:01 Re: Time handling in pgsql. (fwd)