how to find a pg_toast table's primary table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: how to find a pg_toast table's primary table
From: ProPAAS DBA <dba@xxxxxxxxxxx>
Date: Tue, 13 Dec 2016 16:24:49 -0700
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.5.1

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Follow-Ups:
- Re: how to find a pg_toast table's primary table
  - From: Jorge Torralba
- Re: how to find a pg_toast table's primary table
  - From: Jerry Sievers
- Re: how to find a pg_toast table's primary table
  - From: Joshua D. Drake

Prev by Date: Re: Frequent errors in postgresql.log
Next by Date: Re: how to find a pg_toast table's primary table
Previous by thread: Frequent errors in postgresql.log
Next by thread: Re: how to find a pg_toast table's primary table
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux