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 1tzNL0-001F3Q-JU for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Mar 2025 22:10:34 +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 1tzNKy-00DG8h-UN for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Mar 2025 22:10:32 +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 1tzNKy-00DG6e-Jk for pgsql-hackers@lists.postgresql.org; Mon, 31 Mar 2025 22:10:32 +0000 Received: from mail-lj1-x22f.google.com ([2a00:1450:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tzNJt-002DTK-2J for pgsql-hackers@lists.postgresql.org; Mon, 31 Mar 2025 22:09:27 +0000 Received: by mail-lj1-x22f.google.com with SMTP id 38308e7fff4ca-30bf3f3539dso46554921fa.1 for ; Mon, 31 Mar 2025 15:09:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743458963; x=1744063763; darn=lists.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=nQdvyr4HEXM5wnGKmNEVNbviOyvGL7/lDQdq1cZMdb0=; b=W6Vmp41i+gkE927B6Ro65dpgR5sUKurCpl47a7IlMJ+WNRDN2KJ7i58bahZl1dVlcV 4mY8qsetBv99D6V/a/YT/ZEQ3gcJSgfU91UCGG2yrycot/MLNbwukYZgwS/eX6599Im7 EBFEU8brM/ddPwSM2v+93Rxx+DGEidEdive/wzHNwMS4AvVuOWpaZnkFRRfn/I/HTtZY Opv03cfGN+H8cdPAUp4OQAPau9woogtYRrNH3t8p5K9elzEk+EviV1Y6cmgMq5+XPIFp cKwk0sBTN+SsF7YB64r0CSrpA1HxSrQTS1ksa8GJd3x6N7Uz/az2ejHWnFTlR+/4Qzm7 6jcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743458963; x=1744063763; 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=nQdvyr4HEXM5wnGKmNEVNbviOyvGL7/lDQdq1cZMdb0=; b=Ql1dBkGAjaxbcHVqY1WWsOvODIHExVABW/pUHmZR1+wkpCxv2IO8sZFYFH7WVZtLnN YrVonm7pFQoK9Vf9cEejHotRsZG5eOAIX8GjQYkGtrYWlNZN+vOfyMAMU0Ccf0wq3IxL na2j06DSQ/d18ftRZ3lBcaRI0XeZMtlABF/Nu3THkPRF1COWMkuT+ixwIvLO03JultHs 6RpbObqVXLGLeDtAEkfAFD5GO4YO9zNXlim8qCrOnnWS2+j3+HRq4T77ij1AnT1epbTO kJCE1jMbhjwOrUs9DBmKnFPuDmq3AsVuFjlXwSCmzxkM6e3WLy5wZlFnPAQjsXVKRkar xKKw== X-Forwarded-Encrypted: i=1; AJvYcCVKhnHjljDXco5e+MHJMOnx1jEs7SI2J1E+aSPljERUu9Aa8q3qCkAFfWRtHI3Tux8iG52ajCVMoky933Nq@lists.postgresql.org X-Gm-Message-State: AOJu0YwbeFZHJ3aFiY3Bs6HU0N7vJx0KqDI2Cg4FOTm5ChTKZz2htbcX mhqkO+XbI8Hgm9EufRmhavBZx4kXjHA+L8MTaJTxgxHsfBXk7yVXnevwmt8zOoEZ4ItxrOyQTTQ axrngMOSRr7EUzmBEjTPd0fTZhFl3mngv X-Gm-Gg: ASbGncvAKXqjWI8qPcyHhZ4Rd4a7tIB4tT2etXxEO8Sy71sEz3uusdmyCbYFQ86iubG EnOSAePEOZH0K+FKQaQHzWjUILlCd/drtCR5ZospHY23hsMp3Dg2BM9+1tI8zg4Wlls8IDttWRL 8erCyPsiz6CQ+7t8bajbC+meXvRT9WVyTl6qLu8ivPGfyvBOavf582hGgEMhnQYffSGKerG5Q= X-Google-Smtp-Source: AGHT+IGL2Nea+hVrst+Tqpf6JMPRwkrebKrHcObufxmMxOBYDeO+4BkydMX0G9jfjV+8n03vx05CPnoyrvAYZ0oTE7w= X-Received: by 2002:a05:651c:1046:b0:30b:c36c:ba96 with SMTP id 38308e7fff4ca-30ddf77fcc1mr27195801fa.1.1743458962867; Mon, 31 Mar 2025 15:09:22 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: David Rowley Date: Tue, 1 Apr 2025 11:09:11 +1300 X-Gm-Features: AQ5f1JpU3z2Kf6QR_Lvk2L1UPcig6DzEpsc8fi4UdQw26_2rZzhoeOnq_AGlKyw Message-ID: Subject: Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN. To: Christoph Berg Cc: Tatsuo Ishii , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVHVlLCAxIEFwciAyMDI1IGF0IDA5OjQwLCBDaHJpc3RvcGggQmVyZyA8bXlvbkBkZWJpYW4u b3JnPiB3cm90ZToNCj4gPSMgZXhwbGFpbiAoYW5hbHl6ZSxidWZmZXJzIG9mZixjb3N0cyBvZmYp IHNlbGVjdCBzdW0obikgb3ZlcigpIGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsMjA0OCkgYShuKTsN Cj4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4NCj4g 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSADQo+ICBXaW5kb3dBZ2cg KGFjdHVhbCB0aW1lPTIuMDczLi4yLjY4NiByb3dzPTIwNDguMDAgbG9vcHM9MSkNCj4gICAgV2lu ZG93OiB3MSBBUyAoKQ0KPiAgICBTdG9yYWdlOiBEaXNrICBNYXhpbXVtIFN0b3JhZ2U6IDY1a0IN Cg0KVGhhbmsgeW91IGZvciB0ZXN0aW5nIHRoYXQuIEkndmUganVzdCBwdXNoZWQgYSBwYXRjaCB0 byBidW1wIGl0IHVwIHRvIDI1MDAuDQoNCkkgc3VzcGVjdCB0aGUgYnVpbGRmYXJtIGRpZG4ndCBj YXRjaCB0aGlzIGR1ZSB0byB0aGUgdHVwbGVzdG9yZQ0KY29uc3VtaW5nIGVub3VnaCBtZW1vcnkg aW4gTUVNT1JZX0NPTlRFWFRfQ0hFQ0tJTkcgYnVpbGRzLg0KDQpEYXZpZA0K