                                                                                                                                                  QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 [                                                                                                                                                                                                                                                                                                            +
   {                                                                                                                                                                                                                                                                                                          +
     "Plan": {                                                                                                                                                                                                                                                                                                +
       "Node Type": "Bitmap Heap Scan",                                                                                                                                                                                                                                                                       +
       "Parallel Aware": false,                                                                                                                                                                                                                                                                               +
       "Async Capable": false,                                                                                                                                                                                                                                                                                +
       "Relation Name": "graph_edges",                                                                                                                                                                                                                                                                        +
       "Alias": "graph_edges",                                                                                                                                                                                                                                                                                +
       "Startup Cost": 8.96,                                                                                                                                                                                                                                                                                  +
       "Total Cost": 84.23,                                                                                                                                                                                                                                                                                   +
       "Plan Rows": 20,                                                                                                                                                                                                                                                                                       +
       "Plan Width": 109,                                                                                                                                                                                                                                                                                     +
       "Actual Startup Time": 0.124,                                                                                                                                                                                                                                                                          +
       "Actual Total Time": 0.124,                                                                                                                                                                                                                                                                            +
       "Actual Rows": 1,                                                                                                                                                                                                                                                                                      +
       "Actual Loops": 1,                                                                                                                                                                                                                                                                                     +
       "Recheck Cond": "(((tenant_id = 'default'::text) AND (scan_id = 'graph-benchmark-estate-current'::text) AND (source_id = 'pkg:go:langchain@1.0.0'::text)) OR ((tenant_id = 'default'::text) AND (scan_id = 'graph-benchmark-estate-current'::text) AND (target_id = 'pkg:go:langchain@1.0.0'::text)))",+
       "Rows Removed by Index Recheck": 0,                                                                                                                                                                                                                                                                    +
       "Exact Heap Blocks": 2,                                                                                                                                                                                                                                                                                +
       "Lossy Heap Blocks": 0,                                                                                                                                                                                                                                                                                +
       "Shared Hit Blocks": 7,                                                                                                                                                                                                                                                                                +
       "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": "BitmapOr",                                                                                                                                                                                                                                                                           +
           "Parent Relationship": "Outer",                                                                                                                                                                                                                                                                    +
           "Parallel Aware": false,                                                                                                                                                                                                                                                                           +
           "Async Capable": false,                                                                                                                                                                                                                                                                            +
           "Startup Cost": 8.96,                                                                                                                                                                                                                                                                              +
           "Total Cost": 8.96,                                                                                                                                                                                                                                                                                +
           "Plan Rows": 20,                                                                                                                                                                                                                                                                                   +
           "Plan Width": 0,                                                                                                                                                                                                                                                                                   +
           "Actual Startup Time": 0.088,                                                                                                                                                                                                                                                                      +
           "Actual Total Time": 0.088,                                                                                                                                                                                                                                                                        +
           "Actual Rows": 0,                                                                                                                                                                                                                                                                                  +
           "Actual Loops": 1,                                                                                                                                                                                                                                                                                 +
           "Shared Hit Blocks": 5,                                                                                                                                                                                                                                                                            +
           "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": "Bitmap Index Scan",                                                                                                                                                                                                                                                              +
               "Parent Relationship": "Member",                                                                                                                                                                                                                                                               +
               "Parallel Aware": false,                                                                                                                                                                                                                                                                       +
               "Async Capable": false,                                                                                                                                                                                                                                                                        +
               "Index Name": "idx_pg_graph_edges_scan_source",                                                                                                                                                                                                                                                +
               "Startup Cost": 0.00,                                                                                                                                                                                                                                                                          +
               "Total Cost": 4.53,                                                                                                                                                                                                                                                                            +
               "Plan Rows": 19,                                                                                                                                                                                                                                                                               +
               "Plan Width": 0,                                                                                                                                                                                                                                                                               +
               "Actual Startup Time": 0.034,                                                                                                                                                                                                                                                                  +
               "Actual Total Time": 0.034,                                                                                                                                                                                                                                                                    +
               "Actual Rows": 0,                                                                                                                                                                                                                                                                              +
               "Actual Loops": 1,                                                                                                                                                                                                                                                                             +
               "Index Cond": "((tenant_id = 'default'::text) AND (scan_id = 'graph-benchmark-estate-current'::text) AND (source_id = 'pkg:go:langchain@1.0.0'::text))",                                                                                                                                       +
               "Shared Hit Blocks": 2,                                                                                                                                                                                                                                                                        +
               "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": "Bitmap Index Scan",                                                                                                                                                                                                                                                              +
               "Parent Relationship": "Member",                                                                                                                                                                                                                                                               +
               "Parallel Aware": false,                                                                                                                                                                                                                                                                       +
               "Async Capable": false,                                                                                                                                                                                                                                                                        +
               "Index Name": "idx_pg_graph_edges_scan_target",                                                                                                                                                                                                                                                +
               "Startup Cost": 0.00,                                                                                                                                                                                                                                                                          +
               "Total Cost": 4.43,                                                                                                                                                                                                                                                                            +
               "Plan Rows": 1,                                                                                                                                                                                                                                                                                +
               "Plan Width": 0,                                                                                                                                                                                                                                                                               +
               "Actual Startup Time": 0.053,                                                                                                                                                                                                                                                                  +
               "Actual Total Time": 0.053,                                                                                                                                                                                                                                                                    +
               "Actual Rows": 2,                                                                                                                                                                                                                                                                              +
               "Actual Loops": 1,                                                                                                                                                                                                                                                                             +
               "Index Cond": "((tenant_id = 'default'::text) AND (scan_id = 'graph-benchmark-estate-current'::text) AND (target_id = 'pkg:go:langchain@1.0.0'::text))",                                                                                                                                       +
               "Shared Hit Blocks": 3,                                                                                                                                                                                                                                                                        +
               "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": 198,                                                                                                                                                                                                                                                                              +
       "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.419,                                                                                                                                                                                                                                                                                  +
     "Triggers": [                                                                                                                                                                                                                                                                                            +
     ],                                                                                                                                                                                                                                                                                                       +
     "Execution Time": 0.160                                                                                                                                                                                                                                                                                  +
   }                                                                                                                                                                                                                                                                                                          +
 ]
(1 row)
