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 1tDzVE-004T2Z-Re for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Nov 2024 05:13:17 +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 1tDzVD-00CLl9-Gs for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Nov 2024 05:13:15 +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 1tDzVD-00CLhr-5C for pgsql-hackers@lists.postgresql.org; Thu, 21 Nov 2024 05:13:15 +0000 Received: from mail-wm1-x343.google.com ([2a00:1450:4864:20::343]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tDzVA-0033J6-B3 for pgsql-hackers@postgresql.org; Thu, 21 Nov 2024 05:13:14 +0000 Received: by mail-wm1-x343.google.com with SMTP id 5b1f17b1804b1-432d866f70fso3891575e9.2 for ; Wed, 20 Nov 2024 21:13:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=cybertec.at; t=1732165991; x=1732770791; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=suoJFw+oB4yBLFGdK5enuFY1GvUysG69zP7NwCGbziU=; b=iBCxMRWWjQVgqJ1esP3IvYqzV1AbZa4VRykGhNwxRAZTRl2+y8iFaayTlHWxI7pkp5 Qb2ddmC+th3qMELlonW+RHIQELPPMtXOFvylrHorfB+zvR/GGl+J4f2mWKXcsspdh79+ MmDpQ7zQBC3pX83JpgkXEwsAkMN1d9RYjfqXE= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732165991; x=1732770791; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=suoJFw+oB4yBLFGdK5enuFY1GvUysG69zP7NwCGbziU=; b=F6THZCrU+0OPw821irtNy9jBgtFO+chUUuj1NInbI7LYP/auYkVyiTSpfjred6t0OR /YYVYzEfev/nwxQTHf/C0CQlafVGRlWpeCnfVnpcC7WJHWkHyHV170TeIGSEdHmegCPA IevyEr8bi4dItJsTBgH21NTh3q9Mfn1CS4trkmGvAfHbKustPikBUMFNYmwRWqPF6e5W N+4kxX1PaOSoyJh/J0csIdV4qH/dax9INHOuxRB//5K9Y+T6hkMXbhjKre3bWk+U0GpI zdWAT6Otjn82Dw6q+F/XXjvA5Y1lzqTdHDSRHF1cjznyx6IZByvYNVlkFkpEjuO99Lx5 5L8w== X-Forwarded-Encrypted: i=1; AJvYcCUe/8YmtG/ml//SPEe0iEvSY9VExq54WFPcxyICdQ26illqZ98GtUFejj9t7Q8LLbC1SxSxNax+FSgwGle5@postgresql.org X-Gm-Message-State: AOJu0YwrJGLsiW65kXDJ7RxWImxm5b40pBYNB8rKlFeqdjTx1hsDYYp8 F2o67g2sZEjFfLDbUNFVbZ//ZcKqXPDMVAW4At/zF3ZkveIrGBYfF0fntoeg9W0= X-Gm-Gg: ASbGncu3YHDLByoyHqTTSwnyQ+RxpZ39F+8F1AwZhhZVO3QTKuoaPqauipQ9soQaZhr J3hGChs12/N0Dgo9qDpu/pbm9GPxEr19aIFD+aCFXeCjr4urGFC6YlO5f9j+YDmKx03KKAf/5BV fsDGfwRNrLZCnewX3njuGuhQgB+PKeucBBsccr67qRYk5U66sUcY2qVB9S+zglalX2mLtBMC/Ar jwujxnW+GTObfa2bRWHj/w/ltqcu2TDmJj1XnEMCd7g/Udk2uw3V2LBimY5TaenoUI= X-Google-Smtp-Source: AGHT+IHeyyd4yofA+Y/+AennZqEPG0LfBByxhPm/GfO6NSPtb2RFHuKZvQ1LoWEGXlCknS3/6U2+CQ== X-Received: by 2002:a05:600c:4504:b0:430:5654:45d0 with SMTP id 5b1f17b1804b1-433489b3dc4mr48865835e9.14.1732165990994; Wed, 20 Nov 2024 21:13:10 -0800 (PST) Received: from localhost.localdomain ([91.26.40.154]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3825493e975sm3878037f8f.88.2024.11.20.21.13.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 20 Nov 2024 21:13:10 -0800 (PST) Message-ID: <28e887b58c2e8b89f2753e6b11079e63d27ce613.camel@cybertec.at> Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE From: Laurenz Albe To: Vik Fearing , David Rowley , Guillaume Lelarge Cc: Greg Sabino Mullane , Robert Haas , Michael Christofides , "David G. Johnston" , Nikolay Samokhvalov , Tom Lane , pgsql-hackers@postgresql.org Date: Thu, 21 Nov 2024 06:13:10 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.4 (3.52.4-2.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-11-20 at 22:54 +0100, Vik Fearing wrote: > On 20/11/2024 22:22, David Rowley wrote: > > On Thu, 21 Nov 2024 at 08:30, Guillaume Lelarge wrote: > > > OK, I'm fine with this. v4 patch attached with one plan showing read,= written, and dirtied buffers. > > I think this might be a good time for anyone out there who is against > > turning on BUFFERS when ANALYZE is on to speak up. > >=20 > > Votes for changing this so far seem to be: Me, Michael Christofides, > > Guillaume Lelarge, Robert, Greg Sabino Mullane, and David Fetter (from > > 2020) [1]. >=20 > Add me to the pro list, please. >=20 > https://www.postgresql.org/message-id/b3197ba8-225f-f53c-326d-5b1756c77c3= e@postgresfriends.org Me, too! https://postgr.es/m/790e175d16cca11244907d3366a6fa376c33e882.camel@cybertec= .at Yours, Laurenz Albe