Re: Details after Load Peak was: OT: Performance of VM - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: Details after Load Peak was: OT: Performance of VM
Date
Msg-id 1517931059.5522.16.camel@lists.simkin.ca
Whole thread Raw
In response to Details after Load Peak was: OT: Performance of VM  (Thomas Güttler <guettliml@thomas-guettler.de>)
List pgsql-performance
On Tue, 2018-02-06 at 15:31 +0100, Thomas Güttler wrote:
.... But one thing is still unclear. Imagine I see a peak in the chart. The peak
was some hours ago. AFAIK sar has only the aggregated numbers.

But I need to know details if I want to answer the question "Why?". The peak
has gone and ps/top/iotop don't help me anymore.


The typical solution is to store stats on everything you can think of with munin, cacti, ganglia, or similar systems.

I know with ganglia at least, in addition to all the many details it already tracks on a system and the many plugins already available for it, you can write your own plugins or simple agents, so you can keep stats on anything you can code around.

Munin's probably the easiest to try out, though.

pgsql-performance by date:

Previous
From: Thomas Güttler
Date:
Subject: Details after Load Peak was: OT: Performance of VM
Next
From: Justin Pryzby
Date:
Subject: Re: failing to use index on UNION of matviews (Re: postgresql 10.1wrong plan in when using partitions bug)