You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
The text was updated successfully, but these errors were encountered:
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.
What do you people think? It is useful enough to open a pr?
The text was updated successfully, but these errors were encountered: