> Huh?  The typical use-case is to enable it for all sessions by
> including it in shared_preload_libraries.  That doesn't require any
> particular session to be superuser.  (If you're superuser you can then
> turn it *off* in your session, should you wish.)

It's not practical to have auto-explain on for all queries on a server
which is processing 10K queries/minute.  And non-superusers can't alter
the settings in their session, even the min_duration.

A practical use of auto-explain would involve during it on for a single
user session, or for a specific database user, neither of which are
possible.

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

In response to

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

Responses

• Re: RFC: Timing Events at 2012-11-06 09:20:58 from Albe Laurenz

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2012-11-06 01:52:13
	Subject: Re: Pg_upgrade speed for many tables
Previous:	From: Josh Berkus	Date: 2012-11-06 01:39:40
	Subject: Re: Pg_upgrade speed for many tables