Node detail is missing info when parsed from text (on "ANY_subquery")
pgiraud opened this issue · 0 comments
pgiraud commented
In the following plan, the on foo
doesn't seem to be parsed correctly. It actually doesn't appear in the in the node detail.
Subquery Scan on foo (cost=0.00..2.27 rows=1 width=265)
Filter: (foo.relname = 'aa'::name)
-> Limit (cost=0.00..1.77 rows=40 width=265)
-> Seq Scan on pg_class (cost=0.00..18.10 rows=410 width=265)
[
{
"Plan": {
"Node Type": "Subquery Scan",
"Parallel Aware": false,
"Async Capable": false,
"Alias": "foo",
"Startup Cost": 0.00,
"Total Cost": 2.27,
"Plan Rows": 1,
"Plan Width": 265,
"Filter": "(foo.relname = 'aa'::name)",
"Plans": [
{
"Node Type": "Limit",
"Parent Relationship": "Subquery",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 0.00,
"Total Cost": 1.77,
"Plan Rows": 40,
"Plan Width": 265,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "pg_class",
"Alias": "pg_class",
"Startup Cost": 0.00,
"Total Cost": 18.10,
"Plan Rows": 410,
"Plan Width": 265
}
]
}
]
}
}
]