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 1komva-0002lx-Cw for pgsql-admin@arkaria.postgresql.org; Mon, 14 Dec 2020 12:26:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1komvZ-0001iC-7R for pgsql-admin@arkaria.postgresql.org; Mon, 14 Dec 2020 12:26:09 +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 1komvY-0001eo-V6 for pgsql-admin@lists.postgresql.org; Mon, 14 Dec 2020 12:26:09 +0000 Received: from mout.perfora.net ([74.208.4.196]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1komvR-0001MD-Qp for pgsql-admin@lists.postgresql.org; Mon, 14 Dec 2020 12:26:08 +0000 Received: from [192.168.1.181] ([72.205.30.64]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0M8Ouq-1jt5w50O5y-00vyWj; Mon, 14 Dec 2020 13:25:51 +0100 Content-Type: multipart/alternative; boundary=Apple-Mail-95AC6B67-2523-45BE-9B04-76A18ED9E84F Mime-Version: 1.0 (1.0) Subject: Re: AW: tools like innotop for PostgreSQL? From: "Michaeldba@sqlexec.com" X-Mailer: iPad Mail (16H5) In-Reply-To: <3131427e785045cfbd32a9caa013ae5c@MITMB5.helios.med.uni-muenchen.de> Date: Mon, 14 Dec 2020 07:25:47 -0500 Cc: Holger Jakobs , "pgsql-admin@lists.postgresql.org" Content-Transfer-Encoding: 7bit Message-Id: <76ECECF0-0ECA-4DDE-ADB0-5D2E8C26D56A@sqlexec.com> References: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de> <3131427e785045cfbd32a9caa013ae5c@MITMB5.helios.med.uni-muenchen.de> To: "Dischner, Anton" X-Provags-ID: V03:K1:cwmf02lrVaz4zcft5u9alnbn/h4lio9HYgXPPzf9SxbblmJxF4v r5N3Cd3tTdYIYx2k0dWNJJ2dgsXwSRTLhc2vY+GWU+b1To8DiAVYzwGguUTokCAYb35HtmN 3nEmOhyyzRrimVrjZ9DYeavh6prKErqJVfd6EMxTFA3yVSEdNFHxkxszOv2yw0npT+ANHHj 9Gf1HXZVttNKeYMJEoSsg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:aWz6D651KXk=:qLxxtu/SbQOYfKJBRl9gJC kktnNGMIXHiTbuQGWnqpfRzTBShJzXa04m242eelC4spiNSZ5lTork8suXfvrtsvm8PRxMbfU UkWHRYC9heFiyGngIZzGxbsDjoxIdxrsZtH9+WQDC8KsEhJP7WOotCiUTZEfpfWQF2Nw3TFTg BRrpVFYJ7STEpyEpVgODKIwJhF9nvO6lJDv/NEFT2jjEKGWR2IU4iTn7sg6smmGqgp9sd42vW OdmqSZg0sdxNo2YBhh7XwCLOGqDTBSxB3+Q7P/2G8ma5/4Nlu+P2pVPOEvrOBY/IsP5p/195/ 6TrjOynnqZCBS2onkT0N8/s+OFKkWxSnnHZaQ3bNFbnPz7Q00xJM2fHcYRNDq4MHK7w+mgnTN 0oh/ct7C9ZR3d09mWMgXZO8RWPVKqCqzVKm5VJgKm0EJmoZc5lYbnpRXv5pj9R2Ok5KHHRX7w YSRERqM6Pw== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-95AC6B67-2523-45BE-9B04-76A18ED9E84F Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Did u try htop? Sent from my iPad > On Dec 14, 2020, at 5:43 AM, Dischner, Anton wrote: >=20 > Hi again, > =20 > pgtop connected to a container does not show any postgres processes. > =20 > The example uses -r parameter. > =20 > Using this parameter leads to error: Stored function 'pg_cputime' is missi= ng. > =20 > To resolve this we should add: > =20 > The pg_proctab extension needs to be loaded into the database you are conn= ecting too. That can be installed from pgxn or source. > =20 > Source: https://github.com/markwkm/pg_top/issues/11 > =20 > Question: Anybody did loading extensions to postgresql especially in a con= tainer, any hints? > =20 > best, > =20 > Anton > =20 > Von: Holger Jakobs =20 > Gesendet: Montag, 14. Dezember 2020 10:15 > An: pgsql-admin@lists.postgresql.org > Betreff: Re: tools like innotop for PostgreSQL? > =20 > Hi Anton, >=20 > try=20 > https://severalnines.com/database-blog/dynamic-monitoring-postgresql-insta= nces-using-pgtop >=20 > Regards, >=20 > Holger >=20 > Am 14.12.20 um 10:14 schrieb Dischner, Anton:=20 > > Hi all,=20 > >=20 > > we are using PostgreSQL in a docker container for a fhir server.=20 > >=20 > > Performance is not as desired/ as fast as other fhir servers currently i= n testing.=20 > >=20 > > For MySQL there are monitoring tools like mytop, innotop which show runn= ing SQL commands.=20 > >=20 > > Are there any equivalent tools for PostgreSQL to find SQL commands which= deserve tuning?=20 > >=20 > > Tried so far:=20 > >=20 > > pg_top only shows system processes.=20 > >=20 > > pgstats is to much vmstat-like=20 > >=20 > > dbeaver does not show running sql-commands to my knowledge=20 > >=20 > > select * from pg_stat_activity;=20 > >=20 > > kind regards,=20 > >=20 > > Anton=20 > >=20 > >=20 > >=20 > >=20 > --=20 > Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 >=20 >=20 >=20 --Apple-Mail-95AC6B67-2523-45BE-9B04-76A18ED9E84F Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Did u try htop?

Sent from my iPad

On Dec 14, 2020, at 5:43 AM, Dischner, Anton <Anton.Dischner@med.uni-muenchen.de> wrote:

Hi again,

 

pgtop connected to a container does not show any postgres processes.

 

The example uses -r parameter.

 

Using this parameter leads to error: Stored function 'pg_cputime' is missing.

 

To resolve this we should add:

 

The pg_proctab extension needs to be loaded into the database you are connecting too. That can be installed from pgxn or source.

 

Source: https://github.com/markwkm/pg_top/issues/11

 

Question: Anybody did loading extensions to postgresql especially in a container, any hints?

 

best,

 

Anton

 

Von: Holger Jakobs <holger@jakobs.com>
Gesendet: Montag, 14. Dezember 2020 10:15
An: pgsql-admin@lists.postgresql.org
Betreff: Re: tools like innotop for PostgreSQL?

 

Hi Anton,

try
https://severalnines.com/database-blog/dynamic-monitoring-postgresql-instances-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 running SQL commands.
>
> Are there any equivalent tools for PostgreSQL to find SQL commands which 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
>
>
>
>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012



--Apple-Mail-95AC6B67-2523-45BE-9B04-76A18ED9E84F--