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 1udIny-005jfO-4X for pgsql-performance@arkaria.postgresql.org; Sun, 20 Jul 2025 01:25:30 +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 1udImx-008y8E-CD for pgsql-performance@arkaria.postgresql.org; Sun, 20 Jul 2025 01:24:27 +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 1udGaW-008cbK-6l for pgsql-performance@lists.postgresql.org; Sat, 19 Jul 2025 23:03:29 +0000 Received: from out203-205-221-236.mail.qq.com ([203.205.221.236]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1udGaR-008Brt-0f for pgsql-performance@postgresql.org; Sat, 19 Jul 2025 23:03:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vip.qq.com; s=s201512; t=1752966195; bh=vpx/kUQ8Gj0CZk8f5OAn7cI4gsuEaY/QfcWPpjUbGW4=; h=From:To:Subject:Date; b=N9c3yyy2CV0gp67LzyN1lOpRCDIMIL5Gd4V3+6WRCB1lLb24jyNPR6hqyfW3l3GSj oi0goFJ8yLKpqj0T1vjOGYvqcJDWYk9jrpiSWyCNo3IvsPuCajgdknJsP0cqYoP0B8 hxVz5pJCp9NR3Xvp8S2rKv8QA+uHYe0cqEB3nytM= X-QQ-XMRINFO: N+gupeqCsbX287b6dEawhJA= X-QQ-XMAILINFO: OCzxluqIaPHW3fz6zw+N0hDwRXkGnV7EjVzqr2DNp+kbhxSoL3Bux4FtQ4Ad7F Qp24UpBJvtxORn1JN733xoHrfOR+jL9SjMg/ErC8z1hRpy7hIRjTkP2ID8zQaGaoOmGigQeWCaLnM 6y6EiRtJ8Kc3QrCGzgL9X+8fEPQKt+N2SndtPAJpfjOOhD95/pdO6XGE4CAYZQjo21lKEHE8JyvGB R1ycFCTrdsYztzMqp6sDY2I6xi5zdO5gKqh0118oUvN0T8O0FOkRam+uq2Qjhs8Ae95xdTK/hgRla rUBo+FQ87KyU4dd5kBO3v7uFuqZ2dF6WcXBndMY/JrTBz0ozoPq+zUSDlyioDxnDKaXa6uBREzUT4 6/yzT/MozEeLTJmOb3vGhg9YqF6nGzkGH1z26/SzuWt7PQDLJRH/TkDmvTbHhW6XTaskonlXOeh5g zeNVcWJ6v1npbQlpnm95UYRypII6Y1Jwnrm0wPyyYm4gzQxAgIU5SKcZarKUlP3stWgdZYgSKyCjE w3jjND4gtflxawSFLM9Uot1Lq8VuBTADQM8WQxtrKYlfd/6u8reo4+04pLGiik6TWqSjEmC1+KmGd woFYFIKy8Rfp3pAbLLkzo2ucVisdy7gVbYy2segSWZWuEZnJkuXBz8InYWHiQvDo/ORoJToMoW1GV awHZPXdYJUJiM7JkjleqR+DNxiYJnCLbx0fnwp9il181oh3NeWtoV8UdBbzowaRsq/WGY6ofGM8Mg kgBSzFEb6ZVArNMc85fXlEZm0Ye2rxoMTOIZjsMLC7BMNgJtb+w3kSvicjvEMrmLSxpFPyjNJHaFO ICXLtC6UFnIwbMyAlqDehK6lu4NrDTbGDeg3JL2Ktacrfk34kYmtdrEyMM5HYu+jsc8Jg+N+zKWJt 0j/FKd/U6Na/nVTLTBDgbOVocc9G1KXKD5fNi1n3eiSj6L8xk2JN0hkbqHDdJ/OXgOP1jb0/ez+be giRUXQ53vFFU/rdOgqEqQN3HZj39ebZi3Nv6qYj1q9SJFDhsDnVyNQnyWgp/ZQM5oRxJO+MQ== From: "=?utf-8?B?WHVhbiBDaGVu?=" To: "=?utf-8?B?cGdzcWwtcGVyZm9ybWFuY2U=?=" Subject: Question: Is it valid for a parent node's total cost to be lower than a child's total cost in EXPLAIN? Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Date: Sat, 19 Jul 2025 19:03:14 -0400 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x X-QQ-mid: xmsezc29-2t1752966194tsx1cskew List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksCgpJIGhhdmUgYSBxdWVzdGlvbiByZWdhcmRpbmcgdGhlIGludGVycHJldGF0aW9uIG9m IHRvdGFsIGNvc3TCoGluIFBvc3RncmVTUUwncyBFWFBMQUlOIG91dHB1dC4KCkluIHNvbWUg Y2FzZXMsIEkgbm90aWNlZCB0aGF0IGEgcGFyZW50IHBhdGggbm9kZSdzIHRvdGFsIGNvc3Qg aXMgbGVzcyB0aGFuwqB0aGF0IG9mIG9uZSBvZiBpdHMgY2hpbGQgcGF0aCBub2Rlcy4gSSBp bml0aWFsbHkgZXhwZWN0ZWQgdGhhdCB0aGUgdG90YWwgY29zdCBvZiBhIG5vZGUgc2hvdWxk IGJlIGF0IGxlYXN0IGFzIGxhcmdlIGFzIHRoZSBzdW0gb2YgaXRzIGNoaWxkIG5vZGVz4oCZ IHRvdGFsIGNvc3RzLCBvciBhdCBsZWFzdCBub3Qgc21hbGxlciB0aGFuIGFueSBzaW5nbGUg Y2hpbGQuCgpJcyB0aGlzIGJlaGF2aW91ciBleHBlY3RlZD8gQ291bGQgaXQgYmUgZHVlIHRv IGVzdGltYXRpb24gaW1wcmVjaXNpb24sIHNlbGVjdGl2aXR5LCBvciBwYXJhbGxlbGlzbSBl ZmZlY3RzPwoKSGVyZSBpcyBhIHJlcHJvZHVjaWJsZSBleGFtcGxlOgoKRFJPUCBUQUJMRSBJ RiBFWElTVFMgdF9hLCB0X2IsIHRfYywgdF9kOwoKQ1JFQVRFIFRBQkxFIHRfYShpZCBJTlQs IHZhbCBURVhUKTsgQ1JFQVRFIFRBQkxFIHRfYihpZCBJTlQsIHZhbCBURVhUKTsKQ1JFQVRF IFRBQkxFIHRfYyhpZCBJTlQsIHZhbCBURVhUKTsgQ1JFQVRFIFRBQkxFIHRfZChpZCBJTlQs IHZhbCBURVhUKTsKCi0tIFNtYWxsIHRhYmxlcwpJTlNFUlQgSU5UTyB0X2EgU0VMRUNUIGks ICdhXycgfHwgaSBGUk9NIGdlbmVyYXRlX3NlcmllcygxLCAxMDAwKSBpOwpJTlNFUlQgSU5U TyB0X2IgU0VMRUNUIGksICdiXycgfHwgaSBGUk9NIGdlbmVyYXRlX3NlcmllcygxLCAxMDAw KSBpOwoKLS0gTGFyZ2UgdGFibGVzCklOU0VSVCBJTlRPIHRfYyBTRUxFQ1QgaSwgcmVwZWF0 KCdjJywgMTAwMCkgRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwgMTAwMDAwKSBpOwpJTlNFUlQg SU5UTyB0X2QgU0VMRUNUIGksIHJlcGVhdCgnZCcsIDEwMDApIEZST00gZ2VuZXJhdGVfc2Vy aWVzKDEsIDEwMDAwMDApIGk7CgpBTkFMWVpFIHRfYTsgQU5BTFlaRSB0X2I7IEFOQUxZWkUg dF9jOyBBTkFMWVpFIHRfZDsKCkVYUExBSU4KU0VMRUNUCsKgIMKgIHRfYS4qLCB0X2IuKiwg dF9jLiosIHRfZC4qCkZST00gdF9hCkpPSU4gdF9iIE9OIHRfYS5pZCA9IHRfYi5pZApKT0lO IHRfYyBPTiB0X2IuaWQgPSB0X2MuaWQKSk9JTiB0X2QgT04gdF9jLmlkID0gdF9kLmlkOwoK VGhlIHJlc3VsdGluZyBFWFBMQUlOIHJlc3VsdCBpczoKCk1lcmdlIEpvaW4gIChjb3N0PTE2 MTI2OTIuMzEuLjE2MTI4NDguOTcgcm93cz0xMDAwIHdpZHRoPTIwMzQpCiAgIE1lcmdlIENv bmQ6ICh0X2EuaWQgPSB0X2MuaWQpCiAgIC0+ICBNZXJnZSBKb2luICAoY29zdD0xMzEuNjYu LjE1MS42NiByb3dzPTEwMDAgd2lkdGg9MTgpCiAgICAgICAgIE1lcmdlIENvbmQ6ICh0X2Eu aWQgPSB0X2IuaWQpCiAgICAgICAgIC0+ICBTb3J0ICAoY29zdD02NS44My4uNjguMzMgcm93 cz0xMDAwIHdpZHRoPTkpCiAgICAgICAgICAgICAgIFNvcnQgS2V5OiB0X2EuaWQKICAgICAg ICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHRfYSAgKGNvc3Q9MC4wMC4uMTYuMDAgcm93cz0x MDAwIHdpZHRoPTkpCiAgICAgICAgIC0+ICBTb3J0ICAoY29zdD02NS44My4uNjguMzMgcm93 cz0xMDAwIHdpZHRoPTkpCiAgICAgICAgICAgICAgIFNvcnQgS2V5OiB0X2IuaWQKICAgICAg ICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHRfYiAgKGNvc3Q9MC4wMC4uMTYuMDAgcm93cz0x MDAwIHdpZHRoPTkpCiAgIC0+ICBNYXRlcmlhbGl6ZSAgKGNvc3Q9MTYxMjU2MC41Mi4uMTYy NTc0OC4yNCByb3dzPTEwMDAwMCB3aWR0aD0yMDE2KQogICAgICAgICAtPiAgR2F0aGVyIE1l cmdlICAoY29zdD0xNjEyNTYwLjUyLi4xNjI1NDk4LjI0IHJvd3M9MTAwMDAwIHdpZHRoPTIw MTYpCiAgICAgICAgICAgICAgIFdvcmtlcnMgUGxhbm5lZDogMgogICAgICAgICAgICAgICAt PiAgTWVyZ2UgSm9pbiAgKGNvc3Q9MTYxMTU2MC40OS4uMTYxMjk1NS43MyByb3dzPTQxNjY3 IHdpZHRoPTIwMTYpCiAgICAgICAgICAgICAgICAgICAgIE1lcmdlIENvbmQ6ICh0X2MuaWQg PSB0X2QuaWQpCiAgICAgICAgICAgICAgICAgICAgIC0+ICBTb3J0ICAoY29zdD0zNjI3NC45 MC4uMzYzNzkuMDcgcm93cz00MTY2NyB3aWR0aD0xMDA4KQogICAgICAgICAgICAgICAgICAg ICAgICAgICBTb3J0IEtleTogdF9jLmlkCiAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ ICBQYXJhbGxlbCBTZXEgU2NhbiBvbiB0X2MgIChjb3N0PTAuMDAuLjE0NzAyLjY3IHJvd3M9 NDE2Njcgd2lkdGg9MTAwOCkKICAgICAgICAgICAgICAgICAgICAgLT4gIE1hdGVyaWFsaXpl ICAoY29zdD0xNTc1Mjg1LjU0Li4xNTgwMjg1LjU3IHJvd3M9MTAwMDAwNiB3aWR0aD0xMDA4 KQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgU29ydCAgKGNvc3Q9MTU3NTI4NS41 NC4uMTU3Nzc4NS41NiByb3dzPTEwMDAwMDYgd2lkdGg9MTAwOCkKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgU29ydCBLZXk6IHRfZC5pZAogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gdF9kICAoY29zdD0wLjAwLi4xNTI4NTgu MDYgcm93cz0xMDAwMDA2IHdpZHRoPTEwMDgpCigyMiByb3dzKQoKd2hpY2ggaW5jbHVkZXMg dGhlIGZvbGxvd2luZzoKCk1lcmdlIEpvaW4gIChjb3N0PTE2MTI2OTIuMzEuLjE2MTI4NDgu OTcgcm93cz0xMDAwIHdpZHRoPTIwMzQpCiAgLT4gLi4uCiAgLT4gTWVyZ2UgSm9pbiAgKGNv c3Q9MTYxMTU2MC40OS4uMTYxMjk1NS43MyByb3dzPTQxNjY3IHdpZHRoPTIwMTYpCgpJbiB0 aGlzIGNhc2UsIHRoZSBjaGlsZCBub2RlIChNZXJnZSBKb2luIG9uIHRfYy5pZCA9IHRfZC5p ZCkgaGFzIGEgdG90YWwgY29zdCBvZiAxNjEyOTU1LjczLCB3aGljaCBpcyBoaWdoZXIgdGhh biB0aGUgcGFyZW504oCZcyB0b3RhbCBjb3N0IG9mIDE2MTI4NDguOTcuCgpDb3VsZCBzb21l b25lIGNsYXJpZnkgd2hldGhlciB0aGlzIGlzIGNvbnNpZGVyZWQgdmFsaWQ/IEFueSBleHBs YW5hdGlvbiBvbiBob3cgdG90YWwgY29zdCBpcyBwcm9wYWdhdGVkIG9yIGNvbXB1dGVkIGlu IHN1Y2ggY2FzZXMgd291bGQgYmUgYXBwcmVjaWF0ZWQuCgpUaGFuayB5b3UgdmVyeSBtdWNo IQoKUG9zdGdyZVNRTCBtYWpvciB2ZXJzaW9uOiAxNgoKQmVzdCByZWdhcmRzLApYdWFuIENo ZW4K