Re: [ADMIN] how to find a pg_toast table's primary table

ProPAAS DBA <dba@propaas.com> writes:

> Hi all;
>
>
> I'm seeing this table as the most vacuumed table:
>
>
> pg_toast.pg_toast_16784
>
> How do I find the primary table for this toast table?

Find the pg_class row with reltoastrelid = $oid-of-toast-table.

HTH

>
>
>
> Thanks in advance

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800