If a table has 1.8M rows in reality, yet pg_stat_get_live_tuples() returns
1.8K, does it matter to the performance of the database, as long as
pg_class.reltuples is the right order of magnitude?

The query planner seems to use the accurate estimate, but what about the
autovacuum daemon? Or anything else?

In short, is pg_stat_get_live_tuples() (and the views that invoke it) used
by any built-in tooling, or is it just there for the user to do monitoring?

Thanks,
Sherrylyn

Reply via email to