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