Re: AW: tools like innotop for PostgreSQL?

Did u try htop?

Sent from my iPad

> On Dec 14, 2020, at 5:43 AM, Dischner, Anton <Anton(dot)Dischner(at)med(dot)uni-muenchen(dot)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(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
>
>
>