I find it easier and more efficient to have the sql ready and a comprehensive performance queries.
One mistake I made was miscalculating the ratio for vacuum threshold and as a result the auto vacuum didn't run.
Any suggestions or corrections, let me know.