On 4/9/19 9:45 AM, Sherrylyn Branchaw wrote:
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?
What version of Postgres?
How are you getting at the 1.8M number?
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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
