Re: Way to eliminate pg_dump activity from pg_stat_all ?

On Jan 20, 2009, at 11:27 AM, Bryce Nesbitt wrote:

> It is not the db that's never used.  Various tables in the db are  
> never used. This is a database that's been continually added to and  
> modified for ten years -- sometimes cruft accumulates.

Understood.

> It would be nice to get pg_dump activity out of the stats for  
> another reason --- pg_dump adds to the sequential scan activity, in  
> a way that does not represent the "typical" use of the database.   
> Essentially pg_dump is an atypical user of  the database, so it's  
> stats are "different" than the rest of the activity.

It sounds like the proper wording for a feature request here would be  
something like "Disable stats collection on a per-session basis".

> Erik Jones wrote:
>> I doubt it.  From the server's perspective, pg_dump is just a  
>> client executing queries.  If the db is never used, why are you  
>> continually backing it up?
>>
>> On Dec 16, 2008, at 12:55 PM, Bryce Nesbitt wrote:
>>
>>> But I think I'm getting clutter from the nightly backups.  Is  
>>> there a way to keep pg_dump activity out of the statistics? I can  
>>> think of several reasons to want such activity excluded, not just  
>>> this one.

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k