Subject: Re: Details after Load Peak was: OT: Performance of VM
To: pgsql-performance@lists.postgresql.org
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>
From: "Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>
Message-ID: <5faea40d-66db-9c23-0256-4e37de1e0d6b@pro-open.de>
Date: Tue, 13 Feb 2018 22:15:31 +0100
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: <e02f17cb-bea7-3ad3-61ba-7798149078b0@thomas-guettler.de>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="sNfj38OGNmPJqufp2wmr16xjnJfjzeuI8"
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--sNfj38OGNmPJqufp2wmr16xjnJfjzeuI8
Content-Type: multipart/mixed; boundary="cw8A1G4EKtfJKamFqoUSkupKOqIbUbXBE";
 protected-headers="v1"
From: "Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>
To: pgsql-performance@lists.postgresql.org
Message-ID: <5faea40d-66db-9c23-0256-4e37de1e0d6b@pro-open.de>
Subject: Re: Details after Load Peak was: OT: Performance of VM
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>
In-Reply-To: <e02f17cb-bea7-3ad3-61ba-7798149078b0@thomas-guettler.de>

--cw8A1G4EKtfJKamFqoUSkupKOqIbUbXBE
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable

Am 06.02.2018 um 15:31 schrieb Thomas G=C3=BCttler:
>=20
>=20
> 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?=20
>>
>> sar is often recommended, see
>> https://blog.2ndquadrant.com/in-the-defense-of-sar/.
>>
>> Can you exclude other reasons like vacuum / vacuum freeze?
>=20
> In the current case it was a problem in the hypervisor.
>=20
> But I want to be prepared for the next time.
>=20
> The tool sar looks good. This way I can generate a chart where I can se=
e
> peaks. Nice.
>=20
> .... 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.
>=20
> 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.
>=20
> 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,
--=20
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


--cw8A1G4EKtfJKamFqoUSkupKOqIbUbXBE--

--sNfj38OGNmPJqufp2wmr16xjnJfjzeuI8
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQEcBAEBCAAGBQJag1V5AAoJEBAQrmsyiTOM9f8H/2NtgOCRXqU+0naqcsqsIhpj
4dxacDl2GB2tQMbtmIHNceQx3tpm0W94Jb8Lfl2VjK5bVeTQVMQ1MA5ECzBaoFoe
+M5/rmyKCXPQ+kAXbzvBDrvAgf90JGoy81AbARB9VYNO+EKvYtSrLp9oqI4+zyeY
iMj9uzkXBH3bHSZMtbXFrZaPXZhp8+yKjxYZgVB3MDHXHm1Fdvy40hoRZGJxUBpy
7mVABELHNiPzQ9uJDsZzOoZCsFh6z1CsYH6uqawPVKSWvSKaY8RRx2qmJ05zAPGg
9dHfqhe+yAWHkNGI70J1+NpXpWWM0YmpsWSV6KCdQI424+aW238KOQSdAJsNXeg=
=dGWf
-----END PGP SIGNATURE-----

--sNfj38OGNmPJqufp2wmr16xjnJfjzeuI8--