dalibo / pev2

Postgres Explain Visualizer 2
https://explain.dalibo.com
PostgreSQL License
2.55k stars 124 forks source link

Node detail is missing info when parsed from text (on "ANY_subquery") #571

Closed pgiraud closed 1 year ago

pgiraud commented 1 year ago

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              
            }                                
          ]                                  
        }                                    
      ]                                      
    }                                        
  }                                          
]