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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> hubert lubaczewski <hubert(dot)lubaczewski(at)eo(dot)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(at)postgresql(dot)org)
>