1

Topic: Whether it is possible to trust representation pg_stat_user_tables?

Good evening.
In general, a situation such:
There is an enormous table.
SELECT COUNT (1) FROM table
Lasts already more than 10 hours.
With what error n_live_tup in pg_stat_user_tables corresponds real  lines in the table?

2

Re: Whether it is possible to trust representation pg_stat_user_tables?

Dark blue Elephant;
And you are assured that locks are not present? What size of the table on ` \dt + ` in the client?
And what disk recycling + response time?