Re: profiling postgresql queries?

Speaking of triggers...

Is there any plan to speed up plpgsql tiggers?  Fairly simple
crosstable insert triggers seem to slow my inserts to a crawl.

Is the best thing just to write triggers in C (I really don't want to
put this stuff in the application logic because it really doesn't
belong there).

Alex Turner
netEconomist

On Apr 12, 2005 10:10 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> hubert lubaczewski <hubert.lubaczewski@eo.pl> writes:
> > and it made me wonder - is there a way to tell how much time of backend
> > was spent on triggers, index updates and so on?
>
> In CVS tip, EXPLAIN ANALYZE will break out the time spent in each
> trigger.  This is not in any released version, but if you're desperate
> you could load up a play server with your data and test.
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>