H002: build list of redundant indexes fixed, generation json data for indexes fixed
Description
In some cases some partial indexes and indexes with conditions we have recommended to remove as redundant. Incorrect conditions was removed from code, so now it should detect redundant indexes more correctly. Also in cases when schema where placed table of index is null such indexes can be skipped in json code. It fixed in this MR too.
-
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/460 https://gitlab.com/postgres-ai/postgres-checkup/issues/470
Examples
Edited by Anatoly Stansler