Re: AW: tools like innotop for PostgreSQL? - Mailing list pgsql-admin

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