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 1mLTI1-00079S-Vz for pgsql-committers@arkaria.postgresql.org; Wed, 01 Sep 2021 16:40:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mLTI0-0003ZY-Tz for pgsql-committers@arkaria.postgresql.org; Wed, 01 Sep 2021 16:40:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLTI0-0003EE-HV for pgsql-committers@lists.postgresql.org; Wed, 01 Sep 2021 16:40:40 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLTHR-0007lM-OR for pgsql-committers@lists.postgresql.org; Wed, 01 Sep 2021 16:40:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=oXY+dnBh+JXteFlby9FOp9wiKLlmhyF5ZMH/eXRy3Bk=; b=6fF9Ltv0yS6tY3o06J8Q11753+ S1eUg5Bm6Jrp6A9zOk86HHOP4LKUVVUCwfl2oMYQV7M/lBYcblcXpenc5w9i9ZDnynjzQICfOZdX4 mkLBbm7XgOR7jEAYWNfGqrKU6J4CEFwwcnE60VyNEqCOC0MCW1a0NDOqIzKhUmZad9OcOyDzxE9zY 2SNLKVCY10SoArf8nYJYAwtycxi+KYAajuJW3/moaG2Osd3VQIc1BwJ2S0P1BL/Qtu1LP97YpLV/H 7dRFaw11K79gJCqx6ttmOPLVfST5uToTZONvQg80jhU9XLe7P+AJALamaQju6NBJnrVS2nYbbowm6 Qee5qD6g==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLTHR-0001NH-9W for pgsql-committers@lists.postgresql.org; Wed, 01 Sep 2021 16:40:05 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mLTHQ-000500-Qz for pgsql-committers@lists.postgresql.org; Wed, 01 Sep 2021 16:40:04 +0000 Content-Type: multipart/mixed; boundary="===============2344344838825967283==" MIME-Version: 1.0 From: Tomas Vondra To: pgsql-committers@lists.postgresql.org Subject: pgsql: Identify simple column references in extended statistics X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 01 Sep 2021 16:40:04 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2344344838825967283== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SWRlbnRpZnkgc2ltcGxlIGNvbHVtbiByZWZlcmVuY2VzIGluIGV4dGVuZGVkIHN0YXRpc3RpY3MK ClVudGlsIG5vdywgd2hlbiBkZWZpbmluZyBleHRlbmRlZCBzdGF0aXN0aWNzLCBldmVyeXRoaW5n IGV4Y2VwdCBhIHBsYWluCmNvbHVtbiByZWZlcmVuY2Ugd2FzIHRyZWF0ZWQgYXMgY29tcGxleCBl eHByZXNzaW9uLiBTbyBmb3IgZXhhbXBsZSAiYSIKd2FzIGEgY29sdW1uIHJlZmVyZW5jZSwgYnV0 ICIoYSkiIHdvdWxkIGJlIGFuIGV4cHJlc3Npb24uIEluIG1vc3QgY2FzZXMKdGhpcyBkb2VzIG5v dCBtYXR0ZXIgbXVjaCwgYnV0IHRoZXJlIHdlcmUgYSBjb3VwbGUgc3RyYW5nZSBjb25zZXF1ZW5j ZXMuCkZvciBleGFtcGxlCgogICAgQ1JFQVRFIFNUQVRJU1RJQ1MgcyBPTiBhIEZST00gdDsKCndv dWxkIGZhaWwsIGJlY2F1c2UgZXh0ZW5kZWQgc3RhdHMgcmVxdWlyZSBhdCBsZWFzdCB0d28gY29s dW1ucy4gQnV0CgogICAgQ1JFQVRFIFNUQVRJU1RJQ1MgcyBPTiAoYSkgRlJPTSB0OwoKd291bGQg c3VjY2VlZCwgYmVjYXVzZSB0aGF0IHJlcXVpcmVtZW50IGRvZXMgbm90IGFwcGx5IHRvIGV4cHJl c3Npb25zLgpNb3Jlb3ZlciwgdGhhdCBzdGF0aXN0aWNzIG9iamVjdCBpcyB1c2VsZXNzIC0gdGhl IG9wdGltaXplciB3aWxsIGFsd2F5cwp1c2UgdGhlIHJlZ3VsYXIgc3RhdGlzdGljcyBjb2xsZWN0 ZWQgZm9yIGF0dHJpYnV0ZSAiYSIuCgpTbyBkbyBhIGJpdCBtb3JlIHdvcmsgdG8gaWRlbnRpZnkg dGhvc2UgZXhwcmVzc2lvbnMgcmVmZXJlbmNpbmcgYSBzaW5nbGUKY29sdW1uLCBhbmQgdHJhbnNs YXRlIHRoZW0gdG8gYSBzaW1wbGUgY29sdW1uIHJlZmVyZW5jZS4gQmFja3BhdGNoIHRvCjE0LCB3 aGVyZSBzdXBwb3J0IGZvciBleHRlbmRlZCBzdGF0aXN0aWNzIG9uIGV4cHJlc3Npb25zIHdhcyBp bnRyb2R1Y2VkLgoKUmVwb3J0ZWQtYnk6IEp1c3RpbiBQcnl6YnkKQmFja3BhdGNoLXRocm91Z2g6 IDE0CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMjAyMTA4MTYwMTMyNTUuR1MxMDQ3 OSU0MHRlbHNhc29mdC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0K aHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81MzdjYTY4ZGJiMjQ2M2Y3 YjFjNDRlOTQ2NmI4ZmJkZDc1MDViMmUxCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpz cmMvYmFja2VuZC9jb21tYW5kcy9zdGF0c2NtZHMuYyAgICAgICAgfCAzNyArKysrKysrKysrKysr KysrKysrKysrKysrKystLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdGF0c19leHQu b3V0IHwgIDIgKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3RhdHNfZXh0LnNxbCAgICAgIHwgIDEg KwozIGZpbGVzIGNoYW5nZWQsIDM0IGluc2VydGlvbnMoKyksIDYgZGVsZXRpb25zKC0pCgo= --===============2344344838825967283==--