> 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