Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u7wyx-00ARue-8j for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 13:51:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u7wyv-000EkM-Hc for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 13:51:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u7wyv-000Eir-5v for pgsql-general@lists.postgresql.org; Thu, 24 Apr 2025 13:51:14 +0000 Received: from mail-ua1-x92c.google.com ([2607:f8b0:4864:20::92c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u7wys-001mx2-0r for pgsql-general@lists.postgresql.org; Thu, 24 Apr 2025 13:51:13 +0000 Received: by mail-ua1-x92c.google.com with SMTP id a1e0cc1a2514c-8778151ddc5so437538241.2 for ; Thu, 24 Apr 2025 06:51:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mokadb-com.20230601.gappssmtp.com; s=20230601; t=1745502669; x=1746107469; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=nD94yMDsXM/24ZePNv45e/lQ9q5BZrDqB5t051bYhHA=; b=0fLi7z8ryB+sFBts+f5iMQgmTbWvhYnbenbzXh6GvZ8DEkDRRq+lFE0mixmNUQ/KfI vwaax3Vp+SOoiRFzIWjXmibm8DYPBuBDKAnEqPCy9qZ139wfedwYDo8/3jt1unDa5Sl5 x0w1U1jfHqkcF656vLYrc4KPuH3pRmVTJEw8ZdHfHk4+o+fBb6Xr7ht/4QA0hl72+JCH /EFczk7dZDCeXz9aCszM923ody0+6nnk6/Z/J5XnF75GKp/uLx6JQ4PICAV64wOHg7uX x5ZdhUcrILrVOVmSgnt22qYvHmuLossCaJwE2+eMkCwBDT+SOe71jFT4kVnjJ0BHG3Uu p9ew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745502669; x=1746107469; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=nD94yMDsXM/24ZePNv45e/lQ9q5BZrDqB5t051bYhHA=; b=aDNTtTodm/j1JT3+x3fX8eOFu/YahZey3+Awvm1iwl1+M9Eqv6t8tIND5NuMiEWkDK S631I/GfQW30yZCza4usyaNBSn3oL8FBS3LgSH5Zps02a8fXpUw+9m4prVCRIEvSCHzV tu4oXMJOW7MVLNtkB6xjrONo+LCCVO8R3JTZVW0fC8qhNhjfTwLUkF5Pmbb52IVZFrSB nXJ/36+iFnoCEHC3h5mtnJu+p//lmg1xAs3LwQ+3sdBA7y4ObPbsSXm+si8tkPpXAvdH 0fBkADJ1Bv1Me/luCZ7WFU1HzfYWkbEcckBxHd3eNfRQHM9nJHO2OlgJCYm95p9ZQRuI J1IA== X-Gm-Message-State: AOJu0Yy7jQmZMcUM5Un4Xn8SPDMlDgGM6QZbtWIYmMELKE1mYdXe3l1z Q9iyRV7EV63BMjPP1dh9KllTbftHm5SNmSuk44upUCYrNB2UhJzMfaUSdaP4eMEiJN8vQ+wia6n FX3yGRZu1AyritpqUJMRA/DKDkRoUBAlgV4qOzA== X-Gm-Gg: ASbGncuFtf3yKKTzquHEwilTBD5FtLBD12gDmPAGIWpM817SqPsgXknmhGJkitnJzbg uUsen4AdNwG+qDMYfmk7FiSu9uJaiz0PzfGai3PQpefIGqEox9qkNtaE6ErFCVWZmS6bmbwlbcM DXN9ntS6vPvu3z9ZE23QNbdg== X-Google-Smtp-Source: AGHT+IEtgGz/P++xP1yG7BtB6QJ7J6uKef+9f5qWvh1+WQjLeDPNEBiUBPcbjJjRCmOc1RQxLZ759asR1SEsHemAfEs= X-Received: by 2002:a05:6102:5487:b0:4bd:3519:44be with SMTP id ada2fe7eead31-4d38d829825mr2137432137.15.1745502669516; Thu, 24 Apr 2025 06:51:09 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Marc Millas Date: Thu, 24 Apr 2025 15:51:01 +0200 X-Gm-Features: ATxdqUE0Hfjj-NsQXWd74Xei2BDs8BnleMLB23qF3rfnXjvxDtHQMsZgdTAIEek Message-ID: Subject: Re: explain To: David Rowley Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000924c6f0633868222" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000924c6f0633868222 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks ! Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Thu, Apr 24, 2025 at 3:41=E2=80=AFPM David Rowley = wrote: > On Fri, 25 Apr 2025 at 01:32, Marc Millas wrote: > > Nested Loop Left Join (cost=3D941400.77..966327.57 rows=3D3 width=3D65= 3) > (actual time=3D52655.694..62533.811 rows=3D346 loops=3D1) > > Buffers: shared hit=3D10068265 read=3D396705 dirtied=3D1858 written= =3D218, > temp read=3D429687 written=3D115187 > > I/O Timings: read=3D79368.246 write=3D11.486 > > > > So, the total execution time is 52655 ms ok > > and the total time for i/o is...79368 ms > > > > how ??? > > The 79.3 seconds is the total time spent doing reads for all parallel > workers. 52.6 seconds is the wall clock time elapsed to execute the > query. > > David > --000000000000924c6f0633868222 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks !

Marc MILLAS
Senior Architect
+33607850= 334



<= div class=3D"gmail_quote gmail_quote_container">
On Thu, Apr 24, 2025 at 3:41=E2=80=AFPM David Rowley <dgrowleyml@gmail.com> wrote:
On Fri, 25 Apr 2025 at= 01:32, Marc Millas <marc.millas@mokadb.com> wrote:
> Nested Loop Left Join=C2=A0 (cost=3D941400.77..966327.57 rows=3D3 widt= h=3D653) (actual time=3D52655.694..62533.811 rows=3D346 loops=3D1)
>=C2=A0 =C2=A0Buffers: shared hit=3D10068265 read=3D396705 dirtied=3D185= 8 written=3D218, temp read=3D429687 written=3D115187
>=C2=A0 =C2=A0I/O Timings: read=3D79368.246 write=3D11.486
>
> So, the total execution time is 52655 ms ok
> and the total time for i/o is...79368 ms
>
> how ???

The 79.3 seconds is the total time spent doing reads for all parallel
workers. 52.6 seconds is the wall clock time elapsed to execute the
query.

David
--000000000000924c6f0633868222--