Keith Fiske wrote: > > > > What queries do you use to estimate index and table bloat? [dd] > Why estimate when you can get the exact amount? At least for b-tree indexes > anyway. > > https://github.com/keithf4/pg_bloat_check Hello Keith, Thanks for this script and for reminding about pgstattuple. The script has the drawback of requiring r/w access to the database, so it cannot be run on a replica. But the idea is excellent. At least it can show the top N bloated relations, and then I can further explore with pgstattuple(), pgstatindex() etc. -- Victor Sudakov, VAS4-RIPE, VAS47-RIPN 2:5005/49@fidonet http://vas.tomsk.ru/
