Re: tools like innotop for PostgreSQL?

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