On 12/14/2020 at 1:12 PM, "Scott Ribe" <scott_ribe@xxxxxxxxxxxxxxxx> wrote: > >> On Dec 14, 2020, at 2:14 AM, Dischner, Anton ><Anton.Dischner@xxxxxxxxxxxxxxxxxxx> wrote: >> >> 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? >> ... > >We use pg_stat_statements Hi Anton for monitoring running SQL check out pg_activity at https://github.com/dalibo/pg_activity , from the OPM guys Dalibo. cheers Peter Goodwin
