Health and performance · stop 10 of 13
bloat_report
Estimates which tables carry the most dead rows.
Works in read modeTool sets: dba · full
You might ask
“Which tables need a vacuum?”
Your assistant may call bloat_report to answer.
How it works
- A quick estimate from the dead-row ratio in
pg_stat_user_tables(tables with over 1,000 dead rows), not a measurement of on-disk bloat.
Parameters
limitnumber- Maximum number of tables to return. Default 10.
What your assistant reads
The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.
Approximate table bloat via dead-tuple ratio from pg_stat_user_tables (simplified estimate — not physical page bloat). Tables with >1000 dead tuples, ordered by bloat %.