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 1tFfx3-00EwIS-CB for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Nov 2024 20:44:57 +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 1tFfx2-000NTQ-0p for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Nov 2024 20:44:56 +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 1tFfx1-000NTG-Nk for pgsql-hackers@lists.postgresql.org; Mon, 25 Nov 2024 20:44:55 +0000 Received: from mail-lf1-x12b.google.com ([2a00:1450:4864:20::12b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tFfwy-003kQi-Vb for pgsql-hackers@postgresql.org; Mon, 25 Nov 2024 20:44:54 +0000 Received: by mail-lf1-x12b.google.com with SMTP id 2adb3069b0e04-53dde1bf977so2534902e87.0 for ; Mon, 25 Nov 2024 12:44:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732567491; x=1733172291; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=PnYmoAnfDmd/Gj9u4frkb3RZpVxeBMH4wP1NVmG2hsg=; b=bFf24NuWDA+udgEdV2bUIx/4yy8JBrxhjb1wTMxLrHiQlRjxVUKxCy++yRvjiioaXD 2gNZDYh1kxXxdCjQbJO4tfMa8xjrGhhXn24wr52KPwVPf6HHY2+BvnzDtnE+F5bILLTy QmW87xJFm30qYJGr+iUX6r0vQI8dpYBJCy92MfZeDn1Tk+FOldrqHiOzd7DwaBYZSa/f a8HWd+c7abNUDku0FZtm1T1KE0JVifuvK/fgU1NbRX/tpiL4DiArVkAgRqdxmQtiJxxs P0JlTgm4AkvSIVlwRUbbQrT95o9YOoBjQTXk5u8xXzgVewd3LeIsbbrYJDoYnHWbYQwU nkyA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732567491; x=1733172291; h=content-transfer-encoding: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=PnYmoAnfDmd/Gj9u4frkb3RZpVxeBMH4wP1NVmG2hsg=; b=vYbUoQcsYvNlj9GK34fK496DmTRbtwG3IvsAe9jP2hWDcIMt+WZSyG/bPqwplYSgz1 QC6j+HuyTdzZt7+hP+TyKqQsf7io7xnJJKTwoEfaAz/uQ8qvcF7YDBuyEamf1nIawAZb ZWx0rhRA2hSQaMHZndeXlJGNcr5N8rDqCQkOrUa0FREbcwv5NpGGHN/qlPrhFPofVd/4 LJOPSqUV35u32uByS5tvtGNJdpyvRc0GhjvTxhH+Uiuc5Li4TLbzGKSUr91oHJjxHvk+ T0epTLyKbrMg9UeUerh6j8zx1DAfub1+bSKXQx5ZHSA2MWW+Pl4Up38pqmAo4EqauVxK xXmQ== X-Forwarded-Encrypted: i=1; AJvYcCUQ1gnapf0LCROuj4vfsmuZa1uTSWwHV3dn8xC6IxKfcE7v+C/hFaRRQpRrwgHwcJ+9TuuPY+FsjzWLxwRG@postgresql.org X-Gm-Message-State: AOJu0YzYAuZC+E52PFgu41hWbXDM26YZeeuYA4KKHbAfi7LKnS3Q+1a7 z0Yf26jGSrBbWXT2vqjxv5ry4pI/ujJXN9bhWbdQnXMZDmtYQqcVlezacsefhoX2gwaxqLdKPXN /p+5nLR2452uziH1gT32UUMV/N2A= X-Gm-Gg: ASbGncsrtu4WgMEqfphkr1CiaWw5gksYk6XfEMAXbobWR0XLxd3OVt/oo3CL3ZM7hLN /C7vUoZlhm1iyR4NHAhyAXdqZijPS8Cc= X-Google-Smtp-Source: AGHT+IE+j80+gUynPY+ZokvOrUFwPgQQ3x98nExPaUVBml0JMCNttM8RZTf0nYKielpv+3v/2VstkkNqu+zdj2YGduA= X-Received: by 2002:ac2:4c90:0:b0:53d:d3ff:83bf with SMTP id 2adb3069b0e04-53dd3ff83f6mr5871243e87.18.1732567490763; Mon, 25 Nov 2024 12:44:50 -0800 (PST) MIME-Version: 1.0 References: <3076356.1730831425@sss.pgh.pa.us> In-Reply-To: From: Robert Haas Date: Mon, 25 Nov 2024 15:44:38 -0500 Message-ID: Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE To: David Rowley Cc: Guillaume Lelarge , Greg Sabino Mullane , Michael Christofides , "David G. Johnston" , Nikolay Samokhvalov , Tom Lane , pgsql-hackers@postgresql.org 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 On Wed, Nov 20, 2024 at 4:23=E2=80=AFPM 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, w= ritten, 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. > > Votes for changing this so far seem to be: Me, Michael Christofides, > Guillaume Lelarge, Robert, Greg Sabino Mullane, and David Fetter (from > 2020) [1]. > > Votes against: None Just to be clear, my vote is more like +0 than +1. I recognize that changing this is popular and I'm not opposed to it, but I'm also not unhappy with things as they are. --=20 Robert Haas EDB: http://www.enterprisedb.com