Postgres pg_toast in autovacuum - which table? Postgres pg_toast in autovacuum - which table? postgresql postgresql

Postgres pg_toast in autovacuum - which table?


Here's a shorter way:

select 15404513::regclass;

where 15404513 is pg_toast_ suffix.


I think you'll want something like:

select n.nspname, c.relname from pg_class c inner join pg_namespace n on c.relnamespace = n.oidwhere reltoastrelid = (    select oid    from pg_class     where relname = 'pg_toast_15404513'     and relnamespace = (SELECT n2.oid FROM pg_namespace n2 WHERE n2.nspname = 'pg_toast') )

It'd be nice if Pg reported this in the vacuum command summary.