-
Notifications
You must be signed in to change notification settings - Fork 174
Open
Description
Is your feature request related to a problem? Please describe.
In PG18, if a node type is used even if the corresponding parameter to enable it is set to "off", a "Disabled" info now appear is the plan.
postgres=# explain (settings) select * from t1 where c1+0<1000000;
QUERY PLAN
------------------------------------------------------------
Seq Scan on t1 (cost=0.00..21370.00 rows=333333 width=22)
Disabled: true
Filter: ((c1 + 0) < 1000000)
Settings: enable_seqscan = 'off'
(4 rows)
postgres=# explain (settings, format json) select * from t1 where c1+0<1000000;
QUERY PLAN
----------------------------------------
[
{
"Plan": {
"Node Type": "Seq Scan",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "t1",
"Alias": "t1",
"Startup Cost": 0.00,
"Total Cost": 21370.00,
"Plan Rows": 333333,
"Plan Width": 22,
"Disabled": true,
"Filter": "((c1 + 0) < 1000000)"
},
"Settings": {
"enable_seqscan": "off"
}
}
]
(1 row)
Describe the solution you'd like
This info could be made visible next to the node type.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels