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 1tMDgv-002kfN-7S for pgsql-admin@arkaria.postgresql.org; Fri, 13 Dec 2024 21:59:21 +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 1tMDgr-00Cq5j-Bj for pgsql-admin@arkaria.postgresql.org; Fri, 13 Dec 2024 21:59:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tMDgq-00Cq5b-Lu for pgsql-admin@lists.postgresql.org; Fri, 13 Dec 2024 21:59:17 +0000 Received: from mail-pj1-x102d.google.com ([2607:f8b0:4864:20::102d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tMDgp-002gwl-0Q for pgsql-admin@postgresql.org; Fri, 13 Dec 2024 21:59:16 +0000 Received: by mail-pj1-x102d.google.com with SMTP id 98e67ed59e1d1-2ee786b3277so1471740a91.1 for ; Fri, 13 Dec 2024 13:59:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734127154; x=1734731954; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=GoqQDYBpdYvepTLONGop5KR98rWkdOrj1coNa4Papgc=; b=NRaAkKBHejlV0+qCAgbMvNRZ36fqZ9ihXwGbWnmIIDZNK8T35br/BdgmQP/hctuI21 5WnoerxrHrm7LsydKIVfzGpnAGENJKmri2E7/VjshFJ49UX2dGXy3X18AXjPgel9uk/q A/IDtb8GSlu02sbouuOx8CSfcWu8OK5fzEEy10U3NdtSGM51gYFqQ4QLhV1WJppe1Hc9 nPtYR8EpbAMRwgmNqfLsQoEpD7DbsW1w0SUUR5hiN2cF3vTInig5bjmusWkKqnB+YRDu n+FyDazYoxrkLR4RnLKasmdQcftFU07UWYVV/ivseCFAmIBZbuGGXXpHfQJjLFKe+NhZ j8Dg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734127154; x=1734731954; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=GoqQDYBpdYvepTLONGop5KR98rWkdOrj1coNa4Papgc=; b=kWAkJgpAibNXR/u8MNt5DYiLuMn6ttmsrjHZkbsHn86PchWj7BwPgNJy/8YuthDIWM BSsf++AN41bjdju+J4s9i3kRlwWzvNlhHZeqF6FlX0zlaizMA4ZVc4DA+YXnZW/qrLvg GTD3rAD3MwVBklfCcXifmjhH1cR65CTf7Bigvk8B0VDCainfsYzTemKCTGgWPuBGGPmL WMrkFDPkBScKxs5KO6w0A6fLqAILmyFpdCFN4CqrxZK0JOm1EjK2OwBjqcVoDuk1rr47 YmiADQbR9cckmfIWZcAQI05I0BOfHSlYfqLQWTjlodXgXSRoRy6hXXLX3X9DoLMLrjXG VbDA== X-Gm-Message-State: AOJu0YxDxWPLotlChleWmhEwdKQxKsJlgPwunp3dDJnQ1Fk9swbjjSV7 ZNG+Lnkz/iGrLT/HsciK6sDOcbtPGfk++/xojQyfXsmnqnfn+ahG71oRU7/dQN1EwG6+IhPNjNa 2CU9fE5cn8SrpnKzY10SEoVG/b9yW+w== X-Gm-Gg: ASbGnctYwQ7WGGyhtJkq+KKNS2mq/AaRULUL1W6KpN0wIU8+Ud3zyC5aynle6VxJ3bl l+x1C4GmMHAgZAypVTYE9tqlM810WYGnWH85vWQgnUzddg1XvunArPijRpz3jiRgVG6NWqfFg X-Google-Smtp-Source: AGHT+IF9eAJnGvK6c2yl2o9jK/Q531xU8e4vF5SIRST0eManqUDZy2XLkHgFQ6tecBjbqIReXJoBXy8yN7h3AmBhZOc= X-Received: by 2002:a17:90b:1d51:b0:2ef:114d:7bf8 with SMTP id 98e67ed59e1d1-2f28fa50ff0mr5957162a91.6.1734127153680; Fri, 13 Dec 2024 13:59:13 -0800 (PST) MIME-Version: 1.0 From: kamal deen Date: Sat, 14 Dec 2024 03:29:03 +0530 Message-ID: Subject: Dead tuple ratio for table & index To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="000000000000fd9cd906292df0d8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000fd9cd906292df0d8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi All, Kindly share the query details to identify the dead tuples ratio at table & index level. We have noticed some of our partioned tables generating more WAL files during vacuumb.(around 50 to 60GB (We are in the plan to remove this manual job later since auto vacuum is enabled) Thanks in advance =E2=98=BA=EF=B8=8F Regards, SK --000000000000fd9cd906292df0d8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi All,

Kind= ly share the query details=C2=A0 to identify the dead tuples ratio at table= & index level.

We h= ave noticed some of our partioned tables generating more WAL files during v= acuumb.(around 50 to 60GB

(We are in the plan to remove this manual job later since auto vacuum is = enabled)=C2=A0

Thanks in= advance =E2=98=BA=EF=B8=8F=C2=A0

Regards,
SK
--000000000000fd9cd906292df0d8--