Postgres Pro
Downloads
Home   >   mailing lists

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

From ProPAAS DBA
Subject [ADMIN] how to find a pg_toast table's primary table
Date
Msg-id d37e27d8-7e83-e077-3e11-a13857a299de@propaas.com
Whole thread Raw
Responses Re: [ADMIN] how to find a pg_toast table's primary table  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: [ADMIN] how to find a pg_toast table's primary table  (Jerry Sievers <gsievers19@comcast.net>)
Re: [ADMIN] how to find a pg_toast table's primary table  (Jorge Torralba <jorge.torralba@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Keith
Date:
Subject: Re: [ADMIN] Frequent errors in postgresql.log
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [ADMIN] how to find a pg_toast table's primary table