Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qspXG-009fR6-2R for pgsql-admin@arkaria.postgresql.org; Tue, 17 Oct 2023 19:15:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qspXC-00DKH4-Tl for pgsql-admin@arkaria.postgresql.org; Tue, 17 Oct 2023 19:15:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qspXC-00DKGw-Gw for pgsql-admin@lists.postgresql.org; Tue, 17 Oct 2023 19:15:19 +0000 Received: from mail-yb1-xb2c.google.com ([2607:f8b0:4864:20::b2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qspX8-001E5U-S7 for pgsql-admin@lists.postgresql.org; Tue, 17 Oct 2023 19:15:18 +0000 Received: by mail-yb1-xb2c.google.com with SMTP id 3f1490d57ef6-d9a398f411fso6866778276.3 for ; Tue, 17 Oct 2023 12:15:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1697570114; x=1698174914; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=uz9N+W1dP9w3AglDD7EIoONaBlHF6LXJJnXNRO/k/S0=; b=Tp+y/2624lQ1XMZWk4ozRN96D6AWZeo2PtwbKSmjHQL/6Uon5mx3fNpckjKtKWXKHY 9cFsE1oA4C62zJIi+yvij/5F2zPpOqOBZG9WfHp2Tj7dzEOFb23GN6u8H6pIZQZk48Mk MncEkrGHW8bX/iRJSkqfHanEmo15mP9danfppL5gDjF69vOyifeCuwqsc7ngbIP9Jg6/ F321xTCr9VWXDMv1gSxSg+ibkMaMmjhRe94AE6uMCIDkDuwUkgP3qrv6TvjLnpUfWnDX 9DSIwfOOiJVmErlHrMzPSAIcxQe9ifGNOA9t1VHUvELcS4SBHHn0Yahj/Xm7EV7BPy3m oZlw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697570114; x=1698174914; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=uz9N+W1dP9w3AglDD7EIoONaBlHF6LXJJnXNRO/k/S0=; b=mCu2STYcHkZiZssLVstvRfywRede2DFW/FwBqY/Z6cKBRErGez/cIWfoWjrTJUx3ml qaqPwerF6uPinvMOpUbbBAd1yM8/olzfgcpuGVlxgfekLEBraguGMaDeHuHbDyNeOa4b qsuiaMUqQQozp7ry3YxFNmltbU2GJYApyzYHPftCqWa1xrdWwFKDxFAzvix/quSZYwrC F2l06BonyxUBmzAh1aXmyKBRNV6bbuTQV+9rUY4CzPVKHSWpxBH+e/sxn85WwLz+rTCX ncFgIgMgxI7FHDzy1571q1me2eFS8g7HAFLotU6MVtMbUUYWnVrR6WzM+inNCg7qWZ/V PF8Q== X-Gm-Message-State: AOJu0YxYgA41lkLkTM7bF9SDax2kpJ+LSkw5CoN2Yy2lVPgrBC1gICUw 6W25fMHGli3IvSJetTarglHKvSX2T3o= X-Google-Smtp-Source: AGHT+IHmeKVKsF60xe+ghhlhd1Qjeoqt8R/xQ+iDaFWkvpOO81M78GLq6CCrJyFrNIq+pBfRlYNczw== X-Received: by 2002:a25:d293:0:b0:d91:116e:db0a with SMTP id j141-20020a25d293000000b00d91116edb0amr3509039ybg.29.1697570113545; Tue, 17 Oct 2023 12:15:13 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:7c18:e478:1f0:7aca? ([2600:1700:bd2c:b810:7c18:e478:1f0:7aca]) by smtp.googlemail.com with ESMTPSA id g201-20020a25dbd2000000b00d7e339ada01sm726085ybf.20.2023.10.17.12.15.12 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 17 Oct 2023 12:15:13 -0700 (PDT) Message-ID: Date: Tue, 17 Oct 2023 14:15:12 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Table health Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/17/23 12:53, Rajesh Kumar wrote: > I have been asked to check table health of specific big table. Are there suspected problems? > What are list of things I have to check? amcheck is what you want? -- Born in Arizona, moved to Babylonia.