[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: Details after Load Peak was: OT: Performance of VM
From: Micky Gough <mgough () squiz ! net>
Date: 2018-02-13 21:55:58
Message-ID: CAEaF9Mj8-kBKBArAU6Cafiw=FeUBVod__sJAOssLsBNpZcP9Bg () mail ! gmail ! com
[Download RAW message or body]
+1 for atop. Be sure to adjust the sampling interval so it suits your
needs. It'll tell you what caused the spike.
Alternatively you could probably use sysdig, but I expect that'd result in
a fair performance hit if your system is already struggling.
Micky
On 14 February 2018 at 08:15, Gunnar "Nick" Bluth <gunnar.bluth@pro-open.de=
>
wrote:
> Am 06.02.2018 um 15:31 schrieb Thomas G=C3=BCttler:
> >
> >
> > Am 05.02.2018 um 14:26 schrieb Andreas Kretschmer:
> >>
> >>
> >> Am 05.02.2018 um 14:14 schrieb Thomas G=C3=BCttler:
> >>> 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 se=
e
> > 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?
>
> I love atop (atoptool.nl) for exactly that kind of situation. It will
> save a snapshot every 10 minutes by default, which you can then simply
> "scroll" back to. Helped me pinpointing nightly issues countless times.
>
> Only really available for Linux though (in case you're on *BSD).
>
> Best regards,
> --
> Gunnar "Nick" Bluth
> RHCE/SCLA
>
> Mobil +49 172 8853339
> Email: gunnar.bluth@pro-open.de
> _____________________________________________________________
> In 1984 mainstream users were choosing VMS over UNIX.
> Ten years later they are choosing Windows over UNIX.
> What part of that message aren't you getting? - Tom Payne
>
>
>
[Attachment #3 (text/html)]
<div dir="ltr">+1 for atop. Be sure to adjust the sampling interval so it suits your \
needs. It'll tell you what caused the spike.<div><br></div><div>Alternatively you \
could probably use sysdig, but I expect that'd result in a fair performance hit \
if your system is already struggling.</div><div><br></div><div>Micky</div></div><div \
class="gmail_extra"><br><div class="gmail_quote">On 14 February 2018 at 08:15, Gunnar \
"Nick" Bluth <span dir="ltr"><<a href="mailto:gunnar.bluth@pro-open.de" \
target="_blank">gunnar.bluth@pro-open.de</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><span class="">Am 06.02.2018 um 15:31 schrieb Thomas \
Güttler:<br> ><br>
><br>
> Am 05.02.2018 um 14:26 schrieb Andreas Kretschmer:<br>
>><br>
>><br>
>> Am 05.02.2018 um 14:14 schrieb Thomas Güttler:<br>
>>> What do you suggest to get some reliable figures?<br>
>><br>
>> sar is often recommended, see<br>
>> <a href="https://blog.2ndquadrant.com/in-the-defense-of-sar/" \
rel="noreferrer" target="_blank">https://blog.2ndquadrant.com/<wbr>in-the-defense-of-sar/</a>.<br>
>><br>
>> Can you exclude other reasons like vacuum / vacuum freeze?<br>
><br>
> In the current case it was a problem in the hypervisor.<br>
><br>
> But I want to be prepared for the next time.<br>
><br>
> The tool sar looks good. This way I can generate a chart where I can see<br>
> peaks. Nice.<br>
><br>
> .... But one thing is still unclear. Imagine I see a peak in the chart.<br>
> The peak<br>
> was some hours ago. AFAIK sar has only the aggregated numbers.<br>
><br>
> But I need to know details if I want to answer the question "Why?". \
The<br> > peak<br>
> has gone and ps/top/iotop don't help me anymore.<br>
><br>
> Any idea?<br>
<br>
</span>I love atop (<a href="http://atoptool.nl" rel="noreferrer" \
target="_blank">atoptool.nl</a>) for exactly that kind of situation. It will<br> save \
a snapshot every 10 minutes by default, which you can then simply<br> \
"scroll" back to. Helped me pinpointing nightly issues countless times.<br> \
<br> Only really available for Linux though (in case you're on *BSD).<br>
<br>
Best regards,<br>
<span class="HOEnZb"><font color="#888888">--<br>
Gunnar "Nick" Bluth<br>
RHCE/SCLA<br>
<br>
Mobil +49 172 8853339<br>
Email: <a href="mailto:gunnar.bluth@pro-open.de">gunnar.bluth@pro-open.de</a><br>
______________________________<wbr>______________________________<wbr>_<br>
In 1984 mainstream users were choosing VMS over UNIX.<br>
Ten years later they are choosing Windows over UNIX.<br>
What part of that message aren't you getting? - Tom Payne<br>
<br>
<br>
</font></span></blockquote></div><br></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic