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 1lhhsv-0005fI-E5 for pgsql-hackers@arkaria.postgresql.org; Sat, 15 May 2021 00:10:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lhhsu-00008J-24 for pgsql-hackers@arkaria.postgresql.org; Sat, 15 May 2021 00:10:24 +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 1lhhst-00008A-MA for pgsql-hackers@lists.postgresql.org; Sat, 15 May 2021 00:10:23 +0000 Received: from mail-io1-xd31.google.com ([2607:f8b0:4864:20::d31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lhhsq-0008Jp-P7 for pgsql-hackers@lists.postgresql.org; Sat, 15 May 2021 00:10:22 +0000 Received: by mail-io1-xd31.google.com with SMTP id n40so469770ioz.4 for ; Fri, 14 May 2021 17:10:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=MG1nf0jOrmA4EI+ZVlpWziaxcUrX3paIcBd6+UAsbIc=; b=Wd6nzJaG62tRkPvnItcBoqr+lPOZcSNVFKt/FiL1pQjRJfwK8W1YR6auyhQwuci8xq VWsKL7YuftRhzgDEo6XrAk+p1c9EHh6Re7rTpxpSmPrDN9pKJwhhuQaJi3toLRK0vLhw SSg8R9VfVuRpsNHE4IHtOiS4TNHRD+ehkXc0da62kNQR8RKjojG7Lk+/vXGSQHEEqjef oIR45dxPHY6B54HceowYqdqAZzrrz5aRPuTMjOVKky5dxw4VHQC43ioG5yyzquaK6vgK 4SrTYgWodWG+psg/JnA6xhoLW+Aq+s6RdcPzJQNwhLv8DHjq3fplUkQ2WYejjNu2RLL1 BFeA== 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:user-agent; bh=MG1nf0jOrmA4EI+ZVlpWziaxcUrX3paIcBd6+UAsbIc=; b=D+mwF4Jp2olU9lhy3X+v0F3EYqmOCfarYXOB6sb3ICPN4dnQza/VMyjoA6ogJZAIbr /7nDb7VzljbUfRjgzHbWaJPqmExD5cF5anTZyjNmbuRgSyxx+XsU7/BS9bumShtBZ3+1 IKlFldDMv64Ypfp5IKq7l8JevO+oIEV0CduO9PrsRIGUbdkM1ka2y5y6mDu5xTqcDuMl HCXB//vekM9RaM3m8lVYVonWm21E56hRR9xhg+79t4lDxnGM3g8ew1WrP0KvY78gaYIG PqtY67qyoCQsbW5TV+246a9Dm87y/zLs0CHGY6yj0iX+0DpAKLbjL4pFOgO3OcRCsxfc eE+g== X-Gm-Message-State: AOAM532CTopwF5daN6pUc1WsUoDDeMBIEPTY6N81F/jKtcd0e6g+8D9s kP/scWvNilHKleIC/fKFcz9zfg== X-Google-Smtp-Source: ABdhPJx3Mrqx1xaAQVUviVwyUGCpKTw2aoQREeCzAxbo8SUCxU4sCX2XjawVPr6+uyXy/YmdKqeUJA== X-Received: by 2002:a02:688:: with SMTP id 130mr4066911jav.48.1621037418763; Fri, 14 May 2021 17:10:18 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id t8sm3850877ilj.56.2021.05.14.17.10.18 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 14 May 2021 17:10:18 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 8D4FE800A39; Fri, 14 May 2021 19:10:17 -0500 (CDT) Date: Fri, 14 May 2021 19:10:17 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: Julien Rouhaud , Fujii Masao , Pavel Stehule , Kyotaro Horiguchi , Magnus Hagander , Michael Paquier , Andres Freund , Tom Lane , Stephen Frost , Bruce Momjian , Christoph Berg , Peter Eisentraut , PostgreSQL Hackers Subject: Re: compute_query_id and pg_stat_statements Message-ID: <20210515001017.GU27406@telsasoft.com> References: <20210514035733.hkcf3alnbyofmplu@nol> <20210514235013.GA16112@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20210514235013.GA16112@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, May 14, 2021 at 07:50:13PM -0400, Alvaro Herrera wrote: > +++ b/doc/src/sgml/config.sgml > @@ -7643,7 +7643,12 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; > identifier to be computed. Note that an external module can > alternatively be used if the in-core query identifier computation > method is not acceptable. In this case, in-core computation > - must be disabled. The default is off. > + must be always disabled. > + Valid values are off (always disabled), > + on (always enabled) and auto, > + which let modules such as > + automatically enable it. > + The default is auto. which lets > +/* True when a module requests query IDs and they're set auto */ > +bool query_id_enabled = false; Does "they're" mean the GUC compute_query_id ? > +/* > + * This should only be called if IsQueryIdEnabled() > + * return true. > + */ > JumbleState * > JumbleQuery(Query *query, const char *querytext) Should it Assert() that ? Maybe you should update this too ? doc/src/sgml/release-14.sgml