profile2.text

200 rows
627 ms

Compiler CYPHER 2.3

Planner COST

Runtime INTERPRETED

+------------------------+----------------+--------+---------+-------------------------------------+------------------------------+
| Operator               | Estimated Rows | Rows   | DB Hits | Identifiers                         | Other                        |
+------------------------+----------------+--------+---------+-------------------------------------+------------------------------+
| +ProduceResults        |            200 |    200 |       0 | reco, score                         | reco, score                  |
| |                      +----------------+--------+---------+-------------------------------------+------------------------------+
| +Projection            |            200 |    200 |       0 | anon[2156], anon[2162], reco, score | anon[2156]; anon[2162]       |
| |                      +----------------+--------+---------+-------------------------------------+------------------------------+
| +Top                   |            200 |    200 |       0 | anon[2156], anon[2162]              | Literal(200);                |
| |                      +----------------+--------+---------+-------------------------------------+------------------------------+
| +EagerAggregation      |            722 |  10324 |  105266 | anon[2156], anon[2162]              | anon[2156]                   |
| |                      +----------------+--------+---------+-------------------------------------+------------------------------+
| +Projection            |         521366 | 105266 |       0 | anon[2156], reco, r, u              | reco; r                      |
| |                      +----------------+--------+---------+-------------------------------------+------------------------------+
| +Expand(All)           |         521366 | 105266 |  105931 | reco, r, u                          | (u)-[r:RATED]->(  reco@2143) |
| |                      +----------------+--------+---------+-------------------------------------+------------------------------+
| +Distinct              |           3306 |    665 |       0 | u                                   | u                            |
| |                      +----------------+--------+---------+-------------------------------------+------------------------------+
| +CartesianProduct      |           3480 |  27025 |       0 | anon[2086], input, m, u             |                              |
| |\                     +----------------+--------+---------+-------------------------------------+------------------------------+
| | +Filter              |           3480 |  27025 |   27025 | anon[2086], m, u                    | u:User                       |
| | |                    +----------------+--------+---------+-------------------------------------+------------------------------+
| | +Expand(All)         |           3480 |  27025 |   27372 | anon[2086], m, u                    | (m)<-[:RATED]-(u)            |
| | |                    +----------------+--------+---------+-------------------------------------+------------------------------+
| | +NodeUniqueIndexSeek |            341 |    347 |     694 | m                                   | :Movie(id)                   |
| |                      +----------------+--------+---------+-------------------------------------+------------------------------+
| +NodeUniqueIndexSeek   |              1 |      1 |       2 | input                               | :User(id)                    |
+------------------------+----------------+--------+---------+-------------------------------------+------------------------------+

Total database accesses: 266290