Consider to add check for columns with type json about pg-index-health HOT 1 CLOSED

-- Finds columns of type 'json'. Use 'jsonb' instead.
select
    t.oid::regclass::text as table_name,
    col.attname::text as column_name,
    col.attnotnull as column_not_null
from pg_catalog.pg_class t
         join pg_catalog.pg_namespace nsp on nsp.oid = t.relnamespace
         join pg_catalog.pg_attribute col on (col.attrelid = t.oid)
where
        t.relkind = 'r' and
        col.attnum > 0 and /* to filter out system columns such as oid, ctid, xmin, xmax, etc.*/
        col.atttypid::regtype::text = 'json' and
        nsp.nspname = :schema_name_param::text
order by t.oid::regclass::text, col.attname::text;