gistfile1.txt

Projection(0)
  |
  +Top
    |
    +Projection(1)
      |
      +EagerAggregation(0)
        |
        +Apply(0)
          |
          +EagerAggregation(1)
          |  |
          |  +Filter(0)
          |    |
          |    +Expand(0)
          |      |
          |      +Filter(1)
          |        |
          |        +Var length expand
          |          |
          |          +NodeIndexSeek
          |
          +Apply(1)
             |
             +Argument
             |
             +Optional
                |
                +Filter(2)
                  |
                  +Expand(1)
                    |
                    +Filter(3)
                      |
                      +Expand(2)
                        |
                        +NodeByLabelScan

+---------------------+---------------+------+--------+-----------------------------+---------------------------------------------------------------------------------+
|            Operator | EstimatedRows | Rows | DbHits |                 Identifiers |                                                                           Other |
+---------------------+---------------+------+--------+-----------------------------+---------------------------------------------------------------------------------+
|       Projection(0) |             1 |    ? |      ? |                             |                                                            forumName, postCount |
|                 Top |             1 |    ? |      ? |                             |                                           {  AUTOINT2}; postCount,   FRESHID389 |
|       Projection(1) |             1 |    ? |      ? |                             |                                                  forum, postCount,   FRESHID389 |
| EagerAggregation(0) |             1 |    ? |      ? |                             |                                                                           forum |
|            Apply(0) |        930165 |    ? |      ? |                             |                                                                                 |
| EagerAggregation(1) |             1 |    ? |      ? |                             |                                                                   friend, forum |
|           Filter(0) |         14453 |    ? |      ? |                             | (hasLabel(forum:Forum(6)) AND Property(membership,joinDate(18)) > {  AUTOINT1}) |
|           Expand(0) |         19270 |    ? |      ? |           membership, forum |                                                                                 |
|           Filter(1) |         20552 |    ? |      ? |                             |                          (NOT(person == friend) AND hasLabel(friend:Person(1))) |
|   Var length expand |         27403 |    ? |      ? | person, friend,   UNNAMED41 |                                                                                 |
|       NodeIndexSeek |           540 |    ? |      ? |                      person |                                                                     :Person(id) |
|            Apply(1) |        930165 |    ? |      ? |                             |                                                                                 |
|            Argument |             ? |    ? |      ? |                             |                                                                                 |
|            Optional |        930165 |    ? |      ? |                             |                                                                                 |
|           Filter(2) |        930165 |    ? |      ? |                             |                                                             friend == friend$$$ |
|           Expand(1) |        930165 |    ? |      ? |       UNNAMED225, friend$$$ |                                                                                 |
|           Filter(3) |       3140119 |    ? |      ? |                             |                                                               forum == forum$$$ |
|           Expand(2) |       3140119 |    ? |      ? |        UNNAMED253, forum$$$ |                                                                                 |
|     NodeByLabelScan |       3140119 |    ? |      ? |                        post |                                                                              :5 |
+---------------------+---------------+------+--------+-----------------------------+---------------------------------------------------------------------------------+