| From: | Thomas Güttler <guettliml(at)thomas-guettler(dot)de> |
|---|---|
| To: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Details after Load Peak was: OT: Performance of VM |
| Date: | 2018-02-06 14:31:27 |
| Message-ID: | e02f17cb-bea7-3ad3-61ba-7798149078b0@thomas-guettler.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2018-02-06 15:30:59 | Re: Details after Load Peak was: OT: Performance of VM |
| Previous Message | Claudio Freire | 2018-02-05 20:14:53 | Re: effective_io_concurrency on EBS/gp2 |