Index FILLFACTOR is not default

Copy SQL

WITH indexes_reloptions AS (SELECT 
  pg_class.relname AS index_name, 
  pg_namespace.nspname AS index_schema,
amname AS index_type,
unnest(reloptions) AS reloptions,
pg_get_indexdef(pg_class.oid) AS index_definition
FROM 
  pg_catalog.pg_class, 
  pg_catalog.pg_namespace,
pg_am
WHERE 
  pg_class.relnamespace = pg_namespace.oid 
AND pg_class.relam=pg_am.oid
AND relkind='i')
SELECT index_name, index_schema, index_type, reloptions, index_definition
FROM indexes_reloptions
WHERE (index_type='btree' AND reloptions ILIKE '%fillfactor%' AND reloptions NOT LIKE '%fillfactor=90%')
OR (index_type<>'btree' AND reloptions ILIKE '%fillfactor%')
ORDER BY index_name;