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 1tpprt-00CwHt-5A for pgsql-committers@arkaria.postgresql.org; Wed, 05 Mar 2025 14:37:05 +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 1tpprr-00Cgpf-Oi for pgsql-committers@arkaria.postgresql.org; Wed, 05 Mar 2025 14:37:03 +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 1tpprr-00CgpX-Gu for pgsql-committers@lists.postgresql.org; Wed, 05 Mar 2025 14:37:03 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tpprp-0017TC-08 for pgsql-committers@lists.postgresql.org; Wed, 05 Mar 2025 14:37:02 +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 1tppro-002rz6-Ng for pgsql-committers@lists.postgresql.org; Wed, 05 Mar 2025 14:37:00 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tppro-000vAZ-14 for pgsql-committers@lists.postgresql.org; Wed, 05 Mar 2025 14:37:00 +0000 Content-Type: multipart/mixed; boundary="===============0195271620465356787==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Show index search count in EXPLAIN ANALYZE. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 05 Mar 2025 14:37:00 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0195271620465356787== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2hvdyBpbmRleCBzZWFyY2ggY291bnQgaW4gRVhQTEFJTiBBTkFMWVpFLgoKRXhwb3NlIHRoZSBj b3VudCBvZiBpbmRleCBzZWFyY2hlcy9pbmRleCBkZXNjZW50cyBpbiBFWFBMQUlOIEFOQUxZWkUn cwpvdXRwdXQgZm9yIGluZGV4IHNjYW4gbm9kZXMuICBUaGlzIGluZm9ybWF0aW9uIGlzIHBhcnRp Y3VsYXJseSB1c2VmdWwKd2l0aCBzY2FucyB0aGF0IHVzZSBTY2FsYXJBcnJheU9wIHF1YWxzLCB3 aGVyZSB0aGUgbnVtYmVyIG9mIGluZGV4IHNjYW5zCmlzbid0IHByZWRpY3RhYmxlIGluIGFkdmFu Y2UgKGF0IGxlYXN0IG5vdCB3aXRoIG9wdGltaXphdGlvbnMgbGlrZSB0aGUKb25lIGFkZGVkIHRv IG5idHJlZSBieSBQb3N0Z3JlcyAxNyBjb21taXQgNWJmNzQ4YjgpLiAgSXQgd2lsbCBhbHNvIGJl CnVzZWZ1bCB3aGVuIEVYUExBSU4gQU5BTFlaRSBzaG93cyBkZXRhaWxzIG9mIGFuIG5idHJlZSBp bmRleCBzY2FuIHRoYXQKdXNlcyBza2lwIHNjYW4gb3B0aW1pemF0aW9ucyBzZXQgdG8gYmUgaW50 cm9kdWNlZCBieSBhbiB1cGNvbWluZyBwYXRjaC4KClRoZSBpbnN0cnVtZW50YXRpb24gd29ya3Mg YnkgdGVhY2hpbmcgaW5kZXggQU1zIHRvIGluY3JlbWVudCBhIG5ldwpuc2VhcmNoZXMgY291bnRl ciB3aGVuZXZlciBhIG5ldyBpbmRleCBzZWFyY2ggYmVnaW5zLiAgVGhlIGNvdW50ZXIgaXMKaW5j cmVtZW50ZWQgYXQgZXhhY3RseSB0aGUgc2FtZSBwb2ludCB0aGF0IGluZGV4IEFNcyBtdXN0IGFs cmVhZHkKaW5jcmVtZW50IHRoZSBpbmRleCdzIHBnX3N0YXRfKl9pbmRleGVzLmlkeF9zY2FuIGNv dW50ZXIgKHdlJ3JlIGNvdW50aW5nCnRoZSBzYW1lIGV2ZW50LCBidXQgYXQgdGhlIHNjYW4gbGV2 ZWwgcmF0aGVyIHRoYW4gdGhlIHJlbGF0aW9uIGxldmVsKS4KVGhlIG5ldyBjb3VudGVyIGlzIHN0 b3JlZCBpbiB0aGUgc2NhbiBkZXNjcmlwdG9yIChJbmRleFNjYW5EZXNjRGF0YSksCndoaWNoIGV4 cGxhaW4uYyByZWFjaGVzIGJ5IGdvaW5nIHRocm91Z2ggdGhlIHNjYW4gbm9kZSdzIFBsYW5TdGF0 ZS4KClRoaXMgYXBwcm9hY2ggZG9lc24ndCBtYXRjaCB0aGUgYXBwcm9hY2ggdXNlZCB3aGVuIHRy YWNraW5nIG90aGVyIGluZGV4CnNjYW4gc3BlY2lmaWMgY29zdHMgKGUuZy4sICJSb3dzIFJlbW92 ZWQgYnkgRmlsdGVyOiIpLiAgSXQgaXMgc2ltaWxhciB0bwp0aGUgYXBwcm9hY2ggdXNlZCBpbiBv dGhlciBjYXNlcyB3aGVyZSB3ZSBtdXN0IHRyYWNrIGNvc3RzIHRoYXQgYXJlIG9ubHkKcmVhZGls eSBhY2Nlc3NpYmxlIGluc2lkZSBhbiBhY2Nlc3MgbWV0aG9kLCBhbmQgbm90IGZyb20gdGhlIGV4 ZWN1dG9yCihlLmcuLCAiSGVhcCBCbG9ja3M6IiBvdXRwdXQgZm9yIGEgQml0bWFwIEhlYXAgU2Nh bikuICBJdCBpcyBpbmhlcmVudGx5Cm5lY2Vzc2FyeSB0byBtYWludGFpbiBhIGNvdW50ZXIgdGhh dCBjYW4gYmUgaW5jcmVtZW50ZWQgbXVsdGlwbGUgdGltZXMKZHVyaW5nIGEgc2luZ2xlIGFtZ2V0 dHVwbGUgY2FsbCAob3IgYW1nZXRiaXRtYXAgY2FsbCksIGFuZCBkaXJlY3RseQpleHBvc2luZyBQ bGFuU3RhdGUuaW5zdHJ1bWVudCB0byBpbmRleCBhY2Nlc3MgbWV0aG9kcyBzZWVtcyB1bmFwcGVh bGluZy4KCkF1dGhvcjogUGV0ZXIgR2VvZ2hlZ2FuIDxwZ0Bib3d0LmllPgpSZXZpZXdlZC1CeTog VG9tYXMgVm9uZHJhIDx0b21hc0B2b25kcmEubWU+ClJldmlld2VkLUJ5OiBSb2JlcnQgSGFhcyA8 cm9iZXJ0bWhhYXNAZ21haWwuY29tPgpSZXZpZXdlZC1CeTogTWFzYWhpcm8gSWtlZGEgPGlrZWRh bXNoQG9zcy5udHRkYXRhLmNvbT4KUmV2aWV3ZWQtQnk6IE1hdHRoaWFzIHZhbiBkZSBNZWVudCA8 Ym9la2V3dXJtK3Bvc3RncmVzQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3Iu ZXMvbS9DQUgyLVd6PVBLUjZyQjdxYngrVm5kN2VxZUI1VlRjclc9aUp2QXNUc0tiZEcra1dfVUFA bWFpbC5nbWFpbC5jb20KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUgyLVd6a1Jx dmFxUjJDVE5xVFpQMHo2RnVMNC0zRUQ2ZVFCMHl4MzhYQk5qMXYtNFFAbWFpbC5nbWFpbC5jb20K CkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81ZWFkODVmYmM4MTE2MmFiMTU5NGY2NTZiMDM2YTIyZTgx NGY5NmIzCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpjb250cmliL2Jsb29tL2Jsc2Nh bi5jICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDEgKwpkb2Mvc3JjL3NnbWwvYmxvb20uc2dt bCAgICAgICAgICAgICAgICAgICAgICAgfCAgIDcgKy0KZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcu c2dtbCAgICAgICAgICAgICAgICAgIHwgIDI4ICsrKysrKy0tCmRvYy9zcmMvc2dtbC9wZXJmb3Jt LnNnbWwgICAgICAgICAgICAgICAgICAgICB8ICA2MCArKysrKysrKysrKysrKysrCmRvYy9zcmMv c2dtbC9yZWYvZXhwbGFpbi5zZ21sICAgICAgICAgICAgICAgICB8ICAgMyArLQpkb2Mvc3JjL3Nn bWwvcnVsZXMuc2dtbCAgICAgICAgICAgICAgICAgICAgICAgfCAgIDIgKwpzcmMvYmFja2VuZC9h Y2Nlc3MvYnJpbi9icmluLmMgICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9hY2Nl c3MvZ2luL2dpbnNjYW4uYyAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9hY2Nlc3Mv Z2lzdC9naXN0Z2V0LmMgICAgICAgICAgICAgfCAgIDIgKwpzcmMvYmFja2VuZC9hY2Nlc3MvaGFz aC9oYXNoc2VhcmNoLmMgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9hY2Nlc3MvaW5kZXgv Z2VuYW0uYyAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25i dHJlZS5jICAgICAgICAgICAgfCAgMTUgKysrKwpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25i dHNlYXJjaC5jICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9hY2Nlc3Mvc3BnaXN0L3NwZ3Nj YW4uYyAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9jb21tYW5kcy9leHBsYWluLmMgICAg ICAgICAgICAgICAgfCAgNDAgKysrKysrKysrKysKc3JjL2luY2x1ZGUvYWNjZXNzL3JlbHNjYW4u aCAgICAgICAgICAgICAgICAgIHwgICA3ICsrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYnJp bl9tdWx0aS5vdXQgICAgICB8ICAyNyArKysrLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv bWVtb2l6ZS5vdXQgICAgICAgICB8ICA0OSArKysrKysrKystLS0tCnNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvcGFydGl0aW9uX3BydW5lLm91dCB8IDEwMCArKysrKysrKysrKysrKysrKysrKysr LS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3NlbGVjdC5vdXQgICAgICAgICAgfCAgIDMg Ky0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvbWVtb2l6ZS5zcWwgICAgICAgICAgICAgIHwgICA1ICst CnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3BhcnRpdGlvbl9wcnVuZS5zcWwgICAgICB8ICAgNCArKwoy MiBmaWxlcyBjaGFuZ2VkLCAzMTAgaW5zZXJ0aW9ucygrKSwgNDkgZGVsZXRpb25zKC0pCgo= --===============0195271620465356787==--