Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cGwT3-0002Fb-Qn for pgsql-admin@arkaria.postgresql.org; Tue, 13 Dec 2016 23:26:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cGwT2-0007dv-Cc for pgsql-admin@arkaria.postgresql.org; Tue, 13 Dec 2016 23:26:40 +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 1cGwRL-0005e2-DS for pgsql-admin@postgresql.org; Tue, 13 Dec 2016 23:24:55 +0000 Received: from mail-io0-x243.google.com ([2607:f8b0:4001:c06::243]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cGwRI-0004ai-K6 for pgsql-admin@postgresql.org; Tue, 13 Dec 2016 23:24:53 +0000 Received: by mail-io0-x243.google.com with SMTP id p13so1342518ioi.0 for ; Tue, 13 Dec 2016 15:24:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=propaas-com.20150623.gappssmtp.com; s=20150623; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding; bh=lPzjPMH2lW/KWyYy5VfkWsdhNb1n6hxWLHNV3Limz2U=; b=P1VtdD8mrZ8a8fPjyvvqWN3nYuaXTboXThgxAqGszgxG0dFiw026o+xwODtvhqtMFv WywrHhn3IV5oGrsySAQ5cYPU+fQEhr9d0AcRtNq3lGZUDc/U9B3PVp9WvC9UtRHZNL/B fDPopviPKOAcbno7MhErHZvL1jtJl/7AnL9QSI3MKuHc63nVXxwQHe63lW5Sdlb5qWKP P1tYu4KkisaAals0j5SBjCMXZuIpunyqxFF2qx/AkmPfDNCLfJ3myTj8nU9HwF9Fbebi h9byYg9JTOL8CJW1uB9GSr9cIYvIW1OjiRyMO7hjm1ncVQhnHoeWXeRRta2cGdQR7X7a Zmag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding; bh=lPzjPMH2lW/KWyYy5VfkWsdhNb1n6hxWLHNV3Limz2U=; b=XjYJO0PxJ0hEdX3DtAwTPjEJJlcKw1nVyvjCvv531Vq4lQ7Ye8/2P0P/vesk2PUhrK VDccZD6/QcmO8kWNDXB2iAaMtAzvlf4SPe297YkmuN8w9jryh59NTJ7YQFCYt6YgWeQA TPqeKjosLDQGS4yG99NiKFrmLqc07v85etomeFqRGgWFH5HPRoHHTEK4JH2jP+Fi8ryh Cj9vRxaJKBqutt6I+FLosj6B85BKq9Ku8tvBKXMOYvdjCL5WK8+XFP1U88Z2so/Kf27K DDHxti1sqa5C5LlSwHtxE2cwL8KQ6J7Xd6Y4Agbb6nTUV9uQfkV+MBtncDbjZgaosuDl NGww== X-Gm-Message-State: AKaTC03r5yTDUN9vC+sHjrcdQahwo4I1o7zHl3Gm+PWTjt8SGFmBXsCI2Lfg6j0ObWoQcQ== X-Received: by 10.107.27.211 with SMTP id b202mr63297127iob.15.1481671491205; Tue, 13 Dec 2016 15:24:51 -0800 (PST) Received: from [192.168.1.17] (c-24-9-41-137.hsd1.co.comcast.net. [24.9.41.137]) by smtp.gmail.com with ESMTPSA id j189sm22081810ioe.14.2016.12.13.15.24.50 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 13 Dec 2016 15:24:50 -0800 (PST) To: pgsql-admin@postgresql.org From: ProPAAS DBA Subject: how to find a pg_toast table's primary table Message-ID: 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 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) 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 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