Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1fif1J-0004ZN-Up
	for pgsql-performance@arkaria.postgresql.org; Thu, 26 Jul 2018 12:05:26 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1fif1I-00026t-5l
	for pgsql-performance@arkaria.postgresql.org; Thu, 26 Jul 2018 12:05:24 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <MichaelDBA@sqlexec.com>)
	id 1fif1H-00026Z-Ui
	for pgsql-performance@lists.postgresql.org; Thu, 26 Jul 2018 12:05:23 +0000
Received: from mout.perfora.net ([74.208.4.197])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <MichaelDBA@sqlexec.com>)
	id 1fif1D-0000UE-UM
	for pgsql-performance@lists.postgresql.org; Thu, 26 Jul 2018 12:05:23 +0000
Received: from [192.168.1.101] ([98.169.215.140]) by mrelay.perfora.net
 (mreueus001 [74.208.5.2]) with ESMTPSA (Nemesis) id 0LvBqe-1g9VUT0k8w-010NrR;
 Thu, 26 Jul 2018 14:05:11 +0200
Message-ID: <5B59B8F6.4070703@sqlexec.com>
Date: Thu, 26 Jul 2018 08:05:10 -0400
From: MichaelDBA <MichaelDBA@sqlexec.com>
User-Agent: Postbox 5.0.25 (Windows/20180328)
MIME-Version: 1.0
To: =?UTF-8?B?VGhvbWFzIEfDvHR0bGVy?= <guettliml@thomas-guettler.de>
CC: pgsql-performance@lists.postgresql.org
Subject: Re: Automated bottleneck detection
References: <6ffd0115-38b7-8a98-b0c9-93fdd86afe4f@thomas-guettler.de>
 <CAOBaU_YdJN8c0cwxQG6uXvFb9-Y5pZrANfD6rL=ArKxuvgdv=w@mail.gmail.com>
 <661a7b2f-5e63-e961-6b5d-8a14dd55c34a@thomas-guettler.de>
 <CAOBaU_b311By9X5=V8brkfgsg=xkSV4kcpGHvz=MH=+-=UFQyg@mail.gmail.com>
 <14b51a31-df17-62ab-1b00-778cce29e57d@thomas-guettler.de>
In-Reply-To: <14b51a31-df17-62ab-1b00-778cce29e57d@thomas-guettler.de>
Content-Type: multipart/alternative;
 boundary="------------070101090508010100050703"
X-Provags-ID: V03:K1:H0XVrSIYbUcgGqtNfcWe094ShbAUOWHui0KJSbtR+KS+bitQ+sq
 LuV+rL/aV9y99VfCcbSlzY2H7feh255y6FVbwOgV4Ai7MvFZTwIvqXulO/TM4r4GrJhtwE1
 teTHKZ0PFp9s4I1s+Jl2wNPiBAEoxbfhKNcSa7RS/IJ2Hh8oJvvfsaOw/54EV3NUGyA5ugC
 bNPMOP4CvJbua4QgRDyKA==
X-UI-Out-Filterresults: notjunk:1;V01:K0:o68uH3EIWUc=:506mK+jKCjHGDhijRTaNg1
 +F6zwIuBzoo5jFesqCLo2mtlsXfG4wbKhpKp1SDdj74vwuqTgavrRKvK1PGYTl/9WiHwpp11m
 LqCHkqFz2gFRvCtYDXG1O25xYKhFHSQfD1wqe4ywSK9ZKHnX7FZ6bafCIYplAaIj0vLJZLhvu
 O2sqWWnAVWvDpI+UjkA+8ln54/NG+0n4i2O3hJw0w21VZip+IsOT1r8VM96Tgg0/VGc7YgFeB
 YUFlmXKiSL5NT3jLmxDfOTkQX6h5UjJadKtk50HLPUuBj45gBwMtdoe1k1tTcm2T9Zocya8fv
 Wr9hUngKaPds9qqur475F1dw9MagDdHuH2OuDnZIZpysQAFUjw+3fxDeEsAk+uS2Hei+KSlHL
 y5tVba5D24J68bPF9He3rrC8bF7KnkewH7rIkhIELPwd52NDiugqTaHEoQ06HWocHS5waFC0S
 DxV3w8wwDfr5b50NTmz63Y7fUc6DxJoEz8emTOSVT/vv07oCKNWPgHL2WWhZqyHBrj+/XBaLa
 khA5db99Nf059XmxVZOgCTX7yq+xg26sCgZ6twOplRUNizuSAGoeNTkYNyKSpratG2lfot6jY
 HZ2aNrUXVLTAf/V+xxUXnosiIw/MJBnRo5D+wBflHTDYxTuYyDZw9vxEpp7SJsTpw32dsfyxs
 jguQwYm8THIN6chvrQqwuj6HCuAiOba88x+u6Avzf1LIrkDmUWsaQeAhU1LtXnJAoYBxfZY6k
 UNU/sepVMth9UlgC
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

This is a multi-part message in MIME format.
--------------070101090508010100050703
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Wow, freakin cool, can't wait to start fiddling with pg_wait_sampling.  
Reckon we can get lightweight locks and spinlocks history with this cool 
new extension instead of awkwardly and repeatedly querying the 
pg_stat_activity table.

Regards,
Michael Vitale

> Thomas Güttler <mailto:guettliml@thomas-guettler.de>
> Thursday, July 26, 2018 7:27 AM
> This sound good. Looks like an automated bootleneck detection
> could be possible with pg_wait_sampling.
>
> Regards,
>   Thomas
>
>
>


--------------070101090508010100050703
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html><head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head><body bgcolor="#FFFFFF" text="#000000">Wow, freakin cool, can't 
wait to start fiddling with pg_wait_sampling.  Reckon we can get 
lightweight locks and spinlocks history with this cool new extension 
instead of awkwardly and repeatedly querying the pg_stat_activity table.<br>
<br>
Regards,<br>
Michael Vitale<br>
<span>

</span><br>
<blockquote style="border: 0px none;" 
cite="mid:14b51a31-df17-62ab-1b00-778cce29e57d@thomas-guettler.de" 
type="cite">
  <div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div 
style="width:100%;border-top:2px solid #EDF1F4;padding-top:10px;">   <div
 
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:49%;">
   	<a moz-do-not-send="true" href="mailto:guettliml@thomas-guettler.de"
 style="color:#485664 
!important;padding-right:6px;font-weight:500;text-decoration:none 
!important;">Thomas Güttler</a></div>   <div 
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:48%;text-align:
 right;">     <font color="#909AA4"><span style="padding-left:6px">Thursday,
 July 26, 2018 7:27 AM</span></font></div>    </div></div>
  <div style="color:#909AA4;margin-left:24px;margin-right:24px;" 
__pbrmquotes="true" class="__pbConvBody">This sound good. Looks like an 
automated bootleneck detection
<br>could be possible with pg_wait_sampling.
<br>
<br>Regards,
<br>  Thomas
<br>
<br><br>
<br></div>
</blockquote>
<br>
</body></html>

--------------070101090508010100050703--