Metrics Related to Vacuum

[mertbakir]

Hi,

I couldn't find these on default grafana dashboards and I wonder if it's possible to add, or if you have any other suggestions to track these:

• Duration of each vacuum
• number of removed tuples
• bloat percentage for each table

In order to get bloat percentage, we created this helper function . We are on postgres 15, not 12.
However, when I check the table table_bloat_approx_summary_sql there is no table name information. How am I supposed to know which table the data belongs, clearly I am doing something wrong.

Example: select * from table_bloat_approx_summary_sql

time:
dbname:
data: {"approx_table_bloat_b": 3834355712, "approx_bloat_percentage": 5}
tag_data: null