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
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
