Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cGwfN-0002dH-5A for pgsql-admin@arkaria.postgresql.org; Tue, 13 Dec 2016 23:39:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cGwfM-0001Os-OY for pgsql-admin@arkaria.postgresql.org; Tue, 13 Dec 2016 23:39:24 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cGwfM-0001Ol-2A for pgsql-admin@postgresql.org; Tue, 13 Dec 2016 23:39:24 +0000 Received: from resqmta-po-01v.sys.comcast.net ([2001:558:fe16:19:96:114:154:160]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cGwfF-0004qH-9S for pgsql-admin@postgresql.org; Tue, 13 Dec 2016 23:39:22 +0000 Received: from resomta-po-17v.sys.comcast.net ([96.114.154.241]) by resqmta-po-01v.sys.comcast.net with SMTP id GwdvcAlx5P4DhGwfCcHVAa; Tue, 13 Dec 2016 23:39:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20161114; t=1481672354; bh=r7+rBOmHW2eNkMTjjTxOR+hYdAPoMNRjJVggdcodWJ8=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=j062/hhQeTL3ZZcha49TaopQVJJlFhJ2NPTj3WmIXu+VBr+5Ncxs/3dqQjpOsgCmz j60Aoho+Yi/elnUiY8vQiSxs9KRG4EN0i0QwC8wfLquRX1dL7320fEkfW7k9RtnnqS 4rPfx0R16rnWNKBRutQpNSqiIlFnaZelPAby4H/UgZRj2nsoUmkOmobojlJRIdKw0A +HKukC75F8ctEd/VBH5oCgbGQH8eFfjSaece1JTBIO/8L73b7yzmWYOmGCaf2E98C+ AKLInNQSvbtQKiYlU/FTNcfAZLI22rXg4q5EBnDdSMWvHzM2+PBtarHPcsADPhzyJO P9F7RipXxEIfQ== Received: from jerry.enova.com ([12.30.159.20]) by resomta-po-17v.sys.comcast.net with SMTP id Gwf1cuLpdsDpiGwf3cIAHz; Tue, 13 Dec 2016 23:39:12 +0000 Received: by jerry.enova.com (Postfix, from userid 1001) id 2B139740202; Tue, 13 Dec 2016 17:39:03 -0600 (CST) From: Jerry Sievers To: ProPAAS DBA Cc: pgsql-admin@postgresql.org Subject: Re: how to find a pg_toast table's primary table References: Date: Tue, 13 Dec 2016 17:39:03 -0600 In-Reply-To: (ProPAAS DBA's message of "Tue, 13 Dec 2016 16:24:49 -0700") Message-ID: <86wpf3qu08.fsf@jerry.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-CMAE-Envelope: MS4wfEpo9UjAGC1IWej8VgUN6MxvVwQVtD6yY02oGBX4b4pJm8pO2e6W2t57NDO3Gv5huGaDud8C6UdTLo7Mi+oOI6ZqE/c5F1yCuUYZH3mTsiLSBwVtFLdD jMTDqn78494yJQRuTb9lMW8frLN554FPb29uSfSZUSTX0PeLsNhUbLzYRida8DiV3UAglrnGMMd6zM7wyM7P3cTn1kN/0IZfhYM= X-Pg-Spam-Score: -4.5 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ProPAAS DBA writes: > 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? Find the pg_class row with reltoastrelid = $oid-of-toast-table. HTH > > > > Thanks in advance -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin