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.96) (envelope-from ) id 1wCGpi-001oky-3C for pgsql-admin@arkaria.postgresql.org; Mon, 13 Apr 2026 12:56:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wCGph-006nc8-0x for pgsql-admin@arkaria.postgresql.org; Mon, 13 Apr 2026 12:56:06 +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.96) (envelope-from ) id 1wCGpg-006nc0-38 for pgsql-admin@lists.postgresql.org; Mon, 13 Apr 2026 12:56:05 +0000 Received: from mail-lj1-x22c.google.com ([2a00:1450:4864:20::22c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wCGpf-00000000pwe-3zPB for pgsql-admin@lists.postgresql.org; Mon, 13 Apr 2026 12:56:05 +0000 Received: by mail-lj1-x22c.google.com with SMTP id 38308e7fff4ca-38e7d983f79so7473811fa.0 for ; Mon, 13 Apr 2026 05:56:03 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776084962; cv=none; d=google.com; s=arc-20240605; b=Zh8Jw4Jp6dqBzysQo7uWh7BmQ4bBC3IzWcTN/KLnSXB29E2qLIfNnTskFiFwX/tu7O tDMI/TayzmVFUBhMeYYXFA4j5/KT1kh6RAP+sbtMiZCJATvXyjyoKVLmKxJISE+RISY2 //YdYFDheiLizS9HvARPm4CG62uSVu2cr6ko0rOB1Cyl5Z9OvlX9JGVpjfrYG0HvV0d0 y0GHz+PRRQ2g0qu9kHHpTDfD2GbqPoppM79DffRHeiRtXXt0rH7blMwHIPJGReFpem/V GYGTnOL33O00yFe1hKd1RgQSjH+XLLKl4+5zlGe0CGX7K16h1ZZBNAnl8TMIPKIObIQ+ S7xg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=+gtYpB2okcH3XbdPkt3Va6gXpELloOdr7lhG9p0hwFg=; fh=druxZHa2fk4e6MLibibygn9AWWgeaAPo4m8Gpo2MBXU=; b=GC/y0XZd9++UGfzhA1T8d03ZXGsO2eB82MwvOg2cWEl6gM3LzJMAsHUDTrNXkmyhJP IfXrCvc1II4f0EtnHQGKwESqiAHJU7xyep+iqLApHaxVxFPUtAxG1diKfdVglOFrsehi xMavYUNVVS9Epc2+7pTWjhnPsUr/7PAev7w+Hqm0hqKfhq3ppc8MrPXSjpppNHvo5LHn MdLnhtZi6Ll0Vyk2+2siZLGnEd8P9DoKUKMawTZydBSTRLLW/U/Upxjh7AjPbgmoRgIe aOFWY2nCIGMUmWk73b7WcoSG93rp5d4dHGWF5J+N6kRwGkifPoDvf5vttLlr/F5Uj6PB vekg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776084962; x=1776689762; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=+gtYpB2okcH3XbdPkt3Va6gXpELloOdr7lhG9p0hwFg=; b=H52Xc9JVz1M7cRkYyTbJLVZvVY5f3aeRF7OkB0IXlCjvbWPnlTjKVgqPUpUF5Xgoej F86mxF9T21dVIY2k/23WrCNCR8uojyGwAQycH7NdA306TH1G4TYioYNN7lgWxSitzjN4 /CsU8niylupvOvKgqDKqZC9c3YJD0T+YuZn4r+ad1HDKxCljZVEKOR0sSZPgHZrkT8l5 2sVsG8b9KJCpnkstqpYHnjfIUYGKKmN9fHobgfYRnLzR02HeVKXOgr7ypbjljhSId6QT Am9ICsDWio+VbY+JwXD/LFYV754sD6svN+efyowmsDkHOJVm//r5VEnvCyaRkkgf04mm 3DjA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776084962; x=1776689762; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=+gtYpB2okcH3XbdPkt3Va6gXpELloOdr7lhG9p0hwFg=; b=GxvepkT+pH9mhTOIIG+P5hKOfit01ayFt5dgs0xsma0ZVoNIwJTMYb/q8/bNDxUSQx V/c1Adon9IyZ1sgARG3kKE60wwgSO2sNBKShkKA/qrPXFwWb3S9zDTIQpMkYE9j/lOVm yBcWheUc7vaZ2IxH4Akbuyh42ItYGrr971IVmMSbvDP7eVrPAQxBT6kQIul+poNw3yBD lavrouZgR21pT7TulVa01FKfkHJ37xulaLZsBfjySOugnENEI72hGLSAZFUQ5nx7/lyn aZ8Om4DzZQ+EUV4bK7q9DRub5fM3phiAQgRCDB8cSwcKLosre75wq4bkeyiMikZLSYwx xFDQ== X-Gm-Message-State: AOJu0Yyy8tZj9nKZUEfly1f81hEwHZ6d2q2PF2tKRM2peWvyybzKERK9 sLwd/VFy1cqgoDiFEQSeI8kJMXZr/YK58YEqehCltpyvizd3wm5gvJwsD5BQf3Qx46GBW0n63he kNdSZNe/uT45gDaTjsVcows5D+SZf82owiA== X-Gm-Gg: AeBDievuN/ENxMM2MCJKyr8TqTftvG0oj1sqcchy2rp5lOg9QGCvOXC6rDJ3+eyPIAz lhDUv5e9fiqoSiQqmAvjIJGqjxfZbcpyMD13+RvWnm3/Zf+ANiZFoMukBTObHTmkxcx70q9/oVZ gms4ndsATf8UfpWaRupPyjP9SAY2nMbDOpyXDUyTsu01RCWtRQJ9mek29LMm12ADKnLmtdV3kUQ u0TyEeAAtR2yAS9PKnT8F+brVoDjnndxoCa+uCJzi87Er71N3T4rkPq8a9dec/PxS0G+9RD1psL HawI5PjvZX3RhI5vKRcSWAJy X-Received: by 2002:a05:651c:111a:b0:38e:1714:b64e with SMTP id 38308e7fff4ca-38e4be46dc8mr31148301fa.3.1776084962250; Mon, 13 Apr 2026 05:56:02 -0700 (PDT) MIME-Version: 1.0 From: Raj Date: Mon, 13 Apr 2026 18:25:48 +0530 X-Gm-Features: AQROBzAoXK5ITf1FZyCUc42G1-YwE2EEq6F0GIcz7Sq38YnxTkTM0EFok09_7Ws Message-ID: Subject: Slowness To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000441325064f57010d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000441325064f57010d Content-Type: text/plain; charset="UTF-8" When customer says they are facing slowness, what all wee need to check in postgres db with 3 node patroni set up (sync between 1 and 2) - async with dr. We recently migrated from oracle to postgres..vacuum analyze is done. How to check this during the time slowness faced and also after couple of hrs of issue window. Should we start with pgstatstatements and logs or how is it. Help.me hight level what all I need to check --000000000000441325064f57010d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
When customer says they are facing slowness, what all wee= need to check in postgres db with 3 node patroni set up (sync between 1 an= d 2) - async with dr.

We recen= tly migrated from oracle to postgres..vacuum analyze is done.

How to check this during the time slo= wness faced and also after couple of hrs of issue window.

Should we start with pgstatstatements and= logs or how is it. Help.me hight level what all I need to check
--000000000000441325064f57010d--