Re: profiling postgresql queries? - Mailing list pgsql-performance

From Tom Lane
Subject Re: profiling postgresql queries?
Date
Msg-id 15425.1113315053@sss.pgh.pa.us
Whole thread Raw
In response to profiling postgresql queries?  (hubert lubaczewski <hubert.lubaczewski@eo.pl>)
Responses Re: profiling postgresql queries?
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Dave Held"
Date:
Subject: Re: 4 way JOIN using aliases
Next
From: Bendik R.Johansen
Date:
Subject: Slow update