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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u7wps-00AOku-Ld
	for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 13:41:53 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u7wpq-0008Xo-2u
	for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 13:41:50 +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 <dgrowleyml@gmail.com>)
	id 1u7wpp-0008Xg-NP
	for pgsql-general@lists.postgresql.org; Thu, 24 Apr 2025 13:41:50 +0000
Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <dgrowleyml@gmail.com>)
	id 1u7wpn-001mtH-1X
	for pgsql-general@lists.postgresql.org;
	Thu, 24 Apr 2025 13:41:50 +0000
Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-30effbfaf4aso11982001fa.3
        for <pgsql-general@lists.postgresql.org>; Thu, 24 Apr 2025 06:41:47 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1745502107; x=1746106907; 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=yBxkhdrrEqOjAS2ywCcXPmn43gKI6k6W56vFp0N2XFk=;
        b=BdDBW9hQV/wY6/uc8+5yvWfaiRLuo4u4oOHmRY58MPVY1zPMHpeZo1OgwPRed5JEdK
         ihY6ji/mJsIl/6b/i0WgFZ5sRXaCtNzd1a6yQbgKrTCR1idSnIZcO8b+EBDcLSs+vWYd
         V1r+OjjLeBiEr45iGqQID7WzP9yS+8RRjgDJieH3vbMd13JwpBTmrPt+zWarfC2z0JKF
         5R0yNOBXwOjWZ4YB8sm5bbGHxqpYuashmr2tid0qBEy6dX5tZzqSf8vChUOop0lNyhKe
         qMp8peuGxPiXQcNwiWzmdunO9vRp9zUWZYi9ccjR9YecrWBs90HpJIGV8oy+55LvNcwT
         7KZg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1745502107; x=1746106907;
        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=yBxkhdrrEqOjAS2ywCcXPmn43gKI6k6W56vFp0N2XFk=;
        b=Hqm4idYkUSPMX2JuEncIoP/ZUA+Kkib7OAUsXQy/kJw66nqwZxSrK2d4+XhfUj+XHA
         gC3wfRb+LzhXwRAjbwfLE788ShttpySbH22ivuS2luV1DLW0mm6IqPvV1QF5kzQKUC26
         Rute6Hb7XLUAHsosyZAN5xqHUcsFSMWssNmOlvrtNSbg05MBgaCboHHvCQsMFuiPBZHU
         LDi8njJuxAxi/l3E5TBX5ROho/7j+gF64/Zg9TjrhbgiXjtVSzmRD3gquJzUeyNXc+Ym
         Lb43y+XbW4tGwA/WVXLpw1NHkBY2BkFM6Y6oOEE7fAcect7sAjrKnUX9cRG8MKG0FlI6
         e7/w==
X-Gm-Message-State: AOJu0YxEx/WWnccsQqj471fsviQVFOX114B4joi74Pj+DBZpyMdKo1yq
	GVtr8sV/f6ccj1/zZ1Kp3P63G97tPNXx3nrkXR7QdjdIMYNECRp/wPL3qAVLJoo2KmPbw3ITgc4
	ybWGzdpjNaBYU2tfDTy2K1nwXrTs=
X-Gm-Gg: ASbGnctJu32HlOndN9GqUL/BcW1oiaCzeJQObHABpbNgtHkyO3MBWsnh0Lk8JWDMuWg
	slCeITrAKNBEY+TZTbexq9LchLJGBjpWmffiXeZmW0xpUajEkyxfZu/NzdjskG+OaSNOo6S1qBv
	htQTL75RD18+7EApB/OxpH2O4CAqDG1j0ANo4PUwJMdFEK/3wtoxYmprvp
X-Google-Smtp-Source: AGHT+IEKyB5YjAkAJpRPyaGK7orersLhuTPunJ+LfCjqP87AleM1QfXz/zqnl78NQ5HYHM0Qg8Z5BrwB5B4HjWF7aCg=
X-Received: by 2002:a05:651c:1588:b0:30c:3f82:6844 with SMTP id
 38308e7fff4ca-3179ffc076amr11005081fa.34.1745502106833; Thu, 24 Apr 2025
 06:41:46 -0700 (PDT)
MIME-Version: 1.0
References: <CADX_1aZDtzTaoV5XNi__VbQCj7iPGaU6i5XANjjPwLwF7Acsww@mail.gmail.com>
In-Reply-To: <CADX_1aZDtzTaoV5XNi__VbQCj7iPGaU6i5XANjjPwLwF7Acsww@mail.gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
Date: Fri, 25 Apr 2025 01:41:34 +1200
X-Gm-Features: ATxdqUG0iDjhAuAtF1MsADZHJyeXyG3ISk8DdGQ-YuF38-zyQDdCu916HjCr-9A
Message-ID: <CAApHDvqN-mSE=9cgApVfp0qQtuasD_-p6PTRqygT8+HrPtb2zA@mail.gmail.com>
Subject: Re: explain
To: Marc Millas <marc.millas@mokadb.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAApHDvqN-mSE%3D9cgApVfp0qQtuasD_-p6PTRqygT8%2BHrPtb2zA%40mail.gmail.com>
Precedence: bulk

On Fri, 25 Apr 2025 at 01:32, Marc Millas <marc.millas@mokadb.com> wrote:
> Nested Loop Left Join  (cost=941400.77..966327.57 rows=3 width=653) (actual time=52655.694..62533.811 rows=346 loops=1)
>   Buffers: shared hit=10068265 read=396705 dirtied=1858 written=218, temp read=429687 written=115187
>   I/O Timings: read=79368.246 write=11.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