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 1kojxA-0005Ie-VD for pgsql-admin@arkaria.postgresql.org; Mon, 14 Dec 2020 09:15:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kojx9-0008Bh-UX for pgsql-admin@arkaria.postgresql.org; Mon, 14 Dec 2020 09:15:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kojx9-0008BO-NH for pgsql-admin@lists.postgresql.org; Mon, 14 Dec 2020 09:15:35 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kojx7-0008Px-8R for pgsql-admin@lists.postgresql.org; Mon, 14 Dec 2020 09:15:34 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 2C760380603; Mon, 14 Dec 2020 10:15:31 +0100 (CET) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id bp2g5nff9ArZ; Mon, 14 Dec 2020 10:15:31 +0100 (CET) Received: from [192.168.178.197] (ip-37-201-154-46.hsi13.unitymediagroup.de [37.201.154.46]) by rs.plausibolo.de (Postfix) with ESMTPSA id B438938041E; Mon, 14 Dec 2020 10:15:30 +0100 (CET) Subject: Re: tools like innotop for PostgreSQL? To: pgsql-admin@lists.postgresql.org References: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de> From: Holger Jakobs Message-ID: Date: Mon, 14 Dec 2020 10:15:29 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.5.0 MIME-Version: 1.0 In-Reply-To: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="tEooeiOUn917N8LWz6OH3kNFh0qoukWAZ" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --tEooeiOUn917N8LWz6OH3kNFh0qoukWAZ Content-Type: multipart/mixed; boundary="2EgB2gMz16Cu6Z5EXC4l1DWdpHjuiMCP1"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: Subject: Re: tools like innotop for PostgreSQL? References: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de> In-Reply-To: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de> --2EgB2gMz16Cu6Z5EXC4l1DWdpHjuiMCP1 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable Content-Language: de-DE Hi Anton, try=20 https://severalnines.com/database-blog/dynamic-monitoring-postgresql-inst= ances-using-pgtop Regards, Holger Am 14.12.20 um 10:14 schrieb Dischner, Anton: > Hi all, > > we are using PostgreSQL in a docker container for a fhir server. > > Performance is not as desired/ as fast as other fhir servers currently = in testing. > > For MySQL there are monitoring tools like mytop, innotop which show run= ning SQL commands. > > Are there any equivalent tools for PostgreSQL to find SQL commands whic= h deserve tuning? > > Tried so far: > > pg_top only shows system processes. > > pgstats is to much vmstat-like > > dbeaver does not show running sql-commands to my knowledge > > select * from pg_stat_activity; > > kind regards, > > Anton > > > > --=20 Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 --2EgB2gMz16Cu6Z5EXC4l1DWdpHjuiMCP1-- --tEooeiOUn917N8LWz6OH3kNFh0qoukWAZ Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCX9ctMQUDAAAAAAAKCRCKV5yTsxlhun3O AKCoQuhbkIGPZFWkdz1pF5jXQbbojQCdE185F5mSNvzYmcudlxONFcSgM/w= =7kkH -----END PGP SIGNATURE----- --tEooeiOUn917N8LWz6OH3kNFh0qoukWAZ--