Hi all,
I have strange behavior with a stat of pg_stat_user_tables (explained
below), where number of live tuples is not the real number at all. (25M
vs 111M)
- select n_live_tup, last_autoanalyze from pg_stat_user_tables where
relname = 'items'
n_live_tup : 111 191 791
last_autoanalyze : 2016-09-27 04:03:35.09233+02
- select count (1) from items;
count
----------
25307071
I've comparated my 10 biggest tables, only this table gave me wrong results.
Does anyone have an idea about it ?
Thanks
--
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
