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 1trzXs-00D0Sj-Pd for pgsql-committers@arkaria.postgresql.org; Tue, 11 Mar 2025 13:21:20 +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 1trzXq-00GEUT-P0 for pgsql-committers@arkaria.postgresql.org; Tue, 11 Mar 2025 13:21:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1trzXq-00GEUK-Fv for pgsql-committers@lists.postgresql.org; Tue, 11 Mar 2025 13:21:18 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1trzXm-002Ezp-2N for pgsql-committers@lists.postgresql.org; Tue, 11 Mar 2025 13:21:18 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1trzXl-005mnC-Ki for pgsql-committers@lists.postgresql.org; Tue, 11 Mar 2025 13:21:13 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1trzXk-001vwd-26 for pgsql-committers@lists.postgresql.org; Tue, 11 Mar 2025 13:21:12 +0000 Content-Type: multipart/mixed; boundary="===============8639048119401367733==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Show index search count in EXPLAIN ANALYZE, take 2. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 11 Mar 2025 13:21:12 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8639048119401367733== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2hvdyBpbmRleCBzZWFyY2ggY291bnQgaW4gRVhQTEFJTiBBTkFMWVpFLCB0YWtlIDIuCgpFeHBv c2UgdGhlIGNvdW50IG9mIGluZGV4IHNlYXJjaGVzL2luZGV4IGRlc2NlbnRzIGluIEVYUExBSU4g QU5BTFlaRSdzCm91dHB1dCBmb3IgaW5kZXggc2Nhbi9pbmRleC1vbmx5IHNjYW4vYml0bWFwIGlu ZGV4IHNjYW4gbm9kZXMuICBUaGlzCmluZm9ybWF0aW9uIGlzIHBhcnRpY3VsYXJseSB1c2VmdWwg d2l0aCBzY2FucyB0aGF0IHVzZSBTY2FsYXJBcnJheU9wCnF1YWxzLCB3aGVyZSB0aGUgbnVtYmVy IG9mIGluZGV4IHNlYXJjaGVzIGNhbiBiZSB1bnByZWRpY3RhYmxlIGR1ZSB0bwppbXBsZW1lbnRh dGlvbiBkZXRhaWxzIHRoYXQgaW50ZXJhY3Qgd2l0aCBwaHlzaWNhbCBpbmRleCBjaGFyYWN0ZXJp c3RpY3MKKGF0IGxlYXN0IHdpdGggbmJ0cmVlIFNBT1Agc2NhbnMsIHNpbmNlIFBvc3RncmVzIDE3 IGNvbW1pdCA1YmY3NDhiOCkuClRoZSBpbmZvcm1hdGlvbiBzaG93biBhbHNvIHByb3ZpZGVzIHVz ZWZ1bCBjb250ZXh0IHdoZW4gRVhQTEFJTiBBTkFMWVpFCnJ1bnMgYSBwbGFuIHdpdGggYW4gaW5k ZXggc2NhbiBub2RlIHRoYXQgc3VjY2Vzc2Z1bGx5IGFwcGxpZWQgdGhlIHNraXAKc2NhbiBvcHRp bWl6YXRpb24gKHNldCB0byBiZSBhZGRlZCB0byBuYnRyZWUgYnkgYW4gdXBjb21pbmcgcGF0Y2gp LgoKVGhlIGluc3RydW1lbnRhdGlvbiB3b3JrcyBieSB0ZWFjaGluZyBhbGwgaW5kZXggQU1zIHRv IGluY3JlbWVudCBhIG5ldwpuc2VhcmNoZXMgY291bnRlciB3aGVuZXZlciBhIG5ldyBpbmRleCBz ZWFyY2ggYmVnaW5zLiAgVGhlIGNvdW50ZXIgaXMKaW5jcmVtZW50ZWQgYXQgZXhhY3RseSB0aGUg c2FtZSBwb2ludCB0aGF0IGluZGV4IEFNcyBhbHJlYWR5IGluY3JlbWVudAp0aGUgcGdfc3RhdF8q X2luZGV4ZXMuaWR4X3NjYW4gY291bnRlciAod2UncmUgY291bnRpbmcgdGhlIHNhbWUgZXZlbnQs CmJ1dCBhdCB0aGUgc2NhbiBsZXZlbCByYXRoZXIgdGhhbiB0aGUgcmVsYXRpb24gbGV2ZWwpLiAg UGFyYWxsZWwgcXVlcmllcwpoYXZlIHdvcmtlcnMgY29weSB0aGVpciBsb2NhbCBjb3VudGVyIHN0 cnVjdCBpbnRvIHNoYXJlZCBtZW1vcnkgd2hlbiBhbgppbmRleCBzY2FuIG5vZGUgZW5kcyAtLSBl dmVuIHdoZW4gaXQgaXNuJ3QgYSBwYXJhbGxlbCBhd2FyZSBzY2FuIG5vZGUuCkFuIGVhcmxpZXIg dmVyc2lvbiBvZiB0aGlzIHBhdGNoIHRoYXQgb25seSB3b3JrZWQgd2l0aCBwYXJhbGxlbCBhd2Fy ZQpzY2FucyBiZWNhbWUgY29tbWl0IDVlYWQ4NWZiICh0aG91Z2ggdGhhdCB3YXMgcXVpY2tseSBy ZXZlcnRlZCBieSBjb21taXQKZDAwMTA3Y2QgZm9sbG93aW5nICJkZWJ1Z19wYXJhbGxlbF9xdWVy eT1yZWdyZXNzIiBidWlsZGZhcm0gZmFpbHVyZXMpLgoKT3VyIGFwcHJvYWNoIGRvZXNuJ3QgbWF0 Y2ggdGhlIGFwcHJvYWNoIHVzZWQgd2hlbiB0cmFja2luZyBvdGhlciBpbmRleApzY2FuIHJlbGF0 ZWQgY29zdHMgKGUuZy4sICJSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiIpLiAgSXQgaXMgY29tcGFy YWJsZQp0byB0aGUgYXBwcm9hY2ggdXNlZCBpbiBzaW1pbGFyIGNhc2VzIGludm9sdmluZyBjb3N0 cyB0aGF0IGFyZSBvbmx5CnJlYWRpbHkgYWNjZXNzaWJsZSBpbnNpZGUgYW4gYWNjZXNzIG1ldGhv ZCwgbm90IGZyb20gdGhlIGV4ZWN1dG9yIHByb3BlcgooZS5nLiwgIkhlYXAgQmxvY2tzOiIgb3V0 cHV0IGZvciBhIEJpdG1hcCBIZWFwIFNjYW4sIHdoaWNoIHdhcyByZWNlbnRseQplbmhhbmNlZCB0 byBzaG93IHBlci13b3JrZXIgY29zdHMgYnkgY29tbWl0IDVhMWU2ZGYzLCB1c2luZyBlc3NlbnRp YWxseQp0aGUgc2FtZSBzY2hlbWUgYXMgdGhlIG9uZSB1c2VkIGhlcmUpLiAgSXQgaXMgbmVjZXNz YXJ5IGZvciBpbmRleCBBTXMgdG8KaGF2ZSBkaXJlY3QgcmVzcG9uc2liaWxpdHkgZm9yIG1haW50 YWluaW5nIHRoZSBuZXcgY291bnRlciwgc2luY2UgdGhlCmNvdW50ZXIgbWlnaHQgbmVlZCB0byBi ZSBpbmNyZW1lbnRlZCBtdWx0aXBsZSB0aW1lcyBwZXIgYW1nZXR0dXBsZSBjYWxsCihvciBwZXIg YW1nZXRiaXRtYXAgY2FsbCkuICBCdXQgaXQgaXMgYWxzbyBuZWNlc3NhcnkgZm9yIHRoZSBleGVj dXRvcgpwcm9wZXIgdG8gbWFuYWdlIHRoZSBzaGFyZWQgbWVtb3J5IG5vdyB1c2VkIHRvIHRyYW5z ZmVyIGVhY2ggd29ya2VyJ3MKY291bnRlciBzdHJ1Y3QgdG8gdGhlIGxlYWRlci4KCkF1dGhvcjog UGV0ZXIgR2VvZ2hlZ2FuIDxwZ0Bib3d0LmllPgpSZXZpZXdlZC1CeTogUm9iZXJ0IEhhYXMgPHJv YmVydG1oYWFzQGdtYWlsLmNvbT4KUmV2aWV3ZWQtQnk6IFRvbWFzIFZvbmRyYSA8dG9tYXNAdm9u ZHJhLm1lPgpSZXZpZXdlZC1CeTogTWFzYWhpcm8gSWtlZGEgPGlrZWRhbXNoQG9zcy5udHRkYXRh LmNvbT4KUmV2aWV3ZWQtQnk6IE1hdHRoaWFzIHZhbiBkZSBNZWVudCA8Ym9la2V3dXJtK3Bvc3Rn cmVzQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUgyLVd6a1Jx dmFxUjJDVE5xVFpQMHo2RnVMNC0zRUQ2ZVFCMHl4MzhYQk5qMXYtNFFAbWFpbC5nbWFpbC5jb20K RGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUgyLVd6PVBLUjZyQjdxYngrVm5kN2Vx ZUI1VlRjclc9aUp2QXNUc0tiZEcra1dfVUFAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0K bWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29t bWl0ZGlmZi8wZmJjZWFlODQxY2I1YTMxYjEzZDNmMjg0YWM4ZmRkMTk4MjJlY2ViCgpNb2RpZmll ZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpjb250cmliL2Jsb29tL2Jsc2Nhbi5jICAgICAgICAgICAg ICAgICAgICAgICAgfCAgIDIgKwpkb2Mvc3JjL3NnbWwvYmxvb20uc2dtbCAgICAgICAgICAgICAg ICAgICAgICAgfCAgIDcgKy0KZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCAgICAgICAgICAg ICAgICAgIHwgIDI4ICsrKysrLS0KZG9jL3NyYy9zZ21sL3BlcmZvcm0uc2dtbCAgICAgICAgICAg ICAgICAgICAgIHwgIDYwICsrKysrKysrKysrKysKZG9jL3NyYy9zZ21sL3JlZi9leHBsYWluLnNn bWwgICAgICAgICAgICAgICAgIHwgICAzICstCmRvYy9zcmMvc2dtbC9ydWxlcy5zZ21sICAgICAg ICAgICAgICAgICAgICAgICB8ICAgMiArCnNyYy9iYWNrZW5kL2FjY2Vzcy9icmluL2JyaW4uYyAg ICAgICAgICAgICAgICB8ICAgMiArCnNyYy9iYWNrZW5kL2FjY2Vzcy9naW4vZ2luc2Nhbi5jICAg ICAgICAgICAgICB8ICAgMiArCnNyYy9iYWNrZW5kL2FjY2Vzcy9naXN0L2dpc3RnZXQuYyAgICAg ICAgICAgICB8ICAgNCArCnNyYy9iYWNrZW5kL2FjY2Vzcy9oYXNoL2hhc2hzZWFyY2guYyAgICAg ICAgICB8ICAgMiArCnNyYy9iYWNrZW5kL2FjY2Vzcy9oZWFwL2hlYXBhbV9oYW5kbGVyLmMgICAg ICB8ICAgMiArLQpzcmMvYmFja2VuZC9hY2Nlc3MvaW5kZXgvZ2VuYW0uYyAgICAgICAgICAgICAg fCAgIDUgKy0Kc3JjL2JhY2tlbmQvYWNjZXNzL2luZGV4L2luZGV4YW0uYyAgICAgICAgICAgIHwg IDcwICsrKysrKysrKysrKystLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL25idHJlZS9uYnRyZWUuYyAg ICAgICAgICAgIHwgIDEwICstLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHNlYXJjaC5j ICAgICAgICAgfCAgIDIgKwpzcmMvYmFja2VuZC9hY2Nlc3Mvc3BnaXN0L3NwZ3NjYW4uYyAgICAg ICAgICAgfCAgIDIgKwpzcmMvYmFja2VuZC9jb21tYW5kcy9leHBsYWluLmMgICAgICAgICAgICAg ICAgfCAgNjMgKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY0luZGV4aW5n LmMgICAgICAgICAgIHwgICAyICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNQYXJhbGxlbC5j ICAgICAgICAgICB8ICA1OSArKysrKysrKystLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNS ZXBsaWNhdGlvbi5jICAgICAgICB8ICAgMiArLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlQml0 bWFwSW5kZXhzY2FuLmMgICAgfCAxMTYgKysrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL2Jh Y2tlbmQvZXhlY3V0b3Ivbm9kZUluZGV4b25seXNjYW4uYyAgICAgIHwgIDk2ICsrKysrKysrKysr KysrKysrKysrLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlSW5kZXhzY2FuLmMgICAgICAgICAg fCAgOTcgKysrKysrKysrKysrKysrKysrKystCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9zZWxmdW5j cy5jICAgICAgICAgICAgICB8ICAgMiArLQpzcmMvaW5jbHVkZS9hY2Nlc3MvZ2VuYW0uaCAgICAg ICAgICAgICAgICAgICAgfCAgMzQgKysrKysrKy0Kc3JjL2luY2x1ZGUvYWNjZXNzL3JlbHNjYW4u aCAgICAgICAgICAgICAgICAgIHwgIDExICsrLQpzcmMvaW5jbHVkZS9leGVjdXRvci9ub2RlQml0 bWFwSW5kZXhzY2FuLmggICAgfCAgIDYgKysKc3JjL2luY2x1ZGUvZXhlY3V0b3Ivbm9kZUluZGV4 b25seXNjYW4uaCAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvZXhlY3V0b3Ivbm9kZUluZGV4c2Nh bi5oICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvbm9kZXMvZXhlY25vZGVzLmggICAgICAg ICAgICAgICAgIHwgIDEyICsrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2JyaW5fbXVsdGku b3V0ICAgICAgfCAgMjcgKysrKy0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvbWVtb2l6ZS5v dXQgICAgICAgICB8ICA0OSArKysrKysrLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3Bh cnRpdGlvbl9wcnVuZS5vdXQgfCAxMDAgKysrKysrKysrKysrKysrKysrLS0tLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL3NlbGVjdC5vdXQgICAgICAgICAgfCAgIDMgKy0Kc3JjL3Rlc3QvcmVn cmVzcy9zcWwvbWVtb2l6ZS5zcWwgICAgICAgICAgICAgIHwgICA1ICstCnNyYy90ZXN0L3JlZ3Jl c3Mvc3FsL3BhcnRpdGlvbl9wcnVuZS5zcWwgICAgICB8ICAgNCArCnNyYy90b29scy9wZ2luZGVu dC90eXBlZGVmcy5saXN0ICAgICAgICAgICAgICB8ICAgMiArCjM3IGZpbGVzIGNoYW5nZWQsIDc5 NyBpbnNlcnRpb25zKCspLCA5OCBkZWxldGlvbnMoLSkKCg== --===============8639048119401367733==--