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 1w5wLl-003mdV-0X for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 01:51:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5wLj-0071rK-2K for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 01:51:00 +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 1w5wLj-0071rC-19 for pgsql-hackers@lists.postgresql.org; Fri, 27 Mar 2026 01:50:59 +0000 Received: from mail-qv1-xf33.google.com ([2607:f8b0:4864:20::f33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5wLh-00000001ErV-17BH for pgsql-hackers@postgresql.org; Fri, 27 Mar 2026 01:50:58 +0000 Received: by mail-qv1-xf33.google.com with SMTP id 6a1803df08f44-899fbf92bdbso19427416d6.0 for ; Thu, 26 Mar 2026 18:50:57 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774576256; cv=none; d=google.com; s=arc-20240605; b=leuFqSyDvG2qDmomNkM+5xyVttYz6+40Np8YGNUdLH4SrfUM9/IYjTjgCQx140UpEl ZiFU3JrXpErH1U3GTdoTn0jvpBoVXiGqjx+5IhS9J4ZZat4PI3jBClCw4r9PsTdf1p1R EMv6wpE1a66FN5ekF/Rj1MNlimuSADMC4tmpkTc9hAQmVMHfmV0r9OTyOE57TlCd6PIQ hTFB/GcJlyFTRXwzAZ1R2hBl4S+453dkgy/iavcfXqKbEzvzZEfmvCPBiOle2j5Eq6+B pGLOwXp4i24lk8GpRfSmEb9ftBJPu4LjFjlWpSN3Jg+pD+q9Z1SbXPUbF6HTabXde+ao dAwg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=82zO8MbnTpdvto+/safOekHhtWFRr42kXpAg0kYaxMw=; fh=fiYnROVeCrBZxX8tC2R2ceg72COOCBltVIwK4RyH1kY=; b=EeFZxvyiiOrgJu3LWBNOkNygpaaIt3bpg5/cjkOu++clwHAID4y98WvpRE8Ordm8Jh StfEgNyeOSVoIMpOglrfY5dX683iqVxmyVdXSte8yK0131/4eLAdm1hsfCDfkCFrcHd3 Tmf6017TxbLN9OiG98TGgNe1W8L9w0WCt/QzQXLVz07A5XGFdVDX0ZhKkala0oQwfDhL GNlqMhaKRvomwEPUCDrjjXyNLCY6JK7UhWJz3BYOR4D7/vle0EGk/8aOWyzofSMqpVed 3WXIxRSSBRCvYepUKoLsb7SVf9OAN9mcpQf9EJNxZHQ2y6vMZ3TJ4tv7NRgptVCSSdXH nRUA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fittl.com; s=google; t=1774576256; x=1775181056; 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=82zO8MbnTpdvto+/safOekHhtWFRr42kXpAg0kYaxMw=; b=MJEa/EcOirIpdZxl4cPULeJt7si2wkecNz6sTfsv9DFVrdpESKxJUM8T1Qfz1Orj0/ QCp8PIMnhwdiDSh2B0p3tbyqcDTOC7S+nZZTdeQPyK4cW5sXsdIN6oyyiSAfXb/jfx4/ bFNeblhR3b5NjriEvNVPzOVE9OBc7Dc/xQbGI= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774576256; x=1775181056; 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=82zO8MbnTpdvto+/safOekHhtWFRr42kXpAg0kYaxMw=; b=GFNim18PNZ8EPr3F8fJUduwbZqqAS1Df5wbC8L0XbT23Xxad98/Li3i2oxMeWt8kLK 9errKfywCyCvq0GApWdi+8AbtlAVD3j1xVqU9RNojYmt+AZuwr6c8COY1HZC12epu43c Ody+H9RyaLmJ68sOvcg5DzbCs1t6DNFUdYag5uqVZ7LXFbvI47NmtXTHvYhpXrTjrZ8n wRDf99HpfLkvOmWY5sz8P6rJ//hVK5zTaAbENu5nHrCXsxwuEjzMZmOHjDrSz01uCdwI pYMn/FyVrcNLDI0UOQEFUmx3qiG+VY/qo4FHN+Ej8kx8LpaNIz0cjsa4iO5zUOHSb58G t0OQ== X-Forwarded-Encrypted: i=1; AJvYcCUFGjez1rw1AMdoYP7oj3pZCe3D6Xnd1l6apTDsCe62q9u6idkgnUZyf6+1T+GxbaegI+4CRLDsMDgZsCUP@postgresql.org X-Gm-Message-State: AOJu0YxDhEIRsPOGIqTsR5CuOqf4a5He4zoUruBcoGAvDYvWsOuhKHw7 dS4ASOO5oWTLZ70sfkXl5ujlZ/HxCFUjPSJZOzLNmnXslLMjEKa5wziqUjKj24eX0gBvdI5nBil 8eJGK1yXKymYVRIn0l/eMIo6hWzA102Kt7fcIVgQj X-Gm-Gg: ATEYQzxZKLNxgtH88yqfW2mdinwGJVD7gbHwWk9olNDMWSWnGxBLEG7ZatP5qpnkaxG DIEe+3X2OOtWBXYcR+6WykVkUyHtg9LXqcPH0FtE3DhpArSq9ZCofUJ7dXFIoB/7ra7Coreh7Bl TDJ+e3dPT8pEEwxGR8ifaz0k63EFU1asUCie6BGO1ZYIYNK8SW5KsonqCbK37otXX4ICcM2UL1v Sn2P88GajRor6I4reJCHoNzYf4Qtje0rDMVPGK3MbMvm/IvT+jcqVOHSHJ+XKUl5cdxm7LVRMY5 iabV6g2m12Jb2qp0QIfeowBMbsS1xd6iUCjkhJE= X-Received: by 2002:a05:6214:4c48:b0:89c:4e73:63c with SMTP id 6a1803df08f44-89ce8ecb4f1mr6388626d6.45.1774576256472; Thu, 26 Mar 2026 18:50:56 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Lukas Fittl Date: Thu, 26 Mar 2026 18:50:20 -0700 X-Gm-Features: AQROBzDB75p7Rgij_f4FjNtpXi51RlcdQwwYB9GZ-CTKdKKwluYk6G39Re1VOgs Message-ID: Subject: Re: Refactor query normalization into core query jumbling To: Sami Imseih Cc: Michael Paquier , zengman , pgsql-hackers , Julien Rouhaud 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 Thu, Mar 26, 2026 at 10:19=E2=80=AFAM Sami Imseih = wrote: > Both of those changes belong in 0002. See the attached v7. Looks good! I've also done a quick follow-up test with pg_tracing and that simplifies its logic as expected [0] to be able to extract inline parameter values. Thanks, Lukas [0]: https://github.com/lfittl/pg_tracing/commit/ae937fdee4aa57206b31b5746f= 36dd8e55cf43d1#diff-41cf816684c420b8808fb4899e38a38aaf4f875613c4785e291010a= a2b0ea267 --=20 Lukas Fittl