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 1qgNk9-00FY8h-UE for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Sep 2023 11:09:14 +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 1qgNk8-00GZlw-Ir for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Sep 2023 11:09:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qgNk8-00GZli-7H for pgsql-hackers@lists.postgresql.org; Wed, 13 Sep 2023 11:09:12 +0000 Received: from mail1.dalibo.net ([51.159.93.128] helo=mail.dalibo.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qgNk4-004Jyj-KU for pgsql-hackers@postgresql.org; Wed, 13 Sep 2023 11:09:10 +0000 Received: from karst (larco.ioguix.net [78.202.0.6]) by mail.dalibo.com (Postfix) with ESMTPSA id 3E0191FBAA; Wed, 13 Sep 2023 13:09:05 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1694603345; bh=56HhzYHdVeaISgg5Ci8qg7t1VCr2JUBM7J/V19kgI/A=; h=Date:From:To:Cc:Subject:In-Reply-To:References:From; b=Psl27Tv/Hs34DZASp+HiNZbBDlwS6aoszLnLhjkcitiBk7oyDSBWb805eBqROlwwk BtKR0WueOPVUXAp7tsbGXwylkEhslX/1Np/6SGAKKK8YU0Bswye6sVmcGCFwkpzkh4 HnAtsJCMsZDIn58msXm8ve0zCGZboSpjzICeGnQ8= Date: Wed, 13 Sep 2023 13:09:04 +0200 From: Jehan-Guillaume de Rorthais To: stepan rutz Cc: Matthias van de Meent , pgsql-hackers@postgresql.org Subject: Re: Detoasting optionally to make Explain-Analyze less misleading Message-ID: <20230913130904.7386a230@karst> In-Reply-To: <2f57ca27-6828-eefc-9dd3-6e2d4578a8fa@gmx.de> References: <2f57ca27-6828-eefc-9dd3-6e2d4578a8fa@gmx.de> Organization: Dalibo MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Stepan & all, On Tue, 12 Sep 2023 17:16:00 +0200 stepan rutz wrote: ... > Attached a new patch. Hoping for feedback, Nice addition to EXPLAIN! On the feature front, what about adding the actual detoasting/serializing t= ime in the explain output? That could be: =3D> explain (analyze,serialize,costs off,timing off)=20 select * from test_detoast; QUERY PLAN =20 =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80 Seq Scan on public.test_detoast (actual rows=3DNv loops=3DN) Planning Time: N ms Execution Time: N ms Serialize Time: N ms