Display Total in reports related to bloat and dead tuples, indexes (index sizes)

Goal

TODO

Display Total in reports related to bloat and dead tuples, indexes (index sizes).

How to implement

See how it's implemented in "L001 Table sizes" – do the same.

Acceptance criteria

As I DBA, I can quickly understand the total size:

  • of heap bloat (estimated)
  • of index bloat (estimated)
  • unused indexes to be dropped (how much disk space can I save?)
  • redundant indexes to be dropped (how much disk space can I save?)
  • invalid indexes (how much disk they occupy which I can save potentially?)
Edited by Anna