From: Michaeldba@sqlexec.com <Michaeldba@sqlexec.com>
To: Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
Cc: Holger Jakobs <holger@jakobs.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: AW: tools like innotop for PostgreSQL?
Date: Mon, 14 Dec 2020 07:25:47 -0500
Message-ID: <76ECECF0-0ECA-4DDE-ADB0-5D2E8C26D56A@sqlexec.com> (raw)
In-Reply-To: <3131427e785045cfbd32a9caa013ae5c@MITMB5.helios.med.uni-muenchen.de>
References: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de>
<b2f62ff7-6d6e-87ff-37ef-0135d24ba65d@jakobs.com>
<3131427e785045cfbd32a9caa013ae5c@MITMB5.helios.med.uni-muenchen.de>
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
>
>
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Michaeldba@sqlexec.com, Anton.Dischner@med.uni-muenchen.de, holger@jakobs.com
Subject: Re: tools like innotop for PostgreSQL?
In-Reply-To: <76ECECF0-0ECA-4DDE-ADB0-5D2E8C26D56A@sqlexec.com>
References: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de> <b2f62ff7-6d6e-87ff-37ef-0135d24ba65d@jakobs.com> <3131427e785045cfbd32a9caa013ae5c@MITMB5.helios.med.uni-muenchen.de> <76ECECF0-0ECA-4DDE-ADB0-5D2E8C26D56A@sqlexec.com>
* 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