<!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. So I tried to
identify and confirm with:<br>
<blockquote><tt>select pg_stat_reset(); <br>
<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. 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>