pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedtools like innotop for PostgreSQL?
4+ messages / 4 participants
[nested] [flat]
* tools like innotop for PostgreSQL?
@ 2020-12-14 09:14 Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
2020-12-14 09:15 ` Re: tools like innotop for PostgreSQL? Holger Jakobs <holger@jakobs.com>
2020-12-14 13:11 ` Re: tools like innotop for PostgreSQL? Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 2 replies; 4+ messages in thread
From: Dischner, Anton @ 2020-12-14 09:14 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: tools like innotop for PostgreSQL?
2020-12-14 09:14 tools like innotop for PostgreSQL? Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
@ 2020-12-14 09:15 ` Holger Jakobs <holger@jakobs.com>
1 sibling, 0 replies; 4+ messages in thread
From: Holger Jakobs @ 2020-12-14 09:15 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: tools like innotop for PostgreSQL?
2020-12-14 09:14 tools like innotop for PostgreSQL? Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
@ 2020-12-14 13:11 ` Scott Ribe <scott_ribe@elevated-dev.com>
2020-12-14 14:37 ` Re: tools like innotop for PostgreSQL? zurich@nym.hush.com
1 sibling, 1 reply; 4+ messages in thread
From: Scott Ribe @ 2020-12-14 13:11 UTC (permalink / raw)
To: Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>; +Cc: pgsql-admin
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: tools like innotop for PostgreSQL?
2020-12-14 09:14 tools like innotop for PostgreSQL? Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
2020-12-14 13:11 ` Re: tools like innotop for PostgreSQL? Scott Ribe <scott_ribe@elevated-dev.com>
@ 2020-12-14 14:37 ` zurich@nym.hush.com
0 siblings, 0 replies; 4+ messages in thread
From: zurich@nym.hush.com @ 2020-12-14 14:37 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; Anton Dischner <anton.dischner@med.uni-muenchen.de>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-12-14 14:37 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-14 09:14 tools like innotop for PostgreSQL? Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
2020-12-14 09:15 ` Holger Jakobs <holger@jakobs.com>
2020-12-14 13:11 ` Scott Ribe <scott_ribe@elevated-dev.com>
2020-12-14 14:37 ` zurich@nym.hush.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox