Skip site navigation (1) Skip section navigation (2)

Re: RFC: Timing Events

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: RFC: Timing Events
Date: 2012-11-06 01:42:21
Message-ID: 50986AFD.7060305@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> 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

Responses

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group