Way to eliminate pg_dump activity from pg_stat_all ?

Поиск
Список
Период
Сортировка
От Bryce Nesbitt
Тема Way to eliminate pg_dump activity from pg_stat_all ?
Дата
Msg-id 494815CE.5090907@obviously.com
обсуждение исходный текст
Ответы Re: Way to eliminate pg_dump activity from pg_stat_all ?  (Erik Jones <ejones@engineyard.com>)
Список pgsql-sql
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 /> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Judith Altamirano
Дата:
Сообщение: pg_clog/0202 Error
Следующее
От: Erik Jones
Дата:
Сообщение: Re: Way to eliminate pg_dump activity from pg_stat_all ?