Enable the Pgstattuple Extension
The extension pgstattuple is best used when you suspect something is amiss with the performance of a query and you suspect bloat.
The pgstattuple is the most accurate way to determine the bloat in a particular table or index.
I would like the ability to run the command manually as part of my debugging exercises.
It is not required that pgstattuple be run as a service because it is intrusive.