Skip to content

fix: F004 exclude empty tables from recommendations

Dmitry requested to merge dmius-f004-fix into master

Description

In case when a table is empty (has 0 rows) its heap bloat is estimated as 100%. In some cases, such a table might be included in "F004 Recommendations" and considered as of top priority (P1). This leads to messages containing the wrong statement "can be reduced 0.00 times", for example:

table1: size 5.87 MiB, can be reduced 0.00 times, by ~5.87 MiB (~100.00%)

This behavior was changed: from now on, empty tables are excluded from consideration.

CI: a new test was added to check this case automatically.

  • the MR description has been reviewed
  • this MR contains text changes and they have been reviewed OR there are no texts changes
  • this MR contains GUI/CLI changes and they have been reviewed OR there are no GUI/CLI changes
  • this MR contains API changes and they have been reviewed OR there are no API changes

Related issue

https://gitlab.com/postgres-ai/postgres-checkup/issues/444

Edited by Nikolay Samokhvalov

Merge request reports