On Tue, 2023-10-17 at 23:23 +0530, Rajesh Kumar wrote: > I have been asked to check table health of specific big table. > > What are list of things I have to check? Look at pg_stat_all_tables to see if the number of dead tuples is excessive and if autovacuum and autoanalyze are running as they should. Look at pg_class to see if "relfrozenxid" and "relminmxid" are far from the danger zone. Run the function pgstattuple_approx() to see if the table is bloated. Yours, Laurenz Albe
