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

From Thomas Güttler
Subject Details after Load Peak was: OT: Performance of VM
Date
Msg-id e02f17cb-bea7-3ad3-61ba-7798149078b0@thomas-guettler.de
Whole thread Raw
In response to Re: OT: Performance of VM  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Details after Load Peak was: OT: Performance of VM  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Re: Details after Load Peak was: OT: Performance of VM  ("Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>)
List pgsql-performance

Am 05.02.2018 um 14:26 schrieb Andreas Kretschmer:
> 
> 
> Am 05.02.2018 um 14:14 schrieb Thomas Güttler:
>> What do you suggest to get some reliable figures? 
> 
> sar is often recommended, see https://blog.2ndquadrant.com/in-the-defense-of-sar/.
> 
> Can you exclude other reasons like vacuum / vacuum freeze?

In the current case it was a problem in the hypervisor.

But I want to be prepared for the next time.

The tool sar looks good. This way I can generate a chart where I can see peaks. Nice.

.... 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.

Any idea?

Regards,
   Thomas Güttler





-- 
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines


pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: effective_io_concurrency on EBS/gp2
Next
From: Alan Hodgson
Date:
Subject: Re: Details after Load Peak was: OT: Performance of VM