                                                                         QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
 [                                                                                                                                                         +
   {                                                                                                                                                       +
     "Plan": {                                                                                                                                             +
       "Node Type": "Limit",                                                                                                                               +
       "Parallel Aware": false,                                                                                                                            +
       "Async Capable": false,                                                                                                                             +
       "Startup Cost": 1670.42,                                                                                                                            +
       "Total Cost": 1672.42,                                                                                                                              +
       "Plan Rows": 200,                                                                                                                                   +
       "Plan Width": 36,                                                                                                                                   +
       "Actual Startup Time": 8.781,                                                                                                                       +
       "Actual Total Time": 8.903,                                                                                                                         +
       "Actual Rows": 500,                                                                                                                                 +
       "Actual Loops": 1,                                                                                                                                  +
       "Shared Hit Blocks": 4178,                                                                                                                          +
       "Shared Read Blocks": 0,                                                                                                                            +
       "Shared Dirtied Blocks": 0,                                                                                                                         +
       "Shared Written Blocks": 0,                                                                                                                         +
       "Local Hit Blocks": 0,                                                                                                                              +
       "Local Read Blocks": 0,                                                                                                                             +
       "Local Dirtied Blocks": 0,                                                                                                                          +
       "Local Written Blocks": 0,                                                                                                                          +
       "Temp Read Blocks": 0,                                                                                                                              +
       "Temp Written Blocks": 0,                                                                                                                           +
       "Plans": [                                                                                                                                          +
         {                                                                                                                                                 +
           "Node Type": "Recursive Union",                                                                                                                 +
           "Parent Relationship": "InitPlan",                                                                                                              +
           "Subplan Name": "CTE walk",                                                                                                                     +
           "Parallel Aware": false,                                                                                                                        +
           "Async Capable": false,                                                                                                                         +
           "Startup Cost": 0.00,                                                                                                                           +
           "Total Cost": 1650.65,                                                                                                                          +
           "Plan Rows": 791,                                                                                                                               +
           "Plan Width": 46,                                                                                                                               +
           "Actual Startup Time": 0.001,                                                                                                                   +
           "Actual Total Time": 5.699,                                                                                                                     +
           "Actual Rows": 10173,                                                                                                                           +
           "Actual Loops": 1,                                                                                                                              +
           "Shared Hit Blocks": 4178,                                                                                                                      +
           "Shared Read Blocks": 0,                                                                                                                        +
           "Shared Dirtied Blocks": 0,                                                                                                                     +
           "Shared Written Blocks": 0,                                                                                                                     +
           "Local Hit Blocks": 0,                                                                                                                          +
           "Local Read Blocks": 0,                                                                                                                         +
           "Local Dirtied Blocks": 0,                                                                                                                      +
           "Local Written Blocks": 0,                                                                                                                      +
           "Temp Read Blocks": 0,                                                                                                                          +
           "Temp Written Blocks": 0,                                                                                                                       +
           "Plans": [                                                                                                                                      +
             {                                                                                                                                             +
               "Node Type": "Result",                                                                                                                      +
               "Parent Relationship": "Outer",                                                                                                             +
               "Parallel Aware": false,                                                                                                                    +
               "Async Capable": false,                                                                                                                     +
               "Startup Cost": 0.00,                                                                                                                       +
               "Total Cost": 0.01,                                                                                                                         +
               "Plan Rows": 1,                                                                                                                             +
               "Plan Width": 36,                                                                                                                           +
               "Actual Startup Time": 0.001,                                                                                                               +
               "Actual Total Time": 0.001,                                                                                                                 +
               "Actual Rows": 1,                                                                                                                           +
               "Actual Loops": 1,                                                                                                                          +
               "Shared Hit Blocks": 0,                                                                                                                     +
               "Shared Read Blocks": 0,                                                                                                                    +
               "Shared Dirtied Blocks": 0,                                                                                                                 +
               "Shared Written Blocks": 0,                                                                                                                 +
               "Local Hit Blocks": 0,                                                                                                                      +
               "Local Read Blocks": 0,                                                                                                                     +
               "Local Dirtied Blocks": 0,                                                                                                                  +
               "Local Written Blocks": 0,                                                                                                                  +
               "Temp Read Blocks": 0,                                                                                                                      +
               "Temp Written Blocks": 0                                                                                                                    +
             },                                                                                                                                            +
             {                                                                                                                                             +
               "Node Type": "Nested Loop",                                                                                                                 +
               "Parent Relationship": "Inner",                                                                                                             +
               "Parallel Aware": false,                                                                                                                    +
               "Async Capable": false,                                                                                                                     +
               "Join Type": "Inner",                                                                                                                       +
               "Startup Cost": 0.29,                                                                                                                       +
               "Total Cost": 164.27,                                                                                                                       +
               "Plan Rows": 79,                                                                                                                            +
               "Plan Width": 46,                                                                                                                           +
               "Actual Startup Time": 0.128,                                                                                                               +
               "Actual Total Time": 1.253,                                                                                                                 +
               "Actual Rows": 2543,                                                                                                                        +
               "Actual Loops": 4,                                                                                                                          +
               "Inner Unique": false,                                                                                                                      +
               "Shared Hit Blocks": 4178,                                                                                                                  +
               "Shared Read Blocks": 0,                                                                                                                    +
               "Shared Dirtied Blocks": 0,                                                                                                                 +
               "Shared Written Blocks": 0,                                                                                                                 +
               "Local Hit Blocks": 0,                                                                                                                      +
               "Local Read Blocks": 0,                                                                                                                     +
               "Local Dirtied Blocks": 0,                                                                                                                  +
               "Local Written Blocks": 0,                                                                                                                  +
               "Temp Read Blocks": 0,                                                                                                                      +
               "Temp Written Blocks": 0,                                                                                                                   +
               "Plans": [                                                                                                                                  +
                 {                                                                                                                                         +
                   "Node Type": "WorkTable Scan",                                                                                                          +
                   "Parent Relationship": "Outer",                                                                                                         +
                   "Parallel Aware": false,                                                                                                                +
                   "Async Capable": false,                                                                                                                 +
                   "CTE Name": "walk",                                                                                                                     +
                   "Alias": "walk_1",                                                                                                                      +
                   "Startup Cost": 0.00,                                                                                                                   +
                   "Total Cost": 0.22,                                                                                                                     +
                   "Plan Rows": 3,                                                                                                                         +
                   "Plan Width": 36,                                                                                                                       +
                   "Actual Startup Time": 0.071,                                                                                                           +
                   "Actual Total Time": 0.084,                                                                                                             +
                   "Actual Rows": 251,                                                                                                                     +
                   "Actual Loops": 4,                                                                                                                      +
                   "Filter": "(depth < 3)",                                                                                                                +
                   "Rows Removed by Filter": 2292,                                                                                                         +
                   "Shared Hit Blocks": 0,                                                                                                                 +
                   "Shared Read Blocks": 0,                                                                                                                +
                   "Shared Dirtied Blocks": 0,                                                                                                             +
                   "Shared Written Blocks": 0,                                                                                                             +
                   "Local Hit Blocks": 0,                                                                                                                  +
                   "Local Read Blocks": 0,                                                                                                                 +
                   "Local Dirtied Blocks": 0,                                                                                                              +
                   "Local Written Blocks": 0,                                                                                                              +
                   "Temp Read Blocks": 0,                                                                                                                  +
                   "Temp Written Blocks": 0                                                                                                                +
                 },                                                                                                                                        +
                 {                                                                                                                                         +
                   "Node Type": "Index Scan",                                                                                                              +
                   "Parent Relationship": "Inner",                                                                                                         +
                   "Parallel Aware": false,                                                                                                                +
                   "Async Capable": false,                                                                                                                 +
                   "Scan Direction": "Forward",                                                                                                            +
                   "Index Name": "idx_pg_graph_edges_scan_source",                                                                                         +
                   "Relation Name": "graph_edges",                                                                                                         +
                   "Alias": "e",                                                                                                                           +
                   "Startup Cost": 0.29,                                                                                                                   +
                   "Total Cost": 54.36,                                                                                                                    +
                   "Plan Rows": 26,                                                                                                                        +
                   "Plan Width": 77,                                                                                                                       +
                   "Actual Startup Time": 0.002,                                                                                                           +
                   "Actual Total Time": 0.004,                                                                                                             +
                   "Actual Rows": 10,                                                                                                                      +
                   "Actual Loops": 1005,                                                                                                                   +
                   "Index Cond": "((tenant_id = 'default'::text) AND (scan_id = 'graph-benchmark-estate-current'::text) AND (source_id = walk_1.node_id))",+
                   "Rows Removed by Index Recheck": 0,                                                                                                     +
                   "Filter": "(traversable = 1)",                                                                                                          +
                   "Rows Removed by Filter": 0,                                                                                                            +
                   "Shared Hit Blocks": 4178,                                                                                                              +
                   "Shared Read Blocks": 0,                                                                                                                +
                   "Shared Dirtied Blocks": 0,                                                                                                             +
                   "Shared Written Blocks": 0,                                                                                                             +
                   "Local Hit Blocks": 0,                                                                                                                  +
                   "Local Read Blocks": 0,                                                                                                                 +
                   "Local Dirtied Blocks": 0,                                                                                                              +
                   "Local Written Blocks": 0,                                                                                                              +
                   "Temp Read Blocks": 0,                                                                                                                  +
                   "Temp Written Blocks": 0                                                                                                                +
                 }                                                                                                                                         +
               ]                                                                                                                                           +
             }                                                                                                                                             +
           ]                                                                                                                                               +
         },                                                                                                                                                +
         {                                                                                                                                                 +
           "Node Type": "Aggregate",                                                                                                                       +
           "Strategy": "Hashed",                                                                                                                           +
           "Partial Mode": "Simple",                                                                                                                       +
           "Parent Relationship": "Outer",                                                                                                                 +
           "Parallel Aware": false,                                                                                                                        +
           "Async Capable": false,                                                                                                                         +
           "Startup Cost": 19.78,                                                                                                                          +
           "Total Cost": 21.78,                                                                                                                            +
           "Plan Rows": 200,                                                                                                                               +
           "Plan Width": 36,                                                                                                                               +
           "Actual Startup Time": 8.780,                                                                                                                   +
           "Actual Total Time": 8.873,                                                                                                                     +
           "Actual Rows": 500,                                                                                                                             +
           "Actual Loops": 1,                                                                                                                              +
           "Group Key": ["walk.node_id", "walk.depth"],                                                                                                    +
           "Planned Partitions": 0,                                                                                                                        +
           "HashAgg Batches": 1,                                                                                                                           +
           "Peak Memory Usage": 337,                                                                                                                       +
           "Disk Usage": 0,                                                                                                                                +
           "Shared Hit Blocks": 4178,                                                                                                                      +
           "Shared Read Blocks": 0,                                                                                                                        +
           "Shared Dirtied Blocks": 0,                                                                                                                     +
           "Shared Written Blocks": 0,                                                                                                                     +
           "Local Hit Blocks": 0,                                                                                                                          +
           "Local Read Blocks": 0,                                                                                                                         +
           "Local Dirtied Blocks": 0,                                                                                                                      +
           "Local Written Blocks": 0,                                                                                                                      +
           "Temp Read Blocks": 0,                                                                                                                          +
           "Temp Written Blocks": 0,                                                                                                                       +
           "Plans": [                                                                                                                                      +
             {                                                                                                                                             +
               "Node Type": "CTE Scan",                                                                                                                    +
               "Parent Relationship": "Outer",                                                                                                             +
               "Parallel Aware": false,                                                                                                                    +
               "Async Capable": false,                                                                                                                     +
               "CTE Name": "walk",                                                                                                                         +
               "Alias": "walk",                                                                                                                            +
               "Startup Cost": 0.00,                                                                                                                       +
               "Total Cost": 15.82,                                                                                                                        +
               "Plan Rows": 791,                                                                                                                           +
               "Plan Width": 36,                                                                                                                           +
               "Actual Startup Time": 0.002,                                                                                                               +
               "Actual Total Time": 7.282,                                                                                                                 +
               "Actual Rows": 10173,                                                                                                                       +
               "Actual Loops": 1,                                                                                                                          +
               "Shared Hit Blocks": 4178,                                                                                                                  +
               "Shared Read Blocks": 0,                                                                                                                    +
               "Shared Dirtied Blocks": 0,                                                                                                                 +
               "Shared Written Blocks": 0,                                                                                                                 +
               "Local Hit Blocks": 0,                                                                                                                      +
               "Local Read Blocks": 0,                                                                                                                     +
               "Local Dirtied Blocks": 0,                                                                                                                  +
               "Local Written Blocks": 0,                                                                                                                  +
               "Temp Read Blocks": 0,                                                                                                                      +
               "Temp Written Blocks": 0                                                                                                                    +
             }                                                                                                                                             +
           ]                                                                                                                                               +
         }                                                                                                                                                 +
       ]                                                                                                                                                   +
     },                                                                                                                                                    +
     "Planning": {                                                                                                                                         +
       "Shared Hit Blocks": 205,                                                                                                                           +
       "Shared Read Blocks": 0,                                                                                                                            +
       "Shared Dirtied Blocks": 0,                                                                                                                         +
       "Shared Written Blocks": 0,                                                                                                                         +
       "Local Hit Blocks": 0,                                                                                                                              +
       "Local Read Blocks": 0,                                                                                                                             +
       "Local Dirtied Blocks": 0,                                                                                                                          +
       "Local Written Blocks": 0,                                                                                                                          +
       "Temp Read Blocks": 0,                                                                                                                              +
       "Temp Written Blocks": 0                                                                                                                            +
     },                                                                                                                                                    +
     "Planning Time": 0.461,                                                                                                                               +
     "Triggers": [                                                                                                                                         +
     ],                                                                                                                                                    +
     "Execution Time": 9.337                                                                                                                               +
   }                                                                                                                                                       +
 ]
(1 row)
