> I think auto_explain would help you solve such rare incidents
> if it could dump several statistics into server log, including lock
> waits and block reads/writes statistic per-session, for example.
> 
> Do we have something to add to auto_explain?

Well, to be frank, I've never found auto-explain to be useful because of
its restriction to superuser sessions.  It's an interesting
proof-of-concept, but completely useless at any production site.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

• Re: RFC: Timing Events at 2012-11-04 09:28:11 from Satoshi Nagayasu

Responses

• Re: RFC: Timing Events at 2012-11-05 20:44:54 from Tom Lane

pgsql-hackers by date

Next:	From: Andrew Dunstan	Date: 2012-11-05 18:50:39
	Subject: Re: Deprecations in authentication
Previous:	From: Peter Eisentraut	Date: 2012-11-05 18:47:58
	Subject: Re: Deprecations in authentication