pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gunnar \"Nick\" Bluth <gunnar.bluth@pro-open.de>
To: pgsql-performance@lists.postgresql.org
Subject: Re: Details after Load Peak was: OT: Performance of VM
Date: Tue, 13 Feb 2018 22:15:31 +0100
Message-ID: <5faea40d-66db-9c23-0256-4e37de1e0d6b@pro-open.de> (raw)
In-Reply-To: <e02f17cb-bea7-3ad3-61ba-7798149078b0@thomas-guettler.de>
References: <3bc54eb3-135d-692c-47e2-208189a350d7@thomas-guettler.de>
	<91fec1f8-d11d-2413-6b57-5310ab0e3b8a@a-kretschmer.de>
	<e02f17cb-bea7-3ad3-61ba-7798149078b0@thomas-guettler.de>

Am 06.02.2018 um 15:31 schrieb Thomas Güttler:
> 
> 
> 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?

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

Attachments:

  [application/pgp-signature] signature.asc (472B, ../5faea40d-66db-9c23-0256-4e37de1e0d6b@pro-open.de/2-signature.asc)
  download

view thread (4+ messages)  latest in thread

Message-ID: <5faea40d-66db-9c23-0256-4e37de1e0d6b@pro-open.de>
Permalink:  ../5faea40d-66db-9c23-0256-4e37de1e0d6b@pro-open.de/
Also on:    postgresql.org/message-id/5faea40d-66db-9c23-0256-4e37de1e0d6b@pro-open.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gunnar.bluth@pro-open.de, pgsql-performance@lists.postgresql.org
  Subject: Re: Details after Load Peak was: OT: Performance of VM
  In-Reply-To: <5faea40d-66db-9c23-0256-4e37de1e0d6b@pro-open.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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