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 1o5muS-0001qn-6S for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Jun 2022 11:28:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o5muQ-0007di-O7 for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Jun 2022 11:28:02 +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 1o5muQ-0007dZ-Eq for pgsql-hackers@lists.postgresql.org; Mon, 27 Jun 2022 11:28:02 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o5muP-0001DH-7F for pgsql-hackers@lists.postgresql.org; Mon, 27 Jun 2022 11:28:02 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 1D0305C00DD; Mon, 27 Jun 2022 07:28:00 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Mon, 27 Jun 2022 07:28:00 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ilmari.org; h=cc :cc:content-transfer-encoding:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to; s=fm3; t=1656329280; x= 1656415680; bh=5MRmjYWpDxxcqnZWv6AEH6AmIwTgRN6m/pXeX7f5azY=; b=2 S5M8Wes3Qch4yGyZx3nCCCPCldFRSqFne9FwJz1K1tSNMgjEQUl1Gis1ZRYdeLyB E+znKgvkRoFcaTVmviVK0rwtFJSi7ZCOMJFxbWOQPg+mPu85FjJvT4V37jDZtVPI VegTUTmzdJOxAGfu5Sv1Nnx99AJcWjVfXTUqV3e8l0C1+FMc7ezb/hj/Q3iUqpsx gy5as8Yf4NtP9IzyagJBdEAAC1erYIMe0ET7Bdi2MRUIJgYa7f7IKOCmJtJNSrc/ Kw/00M62H3o1MFmtaOu6O1vn41Kbgx4XGMlEDTPZDs2fqwM8EL3aE9/VP8ArsWfV Vpc/vz8AT8T75UDQTQ3vw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1656329280; x= 1656415680; bh=5MRmjYWpDxxcqnZWv6AEH6AmIwTgRN6m/pXeX7f5azY=; b=W be9Q0o1duWEN052NfJeGougVwYMGrGtTyoKlFa/KVxpt63oB/7uHvIvGpwnUfDcR 7RF/Eqfr+TCImo/xZ3Dv6LYGuE8T2/G9ykkN08s3G5EnaBDsyibncyL7h+f//ESO lAKutdf45kAlPeatzQX3sWO47s6vjehmjHC/XSgxWrh9U3sIyIQS6oPhBZQZWiFK ROf1vmbIOczYqZ7gXlQDrjLVNxKHoLYxq7juHHTcN+VpZjQqMPrYW2UvzNeJ5RZA /5LsO+g547naCUlno91FiYSBwuOb40RjjjwG71nPDptye3yZ6seMFMQbkc+qKFQ4 hdzlzLTjYkNne5aZXbZew== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrudeghedggeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpefhvfevufhfffgjkfgfgggtgfesthekredt tderjeenucfhrhhomhepffgrghhfihhnnhgpkfhlmhgrrhhipgforghnnhhsnohkvghruc eoihhlmhgrrhhisehilhhmrghrihdrohhrgheqnecuggftrfgrthhtvghrnhepgeegkefg feehleekuefhveevkedttdeftdffueevueejfedtgedtteffgedthfelnecuvehluhhsth gvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepihhlmhgrrhhisehilhhm rghrihdrohhrgh X-ME-Proxy: Feedback-ID: i1ff147bf:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 27 Jun 2022 07:27:59 -0400 (EDT) From: =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= To: Michael Paquier Cc: pgsql-hackers@lists.postgresql.org Subject: Re: Logging query parmeters in auto_explain References: <87ee09mohb.fsf@wibble.ilmari.org> <8735ggn2lf.fsf@wibble.ilmari.org> <87tu8tla5s.fsf@wibble.ilmari.org> <87iloml5a5.fsf@wibble.ilmari.org> Date: Mon, 27 Jun 2022 12:27:57 +0100 In-Reply-To: <87iloml5a5.fsf@wibble.ilmari.org> ("Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker=22's?= message of "Mon, 27 Jun 2022 12:22:42 +0100") Message-ID: <87fsjql51e.fsf@wibble.ilmari.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Dagfinn Ilmari Mannsåker writes: > Michael Paquier writes: > >> On Thu, Jun 09, 2022 at 11:55:11PM +0100, Dagfinn Ilmari Mannsåker wrote: >>> Done (and more tests added), v3 attached. >> >> One thing I am wondering is if we'd better mention errdetail_params() >> at the top of the initial check done in ExplainQueryParameters(). >> That's a minor issue, though. >> >> +sub query_log >> +{ >> Perhaps a short description at the top of this routine to explain it >> is worth it? > > Done. I also moved the function to the bottom of the file, to avoid > distracting from the actual test queries. I forgot to mention, I also changed the order of the query and parameters, so that they can more naturally be left out when no changes are needed. - ilmari