Hello SK, you can use the pgstattuple extension, which provides exact table and index bloat statistics. https://www.postgresql.org/docs/current/pgstattuple.html https://www.percona.com/blog/postgresql-tuple-level-statistics-with-pgstattuple/ Regards, Sravya. On Sat, Dec 14, 2024 at 3:29 AM kamal deen <kamaldeendba@xxxxxxxxx> wrote: > > Hi All, > > Kindly share the query details to identify the dead tuples ratio at table & index level. > > We have noticed some of our partioned tables generating more WAL files during vacuumb.(around 50 to 60GB > > (We are in the plan to remove this manual job later since auto vacuum is enabled) > > Thanks in advance ☺️ > > Regards, > SK
