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.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1whGNQ-0007Dk-05
	for pgsql-bugs@arkaria.postgresql.org;
	Wed, 08 Jul 2026 00:43:00 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1whGNO-003wqh-1y
	for pgsql-bugs@arkaria.postgresql.org;
	Wed, 08 Jul 2026 00:42:59 +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.96)
	(envelope-from <thombrown@gmail.com>)
	id 1whGNO-003wqZ-1A
	for pgsql-bugs@lists.postgresql.org;
	Wed, 08 Jul 2026 00:42:59 +0000
Received: from mail-wm1-f49.google.com ([209.85.128.49])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <thombrown@gmail.com>)
	id 1whGNN-000000004SL-0IVs
	for pgsql-bugs@postgresql.org;
	Wed, 08 Jul 2026 00:42:58 +0000
Received: by mail-wm1-f49.google.com with SMTP id
 5b1f17b1804b1-493b77b150aso574725e9.2
        for <pgsql-bugs@postgresql.org>; Tue, 07 Jul 2026 17:42:57 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; t=1783471376; cv=none;
        d=google.com; s=arc-20260327;
        b=hEYsZn5LRCNm0L6ByI8J3rl3919pFaCnspRHnJXV1Q+Gs31ScQs+r2YQu+dTLFNPEy
         rxQH1DfNhvQQJt5JkbY3szCWRzfRa/kpUf8jlF7u6igFPhBV65BhRCaPuVEx2WGFQdEE
         tquuNqNe/GHo8zayTbwuBNhGsQ/Qp9SsQ1senslmDkO/VH4c/XJgTAPqnxiNiR3FWNEh
         ths0s2WsD2HeeSasCDYDW4teoPwi5mXiYwpiStpLnMvAzyefSodMQNJlcISzkvKkBt5q
         A6av+pDN1F2sQ3W81rc71tg1Xf3w8YnqrMjLH6CEaeTqYMs6Mb6Zn0jhFSSsFw/RDw+j
         G69A==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com;
 s=arc-20260327;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version;
        bh=S9UDpBi08OfRP5hsiiT+zeuvHcTSdTX7qtLoSXfuyVU=;
        fh=I3eq9JLue6E0avFHTsCcomGp3fA3Ma3e1aqZSlFoqdo=;
        b=CM8LYwubwzNcoaVIgeV1ewUeKw3PBOdBowCDnktp9WpKIkN9tSvM6cIFOMnLpOz4d1
         Qfz+K1Lxd94wbBh+C75dA3wRVrVuhALnQZtVBFL2AapOOVNSjdofV+PanqRSnLiJVGsj
         SUismEmqZ5IhNVpUr4ei94r5Ejj5phug3YYzrN7iqQC9AK55TxM4ZDm8y81bV24x5OZw
         0ZhQ6+SO9HQOQ7Ly05aVfEJLV9jgH5bYImzhL7syM3lbf2RoBRsVBzrINdX/++o/3Txo
         khY+hR7r7d5oJas4QVDJJ5XGbZP7NIyvWTSBzvpUDuUdJSCW2O103tpeDdde/YOE4j1w
         XjRA==;
        darn=postgresql.org
ARC-Authentication-Results: i=1; mx.google.com; arc=none
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1783471376; x=1784076176;
        h=content-transfer-encoding:content-type:cc:to:subject:message-id
         :date:from:in-reply-to:references:mime-version:x-gm-gg
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to
         :content-type;
        bh=S9UDpBi08OfRP5hsiiT+zeuvHcTSdTX7qtLoSXfuyVU=;
        b=J9cAQv1IxscQVuYgngouJp1FRqXpyBX4wCCHRvZrL8OAkyyVoJqJfKD1OKAM2CkxIL
         9/lMqSwcyOwVEGCvnHYEkDED+DmiuxwmW7NiOz+2LigE+28iHqGO0Czgso7paUgr21fE
         zx2hAeKU2T2OpmTuz8FNrNEJr/tiK2m2R7UuhRTm9g8r8nuv08w1JlanHjiHvEtFmqFq
         8/DxOgI9ywX0IvSNg0c+2gwSpZg+3rZhrapxkTb5BHwmCYPpy8vAojhJ67+mUypUEcvL
         3P6dLuMmSvkRKBCkGD3K2An/GOOKitvfUapfMKmdhettwVZZlIHFp6Rrn82+H7KjO6Pm
         5syw==
X-Gm-Message-State: AOJu0YztS3WKjrox8a8ejpOqghZFCfEdW5dmLh7BvljraN9+bNBoGu4t
	JXvEU/EvHlWpTCbxGCLIVCen2S4Mm32nPzRD97h8dn2T/m5oRm/45Mtrva0fPQsdkRPlckGZlEJ
	PvvET37uCOAffW2C8ER8XCNinxlmqlaY=
X-Gm-Gg: AfdE7cl49hoOj1mZXaqQ5Qb9HAP+CExaZA38+JCPEXAyktEZvOXBLSPqzWYKEkM1GPV
	ThGc3KNhfBVNo3Bm5TLOHno/5Z1sjE3OjEhDIxVXxbkqjIzm2ybE28/PKR0TexPrsNvvc4cWtjq
	u/YwyUNV2lnyWq9Psr21dzcl/yMCe0dukyUj+kpAc2E4OX86BfN1mfKwQESLmCscFy2QV0YIhAu
	LBHpzZjaFu6kiSFxbfkrfi/cvZNqf07Jor3LTGCE+xEHnP9HltfOoOCBLSy7lXi3jDx8Ns/
X-Received: by 2002:a5d:5e8b:0:b0:475:f100:3600 with SMTP id
 ffacd0b85a97d-47df078b345mr26132f8f.61.1783471375428; Tue, 07 Jul 2026
 17:42:55 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CAA-aLv5QYTaMOk=Qhv6cgwceeHETZV8YJvWZ_rH+yVZCuchATA@mail.gmail.com>
 <CAMbWs4_0_DmnVc=oHbkqOCMnwwdM5GUDZzioPA+o4-WTsNnYSQ@mail.gmail.com>
 <CAMbWs4-b2By5XFEn-_ZJKgN4-8SBhAoRZJrt4gwmM2ctOQzAyw@mail.gmail.com>
 <CAA-aLv6p3tMdY4KJ9wG_DxL1_3MTMCeKj8zUo+1-MctSBmvfdw@mail.gmail.com>
 <CAMbWs4_+Xh6JRTUrxBHhr2-5e+5Y74vne_xR_Dr_=Y0t=5cjgg@mail.gmail.com>
 <CAA-aLv5Tybb_PAG8vmxB8KJXNgwqEBtAnd_nneP2YNahxs9irg@mail.gmail.com>
 <CAA-aLv6F_ebaU6Czuht5NTRQog0r-TpR9emV-qDKUnGe=eR8Lw@mail.gmail.com>
 <CAMbWs49k63s-6ZBEXz5d=UovJOSNkg7JTbuL8n+RGAVcnT+bWA@mail.gmail.com>
In-Reply-To: 
 <CAMbWs49k63s-6ZBEXz5d=UovJOSNkg7JTbuL8n+RGAVcnT+bWA@mail.gmail.com>
From: Thom Brown <thom@linux.com>
Date: Wed, 8 Jul 2026 01:42:28 +0100
X-Gm-Features: AVVi8CcoxlSgBNSuHd6EEmdwJcFA3tOv3CFyFStmTmwBVh1l26_afpj5k05bxNA
Message-ID: 
 <CAA-aLv59Jihb4dh4XWvz9Pj6Ac3VHHd7tCH5C9=jniiCxNEonw@mail.gmail.com>
Subject: Re: EXPLAIN (VERBOSE) fails with for JSON_ARRAYAGG/JSON_OBJECTAGG +
 window function
To: Richard Guo <guofenglinux@gmail.com>
Cc: pgsql-bugs <pgsql-bugs@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/CAA-aLv59Jihb4dh4XWvz9Pj6Ac3VHHd7tCH5C9%3DjniiCxNEonw%40mail.gmail.com>
Precedence: bulk

On Wed, 8 Jul 2026 at 01:08, Richard Guo <guofenglinux@gmail.com> wrote:
>
> On Tue, Jul 7, 2026 at 11:20=E2=80=AFPM Thom Brown <thom@linux.com> wrote=
:
> > So all looks good to me.
>
> Pushed and back-patched.

Thanks. Much appreciate you working on this.

Thom