Re: Does pg_stat_get_live_tuples() matter?

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(dot)klaver(at)aklaver(dot)com