Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> BTW, something that just occurred to me now: EXPLAIN is currently really
> designed only for SELECTs. It would make sense to upgrade it for
> INSERT/UPDATE/DELETE to list the triggers that will get fired. While
> we'd have to treat user triggers as black boxes, I think it would also
> be possible to "look inside" RI triggers and display the plans of the
> queries that will get invoked.
It seems EXPLAIN ANALYZE at least ought to be able to show the complete plan
for even user triggers.
--
greg