Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lgOvg-0005QG-FM for pgsql-hackers@arkaria.postgresql.org; Tue, 11 May 2021 09:43:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lgOvf-00007l-Ei for pgsql-hackers@arkaria.postgresql.org; Tue, 11 May 2021 09:43:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lgOsd-0004a0-2r for pgsql-hackers@lists.postgresql.org; Tue, 11 May 2021 09:40:43 +0000 Received: from mail-pg1-x52d.google.com ([2607:f8b0:4864:20::52d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lgOsa-0003Mp-Tz for pgsql-hackers@lists.postgresql.org; Tue, 11 May 2021 09:40:42 +0000 Received: by mail-pg1-x52d.google.com with SMTP id c21so15367816pgg.3 for ; Tue, 11 May 2021 02:40:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=AtLjF8Xc5wv3ip3V3J86qa1IYGgLitIrwkIqDTiIk4E=; b=dLuHErz4gyauhMrUu9ar1RhgvqBj+86Dkj1TJtT1VUedRJt08kZhHx1BWUoVXEYMD+ R9OxhZXsfH6d9xcMKCo+G1K0+VWPRqj5Q0ZluuCR4IdvVwYsu8NuVGQma+cyjX5mZGrX 2hc/xARRtdnOFkhIqlxg53fMJPXMTThv6hv3/V1KU12cQpi8ODTvUIXXS7EkYCcD9+hH alFqCyWgPm1VaM4LWlJWcPFuq5T5SbyyKCZzr7TpEfFVNI+CZnyEy3Fya0oSAuNr06m8 kROoIDQNexKdXASnmChyLesIPonDDszyFwpfZNiN6O5WoS11J86iYGlelX6imzdg4u3I 6M/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=AtLjF8Xc5wv3ip3V3J86qa1IYGgLitIrwkIqDTiIk4E=; b=h2D0Xl95MIDZkydVa31grs3BoC5YqrkBbVMND0lEv98CRUo1r4w90GipJxQcmi2ANa t5w2z6DCECC6ZyBdaER1byB+jbP4zz1zixPPjhPBLtK7dG42YrAr8i+akaunDC7/XU+q 8NrX5p6yc3uaOI025Zcvyqzje+S8gxvfla94+7Aq7HWM1cdyo5zU2sO2vYVM6iCDbryP rYoXuz4ZTzXWzYFkqP+qYqFQ/uzmCHPn/vYfkihi3tK06rkJbhCrvHh5T7Vhc+fMF83T huc/084B8lOW4k0upuhNadXMzd/O2sMfB6zvFdB1zLfHkdVXMgXjGTMMHw+pULR5LIME 2GcQ== X-Gm-Message-State: AOAM532SoT08F33PUWASZMjxOr6Hbw+kkJf2MtoCHGE6SNHMfggf79BM hbnDQI84vv57ZdN8K4sZZZg= X-Google-Smtp-Source: ABdhPJySG+9+NHSLF/rSSB8GjWScFSP2WjvtKkmIwCnPz/ucliYMLKl2apx7Sa7Srx8r0AfEuLb0VA== X-Received: by 2002:a65:640f:: with SMTP id a15mr17093851pgv.251.1620726038647; Tue, 11 May 2021 02:40:38 -0700 (PDT) Received: from nol (2001-b011-0008-929a-d1b5-2d99-2ba7-4d91.dynamic-ip6.hinet.net. [2001:b011:8:929a:d1b5:2d99:2ba7:4d91]) by smtp.gmail.com with ESMTPSA id a24sm13195468pgv.76.2021.05.11.02.40.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 11 May 2021 02:40:38 -0700 (PDT) Date: Tue, 11 May 2021 17:41:06 +0800 From: Julien Rouhaud To: Magnus Hagander Cc: Fujii Masao , Michael Paquier , Andres Freund , Tom Lane , Alvaro Herrera , Stephen Frost , Bruce Momjian , Christoph Berg , Peter Eisentraut , PostgreSQL Developers Subject: Re: compute_query_id and pg_stat_statements Message-ID: <20210511094106.tqocsdmoefvu5lpu@nol> References: <20210426174331.GA19401@alvherre.pgsql> <20210426181408.3j6kkzpxnadpwptv@alap3.anarazel.de> <2295572.1619461260@sss.pgh.pa.us> <20210426183745.4gd2s5qra6mlxfto@alap3.anarazel.de> <20210427062504.ofz3rgedbrl5bep2@nol> <20210511073539.vw4m46vvbqhiwnz5@nol> <4f0929bf-c690-f2be-a050-a69a47a79651@oss.nttdata.com> <20210511085219.knbimwnsq45cloxm@nol> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, May 11, 2021 at 10:59:51AM +0200, Magnus Hagander wrote: > > That doesn't fundamentally make it impossible, you just have to add it > to the list of variables being copied over, wouldn't you? See > save_backend_variables() Yes, I agree, and that's what I meant by "explicitly handled". The thing is that I don't know if that's the best way to go, as it doesn't solve the "is it actually enabled" and/or "which implementation is used". At least the patch I sent, although it's totally a hack, let you know if compute_query_id is enabled or not. I'm fine with implementing it that way, but only if there's a consensus.