Comments on: PostgreSQL Tuple-Level Statistics With pgstattuple https://www.percona.com/blog/postgresql-tuple-level-statistics-with-pgstattuple/ Wed, 01 Nov 2023 18:32:52 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Yeshas Siddi MS https://www.percona.com/blog/postgresql-tuple-level-statistics-with-pgstattuple/#comment-10974195 Wed, 01 Nov 2023 18:32:52 +0000 https://www.percona.com/blog/?p=91059#comment-10974195 Hi Shivam,

Thank you for the blog, really helpful. I tried pgstattuple and noticed that the iops consumption goes through the roof as the size of the tables increases, which made me curious about pgstattuple_approx(regclass). This function does not do a full table scan, with the caveat that the table should be vacuumed frequently so that the visibility map provides up to date info about visible tuples.

Regards,
Yeshas Siddi M S

]]>