AW: tools like innotop for PostgreSQL?

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(at)jakobs(dot)com>
Gesendet: Montag, 14. Dezember 2020 10:15
An: pgsql-admin(at)lists(dot)postgresql(dot)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