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 1tisRe-003He4-TJ for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Feb 2025 09:57:14 +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 1tisRc-006jGr-R8 for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Feb 2025 09:57:13 +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 1tisRc-006jBF-GK for pgsql-hackers@lists.postgresql.org; Fri, 14 Feb 2025 09:57:13 +0000 Received: from mail-pl1-x634.google.com ([2607:f8b0:4864:20::634]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tisRb-000k9c-1a for pgsql-hackers@postgresql.org; Fri, 14 Feb 2025 09:57:12 +0000 Received: by mail-pl1-x634.google.com with SMTP id d9443c01a7336-21f92258aa6so48468395ad.3 for ; Fri, 14 Feb 2025 01:57:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739527030; x=1740131830; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=P1g6zKJaOMcODnjvj6WdbFJ987eq7Y+AJ+Yh1KmuDcQ=; b=bSDNWil/yczJnW/vlFsC6Nca5iw/d0QThezr52BWcPgBdlH4mb63Iigfh1NLKeXNXp 1uq/pqjMLqeRwhgQAXG+ry7K71bk7a+kU/uvrS2nKlE2pHgq+rBUbXixpr1sHlov1ke8 WSN1LSs5vJ1+9EbVuMxTGOLQ+gdV6E2PfZrtt0ivAk6LZHMrBgQnmSomPiGuCMY/Ubp/ SNNtdzyyrzRDNxcbLeM0uuz2opsocrxoRcV0tIvh7XRTGdd/sR+spnTt08BS8Ckw4IiA KU5qzOZAgu1hJlyQObhtqOPX7eTn/wBvxp48BZs+EzIzWUYh4626r4cJqHeYxji5AdT8 Zfbg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739527030; x=1740131830; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=P1g6zKJaOMcODnjvj6WdbFJ987eq7Y+AJ+Yh1KmuDcQ=; b=KOc/ACL9vsNJ1tVVwbTL63PAPnPdknwDqYx2KjtJze+dPVcbtYQeoXrMoRh9QmVIj9 EegoD+1vnNx7yscCFaKpvMHuMut3lrTTMRDh33+9n/nGTZHg1p7/sOwpu9raWCa203gI rdlWY/f2lB1HJqwZLxPWEbfjDhCGMsDBADK2QdqynGR/xW2AVKXfSBY+ylzAk6YJQazv B3sHkfChgIwHA0D4AU47p/ZIKaoncCbEFYwQUDpJ9W/MKLXe33kPr7jOmo5z72hifE+b Tzg7U7OVW8S3ke9HWaC0hMiB0d6M0Tsq4E18sI3Kp69szEa+Zng7jpFKLbhlw0OMXJZ/ C/Uw== X-Forwarded-Encrypted: i=1; AJvYcCVXp5+V0LU34mAirAbw5pf21LIDHLR21Gqd422mRTCAhCJZ3GX7ECa4WP6FGbav7sJnyo+2eRlvGVgtigDb@postgresql.org X-Gm-Message-State: AOJu0YxmsctiwjVZswWgY+hs/mNtyugjHaDQ3MzSTsuWU5JHdUr07V1b 9CKknkIz/a/5gAXT8302oyfiuDUWIosNepVCwnYmGPx2B1UWkznA X-Gm-Gg: ASbGncsrSc7/TS8K+ujWzQ8omcUls58SjaF4DG59i4s4hbGObEthpeKjJYuuQJDp/WT SspOH3dOGWFaKcKi1Xtgx7U3nO4XW/vDaQ5QV8Iwv5t/olVgnHIDCws2GMgI4yLk6oDrMnb88kF mD7FvIZIkJTEXeOiSzn/1//7mbz0NZVUJTc11miZaOXmlYphpZfY+tCYyfIDc9LUuPtgg7H5h4C EWXR11mRtaumJjWJlgxPGnS0oGZzf026i7szA4406qs5GSiGA5dQyghHoJTyrU1+eE5TzdSYZV1 J0FrjQs= X-Google-Smtp-Source: AGHT+IFMa4tXZ/wTpVG6nxTjtlP8vLjbvCrLR5ypQ9FP2eoSit34E+3R1LUnJiHqvy6mCYNrryjS0g== X-Received: by 2002:a17:902:f64c:b0:21f:164d:93fe with SMTP id d9443c01a7336-220bbc8ba82mr208878135ad.53.1739527030340; Fri, 14 Feb 2025 01:57:10 -0800 (PST) Received: from jrouhaud ([115.43.41.38]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-220d556d6d2sm25364725ad.177.2025.02.14.01.57.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 14 Feb 2025 01:57:09 -0800 (PST) Date: Fri, 14 Feb 2025 17:57:01 +0800 From: Julien Rouhaud To: =?iso-8859-1?Q?=C1lvaro?= Herrera Cc: Dmitry Dolgov <9erthalion6@gmail.com>, Sami Imseih , Kirill Reshke , Sergei Kornilov , yasuo.honda@gmail.com, tgl@sss.pgh.pa.us, smithpb2250@gmail.com, vignesh21@gmail.com, michael@paquier.xyz, nathandbossart@gmail.com, stark.cfm@gmail.com, geidav.pg@gmail.com, marcos@f10.com.br, robertmhaas@gmail.com, david@pgmasters.net, pgsql-hackers@postgresql.org, pavel.trukhanov@gmail.com, Sutou Kouhei Subject: Re: pg_stat_statements and "IN" conditions Message-ID: References: <202502140936.lni5gtrycnzf@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202502140936.lni5gtrycnzf@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Feb 14, 2025 at 10:36:48AM +0100, Álvaro Herrera wrote: > On 2025-Feb-14, Julien Rouhaud wrote: > > > Since the merging is a yes/no option (I think there used to be some discussions > > about having a threshold or some other fancy modes), maybe you could instead > > differentiate the merged version by have 2 constants rather than this "..." or > > something like that? > > Maybe the representation can be "($1 /*, ... */)" so that it's obvious > that the array extends beyond the first element but is still > syntactically valid. Yeah that works too and it's probably way easier to implement.