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 1mOOYW-0001VR-9t for pgsql-performance@arkaria.postgresql.org; Thu, 09 Sep 2021 18:13:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mOOYT-0004OW-KU for pgsql-performance@arkaria.postgresql.org; Thu, 09 Sep 2021 18:13:45 +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 1mOOYT-0004OO-CW for pgsql-performance@lists.postgresql.org; Thu, 09 Sep 2021 18:13:45 +0000 Received: from mout.kundenserver.de ([217.72.192.75]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mOOYN-0004SU-Jh for pgsql-performance@postgresql.org; Thu, 09 Sep 2021 18:13:44 +0000 Received: from ANAT ([78.197.128.121]) by mrelayeu.kundenserver.de (mreue109 [212.227.15.184]) with ESMTPSA (Nemesis) id 1MxUfn-1n8wdC1uvp-00xu2v for ; Thu, 09 Sep 2021 20:13:35 +0200 From: "Michel SALAIS" To: Subject: sql execution time in pg_stat_statements Date: Thu, 9 Sep 2021 20:13:33 +0200 Message-ID: <005f01d7a5a6$67784b50$3668e1f0$@msym.fr> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0060_01D7A5B7.2B0253D0" X-Mailer: Microsoft Outlook 16.0 Thread-Index: Adelpel537/e59LkRrKfXMwWz7SC1w== Content-Language: fr X-Provags-ID: V03:K1:lE+3IejuKFbTtG/jaoRs73RjW77VlQWYzELLGXd8YfT4GOQiCRJ 3qY9bxPAtDd4tjcXbIJ3PJOlQS8fMlx9THzv+gHYvDSfhqf7meF60USg8b2XZPXwlKevbRR Aa6zjszP/2JD83JSkfrc1OxmOezST79L4w7GSZfkSw9lphkNrZ7xpIwXtoXtCVaMO8CLdMh WvYxzCY0iiht7Yqh3DJhQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:xbFypsmvLnY=:0uy8YEPmhjTVbEeNkmmLx+ KpaKIhm032ndx6Ou/Qdjt5P6zxBxy+t0LCjww2fZyv51asDnW4cg7uXa7NbZbt+TiGfD+Tbsv lFXzy+n8ZD/2HsnzjBoXwoGt4JQ32WisB6QvoFRLAMfYsEl6J8M9P/n61fRr9ymitKMgt5w/z I4km+Z2gRivWoR+1ULxMPhiio5LDXi7u4Frjv8CIw12nc5M8tq57+8ccMAhLoSKjp2F08O3hd 7zXBEqY5nHygJ6Ogc02tiWU6NeAXxs5rhXeeGsSTG4MfEYRVqp5DzMqv+PaZfYIr0S2w91Amm sTB8LCTIZsseC/L9bRQofKtsFffTO6f4AocTRsvCaV7jhWizAF5Zs7shoVeEwH9dnrRV2xzk7 sDmT3d9kG+SurJnTf33ex61cK0XVKtv4varxxRk37HD9XRrtjUKju1u14SiKstFbc2+imhrzD O/Fp1mrA58Hs3p3G5wTJSLwW3IodoqCiFMkZ1BYY3dGF3tVzd1xDEcm//wyp1AaZ2OnkhX8V5 WAI4QDi2BvuExbAxyblPKT9xV0zXvQxLfIaH5I1AFNlow4kW//HK+iDKW+f40lR9OymggkyWg tMBYYCU0cluHgcqoPV75H1Y0GJc4XG6xO0moDJByyAO7s1fOIMBBS2ACC1RXzJ6gADz849rmx JeeOb+DtvVHAhFybPZULAza9SDiTYHSFfSa3gzmptkacLFVwLbOkiBSLyyu99MdDeFd0yhSUD Fw3TIH+cdouokj8mV+hy/ffjMW7gpIhsSHYGfQ== 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_0060_01D7A5B7.2B0253D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi all, I think that total_time in pg_stat_statements is cpu time + possible waits. So, can I say that: Total_sql_time = total_time + blk_read_time + blk_write_time Documentation is not clear at all on that. Thanks in advance Michel SALAIS ------=_NextPart_000_0060_01D7A5B7.2B0253D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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_0060_01D7A5B7.2B0253D0--