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