Postgres Pro
Downloads
Home   >   mailing lists

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

From Jorge Torralba
Subject Re: [ADMIN] how to find a pg_toast table's primary table
Date
Msg-id CACut7uSmEsnASj_DQ=+LHTDNKy2PopzO_+pLNMV6oPaFgUwyow@mail.gmail.com
Whole thread Raw
In response to [ADMIN] how to find a pg_toast table's primary table  (ProPAAS DBA <dba@propaas.com>)
List pgsql-admin
Tree view
select relname from pg_class where reltoastrelid = ( select oid from pg_class where relname = 'toast_table_name' );

On Tue, Dec 13, 2016 at 3:24 PM, ProPAAS DBA <dba@propaas.com> 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?



Thanks in advance



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.

pgsql-admin by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: [ADMIN] how to find a pg_toast table's primary table
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] how to find a pg_toast table's primary table