Content-Type: multipart/mixed; boundary="------------lBl4GHYGWTcjc0Q5q0SZ8lHi"
Message-ID: <1987734a-013a-47f1-85c6-9ae19a49dbe3@postgrespro.ru>
Date: Fri, 10 Jul 2026 15:35:19 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: pgsql-hackers@lists.postgresql.org
From: Anton Ratundalov <a.ratundalov@postgrespro.ru>
Subject: Proposal : Retain explainable statement location on ExplainStmt
 structure.
Archived-At: 
 <https://www.postgresql.org/message-id/1987734a-013a-47f1-85c6-9ae19a49dbe3%40postgrespro.ru>
Precedence: bulk

This is a multi-part message in MIME format.
--------------lBl4GHYGWTcjc0Q5q0SZ8lHi
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi hackers

Let me propose to amend ExplainStmt structure with an new attribute 
explainable_loc of ParseLoc type

with the purpose of separating an EXPLAIN command ( together with it's 
options ) from the statement to be explained.

This, for example, will allow to execute EXPLAIN remotely with a 
different set of options.

Please, find code changes in the patch.


Best regards,

Anton Ratundalov,

Postgres Professional

--------------lBl4GHYGWTcjc0Q5q0SZ8lHi
Content-Type: text/x-patch; charset=UTF-8;
 name="retain_explainable_statement_location.patch"
Content-Disposition: attachment;
 filename="retain_explainable_statement_location.patch"
Content-Transfer-Encoding: base64

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkgYi9zcmMvYmFja2VuZC9w
YXJzZXIvZ3JhbS55CmluZGV4IDBmNGU4NjM4YzNkLi5jNDMxZmNlN2FjOSAxMDA2NDQKLS0t
IGEvc3JjL2JhY2tlbmQvcGFyc2VyL2dyYW0ueQorKysgYi9zcmMvYmFja2VuZC9wYXJzZXIv
Z3JhbS55CkBAIC0xMjc1OCw2ICsxMjc1OCw3IEBAIEV4cGxhaW5TdG10OgogCiAJCQkJCW4t
PnF1ZXJ5ID0gJDI7CiAJCQkJCW4tPm9wdGlvbnMgPSBOSUw7CisJCQkJCW4tPmV4cGxhaW5h
YmxlX2xvYyA9IEAyOwogCQkJCQkkJCA9IChOb2RlICopIG47CiAJCQkJfQogCQl8IEVYUExB
SU4gYW5hbHl6ZV9rZXl3b3JkIG9wdF92ZXJib3NlIEV4cGxhaW5hYmxlU3RtdApAQCAtMTI3
NjksNiArMTI3NzAsNyBAQCBFeHBsYWluU3RtdDoKIAkJCQkJaWYgKCQzKQogCQkJCQkJbi0+
b3B0aW9ucyA9IGxhcHBlbmQobi0+b3B0aW9ucywKIAkJCQkJCQkJCQkJIG1ha2VEZWZFbGVt
KCJ2ZXJib3NlIiwgTlVMTCwgQDMpKTsKKwkJCQkJbi0+ZXhwbGFpbmFibGVfbG9jID0gQDQ7
CiAJCQkJCSQkID0gKE5vZGUgKikgbjsKIAkJCQl9CiAJCXwgRVhQTEFJTiBWRVJCT1NFIEV4
cGxhaW5hYmxlU3RtdApAQCAtMTI3NzcsNiArMTI3NzksNyBAQCBFeHBsYWluU3RtdDoKIAog
CQkJCQluLT5xdWVyeSA9ICQzOwogCQkJCQluLT5vcHRpb25zID0gbGlzdF9tYWtlMShtYWtl
RGVmRWxlbSgidmVyYm9zZSIsIE5VTEwsIEAyKSk7CisJCQkJCW4tPmV4cGxhaW5hYmxlX2xv
YyA9IEAzOwogCQkJCQkkJCA9IChOb2RlICopIG47CiAJCQkJfQogCQl8IEVYUExBSU4gJygn
IHV0aWxpdHlfb3B0aW9uX2xpc3QgJyknIEV4cGxhaW5hYmxlU3RtdApAQCAtMTI3ODUsNiAr
MTI3ODgsNyBAQCBFeHBsYWluU3RtdDoKIAogCQkJCQluLT5xdWVyeSA9ICQ1OwogCQkJCQlu
LT5vcHRpb25zID0gJDM7CisJCQkJCW4tPmV4cGxhaW5hYmxlX2xvYyA9IEA1OwogCQkJCQkk
JCA9IChOb2RlICopIG47CiAJCQkJfQogCQk7CmRpZmYgLS1naXQgYS9zcmMvaW5jbHVkZS9u
b2Rlcy9wYXJzZW5vZGVzLmggYi9zcmMvaW5jbHVkZS9ub2Rlcy9wYXJzZW5vZGVzLmgKaW5k
ZXggYTkyZGJkYTA3NzAuLmJhZDkzM2Q0ZjBlIDEwMDY0NAotLS0gYS9zcmMvaW5jbHVkZS9u
b2Rlcy9wYXJzZW5vZGVzLmgKKysrIGIvc3JjL2luY2x1ZGUvbm9kZXMvcGFyc2Vub2Rlcy5o
CkBAIC00MTUyLDQgKzQxNTIsNSBAQCB0eXBlZGVmIHN0cnVjdCBFeHBsYWluU3RtdAogCU5v
ZGVUYWcJCXR5cGU7CiAJTm9kZQkgICAqcXVlcnk7CQkJLyogdGhlIHF1ZXJ5IChzZWUgY29t
bWVudHMgYWJvdmUpICovCiAJTGlzdAkgICAqb3B0aW9uczsJCS8qIGxpc3Qgb2YgRGVmRWxl
bSBub2RlcyAqLworCVBhcnNlTG9jICAgZXhwbGFpbmFibGVfbG9jOwogfSBFeHBsYWluU3Rt
dDsK

--------------lBl4GHYGWTcjc0Q5q0SZ8lHi--