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

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: ProPAAS DBA <dba(at)propaas(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to find a pg_toast table's primary table
Date: 2016-12-13 23:39:03
Message-ID: 86wpf3qu08.fsf@jerry.enova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

ProPAAS DBA <dba(at)propaas(dot)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(dot)consulting(at)comcast(dot)net
p: 312.241.7800

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Torralba 2016-12-13 23:40:37 Re: how to find a pg_toast table's primary table
Previous Message Joshua D. Drake 2016-12-13 23:33:55 Re: how to find a pg_toast table's primary table