Обсуждение: pgstattuple extension - Can pgstattuple_approx support toast tables?

Hello,

The pgstattuple extension is pretty useful to monitor table bloat.

I have few large tables with bytea column that represent TB of data that I would need to monitor.

I ran pgstattuple() on the associated toast tables but it takes hours to run.

pgstattuple_approx() would be a nice alternative but it does not accept toast tables.

It can be run on pg_largeobject which is very similar to the toast table structures.

Why pgstattuple_approx() cannot be run on toast tables?

Regards,