Skip to content

Take "Disabled" info into account #826

@pgiraud

Description

@pgiraud

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions