how to find a pg_toast table's primary table

From: ProPAAS DBA <dba(at)propaas(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: how to find a pg_toast table's primary table
Date: 2016-12-13 23:24:49
Message-ID: d37e27d8-7e83-e077-3e11-a13857a299de@propaas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2016-12-13 23:33:55 Re: how to find a pg_toast table's primary table
Previous Message Keith 2016-12-13 03:24:14 Re: Frequent errors in postgresql.log