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 1ts1Op-00DJvd-9V for pgsql-committers@arkaria.postgresql.org; Tue, 11 Mar 2025 15:20:07 +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 1ts1Om-000kwS-Vq for pgsql-committers@arkaria.postgresql.org; Tue, 11 Mar 2025 15:20:04 +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 1ts1Om-000kwJ-Nw for pgsql-committers@lists.postgresql.org; Tue, 11 Mar 2025 15:20:04 +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 1ts1Ok-002FQJ-1x for pgsql-committers@lists.postgresql.org; Tue, 11 Mar 2025 15:20:03 +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 1ts1Oj-005p8N-W9 for pgsql-committers@lists.postgresql.org; Tue, 11 Mar 2025 15:20:01 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ts1Oj-001wle-2J for pgsql-committers@lists.postgresql.org; Tue, 11 Mar 2025 15:20:01 +0000 Content-Type: multipart/mixed; boundary="===============2856724727960344769==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve EXPLAIN's display of window functions. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 11 Mar 2025 15:20:01 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2856724727960344769== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBFWFBMQUlOJ3MgZGlzcGxheSBvZiB3aW5kb3cgZnVuY3Rpb25zLgoKVXAgdG8gbm93 IHdlIGp1c3QgcHVudGVkIG9uIHNob3dpbmcgdGhlIHdpbmRvdyBkZWZpbml0aW9ucyB1c2VkCmlu IGEgcGxhbiwgd2l0aCB3aW5kb3cgZnVuY3Rpb24gY2FsbHMgcmVwcmVzZW50ZWQgYXMgIk9WRVIg KD8pIi4KVG8gaW1wcm92ZSB0aGF0LCBzaG93IHRoZSB3aW5kb3cgZGVmaW5pdGlvbiBpbXBsZW1l bnRlZCBieSBlYWNoCldpbmRvd0FnZyBwbGFuIG5vZGUsIGFuZCByZWZlcmVuY2UgdGhlaXIgd2lu ZG93IG5hbWVzIGluIE9WRVIuCkZvciBuYW1lbGVzcyB3aW5kb3cgY2xhdXNlcyBnZW5lcmF0ZWQg YnkgIk9WRVIgKC4uLikiLCBhc3NpZ24KdW5pcXVlIG5hbWVzIHcxLCB3MiwgZXRjLgoKSW4gcGFz c2luZywgcmUtb3JkZXIgdGhlIHByb3BlcnRpZXMgc2hvd24gZm9yIGEgV2luZG93QWdnIG5vZGUK c28gdGhhdCB0aGUgUnVuIENvbmRpdGlvbiAoaWYgYW55KSBhcHBlYXJzIGFmdGVyIHRoZSBXaW5k b3cKcHJvcGVydHkgYW5kIGJlZm9yZSB0aGUgRmlsdGVyIChpZiBhbnkpLiAgVGhpcyBzZWVtcyBt b3JlCnNlbnNpYmxlIHNpbmNlIHRoZSBSdW4gQ29uZGl0aW9uIGlzIGFzc29jaWF0ZWQgd2l0aCB0 aGUgV2luZG93CmFuZCBhY3RzIGJlZm9yZSB0aGUgRmlsdGVyLgoKVGhhbmtzIHRvIERhdmlkIEcu IEpvaG5zdG9uIGFuZCDDgWx2YXJvIEhlcnJlcmEgZm9yIGRlc2lnbgpzdWdnZXN0aW9ucy4KCkF1 dGhvcjogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPgpSZXZpZXdlZC1ieTogRGF2aWQgUm93 bGV5IDxkZ3Jvd2xleW1sQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMv bS8xNDQ1MzAuMTc0MTQ2OTk1NUBzc3MucGdoLnBhLnVzCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv OGIxYjM0MjU0NGI2OWIyODFmZmQzYWFmZTU5NGFlYzYyOWVjNGQzYwoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvZXhwZWN0ZWQvcG9zdGdyZXNfZmR3 Lm91dCAgICB8ICAyNSArLQpzcmMvYmFja2VuZC9jb21tYW5kcy9leHBsYWluLmMgICAgICAgICAg ICAgICAgICAgIHwgMTE3ICsrKysrKystCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2NyZWF0 ZXBsYW4uYyAgICAgICAgICAgfCAgMzkgKy0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3Bs YW5uZXIuYyAgICAgICAgICAgICAgfCAgNTEgKysrKwpzcmMvYmFja2VuZC91dGlscy9hZHQvcnVs ZXV0aWxzLmMgICAgICAgICAgICAgICAgIHwgMTUwICsrKysrKysrLS0tCnNyYy9pbmNsdWRlL25v ZGVzL3BsYW5ub2Rlcy5oICAgICAgICAgICAgICAgICAgICAgfCAgIDMgKwpzcmMvaW5jbHVkZS91 dGlscy9ydWxldXRpbHMuaCAgICAgICAgICAgICAgICAgICAgIHwgICA1ICsKc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9ib3gub3V0ICAgICAgICAgICAgICAgICB8ICAxNCArLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL2NyZWF0ZV9pbmRleF9zcGdpc3Qub3V0IHwgIDQyICstLQpzcmMvdGVz dC9yZWdyZXNzL2V4cGVjdGVkL2V4cGxhaW4ub3V0ICAgICAgICAgICAgIHwgIDQ1ICsrKy0Kc3Jj L3Rlc3QvcmVncmVzcy9leHBlY3RlZC9nZW5lcmF0ZWRfdmlydHVhbC5vdXQgICB8ICAgMyArLQpz cmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dyb3VwaW5nc2V0cy5vdXQgICAgICAgIHwgIDEyICst CnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcGFydGl0aW9uX3BydW5lLm91dCAgICAgfCAgIDQg Ky0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wb2x5Z29uLm91dCAgICAgICAgICAgICB8ICAg MyArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3NlbGVjdF9wYXJhbGxlbC5vdXQgICAgIHwg ICA3ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3FsanNvbi5vdXQgICAgICAgICAgICAg fCAgMTggKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC93aW5kb3cub3V0ICAgICAgICAgICAg ICB8IDMwOCArKysrKysrKysrKysrLS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2V4cGxh aW4uc3FsICAgICAgICAgICAgICAgICAgfCAgIDUgKwoxOCBmaWxlcyBjaGFuZ2VkLCA1OTggaW5z ZXJ0aW9ucygrKSwgMjUzIGRlbGV0aW9ucygtKQoK --===============2856724727960344769==--