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

Way to eliminate pg_dump activity from pg_stat_all ?

From: Bryce Nesbitt <bryce2(at)obviously(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Way to eliminate pg_dump activity from pg_stat_all ?
Date: 2008-12-16 20:55:42
Message-ID: 494815CE.5090907@obviously.com (view raw or flat)
Thread:
Lists: pgsql-sql
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
I've got a bunch of tables in a legacy database that I <i>know</i> are
<i>never</i> used, and some more I'm not sure about.&nbsp; So I tried to
identify and confirm with:<br>
<blockquote><tt>select pg_stat_reset(); <br>
&nbsp;&nbsp;&nbsp;&nbsp; <br>
-- Wait a long time<br>
  <br>
select * from pg_stat_all_tables where schemaname='public' order by
seq_scan,seq_tup_read;<br>
select greatest(heap_blks_read,heap_blks_hit),relname from
pg_statio_all_tables where schemaname='public' order by 1 desc; </tt><br>
</blockquote>
But I think I'm getting clutter from the nightly backups.&nbsp; 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.<br>
</body>
</html>


Attachment: unknown_filename
Description: text/html (879 bytes)

Responses

pgsql-sql by date

Next:From: Erik JonesDate: 2008-12-17 00:33:21
Subject: Re: Way to eliminate pg_dump activity from pg_stat_all ?
Previous:From: Judith AltamiranoDate: 2008-12-16 17:54:38
Subject: pg_clog/0202 Error

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