Re: No stats visible?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: No stats visible?
Дата
Msg-id m31y1mq4sj.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на No stats visible?  (Steve Lane <slane@moyergroup.com>)
Список pgsql-general
Steve Lane <slane@moyergroup.com> writes:

> Hello all:
>
> I've been looking at Postgres' statistics tables to try to get some sense of
> why my database server seems to be running slowly. Oddly, the stats tables
> seem to be recording no activity! pg_stat_get_tuples_inserted on one of my
> main tables says no tuples have been inserted. I also get lots of zeroes for
> all the main numbers on most of the other tables.

Are you running ANALYZE regularly?  Are you VACUUMing?

-Doug

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

Предыдущее
От: "Andy Kriger"
Дата:
Сообщение: administering connections to a database?
Следующее
От: Ivan
Дата:
Сообщение: simple questions