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 ) id 1veuIH-001jhM-1u for pgsql-hackers@arkaria.postgresql.org; Sun, 11 Jan 2026 12:11:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1veuIG-00Bzf8-16 for pgsql-hackers@arkaria.postgresql.org; Sun, 11 Jan 2026 12:11:41 +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 ) id 1veuIG-00Bzf0-06 for pgsql-hackers@lists.postgresql.org; Sun, 11 Jan 2026 12:11:40 +0000 Received: from mail-ua1-x92e.google.com ([2607:f8b0:4864:20::92e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1veuIF-005WJL-0H for pgsql-hackers@postgresql.org; Sun, 11 Jan 2026 12:11:39 +0000 Received: by mail-ua1-x92e.google.com with SMTP id a1e0cc1a2514c-93f56a97064so1700020241.1 for ; Sun, 11 Jan 2026 04:11:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1768133498; x=1768738298; 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=O5QQ6kZcnfm3yvovBcGH4kmLgL00FTTs3uxu3nb2YdQ=; b=N62fJ2Dzqda1bjD4WJDqo4b+sRpEtlG2AqYJLZNsOMWEQJhGTGZ8Cj7TCyb/vp4FFA VIrIyaN0eIDHVK9nAjzV99scdlPovFCF4fyxIf8DnFzIJa1COlG7DG3kcl3G5ewerCW7 3c7GuYdTRd0SB6Rj0Dj4ikFowRk0sJUGj6Rcm6BFT+ATth6BPKH6XmeBhuwVlS1X+0dU u7Xttq+dEriT14ckbIgd/0qa4YqknBiMXmNTMVmZifg5YWWaBFRtwxf1UidTuwUrFUv+ Ddk21qUhtb2mAwgIr36tmFcGL5mX8a/swhDAftHSmz7JPAntUTggKuErBDSXXGubb8MT yQ4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768133498; x=1768738298; h=content-transfer-encoding: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; bh=O5QQ6kZcnfm3yvovBcGH4kmLgL00FTTs3uxu3nb2YdQ=; b=qA3uxF1HLmsiky2Lph6QFK5Bt2w7EJ0GRzaXjNNs4FUOhiY8Wq3OSlJA1rubh2bO8Q 2+04OS9Joe2NQswlkvAv0oxoWqJsjizeU0Mna0OnH0MXsS2ROvWRelInX9ESMIMLgtNm aKL/o0s3wqHj5kycrArk1SoJ4Wa2N1mk6B+Wa028U0g3qFtxOOAPiaFM9i+dYbjGr1ob AmD35bCBQaBa+4x8YhHcFRV3Uus+UlpLgjXPjdPciq+KR3mgyN12/VnLHH5tDoaKXFCw wZEomiqr+Q2mBq7q2VCH4akm8Tg6J5ts3cOgdtBv8lXNU0vV2DXyJZBpBXTxtlXEfWwU 9YVQ== X-Forwarded-Encrypted: i=1; AJvYcCWWyp92WotYB+W2/6VDtQgtTXLPlIc/1RJJap8tHlyRi1n8On5rsSP+n2yetYbn0uTOTgTeDrJ7TS/DajWq@postgresql.org X-Gm-Message-State: AOJu0Yxul7JDXiCOtiFcP5aibBgRQKk/Uj3tPjzs4DMuOubpr7Qiev6i zkYH//mAhGXFmwplhC0/G37x12X40k2r0jAz6kAyDOc0eNL1xXjoh7gWnZRhp5njT5lBMZBYDTL aHZ0uOeiHQss9qohb7NVV3E5kjjv1SOUDMYRlswgHUQ== X-Gm-Gg: AY/fxX4Q8zEa1bbpyiwHs6O3CSJSOWLCA6jMWY0PTR2UYFyn23wYvckMYW304cvDSfr R75SQpMUlrscQSfnwvVZomZbmrIjTygBHjzky6puiCErSIroE/H80UVzP8LH8sh1xnPMfPkvmtG WJslGrq/oXvF0lmvmazwVbZ+FwpPlr02EmeFpkpV4nnlRz8d9amX72MXRF+yfs3A+RM+qPLT9m0 joIFNIBh6dwYufgcDZ0Pl8Oiz7LDbfMDiMU+gVT0u1soK6/V0+Iu/VK6FDKs0Q3k27nmjNiEKAb BH+nhDzQHkspUqXRQ6Rs7UvqghbLJZ9L9wlj83kOJ6Y8dST0koDjPywS3ahS52vnUkT9EnK5Xc/ IuVF4UsP04+cbO2C5mgidocfMA/wwM+J6Yh7S5CU4+oZVx4UWE1xd3vHQJOpDbP7Fzel8us8x6r ks1h4gVmjc X-Google-Smtp-Source: AGHT+IF1kTYUe1eYqjHAg1PZZ7QBjaPwsc1rM3niVx4hi74fp68Mya9Rmfoxlx+M3g0L9R1z0YQtrZ3/TCOEYJP7uP4= X-Received: by 2002:a05:6102:4589:b0:5df:a069:4f79 with SMTP id ada2fe7eead31-5ecb6947a55mr5973237137.20.1768133497778; Sun, 11 Jan 2026 04:11:37 -0800 (PST) MIME-Version: 1.0 References: <2546766.1768063587@sss.pgh.pa.us> In-Reply-To: From: jian he Date: Sun, 11 Jan 2026 20:11:00 +0800 X-Gm-Features: AZwV_QjwDygbdgxpK9kuhF4qjQbWepVtGm9_JROfYcbvYtz1z2FNvjzAmQx04yc Message-ID: Subject: Re: JumbleQuery ma treat different GROUP BY expr as the same To: Michael Paquier Cc: Tom Lane , PostgreSQL-development , Richard Guo 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 Sun, Jan 11, 2026 at 6:13=E2=80=AFPM Michael Paquier wrote: > > This issue also points to a gap in the regression of > pg_stat_statements, where we have never bothered testing patterns of > GROUP BY with the same table and different attributes. Jian, would > you like to write a patch? > -- > Michael Sure, I will give it a try over the next few days.