Returns only 1 index on the table with the data

[replyvishu]

The query returns bloat and size information only on one index of the table even if tables has multiple indexes.

[qdw]

The query in index_bloat_check.sql shows only indexes that are over 10MB in size and over 50% bloat. That might be the reason you're seeing only one index.

If you want to see all indexes, you can edit index_bloat_check.sql and remove this line:

WHERE ( bloat_pct > 50 and bloat_mb > 10 )

Please let me know whether that fixes your issue or not. Thanks!

[replyvishu]

I am sorry if the description of the issue was not very explanatory. The issue is even if table has multiple indexes on it , the index_bloat_check.sql script shows only one index on the table even if other indexes in the same table matches the criteria.

I had to remove the clause 'AND pg_attribute.attnum = ind_atts.attnum' to get all index information on the table that matches the criteria.