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 1wBFyj-000svP-0F for pgsql-admin@arkaria.postgresql.org; Fri, 10 Apr 2026 17:49:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wBFyg-00Dnhs-1r for pgsql-admin@arkaria.postgresql.org; Fri, 10 Apr 2026 17:49:11 +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.96) (envelope-from ) id 1wBFyg-00Dnhf-0Q for pgsql-admin@lists.postgresql.org; Fri, 10 Apr 2026 17:49:11 +0000 Received: from mail-dl1-x1233.google.com ([2607:f8b0:4864:20::1233]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wBFye-00000000N2s-3oaD for pgsql-admin@lists.postgresql.org; Fri, 10 Apr 2026 17:49:10 +0000 Received: by mail-dl1-x1233.google.com with SMTP id a92af1059eb24-12c20010f10so5798265c88.0 for ; Fri, 10 Apr 2026 10:49:09 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775843347; cv=none; d=google.com; s=arc-20240605; b=lOJRtdq+z6RMRYc0HMzHqAmmDCod2aVvBAyIo/sx92vhsSoGwo8q+3n6iWq6gwuhr0 jGqrrmE4swL5JA9i+un7fpVAkAOH+RchgcyxqAuZizw76HBnNnbrHxAR71G5548vd3vj A7yKTKbYFzbrBrZ3psgx6wiUTGgHiOP1udPxoFCKg8PccpK1Y/ND/MvLn4nhvgWm43Bp sbjf/h7g4hg8eJkCyX3sh8HVqo1bTY61mwG2PfO+qv89Hqf70QnyhaJjCreGYBwnVW5J Qpv4ln7lvh5c3km24a1cettRnGqn0x+V2LIIPf6FyDZCaj3fISO6nHUR22pIFfTV9NV8 Os6A== 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=pYPtL7JbCV2XIzIPdm3+jFy0Vc1GHLoIfnLlAuQLjZQ=; fh=druxZHa2fk4e6MLibibygn9AWWgeaAPo4m8Gpo2MBXU=; b=Rz/7AtVrOc0KlUfEuCT+fGdpkkC3BJLpxyoP/dcbjNM2/OW32sRHmVgA1tLiHTWHV7 E4MgFKK5tZBPDLXUdbQVBZmkgUL1l4z0sdPZqjL8eZGMnw69cdn+6UvA21YAIIcxH9kz UqF9NKlavsX2DdFJGm1D/JMadqD0/DmZPqZEiX7qckd3DbkztVM1NfGV+BrkDD+8DkNX VDkxvXLHPbI6YbuoJkWBLqyvIKPwGkJ0BJOdzydwt1zrJzHmszhY30ACsLhmb5qoM/uF J0yk2IXAh2WiMaAqCeM320lvIqjYdw++2QOF3g+nAdn4v/jYCjm0BZvBYYdyUoypo9Ao MEVA==; 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=1775843347; x=1776448147; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=pYPtL7JbCV2XIzIPdm3+jFy0Vc1GHLoIfnLlAuQLjZQ=; b=crdqua9+S5HZkRQHGie1bJhUD7ur7WfIt+3t81lEid3kbboeldDwSCXvPrHXbd1wJM wJGTgxvs6feGNIR0rPHC1dmUsTo+rrvRqpinftsb41EwrNFF5Ju42YrSsJI7ftCTbrE3 eqvH5INvEfJfGbRyXpalV+UYYpPTXe/eF1gxJynwFLxm/v5pflq5Dw2W8vvGqbHicdbN l4SZK1k2c2nzjTwb6Plon0qXMakelgOau9zOoJFKiksFVoCzZTcVhrLTkNTsqoHYH4KS mNkRSVJe+sUEOp8upjPt0o5tEw/xOkGlXM2NNOLBItMwaCD+q6oWsVp62rAi0zavoXjj wmCg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775843347; x=1776448147; 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=pYPtL7JbCV2XIzIPdm3+jFy0Vc1GHLoIfnLlAuQLjZQ=; b=LQ9T4XZ2kYdckoQjseIZQLWIslRAUUkIrAXfxtWuWRo0JvgP/DZn5b2zHzBJf/ld+w F0gUMYveiLbpHBKPxlDtuMmgcqnTg6LznfSzdn6HMMjYB0ghkiODS9O962iVFfr7i7lB gSBvqcVXVYCOA3yCerdyLdGlDnMN1mZqG6az9Blb6czNq2fuZU0kgS8WqY5EL5qXd89q s9gB6jBWtQ+pr1JoYCDWujWZHaLb0xmeWl9TeEu3nJ/0JE4/FWWVV6BJYoEcPqSkdmbn O7u4u+uSCOzUYn46D42+3dE2ermcDfgThOLa/zqkgKApmx40gvog6H81JscMYL1X42r1 FOOw== X-Gm-Message-State: AOJu0Yzd7jcbHEOqNJub4Zq3kXaIT45V/ybXu+tFsvZPOjsCpwjSV2SD XU6s/sOdmK+3t0E0Yifo6iKDBfPTSovjvu5aAvTeDm4Evq6ebzf/sBl//neqrWlYkRLNWzoCEiB E5S0TnDcvnJ+6W8FRL+IAb5pQ3+WdSEOKhvb+ X-Gm-Gg: AeBDiesT17MNn2QgV/W5ON+TCV2pthO7hg7/hIAakb+b87MSExHlYcmsFF6Brlowgfj ZxW4/eYpXWOTGZouLW8eodWzXOy/7DPzGjkJxp7BHhFMbPMEM6tEJFxvlGeM/jkc6IibIw7fsB3 fw8rn6vhFbDUgvAte9SSrqiXz37Yev/DlsH0E0AVUkpWgWQYSTQvqfuOl6Pi8MPgv5lufHeFI3M 7Ro3amfbwy97aXY4i962O4YMJZtCEDm+fmJOJeWdzj0ZUNUn6r48ov961bywDtiOMoPr9LO9BK9 dcm+wIi+ X-Received: by 2002:a05:7022:60a0:b0:128:d51a:5161 with SMTP id a92af1059eb24-12c34eeb884mr2256951c88.27.1775843347053; Fri, 10 Apr 2026 10:49:07 -0700 (PDT) MIME-Version: 1.0 From: mahamood hussain Date: Fri, 10 Apr 2026 23:18:54 +0530 X-Gm-Features: AQROBzCAfqAGsfbi0tDhYd9w6SqcGEo1lCq626DM37a53zkxQviqT0Rs2JlWYU4 Message-ID: Subject: Seeking Advice: PostgreSQL Performance Troubleshooting Without Third-Party Tools To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000e0c147064f1ebf67" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e0c147064f1ebf67 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Team, We are currently working on a migration project from DB2 to PostgreSQL. Post-migration, we=E2=80=99re observing several performance issues such as long-running queries and occasional instance crashes. It also appears that some application-side workloads may not be optimized for PostgreSQL.