Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mOP7F-0002zu-6K for pgsql-performance@arkaria.postgresql.org; Thu, 09 Sep 2021 18:49:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mOP7D-0007Ic-Lp for pgsql-performance@arkaria.postgresql.org; Thu, 09 Sep 2021 18:49:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mOP7D-0007FC-D2 for pgsql-performance@lists.postgresql.org; Thu, 09 Sep 2021 18:49:39 +0000 Received: from mout.kundenserver.de ([212.227.126.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mOP7A-0004sO-Qd for pgsql-performance@postgresql.org; Thu, 09 Sep 2021 18:49:38 +0000 Received: from ANAT ([78.197.128.121]) by mrelayeu.kundenserver.de (mreue010 [212.227.15.168]) with ESMTPSA (Nemesis) id 1MuDLZ-1nERrn20Bp-00uc9Z for ; Thu, 09 Sep 2021 20:49:34 +0200 From: "Michel SALAIS" To: References: <005f01d7a5a6$67784b50$3668e1f0$@msym.fr> In-Reply-To: <005f01d7a5a6$67784b50$3668e1f0$@msym.fr> Subject: RE: sql execution time in pg_stat_statements Date: Thu, 9 Sep 2021 20:49:32 +0200 Message-ID: <006601d7a5ab$6e01c780$4a055680$@msym.fr> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0067_01D7A5BC.318BD000" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQJfVqXLzTD3tJt7ImS9sFGS32Fv3aqMqCKw Content-Language: fr X-Provags-ID: V03:K1:sHRf5UbPJUD57pQUHlX5Oi3N1JQgGE8etmCoJ8SW2Mbidk51e55 2zXi3LITd+bgGg+zWhLGXCRYxUekkBrsBg0Ahe5cm0LjEIoCVlbI8pTK5+CWZialJExVeFk Q/xWn/pLdjGK5zaS2S0QVKqGltptOwWrQaa1hqDS1mMfeEI7ZdzHd+g25TcPV5/wuEgjn8y 4LKAQOlOJvbc4Anavq6tA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:92tjx7lGCLc=:mgC2jgX9aLnMobgs0MiqMw ZcauDBcB4km3Epqc9h7/tslrf1mIuc/khV789eco8+E4UOb8Vsj/PdNb74AvF+FCsontfRC1Q A6NUvpmHieHz8SYWRTlTCMCxBdYMov70RJPF0vewhvlHWpkiFV690o0c88NxugteJpbY2EuX+ 3/yUzoFqtZNK8WcMwjx6B88ix/LM1EfDVXR815zJuQA4U9zRXa1bRLQIpuiS/5v7Jcvgjt3EN cRWNYS40iHLuXbmvb5cInMYDoIIuWNa7WM9Mf1diAg2wsJD3cJG964bXpTD0ZsQJEVrLWe8Yo bNgZ9vrTfnp18PAxWJXnFDm0MLQUorosyR3i3TG75UK5JIiwY/Cf7dCS4OFrbw6n9RsdLGUBt oAPziRFo65JW31/tlEH1bRMFAnDRdz799mmWOPPdHUtFFYFOFGwoG6bxOO4gwR4EFCg+lagqt doZOxzM2GAZfEp8Rhni9EHcQOVMnUJY6MQaot6ms9g1nc9qLkoHXHK7BkKvG6gftbrUj8lfqN p0ddHgOKQ+JYUcWuI5WCYhne5ijrtbG9/FQfqmZcxHl7cJz3SmPLynMw+0RHWYWIZZVemLSV2 l96m9eFNj1WHF+JU+RHYI14wjKSIdUipW2QJHFIaT7hZM/h8S4lp129mCsTD75ifuRMRapLpB +peJPTV7DQpBh6LQUW0aBDcaZoFl0Ur+Bl+RWrSlTkMn2KZ40F0KpuEMMpemSCXcjXlLg/kvV e6ZJARLM+9G+WXYc57Ab1u4/klqH6MO/USxOBg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0067_01D7A5BC.318BD000 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Just to say that for PostgreSQL 13, total_time is replaced by =93total_exec_time + total_plan_time=94 =20 Michel SALAIS De : Michel SALAIS =20 Envoy=E9 : jeudi 9 septembre 2021 20:14 =C0 : pgsql-performance@postgresql.org Objet : sql execution time in pg_stat_statements =20 Hi all, =20 I think that total_time in pg_stat_statements is cpu time + possible = waits. So, can I say that: Total_sql_time =3D total_time + blk_read_time + blk_write_time =20 Documentation is not clear at all on that. =20 Thanks in advance=20 =20 Michel SALAIS ------=_NextPart_000_0067_01D7A5BC.318BD000 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Just to say that for PostgreSQL 13, = total_time is replaced by “total_exec_time + = total_plan_time”

 

Michel = SALAIS

De : Michel SALAIS <msalais@msym.fr> =
Envoy=E9 : jeudi 9 septembre 2021 = 20:14
=C0 : = pgsql-performance@postgresql.org
Objet : sql execution = time in pg_stat_statements

 

Hi = all,

 

I think that total_time in = pg_stat_statements is cpu time + possible waits. So, can I say = that:

Total_sql_time =3D total_time + blk_read_time + = blk_write_time

 

Documentation is not clear at all on = that.

 

Thanks in advance

 

Michel = SALAIS

------=_NextPart_000_0067_01D7A5BC.318BD000--