Does pg_stat_get_live_tuples() matter? - Mailing list pgsql-general

From Sherrylyn Branchaw
Subject Does pg_stat_get_live_tuples() matter?
Date
Msg-id CAB_myF4K=VFL=VF41k2=qNgTQ=r0AzojmBin=ejVHT9A-wat3A@mail.gmail.com
Whole thread Raw
Responses Re: Does pg_stat_get_live_tuples() matter?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Does pg_stat_get_live_tuples() matter?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Transactions
Next
From: Adrian Klaver
Date:
Subject: Re: Does pg_stat_get_live_tuples() matter?