profile1.cypher

200 rows
494 ms

Compiler CYPHER 2.3

Planner COST

Runtime INTERPRETED

+----------------------+----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| Operator             | Estimated Rows | Rows  | DB Hits | Identifiers                          | Other                                                                                                    |
+----------------------+----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +ProduceResults      |             35 |   200 |       0 | reco, score                          | reco, score                                                                                              |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +Projection          |             35 |   200 |       0 | anon[180], anon[186], reco, score    | anon[180]; anon[186]                                                                                     |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +Top                 |             35 |   200 |       0 | anon[180], anon[186]                 | Literal(200);                                                                                            |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +EagerAggregation    |             35 | 10245 |   95306 | anon[180], anon[186]                 | anon[180]                                                                                                |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +Projection          |           1233 | 95306 |       0 | anon[180], reco, other, r            | reco; r                                                                                                  |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +Expand(All)         |           1233 | 95306 |   95757 | reco, other, r                       | (other)-[r:RATED]->(  reco@167)                                                                          |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +Distinct            |            129 |   451 |       0 | other                                | other                                                                                                    |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +Expand(All)         |            136 |  3146 |    3254 | anon[103], anon[19], input, m, other | (m)<-[:RATED]-(other)                                                                                    |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +Filter              |             14 |   108 |     990 | anon[19], input, m                   | Ands(GetDegree(m,Some(RATED),INCOMING) < {  AUTOINT1}, {  AUTOINT2} < GetDegree(m,Some(RATED),INCOMING)) |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +Expand(All)         |            158 |   347 |     348 | anon[19], input, m                   | (input)-[:RATED]->(m)                                                                                    |
| |                    +----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| +NodeUniqueIndexSeek |              1 |     1 |       2 | input                                | :User(id)                                                                                                |
+----------------------+----------------+-------+---------+--------------------------------------+----------------------------------------------------------------------------------------------------------+

Total database accesses: 195657