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 1t8wQX-006qQ0-Hu for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Nov 2024 06:55:32 +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 1t8wQT-00Cr3V-Ui for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Nov 2024 06:55:30 +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 1t8wQT-00Cr1F-KT for pgsql-hackers@lists.postgresql.org; Thu, 07 Nov 2024 06:55:30 +0000 Received: from fhigh-a6-smtp.messagingengine.com ([103.168.172.157]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8wQR-000aqL-IF for pgsql-hackers@postgresql.org; Thu, 07 Nov 2024 06:55:28 +0000 Received: from phl-compute-10.internal (phl-compute-10.phl.internal [10.202.2.50]) by mailfhigh.phl.internal (Postfix) with ESMTP id 287F2114019A; Thu, 7 Nov 2024 01:55:26 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-10.internal (MEProxy); Thu, 07 Nov 2024 01:55:26 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm2; t=1730962526; x=1731048926; bh=IXt8G8MJ5SRuy+3lfTwsUnrR4K63UNyO usXAi2kBsFI=; b=R0Z4h6VALWcnDtVOG+e4s+7ksO1D6+NYGoeCEwINZP1sq+1a 1EPxRcpN1uYHZHlV/qCSUa+MPACXPbCEq42XCIfrkvMHKI43gD60MVMrFGGBoQXY hRavjBr4raLw+WwXSnPFEev9eK45I5PEy5O6qffB9+e4+vrAvWd8M0i1OM9MSMQL xOVS2E/BkeYpsEsAV0WaYnSGukBw4RIzkq1PvcgMpffFYGSR/cKo5aXm9xJj3E9y GkKwXrekZvnqv5qtV47DW87GBzxMWn9kc2Ost3wdQKAvQ82jKKYTHkGQwgaRGBt9 5m71nlSQ8ihke9LkYO4V1t1RKmSBJy2f32oQtQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1730962526; x= 1731048926; bh=IXt8G8MJ5SRuy+3lfTwsUnrR4K63UNyOusXAi2kBsFI=; b=X Iz+uzuiSZKy8BSUTrGdfH5iMSf95LTCl14iz5ePXNiaNK1qklXYwbQaV0++JG6nJ iHOCxOZIlfw0I1CQU3fd2RZ+p4zUiP8oyhLjPp+fRq4Q00QgKir/zL6H+VAK1vGR VCkC0Bv5/44l0ryHa5N1VwC2AI8upLH+ddsDM3SgUwTAa1V2dKNbEjU93EW3gq71 4/200HLZL9iAYreEKr7doyx0Kwg0pY3UqX04u6CMUDSTwceBCxDVTxwtokqXrwW6 NT3OqMhJuCFYWCM6BvyDVnPMgXpev/F+r6hPP81s/CKzCAj0z5lQEfrGtFu26aqS fMW2Z+jh5WlPW5FDF1LQg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrtdefgddutddvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdej necuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvg hnthhrrghuthdrohhrgheqnecuggftrfgrthhtvghrnhepgfejtdfhkeeftdeugfeileeh teeljeeghfeuledthfeutedvffdukeefjefhgeehnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdho rhhgpdhnsggprhgtphhtthhopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthhope hrohgsvghrthhmhhgrrghssehgmhgrihhlrdgtohhmpdhrtghpthhtohepshgrmhhokhhh vhgrlhhovhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrh hssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 7 Nov 2024 01:55:25 -0500 (EST) Message-ID: <1f6e3f50-9838-409e-bccf-c089948075fa@eisentraut.org> Date: Thu, 7 Nov 2024 07:55:24 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE To: Robert Haas , Nikolay Samokhvalov Cc: pgsql-hackers@postgresql.org References: Content-Language: en-US From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 05.11.24 19:19, Robert Haas wrote: >> 1) EXPLAIN ANALYZE Is sometimes very confusing (because there is ANALYZE). Let's rename it to EXPLAIN EXECUTE? > The trouble is that EXPLAIN EXECUTE already means something. > > robert.haas=# explain execute foo; > ERROR: prepared statement "foo" does not exist > > Granted, that would not make it impossible to make EXPLAIN (EXECUTE) a > synonym for EXPLAIN (ANALYZE), but IMHO it would be pretty confusing > if EXPLAIN EXECUTE and EXPLAIN (EXECUTE) did different things. At some point in the past, the idea of renaming EXPLAIN ANALYZE to PROFILE was thrown around. I still kind of like that idea. You'd have to keep the existing syntax around, of course.