On 12/14/2020 at 1:12 PM, "Scott Ribe" <scott_ribe@elevated-dev.com> wrote:
>
>> On Dec 14, 2020, at 2:14 AM, Dischner, Anton
><Anton.Dischner@med.uni-muenchen.de> 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