From: Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
To: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: AW: tools like innotop for PostgreSQL?
Date: Mon, 14 Dec 2020 10:43:35 +0000
Message-ID: <3131427e785045cfbd32a9caa013ae5c@MITMB5.helios.med.uni-muenchen.de> (raw)
In-Reply-To: <b2f62ff7-6d6e-87ff-37ef-0135d24ba65d@jakobs.com>
References: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de>
<b2f62ff7-6d6e-87ff-37ef-0135d24ba65d@jakobs.com>
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<https://pg_proctab.gitlab.io/; extension needs to be loaded into the database you are connecting too. That can be installed from pgxn<https://pgxn.org/dist/pg_proctab/; or source<https://gitlab.com/pg_proctab/pg_proctab;.
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Anton.Dischner@med.uni-muenchen.de, holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: AW: tools like innotop for PostgreSQL?
In-Reply-To: <3131427e785045cfbd32a9caa013ae5c@MITMB5.helios.med.uni-muenchen.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox