Metric table_bloat_approx_summary_sql fails with Divide by Zero

[dtmdl]

Similar to #464 (get_table_bloat_approx_sql), the table_bloat_approx_summary_sql fails with a divide by zero error in some circumstances. I applied the same fix to the postgres 12 metric_su.sql, and it appears to work correctly.

[github-actions[bot]]

📅 This issue has been automatically marked as stale because lack of recent activity. It will be closed if no further activity occurs. ♻️ If you think there is new information allowing us to address the issue, please reopen it and provide us with updated details. 🤝 Thank you for your contributions.

[dtmdl]

Still applicable.

[pashagolub]

What version is affected?

Thanks in advance

[dtmdl]

I encountered the problem using:

pgwatch2 1.9.0 postgresql 14.4

Not sure if it's limited to those versions, or just a problem with newly-created (empty) databases.

[github-actions[bot]]

📅 This issue has been automatically marked as stale because lack of recent activity. It will be closed if no further activity occurs. ♻️ If you think there is new information allowing us to address the issue, please reopen it and provide us with updated details. 🤝 Thank you for your contributions.

[dtmdl]

Still applicable.

[pashagolub]

Sorry for delay with answer. Would you please open the pull request with a fix?

Thanks in advance!