Re: pg_stat tables empty

Поиск
Список
Период
Сортировка
От Gavin Thompson
Тема Re: pg_stat tables empty
Дата
Msg-id 1086910275.2990.33.camel@xenothanes
обсуждение исходный текст
Ответ на Re: pg_stat tables empty  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Sorry Tom, my description was a bit misleading, some stats tables are
being updated, some aren't.

e.g. pg_stat_all_tables is being updated, whereas pg_statio_all_tables
has rows for each table but the columns are not being updated.

Cheers,
Gavin

On Fri, 2004-06-11 at 06:47, Tom Lane wrote:
> Gavin Thompson <gavin@catalyst.net.nz> writes:
> > My statistics collector is not collecting any statistics and functions
> > such as pg_stat_get_tuples_fetched() return 0.
>
> I'd wonder about kernel packet filtering preventing the data from
> getting through to the collector.  Our CVS tip has a startup-time check
> to warn of this situation, but it's not in any released version...
>
>             regards, tom lane


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

Предыдущее
От: sathish
Дата:
Сообщение: doubt
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: which system tables govern access privileges?