Re: Question about DB stats resets

Поиск
Список
Период
Сортировка
От raghu ram
Тема Re: Question about DB stats resets
Дата
Msg-id CALnrrJSJ3iiZQSfc0jX5ypvDLnhWmSAFp+yo4p_kysrvyE1=TA@mail.gmail.com
обсуждение исходный текст
Ответ на Question about DB stats resets  (Luis <luisico@gmail.com>)
Список pgsql-admin

On Fri, Jul 26, 2013 at 9:01 PM, Luis <luisico@gmail.com> wrote:
Hi, I have a doubt about stats reset.

I've been investigating some zero values in some tables tuples stats.
By querying pg_stat_database view I can see reset times (pg_stat_database) that have not been performed by me (doing a SELECT pg_stat_reset())

My question is, what other actions or events may reset the stats of a DB?

I don't know if, somehow, having a busy server or with a high number of DBs may produce this effect.


Statistics will reset whenever we are stopping PostgreSQL Instance in IMMEDIATE mode.

Thanks & Regards
Raghu Ram 

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Disk latency goes up during certaing pediods
Следующее
От: Bert
Дата:
Сообщение: vacuum full suddently took extremely long