pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
> 
> 
> 

view thread (3+ messages)

Message-ID: <76ECECF0-0ECA-4DDE-ADB0-5D2E8C26D56A@sqlexec.com>
Permalink:  ../76ECECF0-0ECA-4DDE-ADB0-5D2E8C26D56A@sqlexec.com/
Also on:    postgresql.org/message-id/76ECECF0-0ECA-4DDE-ADB0-5D2E8C26D56A@sqlexec.com

 · 

reply

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