Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jU6kk-0000Br-Ci for pgsql-admin@arkaria.postgresql.org; Thu, 30 Apr 2020 10:49:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jU6kj-0006T9-Av for pgsql-admin@arkaria.postgresql.org; Thu, 30 Apr 2020 10:49:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jU6ki-0006Pt-Um for pgsql-admin@lists.postgresql.org; Thu, 30 Apr 2020 10:49:13 +0000 Received: from truschnigg.info ([89.163.150.210]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jU6kf-0006Hh-AH for pgsql-admin@postgresql.org; Thu, 30 Apr 2020 10:49:12 +0000 Received: from vault.lan (84-112-34-152.cable.dynamic.surfer.at [84.112.34.152]) by truschnigg.info (Postfix) with ESMTPSA id 22E392024B; Thu, 30 Apr 2020 10:49:07 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=truschnigg.info; s=mail; t=1588243747; bh=Oh/IbwimFN0aYuacH1ucxyfDkeaCge0srW4RmJVV3jw=; h=Date:From:To:Cc:Subject:References:In-Reply-To:From; b=BGXeHPLh+LzujEMm/p2iW0DgbLrTGz7J2M2ULLzZM9OENDMkX8m/WyghwjX2zyTme CyjuCpFlWqe2iIPvH4Xib4ZnsJXuuA0kbKA44+8X5NhKlQZUOJSM+SVhpOj2u6cxb7 UfymzEvfX38sKnokO02I/aour9mMX9103bZi9TVw= Date: Thu, 30 Apr 2020 12:49:03 +0200 From: Johannes Truschnigg To: Ankush Chawla Cc: pgsql-admin Subject: Re: Performance Reports Message-ID: <20200430104903.GA28955@vault.lan> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="h31gzZEtNLTqOjlF" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --h31gzZEtNLTqOjlF Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Ankush! I am not familiar with Oracle databases in general, or the tools you mentioned, but if you want to assess your PostgreSQL database's performance= on a per-query level, you should check out pgbadger[0] (a performance-oriented log analysis tool) and pg_stat_statements[1] (an extension that records aggregate query performance characteristics), for starters. Hth! [0]: http://pgbadger.darold.net/ [1]: https://www.postgresql.org/docs/current/pgstatstatements.html --=20 with best regards: - Johannes Truschnigg ( johannes@truschnigg.info ) www: https://johannes.truschnigg.info/ phone: +43 650 2 133337 xmpp: johannes@truschnigg.info Please do not bother me with HTML-email or attachments. Thank you. --h31gzZEtNLTqOjlF Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAl6qrRsACgkQ95W3jMsY fLV5fxAAq3RqCw82JrN2Z9iZSBoPBNuQ5nZ4dNCw/tVGCHaE1FnQmHlOiHK1xSt7 u8fniFsSsxOVB4I2Dolc6vGb4FBRqX5793UzqIrusgYq8hw/1mjzF3eTBOkT857H csBSuyoeZ9VUgHIHDEc8C50q9ceL2oaqarIciK1s+r9CSWb8kP5BCHPTlUjMpVGr QwWAE+qD0Ve0agqI7ROcEN4piPMSgFk91YCP4N2XcKRt2jMnNC3cN4PkVlqx44Hp 4cPYtE+iwDfyhKmWCJ7kJBGNo9pcdsj+PY4EKc07W5bqkEcML8weECI3TsDVpjt2 3nP/KFMn51P+snGscj3bpAkdYJbmBPvtO9y33WzLPM7IiwpBMvyTGC4GHlE/IbVF VPV8RBH8Knu6xKUakNiMGt7ot67ridKXfYXRipZXE1LkxQ+3Kux3kSkcjax0loy2 68RSAOsZF8pCs+erwyheVvNMxN0GZdHLLnat/mr5PuUjw2gHJ/Mbb0yOo77yJxBE ARMXL4czUxYZxq7mJQtV+R1dt9/7/SN+Pb4kp1cobad3ePBTdfCeI9ADXTExu6NI V0RK1mkz7PlI622W3SUk3pyWKYY9izfYBDbWiRHrxsbeuNRTTEl+zzL0kghOhdfL sG/lxlR7SUGCf7COr//KEWT6QoeonFuOi0vKLrPFl+uioGn12I0= =FN6C -----END PGP SIGNATURE----- --h31gzZEtNLTqOjlF--