From: Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: tools like innotop for PostgreSQL?
Date: Mon, 14 Dec 2020 09:14:03 +0000
Message-ID: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de> (raw)
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
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Anton.Dischner@med.uni-muenchen.de
Subject: Re: tools like innotop for PostgreSQL?
In-Reply-To: <65d64230583e41508a60c0392b56d03f@MITMB5.helios.med.uni-muenchen.de>
* 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