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.96) (envelope-from ) id 1w5n9E-003dML-1X for pgsql-admin@arkaria.postgresql.org; Thu, 26 Mar 2026 16:01:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5n9D-003ecX-01 for pgsql-admin@arkaria.postgresql.org; Thu, 26 Mar 2026 16:01:27 +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.96) (envelope-from ) id 1w5n8i-003a04-0K for pgsql-admin@lists.postgresql.org; Thu, 26 Mar 2026 16:00:56 +0000 Received: from mail-yx1-xb134.google.com ([2607:f8b0:4864:20::b134]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5n8g-00000001JFU-00p5 for pgsql-admin@lists.postgresql.org; Thu, 26 Mar 2026 16:00:56 +0000 Received: by mail-yx1-xb134.google.com with SMTP id 956f58d0204a3-64c9707fc11so920854d50.2 for ; Thu, 26 Mar 2026 09:00:54 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774540852; cv=none; d=google.com; s=arc-20240605; b=LcsWdnkhRq1pJdrsSFczFCa3ogQ0HXXDpy2kadE+FZsCysOc/SiEoFQBRKOnSXSPzk YgjTvDQ6UPIaR4lWxzldhuwG6AWEcvuWTbnHGHNQXrCm8pr7mW7x+Ik3qtQ4Yqa0Z6wf TcAFOofPM8g41WRYVXnG7HVhA1lQCQb5vecPZGFH037VnvesPtx/C0v06I9xgmhgxxeL C9Sz5Os/Hw/+znQt5NomqsP7x+VFvEKRmKAdycy2iLPBLZv/hRyBjufRihdtVM3zkjUn LG89910XSAI9iXlTvAopKxfUZyOmeh3bqMqZLSdx2S62RWVWFb7ZkxgGikL2T+HTBfUW Rvwg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=i+a+g7A2wtGD6WSqNItaP9WOH6shfbVwS2Bl73sod44=; fh=druxZHa2fk4e6MLibibygn9AWWgeaAPo4m8Gpo2MBXU=; b=CvbPYK97/ttNvAeJM+q/d99hmPP4E0JinX1mr8GlAru6diV01Vog5Q+ttRIq1/6CBF /c2ovHqOw/K+dq3mLSRnRS1aiPAFqgxwFEDh1/0ul6Sm8Yvc8zpWFY1Q0To+vV/E2UAL 8lf4j9Qi7CIjCITSmxaAseHydEJWd3MUusHNIKqGobdSiH+nkw/nfhjIjtgmmJhk+n2V rocyKJ4tLn+oZQaGAVEE5bvlwCZbENcRR3AzZ9lfbugVgwgxrrKPBCNapmIle4pDvYXo 363z9K2WLr7MXEYb/QmSNJg1Uf6wHCEkz+3tUj1wmF6xcBKA82Y94tOvoS6DZNAhCGsn 9q9g==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774540852; x=1775145652; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=i+a+g7A2wtGD6WSqNItaP9WOH6shfbVwS2Bl73sod44=; b=Opycw25P+Rox9Sp5n8XYw7MmvDVjuLP+wzRz0nH5EeJPeEAc9FmNyQDJHvzhyVR7uE CH5qJS8qRnNg5/hK4fH28JptDzELjXf8eF5ln7nf2AT5cApazQZwbgqcfcoZ/c6/P0n7 La3S8EolBglvQdQrP0Mu+04jRszWPFzsf7aAtTrO1vf2MBOOdIZ5za9SnbbG3kNVzrlN BQq70XShA54U7SOg0RuS545mGHi3r2vq/6t5eDHc4gzs8ERFklaDtaGxXKnvwfoOPM7e mp/xhrn0qA5EwNsnqWELvgAn8CKo5GF7E2xpaf52lMW3qRcK7Cv/vmVcMHPhpy32W7vF zaxw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774540852; x=1775145652; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=i+a+g7A2wtGD6WSqNItaP9WOH6shfbVwS2Bl73sod44=; b=MVB4kJ+Z6P4FPiFminsTmK/Sk8dZpHL2YM4iKA4KA5W4emQvaBLjzErXzp361fG3O1 qm8Zzp3faAbEse1r+SrPnGehMsrCiJ6SI9CLynyEivgSDfyi/5ZtIN0rDL65QpAVqTS+ c1qlFEJ550q7L/49xw9jqIqFK5tEOxSpa7MUh4UxZTuzmY0GdHX7XslVXHFbLmOkSFqD 51vaQZ4GDglRQq6J7h4YByPux2lMjkHniI6t8kJLPJns7x81g5ppg57W76r6eTwXtIWB aV5hDk238goIjik81ilDvUGDJFIxTl04tTEqNBPDEe+W+xRFDes2Idr85NPhqBuqAv1V WHTA== X-Gm-Message-State: AOJu0YwADMPRBVdY5+oEC59OOuw3uoWFmxBFAQQmIGKvQlvZmIdt+rDc k2r8pZ99C3cAHCWZDbHK6KHq9wim3nXfAew0SzdTa4Vs2Y4Vij6wPLiep8EgUgttiIZGfj6Jtuo 9F8o/DvRPoJV2BiiULSGFRpU1h3Yu1axEpX2U X-Gm-Gg: ATEYQzyx8BLWsNh5L1xfsYy7JmCzZjOB+QxW5uI6GNUmhtG/zXPjt5xOO7EHY/tW3LT lo4a2wBSgl3yLFdQ2sG/RLjah6znXIpWztLEPIlIEQkeszSsehniCS8TGbhYUkc4fHw97F5tj5w ogahBDAZ/1GHGfc5iaWf0YOLTXmunY0ODReaO/CjP5mbSGwDKCzej4kLbSeOuW42LuYkr/2IwC/ QO6Ky5QaBoFTZVhIEaj5J75XcN03DrEXZzfHk42PvJxV0t/2o63TbWMmSQwAka12be4xON6+fRq ombk0gE= X-Received: by 2002:a05:690e:1187:b0:64f:d184:39 with SMTP id 956f58d0204a3-64fd1840936mr2658947d50.34.1774540850810; Thu, 26 Mar 2026 09:00:50 -0700 (PDT) MIME-Version: 1.0 From: kaido vaikla Date: Thu, 26 Mar 2026 18:00:40 +0200 X-Gm-Features: AQROBzB6KaiaKhJDDkrqGVW4f33v992YK1nA1z9d_ucWAtxTBM32T882P0aUq7o Message-ID: Subject: =?UTF-8?Q?auto=5Fexplain_=E2=80=94_log_execution_plans_of_slow_queries?= To: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000000d52ed064def7d02" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000d52ed064def7d02 Content-Type: text/plain; charset="UTF-8" Hi, Is it my understanding correct that auto_explain duration includes time spent data sending to client and other wait events which are not part of query planning, execution time? br Kaido --0000000000000d52ed064def7d02 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,=C2=A0

Is it my understanding correct that auto_expl= ain duration includes time spent data sending to client and other wait even= ts which are not part of query planning, execution time?

br
Kaido=

--0000000000000d52ed064def7d02--