Does pg_stat_get_live_tuples() matter?

From: Sherrylyn Branchaw <sbranchaw(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Does pg_stat_get_live_tuples() matter?
Date: 2019-04-09 16:45:52
Message-ID: CAB_myF4K=VFL=VF41k2=qNgTQ=r0AzojmBin=ejVHT9A-wat3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-04-09 21:28:58 Re: Does pg_stat_get_live_tuples() matter?
Previous Message Melvin Davidson 2019-04-09 15:22:46 Re: Transactions