Re: how to find a pg_toast table's primary table

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: ProPAAS DBA <dba(at)propaas(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: how to find a pg_toast table's primary table
Date: 2016-12-13 23:33:55
Message-ID: fa0a390a-ffbd-8da9-373a-1b981063ca4d@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 12/13/2016 03:24 PM, ProPAAS DBA wrote:
> 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?

Within the database:

select oid::regclass from pg_class where reltoastrelid='16784'::regclass;

JD;

--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2016-12-13 23:39:03 Re: how to find a pg_toast table's primary table
Previous Message ProPAAS DBA 2016-12-13 23:24:49 how to find a pg_toast table's primary table