Re: pg_stat_user_tables.n_tup_ins empty for partitioned table

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: pg_stat_user_tables.n_tup_ins empty for partitioned table
Дата
Msg-id CAKJS1f-VVpdBsVWTbCsDG0ZLPExhNidfGj3HmNeXgXbhv4=qVQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_stat_user_tables.n_tup_ins empty for partitioned table  (Luca Ferrari <fluca1978@gmail.com>)
Ответы Re: pg_stat_user_tables.n_tup_ins empty for partitioned table  (Luca Ferrari <fluca1978@gmail.com>)
Список pgsql-general
On Fri, 24 May 2019 at 19:20, Luca Ferrari <fluca1978@gmail.com> wrote:
>
> On Wed, May 22, 2019 at 7:55 PM Andres Freund <andres@anarazel.de> wrote:
> > That clearly seems wrong. Could you try build a small reproducer?
>
> Apparently not, I've tried to simulate the same but without any
> success, that is n_tup_ins is always correctly set.
> However, I've noted that this behavior applies up to february

Did you perhaps reset the stats or failover to a standby around Feb?

What does: select stats_Reset from pg_stat_database where datname =
current_database(); say?

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: pg_stat_user_tables.n_tup_ins empty for partitioned table
Следующее
От: Luca Ferrari
Дата:
Сообщение: Re: pg_stat_user_tables.n_tup_ins empty for partitioned table