Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] how to find a pg_toast table's primary table - Mailing list pgsql-admin

From Jerry Sievers
Subject Re: [ADMIN] how to find a pg_toast table's primary table
Date
Msg-id 86wpf3qu08.fsf@jerry.enova.com
Whole thread Raw
In response to [ADMIN] how to find a pg_toast table's primary table  (ProPAAS DBA <dba@propaas.com>)
Responses Re: [ADMIN] how to find a pg_toast table's primary table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [ADMIN] how to find a pg_toast table's primary table
Next
From: Jorge Torralba
Date:
Subject: Re: [ADMIN] how to find a pg_toast table's primary table