From: | Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com> |
---|---|
To: | ProPAAS DBA <dba(at)propaas(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: how to find a pg_toast table's primary table |
Date: | 2016-12-13 23:40:37 |
Message-ID: | CACut7uSmEsnASj_DQ=+LHTDNKy2PopzO_+pLNMV6oPaFgUwyow@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)propaas(dot)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(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-12-13 23:46:18 | Re: how to find a pg_toast table's primary table |
Previous Message | Jerry Sievers | 2016-12-13 23:39:03 | Re: how to find a pg_toast table's primary table |