Feature request: List reloptions

[jalexandre0]

Sometimes I need to found tables with individual adjustments like autovacuum_scale_factor ou autovacuum disabled.

I use this query and think it would be useful for other people.

SELECT relname as table, nspname as schema, relkind, reloptions 
FROM
    pg_class c
    JOIN pg_namespace n ON c.relnamespace = n.oid
WHERE reloptions IS NOT NULL AND relname != 'pg_stats'
ORDER BY 2,1;

What do you people think? It is useful enough to open a pr?

[NikolayS]

Great idea @jalexandre0! I've implemented this as PR #73 with some enhancements:

✅ Enhanced version includes:

• Tables, indexes, and materialized views with reloptions
• Partition hierarchy (shows which parent table a partition belongs to)
• Warnings for potentially problematic settings:
  • Autovacuum disabled on large tables
  • Low fillfactor
  • Aggressive autovacuum settings
• Sorted by size (largest objects first)

The query is now available as t2 in the menu (tuning category).

Example output showing partitions:

 schema |    object_name    | object_type |          partition_info          |    size    |               option                |                   note                   
--------+-------------------+-------------+----------------------------------+------------+-------------------------------------+------------------------------------------
 public | measurements_2024 | table       | partition of public.measurements | 8192 bytes | fillfactor=90                       | 
 public | measurements_2025 | table       | partition of public.measurements | 8192 bytes | autovacuum_enabled=false            | autovacuum disabled

Please test it out and let us know if there are any other enhancements you'd like to see!