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 1txF4X-005L8s-07 for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Mar 2025 00:56:45 +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 1txF4V-00CcVT-OG for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Mar 2025 00:56:43 +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 1txF4V-00CcVL-EU for pgsql-hackers@lists.postgresql.org; Wed, 26 Mar 2025 00:56:43 +0000 Received: from mail-qv1-xf32.google.com ([2607:f8b0:4864:20::f32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1txF4U-0018yB-01 for pgsql-hackers@lists.postgresql.org; Wed, 26 Mar 2025 00:56:42 +0000 Received: by mail-qv1-xf32.google.com with SMTP id 6a1803df08f44-6e8f7019422so52983396d6.1 for ; Tue, 25 Mar 2025 17:56:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742950601; x=1743555401; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=SXxYX021yaftJzvQlu6eJvBJfYcKY5VYAsahtkGgLGk=; b=dd3exv+E3PbdGC3FJIMaEIB3obDYHPUZJiifnYYUeNJe+ihH7vvYLCWEeQtknlhf3y dNLh6AwUwu3jK2r7mWUVd1uPeyPZpTzSeYwTSI3syB9M9YfVAmEmfSvHCvOUwq4KVYRx ByYp53ubs0rwJVZYFkYDgKEHHsgU75DV7saJ2FuvrGkT55lP7wt2vel+HjwESAwg5oAS e7ZPptr2hSesOqnCnkYy/k4QQA+TpsxHUSQARnnG8+XqGan3Iypcu61Upb8qNq1JSfOR RMhgDeqXvh3925VndYcwB6r2ISsrKSu5jh/wozbf4/08XtsGzpSBNmXzDHLuI7LALH1A XOWw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742950601; x=1743555401; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=SXxYX021yaftJzvQlu6eJvBJfYcKY5VYAsahtkGgLGk=; b=iTX5luAV5Euwc6Xsd3rwGdWDKHm7ZX9q/5OODXFNqNOpkeX/VZPv697C3/LPnIroeN 9AM6nd7MRCFNF8cM8OyL/BUzua+OwW/tgBJpZadoLqmk4koB/7SxHJynGonIg7GKNw2m A4yGv5NUomeaRdYTIM56b8FbOL6AFGYE65q+OTc04BoVNQiTZ+ELkQr8FvxgOu024mUf zE32DAz56bVokFXduqMDyhsSGv9paxQ+0MFiqiIlvdIgOZ2B3WXxPyqC9cuD50ij/5nV W3IslyeTkIhHrQQM5lgY5K9O+b1qHVgEBQA/7MX+Huaiqfj7dk34Mrj/64RMwVSPEz3g 0oAQ== X-Forwarded-Encrypted: i=1; AJvYcCWFAFjGIIzawRcIzhk0xvaAZ9cpy0c/kVpgiACqSJAe31QzFtnaNHV+E1oRuPc499r1dLQIIkGqpH2FL9Lw@lists.postgresql.org X-Gm-Message-State: AOJu0YzPgRRO82cG1OUOCzpqyxuYEygqEb8PfwcoO/Nrvu7i2DnaM7R5 H+DmCfMoaLlyCFRQaPOudw89/SZ2MZ8BqDx1ebcUtwfIbJ1dvlbH X-Gm-Gg: ASbGncvHrWJ7LUh52syE6+qe7QZ2xontFFxHecmcif5gJ7GgwHPFu1qBndbeW7QKlvW fPZ2kLPCcXEBcDWAVMZOVQi9Vjx627nT44LTK5wjx+tDX+yCp0kiaxjWuq+AM4HX1hJfRhlWg1p 37z5EGtY1PUbnN/GWNChCyDSmCvD/MDZGNZcT/kPGCRyAYejrYXmtrhQjXwcefCcKjDXxT5Q/2t bAITLv0MSFGZVGP95KMT4IzAHcRX8C7d0pB4lMKG3/JHJf3YakUM+ptYcffJAaiKEq/ekoGF2Sd etmKo8TvNnpg4qJpGvWomNOfeFi/4qPf8bRRBYsI1UJzOttIXW3qrHfkLvQzkOOteQn7qDfmOw6 WzGaeFoNtRcv8OE8uA5XU X-Google-Smtp-Source: AGHT+IF9dl7aDIJ4IdcOB/LR3pUQyRzOv4UwhUs19q9XGKV2OHPK+3HcZYZW/8ZwQw+/lnr9rH+v1Q== X-Received: by 2002:a05:6214:2245:b0:6e6:65a6:79a4 with SMTP id 6a1803df08f44-6eb3f36a59dmr348955116d6.44.1742950600959; Tue, 25 Mar 2025 17:56:40 -0700 (PDT) Received: from smtpclient.apple (c-73-74-200-24.hsd1.il.comcast.net. [73.74.200.24]) by smtp.gmail.com with ESMTPSA id 6a1803df08f44-6eb3ef0ec56sm61775936d6.10.2025.03.25.17.56.40 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 25 Mar 2025 17:56:40 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Sami Imseih Mime-Version: 1.0 (1.0) Subject: Re: query_id: jumble names of temp tables for better pg_stat_statement UX Date: Tue, 25 Mar 2025 19:56:29 -0500 Message-Id: <70BA294B-5A33-4F47-A637-8011C1F279CB@gmail.com> References: Cc: Tom Lane , Christoph Berg , Lukas Fittl , PostgreSQL Hackers , ma lz In-Reply-To: To: Michael Paquier X-Mailer: iPhone Mail (22D82) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > If I get the difference right, semantically would apply to concepts > related to linguistics, but that's not what we have here, so you are > using a more general term. FWIW, the pg_stat_statements docs in a few places refer to=20 queries that may look different but have the same meaning=20 as =E2=80=9Csemantically equivalent=E2=80=9D, this is why I used the same=20= terminology here. But, I have no issue with the simplified rewrite either. The patch LGTM as well.=20 Regards, Sami Imseih=20 Amazon Web Services (AWS)=