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
along time<br /><br /> select * from pg_stat_all_tables where schemaname='public' order by seq_scan,seq_tup_read;<br />
selectgreatest(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
activityout of the statistics? I can think of several reasons to want such activity excluded, not just this one.<br />
