Execution plan operators in detail
Certain operators are only used by a subset of the runtimes that Cypher® can choose from. If that is the case, the example queries will be prefixed with an option to choose one of these runtimes.
All Nodes Scan
The AllNodesScan operator reads all nodes from the node store. The variable that will contain the nodes is seen in the arguments.
Any query using this operator is likely to encounter performance problems on a non-trivial database.
Query
MATCH (n) RETURN nQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+---------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+---------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | n | 35 | 35 | 0 | | | | Fused in Pipeline 0 |
| | +---------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | n | 35 | 35 | 36 | 72 | 3/0 | 0.830 | Fused in Pipeline 0 |
+-----------------+---------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 36, total allocated memory: 136Directed Relationship Index Scan
The DirectedRelationshipIndexScan operator examines all values stored in an index, returning all relationships and their start and end nodes with a particular relationship type and a specified property.
Query
MATCH ()-[r: WORKS_IN]->() WHERE r.title IS NOT NULL RETURN rQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+--------------------------------+----------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+--------------------------------+----------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r | 15 | 15 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +DirectedRelationshipIndexScan | (anon_0)-[r:WORKS_IN(title)]->(anon_1) WHERE title IS NOT NULL | 15 | 15 | 31 | 72 | 3/1 | 2.512 | Fused in Pipeline 0 |
+--------------------------------+----------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 31, total allocated memory: 136Undirected Relationship Index Scan
The UndirectedRelationshipIndexScan operator examines all values stored in an index, returning all relationships and their start and end nodes with a particular relationship type and a specified property.
Query
MATCH ()-[r: WORKS_IN]-() WHERE r.title IS NOT NULL RETURN rQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+----------------------------------+---------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+----------------------------------+---------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r | 30 | 30 | 0 | | | | Fused in Pipeline 0 |
| | +---------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +UndirectedRelationshipIndexScan | (anon_0)-[r:WORKS_IN(title)]-(anon_1) WHERE title IS NOT NULL | 30 | 30 | 31 | 72 | 3/1 | 1.938 | Fused in Pipeline 0 |
+----------------------------------+---------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 31, total allocated memory: 136Directed Relationship Index Seek
The DirectedRelationshipIndexSeek operator finds relationships and their start and end nodes using an index seek.
The relationship variable and the index used are shown in the arguments of the operator.
Query
MATCH (candidate)-[r:WORKS_IN]->() WHERE r.title = 'chief architect' RETURN candidateQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+--------------------------------+-----------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+--------------------------------+-----------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | candidate | 2 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +DirectedRelationshipIndexSeek | (candidate)-[r:WORKS_IN(title)]->(anon_0) WHERE title = $autostring_0 | 2 | 1 | 3 | 72 | 3/1 | 1.031 | Fused in Pipeline 0 |
+--------------------------------+-----------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 3, total allocated memory: 136Undirected Relationship Index Seek
The UndirectedRelationshipIndexSeek operator finds relationships and their start and end nodes using an index seek.
The relationship variable and the index used are shown in the arguments of the operator.
Query
MATCH (candidate)-[r:WORKS_IN]-() WHERE r.title = 'chief architect' RETURN candidateQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+----------------------------------+----------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+----------------------------------+----------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | candidate | 4 | 2 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +UndirectedRelationshipIndexSeek | (candidate)-[r:WORKS_IN(title)]-(anon_0) WHERE title = $autostring_0 | 4 | 2 | 3 | 72 | 3/1 | 0.671 | Fused in Pipeline 0 |
+----------------------------------+----------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 3, total allocated memory: 136Directed Relationship By Id Seek
The DirectedRelationshipByIdSeek operator reads one or more relationships by id from the relationship store, and produces both the relationship and the nodes on either side.
Query
MATCH (n1)-[r]->()
WHERE id(r) = 0
RETURN r, n1Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-------------------------------+---------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-------------------------------+---------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r, n1 | 1 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +---------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +DirectedRelationshipByIdSeek | (n1)-[r]->(anon_0) WHERE id(r) = $autoint_0 | 1 | 1 | 1 | 72 | 4/0 | 0.416 | Fused in Pipeline 0 |
+-------------------------------+---------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 1, total allocated memory: 136Undirected Relationship By Id Seek
The UndirectedRelationshipByIdSeek operator reads one or more relationships by id from the relationship store.
As the direction is unspecified, two rows are produced for each relationship as a result of alternating the combination of the start and end node.
Query
MATCH (n1)-[r]-()
WHERE id(r) = 1
RETURN r, n1Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+---------------------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+---------------------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r, n1 | 1 | 2 | 0 | | | | Fused in Pipeline 0 |
| | +--------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +UndirectedRelationshipByIdSeek | (n1)-[r]-(anon_0) WHERE id(r) = $autoint_0 | 1 | 2 | 1 | 72 | 4/0 | 1.461 | Fused in Pipeline 0 |
+---------------------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 1, total allocated memory: 136Directed Relationship Index Contains Scan
The DirectedRelationshipIndexContainsScan operator examines all values stored in an index, searching for entries
containing a specific string; for example, in queries including CONTAINS.
Although this is slower than an index seek (since all entries need to be
examined), it is still faster than the indirection resulting from a type scan using DirectedRelationshipTypeScan, and a property store
filter.
Query
MATCH ()-[r: WORKS_IN]->() WHERE r.title CONTAINS 'senior' RETURN rQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+----------------------------------------+---------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+----------------------------------------+---------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r | 0 | 4 | 0 | | | | Fused in Pipeline 0 |
| | +---------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +DirectedRelationshipIndexContainsScan | (anon_0)-[r:WORKS_IN(title)]->(anon_1) WHERE title CONTAINS $autostring_0 | 0 | 4 | 9 | 72 | 3/1 | 0.919 | Fused in Pipeline 0 |
+----------------------------------------+---------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 9, total allocated memory: 136Undirected Relationship Index Contains Scan
The UndirectedRelationshipIndexContainsScan operator examines all values stored in an index, searching for entries
containing a specific string; for example, in queries including CONTAINS.
Although this is slower than an index seek (since all entries need to be
examined), it is still faster than the indirection resulting from a type scan using DirectedRelationshipTypeScan, and a property store
filter.
Query
MATCH ()-[r: WORKS_IN]-() WHERE r.title CONTAINS 'senior' RETURN rQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------------------------------+--------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------------------------------+--------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r | 0 | 8 | 0 | | | | Fused in Pipeline 0 |
| | +--------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +UndirectedRelationshipIndexContainsScan | (anon_0)-[r:WORKS_IN(title)]-(anon_1) WHERE title CONTAINS $autostring_0 | 0 | 8 | 9 | 72 | 3/1 | 1.384 | Fused in Pipeline 0 |
+------------------------------------------+--------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 9, total allocated memory: 136Directed Relationship Index Ends With Scan
The DirectedRelationshipIndexEndsWithScan operator examines all values stored in an index, searching for entries
ending in a specific string; for example, in queries containing ENDS WITH.
Although this is slower than an index seek (since all entries need to be
examined), it is still faster than the indirection resulting from a label scan using NodeByLabelScan, and a property store
filter.
Query
MATCH ()-[r: WORKS_IN]->() WHERE r.title ENDS WITH 'developer' RETURN rQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+----------------------------------------+----------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+----------------------------------------+----------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r | 0 | 8 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +DirectedRelationshipIndexEndsWithScan | (anon_0)-[r:WORKS_IN(title)]->(anon_1) WHERE title ENDS WITH $autostring_0 | 0 | 8 | 17 | 72 | 3/1 | 1.065 | Fused in Pipeline 0 |
+----------------------------------------+----------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 17, total allocated memory: 136Undirected Relationship Index Ends With Scan
The UndirectedRelationshipIndexEndsWithScan operator examines all values stored in an index, searching for entries
ending in a specific string; for example, in queries containing ENDS WITH.
Although this is slower than an index seek (since all entries need to be
examined), it is still faster than the indirection resulting from a label scan using NodeByLabelScan, and a property store
filter.
Query
MATCH ()-[r: WORKS_IN]-() WHERE r.title ENDS WITH 'developer' RETURN rQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------------------------------+---------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------------------------------+---------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r | 0 | 16 | 0 | | | | Fused in Pipeline 0 |
| | +---------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +UndirectedRelationshipIndexEndsWithScan | (anon_0)-[r:WORKS_IN(title)]-(anon_1) WHERE title ENDS WITH $autostring_0 | 0 | 16 | 17 | 72 | 3/1 | 1.363 | Fused in Pipeline 0 |
+------------------------------------------+---------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 17, total allocated memory: 136Directed Relationship Index Seek By Range
The DirectedRelationshipIndexSeekByRange operator finds relationships and their start and end nodes using an index seek where the value of the property matches a given prefix string.
DirectedRelationshipIndexSeekByRange can be used for STARTS WITH and comparison operators such as <, >, <= and >=.
Query
MATCH (candidate: Person)-[r:WORKS_IN]->(location) WHERE r.duration > 100 RETURN candidateQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+---------------------------------------+----------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+---------------------------------------+----------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | candidate | 4 | 15 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | candidate:Person | 4 | 15 | 15 | | | | Fused in Pipeline 0 |
| | +----------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +DirectedRelationshipIndexSeekByRange | (candidate)-[r:WORKS_IN(duration)]->(location) WHERE duration > $autoint_0 | 4 | 15 | 31 | 72 | 4/1 | 1.661 | Fused in Pipeline 0 |
+---------------------------------------+----------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 46, total allocated memory: 136Undirected Relationship Index Seek By Range
The UndirectedRelationshipIndexSeekByRange operator finds relationships and their start and end nodes using an index seek where the value of the property matches a given prefix string.
UndirectedRelationshipIndexSeekByRange can be used for STARTS WITH and comparison operators such as <, >, <= and >=.
Query
MATCH (candidate: Person)-[r:WORKS_IN]-(location) WHERE r.duration > 100 RETURN candidateQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------------------------+---------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------------------------------+---------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | candidate | 4 | 15 | 0 | | | | Fused in Pipeline 0 |
| | +---------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | candidate:Person | 4 | 15 | 30 | | | | Fused in Pipeline 0 |
| | +---------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +UndirectedRelationshipIndexSeekByRange | (candidate)-[r:WORKS_IN(duration)]-(location) WHERE duration > $autoint_0 | 8 | 30 | 31 | 72 | 4/1 | 13.237 | Fused in Pipeline 0 |
+-----------------------------------------+---------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 61, total allocated memory: 136Directed Relationship Type Scan
The DirectedRelationshipTypeScan operator fetches all relationships and their start and end nodes with a specific type from the relationship type index.
Query
MATCH ()-[r: FRIENDS_WITH]->() RETURN rQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-------------------------------+-------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-------------------------------+-------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r | 2 | 2 | 0 | | | | Fused in Pipeline 0 |
| | +-------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +DirectedRelationshipTypeScan | (anon_0)-[r:FRIENDS_WITH]->(anon_1) | 2 | 2 | 5 | 72 | 2/1 | 0.488 | Fused in Pipeline 0 |
+-------------------------------+-------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 5, total allocated memory: 136Undirected Relationship Type Scan
The UndirectedRelationshipTypeScan operator fetches all relationships and their start and end nodes with a specific type from the relationship type index.
Query
MATCH ()-[r: FRIENDS_WITH]-() RETURN rQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+---------------------------------+------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+---------------------------------+------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | r | 4 | 4 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +UndirectedRelationshipTypeScan | (anon_0)-[r:FRIENDS_WITH]-(anon_1) | 4 | 4 | 5 | 72 | 2/1 | 0.920 | Fused in Pipeline 0 |
+---------------------------------+------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 5, total allocated memory: 136Node By Id Seek
The NodeByIdSeek operator reads one or more nodes by id from the node store.
Query
MATCH (n) WHERE id(n) = 0 RETURN nQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | n | 1 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeByIdSeek | n WHERE id(n) = $autoint_0 | 1 | 1 | 1 | 72 | 3/0 | 0.272 | Fused in Pipeline 0 |
+-----------------+----------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 1, total allocated memory: 136Node By Label Scan
The NodeByLabelScan operator fetches all nodes with a specific label from the node label index.
Query
MATCH (person:Person) RETURN personQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------+---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------+---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +---------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeByLabelScan | person:Person | 14 | 14 | 15 | 72 | 2/1 | 7.126 | Fused in Pipeline 0 |
+------------------+---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 15, total allocated memory: 136Node Index Seek
The NodeIndexSeek operator finds nodes using an index seek.
The node variable and the index used are shown in the arguments of the operator.
If the index is a unique index, the operator is instead called NodeUniqueIndexSeek.
Query
MATCH (location:Location {name: 'Malmo'}) RETURN locationQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | location | 0 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexSeek | location:Location(name) WHERE name = $autostring_0 | 0 | 1 | 2 | 72 | 2/1 | 0.840 | Fused in Pipeline 0 |
+-----------------+----------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 2, total allocated memory: 136Node Unique Index Seek
The NodeUniqueIndexSeek operator finds nodes using an index seek within a unique index. The node variable and the index used are shown in the arguments of the operator.
If the index is not unique, the operator is instead called NodeIndexSeek.
If the index seek is used to solve a MERGE clause, it will also be marked with (Locking).
This makes it clear that any nodes returned from the index will be locked in order to prevent concurrent conflicting updates.
Query
MATCH (t:Team {name: 'Malmo'}) RETURN tQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+----------------------+------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+----------------------+------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | t | 0 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeUniqueIndexSeek | UNIQUE t:Team(name) WHERE name = $autostring_0 | 0 | 0 | 1 | 72 | 0/1 | 0.694 | Fused in Pipeline 0 |
+----------------------+------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 1, total allocated memory: 136Multi Node Index Seek
The MultiNodeIndexSeek operator finds nodes using multiple index seeks.
It supports using multiple distinct indexes for different nodes in the query.
The node variables and the indexes used are shown in the arguments of the operator.
The operator yields a cartesian product of all index seeks.
For example, if the operator does two seeks and the first seek finds the nodes a1, a2 and the second b1, b2, b3,
the MultiNodeIndexSeek will yield the rows (a1, b1), (a1, b2), (a1, b3), (a2, b1), (a2, b2), (a2, b3).
Query
CYPHER runtime=pipelined
MATCH (location:Location {name: 'Malmo'}), (person:Person {name: 'Bob'}) RETURN location, personQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+---------------------+----------------------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+---------------------+----------------------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +ProduceResults | location, person | 0 | 1 | 0 | | 2/0 | 0.176 | In Pipeline 0 |
| | +----------------------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +MultiNodeIndexSeek | location:Location(name) WHERE name = $autostring_0, person:Person(name) WHERE name = $autostring_1 | 0 | 1 | 4 | 72 | 0/2 | 0.512 | In Pipeline 0 |
+---------------------+----------------------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
Total database accesses: 4, total allocated memory: 136Asserting Multi Node Index Seek
The AssertingMultiNodeIndexSeek operator is used to ensure that no unique constraints are violated.
The example looks for the presence of a team with the supplied name and id, and if one does not exist,
it will be created. Owing to the existence of two unique constraints
on :Team(name) and :Team(id), any node that would be found by the UniqueIndexSeek
must be the very same node, or the constraints would be violated.
Query
MERGE (t:Team {name: 'Engineering', id: 42})Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------------------+-----------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------------------+-----------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 1 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 1 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Merge | CREATE (t:Team) | 1 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AssertingMultiNodeIndexSeek | UNIQUE t:Team(name) WHERE name = $autostring_0, UNIQUE t:Team(id) WHERE id = $autoint_1 | 0 | 2 | 4 | 72 | 0/2 | 3.404 | Fused in Pipeline 0 |
+------------------------------+-----------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 4, total allocated memory: 136Node Index Seek By Range
The NodeIndexSeekByRange operator finds nodes using an index seek where the value of the property matches a given prefix string.
NodeIndexSeekByRange can be used for STARTS WITH and comparison operators such as <, >, <= and >=.
If the index is a unique index, the operator is instead called NodeUniqueIndexSeekByRange.
Query
MATCH (l:Location) WHERE l.name STARTS WITH 'Lon' RETURN lQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------+-------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------------+-------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | l | 2 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexSeekByRange | l:Location(name) WHERE name STARTS WITH $autostring_0 | 2 | 1 | 2 | 72 | 3/0 | 0.726 | Fused in Pipeline 0 |
+-----------------------+-------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 2, total allocated memory: 136Node Unique Index Seek By Range
The NodeUniqueIndexSeekByRange operator finds nodes using an index seek within a unique index, where the value of the property matches a given prefix string.
NodeUniqueIndexSeekByRange is used by STARTS WITH and comparison operators such as <, >, <= and >=.
If the index is not unique, the operator is instead called NodeIndexSeekByRange.
Query
MATCH (t:Team) WHERE t.name STARTS WITH 'Ma' RETURN tQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------------+----------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------------------+----------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | t | 2 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeUniqueIndexSeekByRange | UNIQUE t:Team(name) WHERE name STARTS WITH $autostring_0 | 2 | 0 | 1 | 72 | 1/0 | 0.393 | Fused in Pipeline 0 |
+-----------------------------+----------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 1, total allocated memory: 136Node Index Contains Scan
The NodeIndexContainsScan operator examines all values stored in an index, searching for entries
containing a specific string; for example, in queries including CONTAINS.
Although this is slower than an index seek (since all entries need to be
examined), it is still faster than the indirection resulting from a label scan using NodeByLabelScan, and a property store
filter.
Query
MATCH (l:Location) WHERE l.name CONTAINS 'al' RETURN lQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------------+----------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------------+----------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | l | 0 | 2 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexContainsScan | l:Location(name) WHERE name CONTAINS $autostring_0 | 0 | 2 | 3 | 72 | 2/1 | 0.546 | Fused in Pipeline 0 |
+------------------------+----------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 3, total allocated memory: 136Node Index Ends With Scan
The NodeIndexEndsWithScan operator examines all values stored in an index, searching for entries
ending in a specific string; for example, in queries containing ENDS WITH.
Although this is slower than an index seek (since all entries need to be
examined), it is still faster than the indirection resulting from a label scan using NodeByLabelScan, and a property store
filter.
Query
MATCH (l:Location) WHERE l.name ENDS WITH 'al' RETURN lQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------------+-----------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------------+-----------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | l | 0 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexEndsWithScan | l:Location(name) WHERE name ENDS WITH $autostring_0 | 0 | 0 | 1 | 72 | 0/1 | 6.646 | Fused in Pipeline 0 |
+------------------------+-----------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 1, total allocated memory: 136Node Index Scan
The NodeIndexScan operator examines all values stored in an index, returning all nodes with a particular label and a specified property.
Query
MATCH (l:Location) WHERE l.name IS NOT NULL RETURN lQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | l | 10 | 10 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexScan | l:Location(name) WHERE name IS NOT NULL | 10 | 10 | 11 | 72 | 2/1 | 0.981 | Fused in Pipeline 0 |
+-----------------+-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 11, total allocated memory: 136Apply
All the different Apply operators (listed below) share the same basic functionality: they perform a nested loop by taking a single row from the left-hand side, and using the Argument operator on the right-hand side, execute the operator tree on the right-hand side.
The versions of the Apply operators differ in how the results are managed.
The Apply operator (i.e. the standard version) takes the row produced by the right-hand side — which at this point contains data from both the left-hand and right-hand sides — and yields it..
Query
MATCH (p:Person {name:'me'})
MATCH (q:Person {name: p.secondName})
RETURN p, qQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p, q | 1 | 0 | 0 | | | | Fused in Pipeline 1 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Apply | | 1 | 0 | 0 | | | | |
| |\ +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +NodeIndexSeek | q:Person(name) WHERE name = p.secondName | 1 | 0 | 0 | 80 | 0/0 | 0.959 | Fused in Pipeline 1 |
| | +-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +NodeIndexSeek | p:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | 72 | 0/1 | 0.762 | In Pipeline 0 |
+------------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 2, total allocated memory: 144Semi Apply
The SemiApply operator tests for the presence of a pattern predicate, and is a variation of the Apply operator.
If the right-hand side operator yields at least one row, the row from the left-hand side operator is yielded by the SemiApply operator.
This makes SemiApply a filtering operator, used mostly for pattern predicates in queries.
Query
CYPHER runtime=slotted
MATCH (p:Person)
WHERE (p)-[:FRIENDS_WITH]->(:Person)
RETURN p.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-----------------+-------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+-----------------+-------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | `p.name` | 11 | 2 | 0 | 0/0 |
| | +-------------------------------------+----------------+------+---------+------------------------+
| +Projection | p.name AS `p.name` | 11 | 2 | 2 | 1/0 |
| | +-------------------------------------+----------------+------+---------+------------------------+
| +SemiApply | | 11 | 2 | 0 | 0/0 |
| |\ +-------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_3:Person | 2 | 0 | 2 | 0/0 |
| | | +-------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (p)-[anon_2:FRIENDS_WITH]->(anon_3) | 2 | 2 | 33 | 15/0 |
| | | +-------------------------------------+----------------+------+---------+------------------------+
| | +Argument | p | 14 | 14 | 0 | 0/0 |
| | +-------------------------------------+----------------+------+---------+------------------------+
| +Filter | p:Person | 14 | 14 | 35 | 1/0 |
| | +-------------------------------------+----------------+------+---------+------------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 1/0 |
+-----------------+-------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 108, total allocated memory: 64Anti Semi Apply
The AntiSemiApply operator tests for the absence of a pattern, and is a variation of the Apply operator.
If the right-hand side operator yields no rows, the row from the left-hand side operator is yielded by the AntiSemiApply operator.
This makes AntiSemiApply a filtering operator, used for pattern predicates in queries.
Query
CYPHER runtime=slotted
MATCH (me:Person {name: "me"}), (other:Person)
WHERE NOT (me)-[:FRIENDS_WITH]->(other)
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses |
+-------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+
| +ProduceResults | `other.name` | 4 | 13 | 0 | | 0/0 |
| | +--------------------------------------------+----------------+------+---------+----------------+------------------------+
| +Projection | other.name AS `other.name` | 4 | 13 | 13 | | 1/0 |
| | +--------------------------------------------+----------------+------+---------+----------------+------------------------+
| +AntiSemiApply | | 4 | 13 | 0 | | 0/0 |
| |\ +--------------------------------------------+----------------+------+---------+----------------+------------------------+
| | +Expand(Into) | (me)-[anon_2:FRIENDS_WITH]->(other) | 0 | 0 | 55 | 896 | 15/0 |
| | | +--------------------------------------------+----------------+------+---------+----------------+------------------------+
| | +Argument | me, other | 14 | 14 | 0 | | 0/0 |
| | +--------------------------------------------+----------------+------+---------+----------------+------------------------+
| +CartesianProduct | | 14 | 14 | 0 | | 0/0 |
| |\ +--------------------------------------------+----------------+------+---------+----------------+------------------------+
| | +Filter | other:Person | 14 | 14 | 35 | | 1/0 |
| | | +--------------------------------------------+----------------+------+---------+----------------+------------------------+
| | +AllNodesScan | other | 35 | 35 | 36 | | 1/0 |
| | +--------------------------------------------+----------------+------+---------+----------------+------------------------+
| +NodeIndexSeek | me:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | | 0/1 |
+-------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+
Total database accesses: 141, total allocated memory: 976Anti
The Anti operator tests for the absence of a pattern.
If there are incoming rows, the Anti operator will yield no rows.
If there are no incoming rows, the Anti operator will yield a single row.
Query
CYPHER runtime=pipelined
MATCH (me:Person {name: "me"}), (other:Person)
WHERE NOT (me)-[:FRIENDS_WITH]->(other)
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | `other.name` | 4 | 13 | 0 | | 0/0 | 0.174 | In Pipeline 4 |
| | +--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Projection | other.name AS `other.name` | 4 | 13 | 26 | | 2/0 | 0.057 | In Pipeline 4 |
| | +--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Apply | | 4 | 13 | 0 | | 0/0 | | |
| |\ +--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Anti | | 14 | 13 | 0 | 1256 | 0/0 | 0.253 | In Pipeline 4 |
| | | +--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Limit | 1 | 14 | 1 | 0 | 752 | | | Fused in Pipeline 3 |
| | | +--------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Expand(Into) | (me)-[anon_2:FRIENDS_WITH]->(other) | 0 | 1 | 55 | 2856 | | | Fused in Pipeline 3 |
| | | +--------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Argument | me, other | 14 | 14 | 0 | 408 | 1/0 | 1.744 | Fused in Pipeline 3 |
| | +--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +CartesianProduct | | 14 | 14 | 0 | 1800 | | 0.300 | In Pipeline 2 |
| |\ +--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Filter | other:Person | 14 | 14 | 0 | | | | Fused in Pipeline 1 |
| | | +--------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +AllNodesScan | other | 35 | 35 | 36 | 88 | 1/0 | 0.222 | Fused in Pipeline 1 |
| | +--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +NodeIndexSeek | me:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | 72 | 0/1 | 0.473 | In Pipeline 0 |
+-------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 119, total allocated memory: 6352Let Semi Apply
The LetSemiApply operator tests for the presence of a pattern predicate, and is a variation of the Apply operator.
When a query contains multiple pattern predicates separated with OR, LetSemiApply will be used to evaluate the first of these.
It will record the result of evaluating the predicate but will leave any filtering to another operator.
In the example, LetSemiApply will be used to check for the presence of the FRIENDS_WITH
relationship from each person.
Query
CYPHER runtime=slotted
MATCH (other:Person)
WHERE (other)-[:FRIENDS_WITH]->(:Person) OR (other)-[:WORKS_IN]->(:Location)
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+--------------------+-----------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+--------------------+-----------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | `other.name` | 13 | 14 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +Projection | other.name AS `other.name` | 13 | 14 | 14 | 1/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +SelectOrSemiApply | anon_9 | 14 | 14 | 0 | 0/0 |
| |\ +-----------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_7:Location | 14 | 0 | 12 | 0/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (other)-[anon_6:WORKS_IN]->(anon_7) | 14 | 12 | 26 | 12/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Argument | other | 14 | 12 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +LetSemiApply | | 14 | 14 | 0 | 0/0 |
| |\ +-----------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_5:Person | 2 | 0 | 2 | 0/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (other)-[anon_4:FRIENDS_WITH]->(anon_5) | 2 | 2 | 33 | 15/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Argument | other | 14 | 14 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +Filter | other:Person | 14 | 14 | 35 | 1/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +AllNodesScan | other | 35 | 35 | 36 | 1/0 |
+--------------------+-----------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 158, total allocated memory: 64Let Anti Semi Apply
The LetAntiSemiApply operator tests for the absence of a pattern, and is a variation of the Apply operator.
When a query contains multiple negated pattern predicates — i.e. predicates separated with OR, where at
least one predicate contains NOT — LetAntiSemiApply will be used to evaluate the first of these.
It will record the result of evaluating the predicate but will leave any filtering to another operator.
In the example, LetAntiSemiApply will be used to check for the absence of
the FRIENDS_WITH relationship from each person.
Query
CYPHER runtime=slotted
MATCH (other:Person)
WHERE NOT ((other)-[:FRIENDS_WITH]->(:Person)) OR (other)-[:WORKS_IN]->(:Location)
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+--------------------+-----------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+--------------------+-----------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | `other.name` | 11 | 14 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +Projection | other.name AS `other.name` | 11 | 14 | 14 | 1/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +SelectOrSemiApply | anon_9 | 14 | 14 | 0 | 0/0 |
| |\ +-----------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_7:Location | 14 | 0 | 2 | 0/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (other)-[anon_6:WORKS_IN]->(anon_7) | 14 | 2 | 7 | 2/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Argument | other | 14 | 2 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +LetAntiSemiApply | | 14 | 14 | 0 | 0/0 |
| |\ +-----------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_5:Person | 2 | 0 | 2 | 0/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (other)-[anon_4:FRIENDS_WITH]->(anon_5) | 2 | 2 | 33 | 15/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Argument | other | 14 | 14 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +Filter | other:Person | 14 | 14 | 35 | 1/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +AllNodesScan | other | 35 | 35 | 36 | 1/0 |
+--------------------+-----------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 129, total allocated memory: 64Select Or Semi Apply
The SelectOrSemiApply operator tests for the presence of a pattern predicate and evaluates a predicate,
and is a variation of the Apply operator.
This operator allows for the mixing of normal predicates and pattern predicates
that check for the presence of a pattern.
First, the normal expression predicate is evaluated, and, only if it returns false, is the costly pattern predicate evaluated.
Query
MATCH (other:Person)
WHERE other.age > 25 OR (other)-[:FRIENDS_WITH]->(:Person)
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+--------------------+-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+--------------------+-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | `other.name` | 11 | 2 | 0 | | | | Fused in Pipeline 2 |
| | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Projection | other.name AS `other.name` | 11 | 2 | 4 | | | | Fused in Pipeline 2 |
| | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +SelectOrSemiApply | other.age > $autoint_0 | 14 | 2 | 0 | 128 | 0/0 | 0.226 | Fused in Pipeline 2 |
| |\ +-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Limit | 1 | 14 | 2 | 0 | 752 | | | Fused in Pipeline 1 |
| | | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Filter | anon_3:Person | 2 | 2 | 2 | | | | Fused in Pipeline 1 |
| | | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Expand(All) | (other)-[anon_2:FRIENDS_WITH]->(anon_3) | 2 | 2 | 32 | | | | Fused in Pipeline 1 |
| | | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Argument | other | 14 | 14 | 0 | 296 | 2/0 | 0.779 | Fused in Pipeline 1 |
| | +-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Filter | other:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | other | 35 | 35 | 36 | 72 | 1/0 | 0.224 | Fused in Pipeline 0 |
+--------------------+-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 74, total allocated memory: 1080Select Or Anti Semi Apply
The SelectOrAntiSemiApply operator is used to evaluate OR between a predicate and a negative pattern predicate
(i.e. a pattern predicate preceded with NOT), and is a variation of the Apply operator.
If the predicate returns true, the pattern predicate is not tested.
If the predicate returns false or null, SelectOrAntiSemiApply will instead test the pattern predicate.
Query
MATCH (other:Person)
WHERE other.age > 25 OR NOT (other)-[:FRIENDS_WITH]->(:Person)
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------------+-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------------+-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | `other.name` | 4 | 12 | 0 | | | | Fused in Pipeline 3 |
| | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Projection | other.name AS `other.name` | 4 | 12 | 24 | | | | Fused in Pipeline 3 |
| | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +SelectOrAntiSemiApply | other.age > $autoint_0 | 14 | 12 | 0 | 448 | 0/0 | 0.335 | Fused in Pipeline 3 |
| |\ +-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Anti | | 14 | 12 | 0 | 1256 | 0/0 | 0.287 | In Pipeline 2 |
| | | +-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Limit | 1 | 14 | 2 | 0 | 752 | | | Fused in Pipeline 1 |
| | | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Filter | anon_3:Person | 2 | 2 | 2 | | | | Fused in Pipeline 1 |
| | | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Expand(All) | (other)-[anon_2:FRIENDS_WITH]->(anon_3) | 2 | 2 | 32 | | | | Fused in Pipeline 1 |
| | | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Argument | other | 14 | 14 | 0 | 296 | 2/0 | 2.706 | Fused in Pipeline 1 |
| | +-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Filter | other:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | other | 35 | 35 | 36 | 72 | 1/0 | 0.636 | Fused in Pipeline 0 |
+------------------------+-----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 94, total allocated memory: 2336Let Select Or Semi Apply
The LetSelectOrSemiApply operator is planned for pattern predicates that are combined with other predicates using OR.
This is a variation of the Apply operator.
Query
CYPHER runtime=slotted
MATCH (other:Person)
WHERE (other)-[:FRIENDS_WITH]->(:Person) OR (other)-[:WORKS_IN]->(:Location) OR other.age = 5
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-----------------------+-----------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+-----------------------+-----------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | `other.name` | 13 | 14 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +Projection | other.name AS `other.name` | 13 | 14 | 14 | 1/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +SelectOrSemiApply | anon_9 | 14 | 14 | 0 | 0/0 |
| |\ +-----------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_7:Location | 14 | 0 | 12 | 0/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (other)-[anon_6:WORKS_IN]->(anon_7) | 14 | 12 | 26 | 12/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Argument | other | 14 | 12 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +LetSelectOrSemiApply | other.age = $autoint_0 | 14 | 14 | 14 | 0/0 |
| |\ +-----------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_5:Person | 2 | 0 | 2 | 0/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (other)-[anon_4:FRIENDS_WITH]->(anon_5) | 2 | 2 | 33 | 15/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Argument | other | 14 | 14 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +Filter | other:Person | 14 | 14 | 35 | 1/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +AllNodesScan | other | 35 | 35 | 36 | 1/0 |
+-----------------------+-----------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 172, total allocated memory: 64Let Select Or Anti Semi Apply
The LetSelectOrAntiSemiApply operator is planned for negated pattern predicates — i.e. pattern predicates
preceded with NOT — that are combined with other predicates using OR.
This operator is a variation of the Apply operator.
Query
CYPHER runtime=slotted
MATCH (other:Person)
WHERE NOT (other)-[:FRIENDS_WITH]->(:Person) OR (other)-[:WORKS_IN]->(:Location) OR other.age = 5
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+---------------------------+-----------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+---------------------------+-----------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | `other.name` | 12 | 14 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +Projection | other.name AS `other.name` | 12 | 14 | 14 | 1/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +SelectOrSemiApply | anon_9 | 14 | 14 | 0 | 0/0 |
| |\ +-----------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_7:Location | 14 | 0 | 2 | 0/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (other)-[anon_6:WORKS_IN]->(anon_7) | 14 | 2 | 7 | 2/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Argument | other | 14 | 2 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +LetSelectOrAntiSemiApply | other.age = $autoint_0 | 14 | 14 | 14 | 0/0 |
| |\ +-----------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_5:Person | 2 | 0 | 2 | 0/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (other)-[anon_4:FRIENDS_WITH]->(anon_5) | 2 | 2 | 33 | 15/0 |
| | | +-----------------------------------------+----------------+------+---------+------------------------+
| | +Argument | other | 14 | 14 | 0 | 0/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +Filter | other:Person | 14 | 14 | 35 | 1/0 |
| | +-----------------------------------------+----------------+------+---------+------------------------+
| +AllNodesScan | other | 35 | 35 | 36 | 1/0 |
+---------------------------+-----------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 143, total allocated memory: 64Merge
The Merge operator will either read or create nodes and/or relationships.
If matches are found it will execute the provided ON MATCH operations foreach incoming row.
If no matches are found instead nodes and relationships are created and all ON CREATE operations are run.
Query
MERGE (p:Person {name: 'Andy'})
ON MATCH SET p.existed = true
ON CREATE SET p.existed = falseQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+-----------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+-----------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 1 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 1 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Merge | CREATE (p:Person), ON MATCH SET p.existed = true, ON CREATE SET p.existed = false | 1 | 1 | 1 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexSeek | p:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | 72 | 2/1 | 0.642 | Fused in Pipeline 0 |
+-----------------+-----------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 3, total allocated memory: 136Locking Merge
The LockingMerge operator is just like a normal Merge but will lock the start and end node when creating a relationship if necessary.
Query
MATCH (s:Person {name: 'me'}) MERGE (s)-[:FRIENDS_WITH]->(s)Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 1 | 0 | 0 | | | | Fused in Pipeline 1 |
| | +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 1 | 0 | 0 | | | | Fused in Pipeline 1 |
| | +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Apply | | 1 | 1 | 0 | | | | |
| |\ +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +LockingMerge | CREATE (s)-[anon_0:FRIENDS_WITH]->(s), LOCK(s) | 1 | 1 | 1 | | | | Fused in Pipeline 1 |
| | | +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Expand(Into) | (s)-[anon_0:FRIENDS_WITH]->(s) | 0 | 0 | 8 | 896 | | | Fused in Pipeline 1 |
| | | +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Argument | s | 1 | 3 | 0 | 80 | 4/0 | 0.663 | Fused in Pipeline 1 |
| | +------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +NodeIndexSeek | s:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | 72 | 0/1 | 0.322 | In Pipeline 0 |
+-----------------+------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 11, total allocated memory: 976Roll Up Apply
The RollUpApply operator is used to execute an expression which takes as input a pattern, and returns a list with content from the matched pattern;
for example, when using a pattern expression or pattern comprehension in a query.
This operator is a variation of the Apply operator.
Query
CYPHER runtime=slotted
MATCH (p:Person)
RETURN p.name, [ (p)-[:WORKS_IN]->(location) | location.name ] AS citiesQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-----------------+-----------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+-----------------+-----------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | `p.name`, cities | 14 | 14 | 0 | 0/0 |
| | +-----------------------------------+----------------+------+---------+------------------------+
| +Projection | p.name AS `p.name` | 14 | 14 | 14 | 0/0 |
| | +-----------------------------------+----------------+------+---------+------------------------+
| +RollUpApply | cities, anon_0 | 14 | 14 | 0 | 0/0 |
| |\ +-----------------------------------+----------------+------+---------+------------------------+
| | +Projection | location.name AS anon_0 | 6 | 15 | 15 | 1/0 |
| | | +-----------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (p)-[anon_2:WORKS_IN]->(location) | 6 | 15 | 33 | 15/0 |
| | | +-----------------------------------+----------------+------+---------+------------------------+
| | +Argument | p | 14 | 14 | 0 | 0/0 |
| | +-----------------------------------+----------------+------+---------+------------------------+
| +Filter | p:Person | 14 | 14 | 35 | 1/0 |
| | +-----------------------------------+----------------+------+---------+------------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 1/0 |
+-----------------+-----------------------------------+----------------+------+---------+------------------------+
Total database accesses: 133, total allocated memory: 64Argument
The Argument operator indicates the variable to be used as an argument to the right-hand side of an Apply operator.
Query
MATCH (s:Person {name: 'me'}) MERGE (s)-[:FRIENDS_WITH]->(s)Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 1 | 0 | 0 | | | | Fused in Pipeline 1 |
| | +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 1 | 0 | 0 | | | | Fused in Pipeline 1 |
| | +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Apply | | 1 | 1 | 0 | | | | |
| |\ +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +LockingMerge | CREATE (s)-[anon_0:FRIENDS_WITH]->(s), LOCK(s) | 1 | 1 | 1 | | | | Fused in Pipeline 1 |
| | | +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Expand(Into) | (s)-[anon_0:FRIENDS_WITH]->(s) | 0 | 0 | 8 | 896 | | | Fused in Pipeline 1 |
| | | +------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Argument | s | 1 | 3 | 0 | 80 | 4/0 | 8.475 | Fused in Pipeline 1 |
| | +------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +NodeIndexSeek | s:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | 72 | 0/1 | 10.014 | In Pipeline 0 |
+-----------------+------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 11, total allocated memory: 976Expand All
Given a start node, and depending on the pattern relationship, the Expand(All) operator will traverse incoming or outgoing relationships.
Query
MATCH (p:Person {name: 'me'})-[:FRIENDS_WITH]->(fof) RETURN fofQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | fof | 0 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(All) | (p)-[anon_0:FRIENDS_WITH]->(fof) | 0 | 1 | 3 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexSeek | p:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | 72 | 4/1 | 1.109 | Fused in Pipeline 0 |
+-----------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 5, total allocated memory: 136Expand Into
When both the start and end node have already been found, the Expand(Into) operator is used to find all relationships connecting the two nodes.
As both the start and end node of the relationship are already in scope, the node with the smallest degree will be used.
This can make a noticeable difference when dense nodes appear as end points.
Query
MATCH (p:Person {name: 'me'})-[:FRIENDS_WITH]->(fof)-->(p) RETURN fofQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | fof | 0 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | not anon_0 = anon_1 | 0 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(Into) | (p)-[anon_0:FRIENDS_WITH]->(fof) | 0 | 0 | 0 | 0 | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(All) | (p)<-[anon_1]-(fof) | 0 | 0 | 3 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexSeek | p:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | 72 | 2/1 | 12.521 | Fused in Pipeline 0 |
+-----------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 5, total allocated memory: 152Optional Expand All
The OptionalExpand(All) operator is analogous to Expand(All), apart from when no relationships match the direction, type and property predicates.
In this situation, OptionalExpand(all) will return a single row with the relationship and end node set to null.
Query
MATCH (p:Person)
OPTIONAL MATCH (p)-[works_in:WORKS_IN]->(l) WHERE works_in.duration > 180
RETURN p, lQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+----------------------+-------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+----------------------+-------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p, l | 14 | 15 | 2 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +OptionalExpand(All) | (p)-[works_in:WORKS_IN]->(l) WHERE works_in.duration > $autoint_0 | 14 | 15 | 47 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 5/0 | 1.701 | Fused in Pipeline 0 |
+----------------------+-------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 85, total allocated memory: 136Optional Expand Into
The OptionalExpand(Into) operator is analogous to Expand(Into), apart from when no matching relationships are found.
In this situation, OptionalExpand(Into) will return a single row with the relationship and end node set to null.
As both the start and end node of the relationship are already in scope, the node with the smallest degree will be used.
This can make a noticeable difference when dense nodes appear as end points.
Query
MATCH (p:Person)-[works_in:WORKS_IN]->(l) OPTIONAL MATCH (l)-->(p) RETURN pQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p | 15 | 15 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +OptionalExpand(Into) | (l)-[anon_0]->(p) | 15 | 15 | 105 | 3360 | | | Fused in Pipeline 0 |
| | +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(All) | (p)-[works_in:WORKS_IN]->(l) | 15 | 15 | 19 | | | | Fused in Pipeline 0 |
| | +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 6/0 | 1.790 | Fused in Pipeline 0 |
+-----------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 160, total allocated memory: 3440VarLength Expand All
Given a start node, the VarLengthExpand(All) operator will traverse variable-length relationships.
Query
MATCH (p:Person)-[:FRIENDS_WITH *1..2]-(q:Person) RETURN p, qQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------+-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------------+-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p, q | 4 | 6 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | q:Person | 4 | 6 | 6 | | | | Fused in Pipeline 0 |
| | +-----------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +VarLengthExpand(All) | (p)-[anon_0:FRIENDS_WITH*..2]-(q) | 4 | 6 | 47 | 128 | | | Fused in Pipeline 0 |
| | +-----------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 7/0 | 2.034 | Fused in Pipeline 0 |
+-----------------------+-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 89, total allocated memory: 208VarLength Expand Into
When both the start and end node have already been found, the VarLengthExpand(Into) operator is used to find all variable-length relationships connecting the two nodes.
Query
MATCH (p:Person)-[:FRIENDS_WITH *1..2]-(p:Person) RETURN pQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------------+-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------------+-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p | 0 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +VarLengthExpand(Into) | (p)-[anon_0:FRIENDS_WITH*..2]-(p) | 0 | 0 | 47 | 128 | | | Fused in Pipeline 0 |
| | +-----------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 4/0 | 0.698 | Fused in Pipeline 0 |
+------------------------+-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 83, total allocated memory: 192VarLength Expand Pruning
Given a start node, the VarLengthExpand(Pruning) operator will traverse variable-length relationships much like the VarLengthExpand(All) operator.
However, as an optimization, some paths will not be explored if they are guaranteed to produce an end node that has already been found (by means of a previous path traversal).
This will only be used in cases where the individual paths are not of interest.
This operator guarantees that all the end nodes produced will be unique.
Query
MATCH (p:Person)-[:FRIENDS_WITH *3..4]-(q:Person) RETURN DISTINCT p, qQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+---------------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+---------------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p, q | 0 | 0 | 0 | | 0/0 | 0.044 | In Pipeline 1 |
| | +------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Distinct | p, q | 0 | 0 | 0 | 224 | 0/0 | 2.558 | In Pipeline 1 |
| | +------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Filter | q:Person | 0 | 0 | 0 | | 0/0 | 0.079 | In Pipeline 1 |
| | +------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +VarLengthExpand(Pruning) | (p)-[:FRIENDS_WITH*3..4]-(q) | 0 | 0 | 32 | 896 | | | In Pipeline 1 |
| | +------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 1/0 | 0.198 | Fused in Pipeline 0 |
+---------------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 68, total allocated memory: 976Assert Same Node
The AssertSameNode operator is used to ensure that no unique constraints are violated in the slotted and interpreted runtime.
The example looks for the presence of a team with the supplied name and id, and if one does not exist,
it will be created. Owing to the existence of two unique constraints
on :Team(name) and :Team(id), any node that would be found by the UniqueIndexSeek
must be the very same node, or the constraints would be violated.
Query
CYPHER runtime=slotted MERGE (t:Team {name: 'Engineering', id: 42})Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+---------------------------------+------------------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+---------------------------------+------------------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | | 1 | 0 | 0 | 0/0 |
| | +------------------------------------------------+----------------+------+---------+------------------------+
| +EmptyResult | | 1 | 0 | 0 | 0/0 |
| | +------------------------------------------------+----------------+------+---------+------------------------+
| +Merge | CREATE (t:Team) | 1 | 1 | 0 | 0/0 |
| | +------------------------------------------------+----------------+------+---------+------------------------+
| +AssertSameNode | t | 0 | 1 | 0 | 0/0 |
| |\ +------------------------------------------------+----------------+------+---------+------------------------+
| | +NodeUniqueIndexSeek(Locking) | UNIQUE t:Team(id) WHERE id = $autoint_1 | 1 | 1 | 1 | 0/1 |
| | +------------------------------------------------+----------------+------+---------+------------------------+
| +NodeUniqueIndexSeek(Locking) | UNIQUE t:Team(name) WHERE name = $autostring_0 | 0 | 1 | 1 | 0/1 |
+---------------------------------+------------------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 2, total allocated memory: 64Empty Result
The EmptyResult operator eagerly loads all incoming data and discards it.
Query
CREATE (:Person)Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+-----------------+----------------+------+---------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+-----------------+----------------+------+---------+------------------------+-----------+---------------------+
| +ProduceResults | | 1 | 0 | 0 | | | Fused in Pipeline 0 |
| | +-----------------+----------------+------+---------+ | +---------------------+
| +EmptyResult | | 1 | 0 | 0 | | | Fused in Pipeline 0 |
| | +-----------------+----------------+------+---------+ | +---------------------+
| +Create | (anon_0:Person) | 1 | 1 | 1 | 0/0 | 0.000 | Fused in Pipeline 0 |
+-----------------+-----------------+----------------+------+---------+------------------------+-----------+---------------------+
Total database accesses: 1, total allocated memory: 136Produce Results
The ProduceResults operator prepares the result so that it is consumable by the user, such as transforming internal values to user values.
It is present in every single query that returns data to the user, and has little bearing on performance optimisation.
Query
MATCH (n) RETURN nQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+---------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+---------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | n | 35 | 35 | 0 | | | | Fused in Pipeline 0 |
| | +---------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | n | 35 | 35 | 36 | 72 | 3/0 | 1.409 | Fused in Pipeline 0 |
+-----------------+---------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 36, total allocated memory: 136Load CSV
The LoadCSV operator loads data from a CSV source into the query.
It is used whenever the LOAD CSV clause is used in a query.
Query
LOAD CSV FROM 'https://neo4j.com/docs/cypher-refcard/3.3/csv/artists.csv' AS line RETURN lineQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+---------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+---------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +ProduceResults | line | 10 | 4 | 0 | | 0/0 | 0.491 | In Pipeline 1 |
| | +---------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +LoadCSV | line | 10 | 4 | 0 | 64 | | | In Pipeline 1 |
+-----------------+---------+----------------+------+---------+----------------+------------------------+-----------+---------------+
Total database accesses: 0, total allocated memory: 136Hash joins in general
Hash joins have two inputs: the build input and probe input. The query planner assigns these roles so that the smaller of the two inputs is the build input. The build input is pulled in eagerly, and is used to build a probe table. Once this is complete, the probe table is checked for each row coming from the probe input side.
In query plans, the build input is always the left operator, and the probe input the right operator.
There are four hash join operators:
Node Hash Join
The NodeHashJoin operator is a variation of the hash join.
NodeHashJoin executes the hash join on node ids.
As primitive types and arrays can be used, it can be done very efficiently.
Query
MATCH (bob:Person {name:'Bob'})-[:WORKS_IN]->(loc)<-[:WORKS_IN]-(matt:Person {name:'Mattis'})
RETURN loc.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------+----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------+----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | `loc.name` | 10 | 0 | 0 | | 0/0 | 0.000 | In Pipeline 2 |
| | +----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Projection | loc.name AS `loc.name` | 10 | 0 | 0 | | 0/0 | 0.000 | In Pipeline 2 |
| | +----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Filter | not anon_0 = anon_1 | 10 | 0 | 0 | | 0/0 | 0.000 | In Pipeline 2 |
| | +----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +NodeHashJoin | loc | 10 | 0 | 0 | 592 | | 0.041 | In Pipeline 2 |
| |\ +----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Expand(All) | (matt)-[anon_1:WORKS_IN]->(loc) | 19 | 0 | 0 | | | | Fused in Pipeline 1 |
| | | +----------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +NodeIndexSeek | matt:Person(name) WHERE name = $autostring_1 | 1 | 0 | 1 | 72 | 1/0 | 0.536 | Fused in Pipeline 1 |
| | +----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Expand(All) | (bob)-[anon_0:WORKS_IN]->(loc) | 19 | 1 | 3 | | | | Fused in Pipeline 0 |
| | +----------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexSeek | bob:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | 72 | 3/0 | 0.668 | Fused in Pipeline 0 |
+------------------+----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 6, total allocated memory: 744Value Hash Join
The ValueHashJoin operator is a variation of the hash join.
This operator allows for arbitrary values to be used as the join key.
It is most frequently used to solve predicates of the form: n.prop1 = m.prop2 (i.e. equality predicates between two property columns).
Query
MATCH (p:Person),(q:Person)
WHERE p.age = q.age
RETURN p,qQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p, q | 10 | 0 | 0 | | 0/0 | 0.000 | In Pipeline 2 |
| | +---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ValueHashJoin | p.age = q.age | 10 | 0 | 0 | 344 | | | In Pipeline 2 |
| |\ +---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Filter | q:Person | 14 | 0 | 0 | | | | Fused in Pipeline 1 |
| | | +---------------+----------------+------+---------+----------------+ | +---------------------+
| | +AllNodesScan | q | 35 | 0 | 0 | 72 | 0/0 | 0.000 | Fused in Pipeline 1 |
| | +---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +---------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 1/0 | 0.485 | Fused in Pipeline 0 |
+-----------------+---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 36, total allocated memory: 568Node Left/Right Outer Hash Join
The NodeLeftOuterHashJoin and NodeRightOuterHashJoin operators are variations of the hash join.
The query below can be planned with either a left or a right outer join.
The decision depends on the cardinalities of the left-hand and right-hand sides; i.e. how many rows would be returned, respectively, for (a:Person) and (a)-→(b:Person).
If (a:Person) returns fewer results than (a)-→(b:Person), a left outer join — indicated by NodeLeftOuterHashJoin — is planned.
On the other hand, if (a:Person) returns more results than (a)-→(b:Person), a right outer join — indicated by NodeRightOuterHashJoin — is planned instead.
Query
MATCH (a:Person)
OPTIONAL MATCH (a)-->(b:Person)
USING JOIN ON a
RETURN a.name, b.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-------------------------+------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-------------------------+------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | `a.name`, `b.name` | 14 | 14 | 0 | | 0/0 | 0.228 | In Pipeline 2 |
| | +------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Projection | cache[a.name] AS `a.name`, cache[b.name] AS `b.name` | 14 | 14 | 24 | | 0/0 | 0.166 | In Pipeline 2 |
| | +------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +NodeRightOuterHashJoin | a | 14 | 14 | 0 | 1144 | | 0.765 | In Pipeline 2 |
| |\ +------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Filter | a:Person | 14 | 14 | 0 | | | | Fused in Pipeline 1 |
| | | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +AllNodesScan | a | 35 | 35 | 36 | 72 | 0/0 | 0.213 | Fused in Pipeline 1 |
| | +------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +CacheProperties | cache[a.name], cache[b.name] | 2 | 2 | 6 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(All) | (b)<-[anon_0]-(a) | 2 | 2 | 19 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | b:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | b | 35 | 35 | 36 | 72 | 4/0 | 0.951 | Fused in Pipeline 0 |
+-------------------------+------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 121, total allocated memory: 1232Triadic Selection
The TriadicSelection operator is used to solve triangular queries, such as the very
common 'find my friend-of-friends that are not already my friend'.
It does so by putting all the friends into a set, and uses the set to check if the
friend-of-friends are already connected to me.
The example finds the names of all friends of my friends that are not already my friends.
Query
CYPHER runtime=slotted MATCH (me:Person)-[:FRIENDS_WITH]-()-[:FRIENDS_WITH]-(other)
WHERE NOT (me)-[:FRIENDS_WITH]-(other)
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-------------------+----------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+-------------------+----------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | `other.name` | 0 | 2 | 0 | 0/0 |
| | +----------------------------------------+----------------+------+---------+------------------------+
| +Projection | other.name AS `other.name` | 0 | 2 | 2 | 1/0 |
| | +----------------------------------------+----------------+------+---------+------------------------+
| +TriadicSelection | WHERE NOT (me)--(other) | 0 | 2 | 0 | 0/0 |
| |\ +----------------------------------------+----------------+------+---------+------------------------+
| | +Filter | not anon_2 = anon_4 | 0 | 2 | 0 | 0/0 |
| | | +----------------------------------------+----------------+------+---------+------------------------+
| | +Expand(All) | (anon_3)-[anon_4:FRIENDS_WITH]-(other) | 0 | 6 | 14 | 4/0 |
| | | +----------------------------------------+----------------+------+---------+------------------------+
| | +Argument | anon_3, anon_2 | 4 | 4 | 0 | 0/0 |
| | +----------------------------------------+----------------+------+---------+------------------------+
| +Expand(All) | (me)-[anon_2:FRIENDS_WITH]-(anon_3) | 4 | 4 | 33 | 17/0 |
| | +----------------------------------------+----------------+------+---------+------------------------+
| +Filter | me:Person | 14 | 14 | 35 | 1/0 |
| | +----------------------------------------+----------------+------+---------+------------------------+
| +AllNodesScan | me | 35 | 35 | 36 | 1/0 |
+-------------------+----------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 120, total allocated memory: 64Triadic Build
The TriadicBuild operator is used in conjunction with TriadicFilter to solve triangular queries, such as the very
common 'find my friend-of-friends that are not already my friend'. These two operators are specific to Pipelined
runtime and together perform the same logic as TriadicSelection does for other runtimes.
TriadicBuild builds a set of all friends, which is later used by TriadicFilter.
The example finds the names of all friends of my friends that are not already my friends.
Query
CYPHER runtime=pipelined MATCH (me:Person)-[:FRIENDS_WITH]-()-[:FRIENDS_WITH]-(other)
WHERE NOT (me)-[:FRIENDS_WITH]-(other)
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | `other.name` | 0 | 2 | 0 | | 0/0 | 0.123 | In Pipeline 3 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Projection | other.name AS `other.name` | 0 | 2 | 4 | | 2/0 | 0.046 | In Pipeline 3 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +TriadicFilter | WHERE NOT (me)--(other) | 0 | 2 | 0 | 896 | 0/0 | 0.151 | In Pipeline 3 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Apply | | 0 | 2 | 0 | | 0/0 | | |
| |\ +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Filter | not anon_2 = anon_4 | 0 | 2 | 0 | | | | Fused in Pipeline 2 |
| | | +----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Expand(All) | (anon_3)-[anon_4:FRIENDS_WITH]-(other) | 0 | 6 | 14 | | | | Fused in Pipeline 2 |
| | | +----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Argument | anon_3, anon_2 | 4 | 4 | 0 | 192 | 0/0 | 0.714 | Fused in Pipeline 2 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +TriadicBuild | (me)--(anon_3) | 4 | 4 | 0 | 376 | 0/0 | 0.588 | In Pipeline 1 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Expand(All) | (me)-[anon_2:FRIENDS_WITH]-(anon_3) | 4 | 4 | 19 | | | | Fused in Pipeline 0 |
| | +----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | me:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | me | 35 | 35 | 36 | 72 | 2/0 | 0.343 | Fused in Pipeline 0 |
+-----------------+----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 73, total allocated memory: 1208Triadic Filter
The TriadicFilter operator is used in conjunction with TriadicBuild to solve triangular queries, such as the very
common 'find my friend-of-friends that are not already my friend'. These two operators are specific to Pipelined
runtime and together perform the same logic as TriadicSelection does for other runtimes.
TriadicFilter uses a set of friends previously built by TriadicBuild to check if the friend-of-friends are already connected to me.
The example finds the names of all friends of my friends that are not already my friends.
Query
CYPHER runtime=pipelined MATCH (me:Person)-[:FRIENDS_WITH]-()-[:FRIENDS_WITH]-(other)
WHERE NOT (me)-[:FRIENDS_WITH]-(other)
RETURN other.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | `other.name` | 0 | 2 | 0 | | 0/0 | 0.126 | In Pipeline 3 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Projection | other.name AS `other.name` | 0 | 2 | 4 | | 2/0 | 0.122 | In Pipeline 3 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +TriadicFilter | WHERE NOT (me)--(other) | 0 | 2 | 0 | 896 | 0/0 | 0.590 | In Pipeline 3 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Apply | | 0 | 2 | 0 | | 0/0 | | |
| |\ +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Filter | not anon_2 = anon_4 | 0 | 2 | 0 | | | | Fused in Pipeline 2 |
| | | +----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Expand(All) | (anon_3)-[anon_4:FRIENDS_WITH]-(other) | 0 | 6 | 14 | | | | Fused in Pipeline 2 |
| | | +----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Argument | anon_3, anon_2 | 4 | 4 | 0 | 192 | 0/0 | 0.547 | Fused in Pipeline 2 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +TriadicBuild | (me)--(anon_3) | 4 | 4 | 0 | 376 | 0/0 | 7.670 | In Pipeline 1 |
| | +----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Expand(All) | (me)-[anon_2:FRIENDS_WITH]-(anon_3) | 4 | 4 | 19 | | | | Fused in Pipeline 0 |
| | +----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | me:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | me | 35 | 35 | 36 | 72 | 2/0 | 0.475 | Fused in Pipeline 0 |
+-----------------+----------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 73, total allocated memory: 1208Cartesian Product
The CartesianProduct operator produces a cartesian product of the two inputs — each row coming from the left child operator will be combined with all the rows from the right child operator.
CartesianProduct generally exhibits bad performance and ought to be avoided if possible.
Query
MATCH (p:Person), (t:Team) RETURN p, tQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-------------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-------------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p, t | 140 | 140 | 0 | | 2/0 | 8.824 | In Pipeline 2 |
| | +----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +CartesianProduct | | 140 | 140 | 0 | 1728 | | 0.871 | In Pipeline 2 |
| |\ +----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Filter | t:Team | 10 | 10 | 0 | | | | Fused in Pipeline 1 |
| | | +----------+----------------+------+---------+----------------+ | +---------------------+
| | +AllNodesScan | t | 35 | 35 | 36 | 88 | 0/0 | 0.159 | Fused in Pipeline 1 |
| | +----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 1/0 | 0.629 | Fused in Pipeline 0 |
+-------------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 72, total allocated memory: 1808Foreach
The Foreach operator executes a nested loop between the left child operator and the right child operator.
In an analogous manner to the Apply operator, it takes a row from the left-hand side and, using the Argument operator, provides it to the operator tree on the right-hand side.
Foreach will yield all the rows coming in from the left-hand side; all results from the right-hand side are pulled in and discarded.
Query
CYPHER runtime=slotted FOREACH (value IN [1,2,3] |
CREATE (:Person {age: value})
)Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-----------------+--------------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+-----------------+--------------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | | 1 | 0 | 0 | 0/0 |
| | +--------------------------------------------+----------------+------+---------+------------------------+
| +EmptyResult | | 1 | 0 | 0 | 0/0 |
| | +--------------------------------------------+----------------+------+---------+------------------------+
| +Foreach | value IN [1, 2, 3], CREATE (anon_0:Person) | 1 | 1 | 9 | 0/0 |
+-----------------+--------------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 9, total allocated memory: 64Eager
For isolation purposes, the Eager operator ensures that operations affecting subsequent operations are executed fully for the whole dataset before continuing execution.
Information from the stores is fetched in a lazy manner; i.e. the pattern matching might not be fully exhausted before updates are applied.
To guarantee reasonable semantics, the query planner will insert Eager operators into the query plan to prevent updates from influencing pattern matching;
this scenario is exemplified by the query below, where the DELETE clause influences the MATCH clause.
The Eager operator can cause high memory usage when importing data or migrating graph structures.
In such cases, the operations should be split into simpler steps; e.g. importing nodes and relationships separately.
Alternatively, the records to be updated can be returned, followed by an update statement.
Query
MATCH (a)-[r]-(b) DELETE r,a,b MERGE ()Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+-----------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+-----------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 36 | 0 | 0 | | | | Fused in Pipeline 3 |
| | +-----------------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 36 | 0 | 0 | | | | Fused in Pipeline 3 |
| | +-----------------+----------------+------+---------+----------------+ | +---------------------+
| +Apply | | 36 | 504 | 0 | | | | |
| |\ +-----------------+----------------+------+---------+----------------+ | +---------------------+
| | +Merge | CREATE (anon_0) | 36 | 504 | 0 | | | | Fused in Pipeline 3 |
| | | +-----------------+----------------+------+---------+----------------+ | +---------------------+
| | +AllNodesScan | anon_0 | 1260 | 504 | 540 | 1216 | 0/0 | 4.271 | Fused in Pipeline 3 |
| | +-----------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Eager | | 36 | 36 | 0 | 944 | 0/0 | 0.289 | In Pipeline 2 |
| | +-----------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Delete | b | 36 | 36 | 9 | | | | Fused in Pipeline 1 |
| | +-----------------+----------------+------+---------+----------------+ | +---------------------+
| +Delete | a | 36 | 36 | 12 | | | | Fused in Pipeline 1 |
| | +-----------------+----------------+------+---------+----------------+ | +---------------------+
| +Delete | r | 36 | 36 | 18 | | | | Fused in Pipeline 1 |
| | +-----------------+----------------+------+---------+----------------+ | +---------------------+
| +Eager | | 36 | 36 | 0 | 944 | 19/0 | 2.109 | Fused in Pipeline 1 |
| | +-----------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Expand(All) | (a)-[r]-(b) | 36 | 36 | 36 | | | | Fused in Pipeline 0 |
| | +-----------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | a | 35 | 35 | 36 | 72 | 2/0 | 0.573 | Fused in Pipeline 0 |
+-----------------+-----------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 651, total allocated memory: 1344Eager Aggregation
The EagerAggregation operator evaluates a grouping expression and uses the result to group rows into different groupings.
For each of these groupings, EagerAggregation will then evaluate all aggregation functions and return the result.
To do this, EagerAggregation, as the name implies, needs to pull in all data eagerly from its source and build up state, which leads to increased memory pressure in the system.
Query
MATCH (l:Location)<-[:WORKS_IN]-(p:Person) RETURN l.name AS location, collect(p.name) AS peopleQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-------------------+------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-------------------+------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | location, people | 4 | 6 | 0 | | 0/0 | 0.454 | In Pipeline 1 |
| | +------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +EagerAggregation | cache[l.name] AS location, collect(p.name) AS people | 4 | 6 | 30 | 3168 | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 15 | 15 | 15 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(All) | (l)<-[anon_0:WORKS_IN]-(p) | 15 | 15 | 16 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +CacheProperties | cache[l.name] | 10 | 10 | 10 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | l:Location | 10 | 10 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | l | 35 | 35 | 36 | 72 | 4/0 | 1.122 | Fused in Pipeline 0 |
+-------------------+------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 107, total allocated memory: 3248Ordered Aggregation
The OrderedAggregation operator is an optimization of the EagerAggregation operator that takes advantage of the ordering of the incoming rows.
This operator uses lazy evaluation and has a lower memory pressure in the system than the EagerAggregation operator.
Query
MATCH (p:Person) WHERE p.name STARTS WITH 'P' RETURN p.name, count(*) AS countQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Ordered by | Other |
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
| +ProduceResults | `p.name`, count | 0 | 2 | 0 | | 0/0 | 0.122 | p.name ASC | In Pipeline 1 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
| +OrderedAggregation | cache[p.name] AS `p.name`, count(*) AS count | 0 | 2 | 0 | 280 | 0/0 | 0.278 | p.name ASC | In Pipeline 1 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
| +NodeIndexSeekByRange | p:Person(name) WHERE name STARTS WITH $autostring_0, cache[p.name] | 0 | 2 | 3 | 72 | 0/1 | 1.675 | p.name ASC | In Pipeline 0 |
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
Total database accesses: 3, total allocated memory: 344Node Count From Count Store
The NodeCountFromCountStore operator uses the count store to answer questions about node counts.
This is much faster than the EagerAggregation operator which achieves the same result by actually counting.
However, as the count store only stores a limited range of combinations, EagerAggregation will still be used for more complex queries.
For example, we can get counts for all nodes, and nodes with a label, but not nodes with more than one label.
Query
MATCH (p:Person) RETURN count(p) AS peopleQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+--------------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+--------------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | people | 1 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeCountFromCountStore | count( (:Person) ) AS people | 1 | 1 | 1 | 72 | 0/0 | 0.335 | Fused in Pipeline 0 |
+--------------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 1, total allocated memory: 136Relationship Count From Count Store
The RelationshipCountFromCountStore operator uses the count store to answer questions about relationship counts.
This is much faster than the EagerAggregation operator which achieves the same result by actually counting.
However, as the count store only stores a limited range of combinations, EagerAggregation will still be used for more complex queries.
For example, we can get counts for all relationships, relationships with a type, relationships with a label on one end, but not relationships with labels on both end nodes.
Query
MATCH (p:Person)-[r:WORKS_IN]->() RETURN count(r) AS jobsQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+----------------------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+----------------------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | jobs | 1 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +--------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +RelationshipCountFromCountStore | count( (:Person)-[:WORKS_IN]->() ) AS jobs | 1 | 1 | 1 | 72 | 0/0 | 0.233 | Fused in Pipeline 0 |
+----------------------------------+--------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 1, total allocated memory: 136Distinct
The Distinct operator removes duplicate rows from the incoming stream of rows.
To ensure only distinct elements are returned, Distinct will pull in data lazily from its source and build up state.
This may lead to increased memory pressure in the system.
Query
MATCH (l:Location)<-[:WORKS_IN]-(p:Person) RETURN DISTINCT lQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | l | 14 | 6 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Distinct | l | 14 | 6 | 0 | 224 | | | Fused in Pipeline 0 |
| | +----------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 15 | 15 | 15 | | | | Fused in Pipeline 0 |
| | +----------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(All) | (l)<-[anon_0:WORKS_IN]-(p) | 15 | 15 | 16 | | | | Fused in Pipeline 0 |
| | +----------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | l:Location | 10 | 10 | 0 | | | | Fused in Pipeline 0 |
| | +----------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | l | 35 | 35 | 36 | 72 | 5/0 | 0.698 | Fused in Pipeline 0 |
+-----------------+----------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 67, total allocated memory: 304Ordered Distinct
The OrderedDistinct operator is an optimization of the Distinct operator that takes advantage of the ordering of the incoming rows.
This operator has a lower memory pressure in the system than the Distinct operator.
Query
MATCH (p:Person) WHERE p.name STARTS WITH 'P' RETURN DISTINCT p.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Ordered by | Other |
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
| +ProduceResults | `p.name` | 0 | 2 | 0 | | 0/0 | 0.078 | p.name ASC | In Pipeline 0 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
| +OrderedDistinct | cache[p.name] AS `p.name` | 0 | 2 | 0 | 32 | 0/0 | 3.111 | p.name ASC | In Pipeline 0 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
| +NodeIndexSeekByRange | p:Person(name) WHERE name STARTS WITH $autostring_0, cache[p.name] | 0 | 2 | 3 | 72 | 0/1 | 0.402 | p.name ASC | In Pipeline 0 |
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------+
Total database accesses: 3, total allocated memory: 136Filter
The Filter operator filters each row coming from the child operator, only passing through rows that evaluate the predicates to true.
Query
MATCH (p:Person) WHERE p.name =~ '^a.*' RETURN pQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p | 14 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | cache[p.name] =~ $autostring_0 | 14 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexScan | p:Person(name) WHERE name IS NOT NULL, cache[p.name] | 14 | 14 | 15 | 72 | 0/1 | 1.033 | Fused in Pipeline 0 |
+-----------------+------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 15, total allocated memory: 136Limit
The Limit operator returns the first 'n' rows from the incoming input.
Query
MATCH (p:Person) RETURN p LIMIT 3Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p | 3 | 3 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +Limit | 3 | 3 | 3 | 0 | 32 | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 3 | 3 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 8 | 4 | 5 | 72 | 3/0 | 0.769 | Fused in Pipeline 0 |
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 5, total allocated memory: 136Skip
The Skip operator skips 'n' rows from the incoming rows.
Query
MATCH (p:Person)
RETURN p
ORDER BY p.id
SKIP 1Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Ordered by | Other |
+-----------------+----------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +ProduceResults | p | 13 | 13 | 0 | | 2/0 | 0.551 | p.id ASC | In Pipeline 1 |
| | +----------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +Skip | $autoint_0 | 13 | 13 | 0 | 32 | 0/0 | 2.429 | p.id ASC | In Pipeline 1 |
| | +----------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +Sort | `p.id` ASC | 14 | 14 | 0 | 392 | 0/0 | 0.238 | p.id ASC | In Pipeline 1 |
| | +----------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +Projection | p.id AS `p.id` | 14 | 14 | 14 | | | | | Fused in Pipeline 0 |
| | +----------------+----------------+------+---------+----------------+ | +------------+---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | | Fused in Pipeline 0 |
| | +----------------+----------------+------+---------+----------------+ | +------------+---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 2/0 | 1.180 | | Fused in Pipeline 0 |
+-----------------+----------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
Total database accesses: 50, total allocated memory: 504Sort
The Sort operator sorts rows by a provided key.
In order to sort the data, all data from the source operator needs to be pulled in eagerly and kept in the query state, which will lead to increased memory pressure in the system.
Query
MATCH (p:Person) RETURN p ORDER BY p.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+--------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Ordered by | Other |
+-----------------+--------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +ProduceResults | p | 14 | 14 | 0 | | 2/0 | 0.366 | p.name ASC | In Pipeline 1 |
| | +--------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +Sort | `p.name` ASC | 14 | 14 | 0 | 1184 | 0/0 | 0.190 | p.name ASC | In Pipeline 1 |
| | +--------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +Projection | p.name AS `p.name` | 14 | 14 | 14 | | | | | Fused in Pipeline 0 |
| | +--------------------+----------------+------+---------+----------------+ | +------------+---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | | Fused in Pipeline 0 |
| | +--------------------+----------------+------+---------+----------------+ | +------------+---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 2/0 | 0.409 | | Fused in Pipeline 0 |
+-----------------+--------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
Total database accesses: 50, total allocated memory: 1264Partial Sort
The PartialSort operator is an optimization of the Sort operator that takes advantage of the ordering of the incoming rows.
This operator uses lazy evaluation and has a lower memory pressure in the system than the Sort operator.
Partial sort is only applicable when sorting on multiple columns.
Query
MATCH (p:Person) WHERE p.name STARTS WITH 'P' RETURN p ORDER BY p.name, p.ageQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Ordered by | Other |
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
| +ProduceResults | p | 0 | 2 | 0 | | 2/0 | 0.414 | p.name ASC, p.age ASC | In Pipeline 1 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
| +PartialSort | `p.name` ASC, `p.age` ASC | 0 | 2 | 0 | 536 | 0/0 | 0.687 | p.name ASC, p.age ASC | In Pipeline 1 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
| +Projection | cache[p.name] AS `p.name`, p.age AS `p.age` | 0 | 2 | 0 | | | | p.name ASC | Fused in Pipeline 0 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+ | +-----------------------+---------------------+
| +NodeIndexSeekByRange | p:Person(name) WHERE name STARTS WITH $autostring_0, cache[p.name] | 0 | 2 | 3 | 72 | 0/1 | 0.818 | p.name ASC | Fused in Pipeline 0 |
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
Total database accesses: 3, total allocated memory: 600Top
The Top operator returns the first 'n' rows sorted by a provided key. Instead of sorting the entire input, only the top 'n' rows are retained.
Query
MATCH (p:Person) RETURN p ORDER BY p.name LIMIT 2Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Ordered by | Other |
+-----------------+----------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +ProduceResults | p | 2 | 2 | 0 | | 2/0 | 0.261 | p.name ASC | In Pipeline 1 |
| | +----------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +Top | `p.name` ASC LIMIT 2 | 2 | 2 | 0 | 1176 | 0/0 | 1.151 | p.name ASC | In Pipeline 1 |
| | +----------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +Projection | p.name AS `p.name` | 14 | 14 | 14 | | | | | Fused in Pipeline 0 |
| | +----------------------+----------------+------+---------+----------------+ | +------------+---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | | Fused in Pipeline 0 |
| | +----------------------+----------------+------+---------+----------------+ | +------------+---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 2/0 | 0.395 | | Fused in Pipeline 0 |
+-----------------+----------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
Total database accesses: 50, total allocated memory: 1256Partial Top
The PartialTop operator is an optimization of the Top operator that takes advantage of the ordering of the incoming rows.
This operator uses lazy evaluation and has a lower memory pressure in the system than the Top operator.
Partial top is only applicable when sorting on multiple columns.
Query
MATCH (p:Person) WHERE p.name STARTS WITH 'P' RETURN p ORDER BY p.name, p.age LIMIT 2Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Ordered by | Other |
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
| +ProduceResults | p | 0 | 2 | 0 | | 2/0 | 0.148 | p.name ASC, p.age ASC | In Pipeline 1 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
| +PartialTop | `p.name` ASC, `p.age` ASC LIMIT 2 | 0 | 2 | 0 | 432 | 0/0 | 0.950 | p.name ASC, p.age ASC | In Pipeline 1 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
| +Projection | cache[p.name] AS `p.name`, p.age AS `p.age` | 0 | 2 | 0 | | | | p.name ASC | Fused in Pipeline 0 |
| | +--------------------------------------------------------------------+----------------+------+---------+----------------+ | +-----------------------+---------------------+
| +NodeIndexSeekByRange | p:Person(name) WHERE name STARTS WITH $autostring_0, cache[p.name] | 0 | 2 | 3 | 72 | 0/1 | 0.519 | p.name ASC | Fused in Pipeline 0 |
+-----------------------+--------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+-----------------------+---------------------+
Total database accesses: 3, total allocated memory: 496Union
The Union operator concatenates the results from the right child operator with the results from the left child operator.
Query
MATCH (p:Location)
RETURN p.name
UNION ALL
MATCH (p:Country)
RETURN p.nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+--------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+--------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | `p.name` | 20 | 11 | 0 | | | | Fused in Pipeline 2 |
| | +--------------------+----------------+------+---------+----------------+ | +---------------------+
| +Union | | 20 | 11 | 0 | 768 | 0/0 | 0.552 | Fused in Pipeline 2 |
| |\ +--------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| | +Projection | `p.name` | 10 | 1 | 0 | | | | Fused in Pipeline 1 |
| | | +--------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Projection | p.name AS `p.name` | 10 | 1 | 1 | | | | Fused in Pipeline 1 |
| | | +--------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Filter | p:Country | 10 | 1 | 0 | | | | Fused in Pipeline 1 |
| | | +--------------------+----------------+------+---------+----------------+ | +---------------------+
| | +AllNodesScan | p | 35 | 35 | 36 | 72 | 0/0 | 0.293 | Fused in Pipeline 1 |
| | +--------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Projection | `p.name` | 10 | 10 | 0 | | | | Fused in Pipeline 0 |
| | +--------------------+----------------+------+---------+----------------+ | +---------------------+
| +Projection | p.name AS `p.name` | 10 | 10 | 10 | | | | Fused in Pipeline 0 |
| | +--------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Location | 10 | 10 | 0 | | | | Fused in Pipeline 0 |
| | +--------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 2/0 | 0.325 | Fused in Pipeline 0 |
+-----------------+--------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 83, total allocated memory: 928Unwind
The Unwind operator returns one row per item in a list.
Query
UNWIND range(1, 5) as value return valueQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------------------------------------+----------------+------+---------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------------------------------------+----------------+------+---------+------------------------+-----------+---------------------+
| +ProduceResults | value | 10 | 5 | 0 | | | Fused in Pipeline 0 |
| | +----------------------------------------+----------------+------+---------+ | +---------------------+
| +Unwind | range($autoint_0, $autoint_1) AS value | 10 | 5 | 0 | 0/0 | 0.000 | Fused in Pipeline 0 |
+-----------------+----------------------------------------+----------------+------+---------+------------------------+-----------+---------------------+
Total database accesses: 0, total allocated memory: 136Exhaustive Limit
The ExhaustiveLimit operator is just like a normal Limit but will always exhaust the input.
Used when combining LIMIT and updates
Query
MATCH (p:Person) SET p.seen=true RETURN p LIMIT 3Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------+---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------+---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | p | 3 | 3 | 0 | | | | Fused in Pipeline 0 |
| | +---------------+----------------+------+---------+----------------+ | +---------------------+
| +ExhaustiveLimit | 3 | 3 | 3 | 0 | 32 | | | Fused in Pipeline 0 |
| | +---------------+----------------+------+---------+----------------+ | +---------------------+
| +SetProperty | p.seen = true | 14 | 14 | 14 | | | | Fused in Pipeline 0 |
| | +---------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +---------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 3/0 | 2.630 | Fused in Pipeline 0 |
+------------------+---------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 50, total allocated memory: 152Optional
The Optional operator is used to solve some OPTIONAL MATCH queries.
It will pull data from its source, simply passing it through if any data exists.
However, if no data is returned by its source, Optional will yield a single row with all columns set to null.
Query
MATCH (p:Person {name:'me'}) OPTIONAL MATCH (q:Person {name: 'Lulu'}) RETURN p, qQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +ProduceResults | p, q | 1 | 1 | 0 | | 2/0 | 0.144 | In Pipeline 2 |
| | +-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +Apply | | 1 | 1 | 0 | | 0/0 | 0.021 | |
| |\ +-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| | +Optional | p | 1 | 1 | 0 | 768 | 0/0 | 0.622 | In Pipeline 2 |
| | | +-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| | +NodeIndexSeek | q:Person(name) WHERE name = $autostring_1 | 1 | 0 | 1 | 80 | 1/0 | 2.817 | In Pipeline 1 |
| | +-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +NodeIndexSeek | p:Person(name) WHERE name = $autostring_0 | 1 | 1 | 2 | 72 | 0/1 | 0.326 | In Pipeline 0 |
+------------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
Total database accesses: 3, total allocated memory: 928Project Endpoints
The ProjectEndpoints operator projects the start and end node of a relationship.
Query
CREATE (n)-[p:KNOWS]->(m) WITH p AS r MATCH (u)-[r]->(v) RETURN u, vQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+---------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+---------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | u, v | 1 | 1 | 0 | | | | Fused in Pipeline 1 |
| | +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Apply | | 1 | 1 | 0 | | | | |
| |\ +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +ProjectEndpoints | (u)-[r*]->(v) | 1 | 1 | 0 | | | | Fused in Pipeline 1 |
| | | +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| | +Argument | r | 1 | 1 | 0 | 96 | 0/0 | 0.205 | Fused in Pipeline 1 |
| | +------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Projection | p AS r | 1 | 1 | 0 | | | | Fused in Pipeline 0 |
| | +------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Create | (n), (m), (n)-[p:KNOWS]->(m) | 1 | 1 | 4 | | 0/0 | 0.000 | Fused in Pipeline 0 |
+---------------------+------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 4, total allocated memory: 176Projection
For each incoming row, the Projection operator evaluates a set of expressions and produces a row with the results of the expressions.
Query
RETURN 'hello' AS greetingQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+---------------------------+----------------+------+---------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+---------------------------+----------------+------+---------+------------------------+-----------+---------------------+
| +ProduceResults | greeting | 1 | 1 | 0 | | | Fused in Pipeline 0 |
| | +---------------------------+----------------+------+---------+ | +---------------------+
| +Projection | $autostring_0 AS greeting | 1 | 1 | 0 | 0/0 | 0.000 | Fused in Pipeline 0 |
+-----------------+---------------------------+----------------+------+---------+------------------------+-----------+---------------------+
Total database accesses: 0, total allocated memory: 136Shortest path
The ShortestPath operator finds one or all shortest paths between two previously matches node variables.
Query
MATCH (andy:Person {name: 'Andy'}),(mattias:Person {name: 'Mattias'}),
p = shortestPath((andy)-[*]-(mattias))
RETURN pQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+---------------------+-----------------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+---------------------+-----------------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +ProduceResults | p | 1 | 1 | 0 | | 1/0 | 1.235 | In Pipeline 1 |
| | +-----------------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +ShortestPath | p = (andy)-[anon_0*]-(mattias) | 1 | 1 | 1 | 1280 | | | In Pipeline 1 |
| | +-----------------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
| +MultiNodeIndexSeek | andy:Person(name) WHERE name = $autostring_0, mattias:Person(name) WHERE name = $autostring_1 | 1 | 1 | 4 | 72 | 1/1 | 2.255 | In Pipeline 0 |
+---------------------+-----------------------------------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------+
Total database accesses: 5, total allocated memory: 1344Empty Row
The EmptyRow operator returns a single row with no columns.
Query
CYPHER runtime=slotted FOREACH (value IN [1,2,3] |
MERGE (:Person {age: value})
)Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-----------------+--------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+-----------------+--------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | | 1 | 0 | 0 | 0/0 |
| | +--------------------------------------+----------------+------+---------+------------------------+
| +EmptyResult | | 1 | 0 | 0 | 0/0 |
| | +--------------------------------------+----------------+------+---------+------------------------+
| +Foreach | value IN [1, 2, 3] | 1 | 1 | 0 | 0/0 |
| |\ +--------------------------------------+----------------+------+---------+------------------------+
| | +Merge | CREATE (anon_0:Person) | 1 | 3 | 9 | 0/0 |
| | | +--------------------------------------+----------------+------+---------+------------------------+
| | +Filter | anon_0:Person AND anon_0.age = value | 1 | 0 | 184 | 2/0 |
| | | +--------------------------------------+----------------+------+---------+------------------------+
| | +AllNodesScan | anon_0 | 35 | 108 | 111 | 1/0 |
| | +--------------------------------------+----------------+------+---------+------------------------+
| +EmptyRow | | 1 | 1 | 0 | 0/0 |
+-----------------+--------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 304, total allocated memory: 64Procedure Call
The ProcedureCall operator indicates an invocation to a procedure.
Query
CALL db.labels() YIELD label RETURN * ORDER BY labelQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Ordered by | Other |
+-----------------+-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +ProduceResults | label | 10 | 4 | 0 | | 0/0 | 0.131 | label ASC | In Pipeline 1 |
| | +-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +Sort | label ASC | 10 | 4 | 0 | 528 | 0/0 | 0.678 | label ASC | In Pipeline 1 |
| | +-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
| +ProcedureCall | db.labels() :: (label :: STRING?) | 10 | 4 | | | | | | Fused in Pipeline 0 |
+-----------------+-----------------------------------+----------------+------+---------+----------------+------------------------+-----------+------------+---------------------+
Total database accesses: ?, total allocated memory: 592Cache Properties
The CacheProperties operator reads nodes and relationship properties and caches them in the current row.
Future accesses to these properties can avoid reading from the store which will speed up the query.
In the plan below we will cache l.name before Expand(All) where there are fewer rows.
Query
MATCH (l:Location)<-[:WORKS_IN]-(p:Person) RETURN l.name AS location, p.name AS nameQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+------------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+------------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | location, name | 15 | 15 | 0 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Projection | cache[l.name] AS location, p.name AS name | 15 | 15 | 30 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 15 | 15 | 15 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(All) | (l)<-[anon_0:WORKS_IN]-(p) | 15 | 15 | 16 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +CacheProperties | cache[l.name] | 10 | 10 | 10 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | l:Location | 10 | 10 | 0 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | l | 35 | 35 | 36 | 72 | 4/0 | 1.255 | Fused in Pipeline 0 |
+------------------+-------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 107, total allocated memory: 152Create Nodes / Relationships
The Create operator is used to create nodes and relationships.
Query
CREATE (max:Person {name: 'Max'}), (chris:Person {name: 'Chris'})
CREATE (max)-[:FRIENDS_WITH]->(chris)Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+--------------------------------------------------------------------+----------------+------+---------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+--------------------------------------------------------------------+----------------+------+---------+------------------------+-----------+---------------------+
| +ProduceResults | | 1 | 0 | 0 | | | Fused in Pipeline 0 |
| | +--------------------------------------------------------------------+----------------+------+---------+ | +---------------------+
| +EmptyResult | | 1 | 0 | 0 | | | Fused in Pipeline 0 |
| | +--------------------------------------------------------------------+----------------+------+---------+ | +---------------------+
| +Create | (max:Person), (chris:Person), (max)-[anon_0:FRIENDS_WITH]->(chris) | 1 | 1 | 7 | 0/0 | 0.000 | Fused in Pipeline 0 |
+-----------------+--------------------------------------------------------------------+----------------+------+---------+------------------------+-----------+---------------------+
Total database accesses: 7, total allocated memory: 136Delete
The Delete operator is used to delete a node or a relationship.
Query
MATCH (me:Person {name: 'me'})-[w:WORKS_IN {duration: 190}]->(london:Location {name: 'London'})
DELETE wQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+-------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+-------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 0 | 0 | 0 | | | | Fused in Pipeline 1 |
| | +-------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 0 | 0 | 0 | | | | Fused in Pipeline 1 |
| | +-------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Delete | w | 0 | 1 | 1 | | | | Fused in Pipeline 1 |
| | +-------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Eager | | 0 | 1 | 0 | 104 | 1/0 | 3.883 | Fused in Pipeline 1 |
| | +-------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +Filter | me.name = $autostring_0 AND w.duration = $autoint_1 AND me:Person | 0 | 1 | 17 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(All) | (london)<-[w:WORKS_IN]-(me) | 0 | 7 | 9 | | | | Fused in Pipeline 0 |
| | +-------------------------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +NodeIndexSeek | london:Location(name) WHERE name = $autostring_2 | 0 | 1 | 2 | 72 | 4/1 | 4.253 | Fused in Pipeline 0 |
+-----------------+-------------------------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 29, total allocated memory: 184Detach Delete
The DetachDelete operator is used in all queries containing the DETACH DELETE clause, when deleting nodes and their relationships.
Query
MATCH (p:Person)
DETACH DELETE pQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 14 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 14 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +DetachDelete | p | 14 | 14 | 31 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +Filter | p:Person | 14 | 14 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | p | 35 | 35 | 36 | 72 | 35/0 | 6.049 | Fused in Pipeline 0 |
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 67, total allocated memory: 152Set Labels
The SetLabels operator is used when setting labels on a node.
Query
MATCH (n)
SET n:PersonQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 35 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 35 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +SetLabels | n:Person | 35 | 35 | 22 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | n | 35 | 35 | 36 | 72 | 3/0 | 3.342 | Fused in Pipeline 0 |
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 58, total allocated memory: 136Remove Labels
The RemoveLabels operator is used when deleting labels from a node.
Query
MATCH (n)
REMOVE n:PersonQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 35 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 35 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +RemoveLabels | n:Person | 35 | 35 | 15 | | | | Fused in Pipeline 0 |
| | +----------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | n | 35 | 35 | 36 | 72 | 3/0 | 1.984 | Fused in Pipeline 0 |
+-----------------+----------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 51, total allocated memory: 136Set Node Properties From Map
The SetNodePropertiesFromMap operator is used when setting properties from a map on a node.
Query
MATCH (n)
SET n = {weekday: 'Monday', meal: 'Lunch'}Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+---------------------------+---------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+---------------------------+---------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 35 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +---------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 35 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +---------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +SetNodePropertiesFromMap | n = {weekday: $autostring_0, meal: $autostring_1} | 35 | 35 | 35 | | | | Fused in Pipeline 0 |
| | +---------------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | n | 35 | 35 | 36 | 72 | 5/0 | 10.565 | Fused in Pipeline 0 |
+---------------------------+---------------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 71, total allocated memory: 136Set Relationship Properties From Map
The SetRelationshipPropertiesFromMap operator is used when setting properties from a map on a relationship.
Query
MATCH (n)-[r]->(m)
SET r = {weight: 5, unit: 'kg'}Query Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------------------------+-----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------------------------+-----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 18 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 18 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +SetRelationshipPropertiesFromMap | r = {weight: $autoint_0, unit: $autostring_1} | 18 | 18 | 18 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +Expand(All) | (m)<-[r]-(n) | 18 | 18 | 36 | | | | Fused in Pipeline 0 |
| | +-----------------------------------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | m | 35 | 35 | 36 | 72 | 6/0 | 5.737 | Fused in Pipeline 0 |
+-----------------------------------+-----------------------------------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 90, total allocated memory: 152Set Property
The SetProperty operator is used when setting a property on a node or relationship.
Query
MATCH (n)
SET n.checked = trueQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime PIPELINED
Runtime version 4.3
+-----------------+------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Other |
+-----------------+------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
| +ProduceResults | | 35 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +------------------+----------------+------+---------+----------------+ | +---------------------+
| +EmptyResult | | 35 | 0 | 0 | | | | Fused in Pipeline 0 |
| | +------------------+----------------+------+---------+----------------+ | +---------------------+
| +SetProperty | n.checked = true | 35 | 35 | 35 | | | | Fused in Pipeline 0 |
| | +------------------+----------------+------+---------+----------------+ | +---------------------+
| +AllNodesScan | n | 35 | 35 | 36 | 72 | 3/0 | 0.552 | Fused in Pipeline 0 |
+-----------------+------------------+----------------+------+---------+----------------+------------------------+-----------+---------------------+
Total database accesses: 71, total allocated memory: 136Create Unique Constraint
The CreateUniqueConstraint operator creates a unique constraint on a property for all nodes having a certain label.
The following query will create a unique constraint with the name uniqueness on the name property of nodes with the Country label.
Query
CREATE CONSTRAINT uniqueness ON (c:Country) ASSERT c.name is UNIQUEQuery Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+-------------------+----------------------------------------------------------------+
| Operator | Details |
+-------------------+----------------------------------------------------------------+
| +CreateConstraint | CONSTRAINT uniqueness ON (c:Country) ASSERT (c.name) IS UNIQUE |
+-------------------+----------------------------------------------------------------+
Total database accesses: ?Drop Unique Constraint
The DropUniqueConstraint operator removes a unique constraint from a property for all nodes having a certain label.
The following query will drop a unique constraint on the name property of nodes with the Country label.
Query
DROP CONSTRAINT ON (c:Country) ASSERT c.name is UNIQUEQuery Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+-----------------+-----------------------------------------------------+
| Operator | Details |
+-----------------+-----------------------------------------------------+
| +DropConstraint | CONSTRAINT ON (c:Country) ASSERT (c.name) IS UNIQUE |
+-----------------+-----------------------------------------------------+
Total database accesses: ?Create Constraint only if it does not already exist
To not get an error creating the same constraint twice, we use the DoNothingIfExists operator for constraints.
This will make sure no other constraint with the given name or another constraint of the same type and schema already exists before the specific CreateConstraint operator creates the constraint.
If it finds a constraint with the given name or with the same type and schema it will stop the execution and no new constraint is created.
The following query will create a unique constraint with the name uniqueness on the name property of nodes with the Country label only if
no constraint named uniqueness or unique constraint on (:Country {name}) already exists.
Query
CREATE CONSTRAINT uniqueness IF NOT EXISTS ON (c:Country) ASSERT c.name is UNIQUEQuery Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+--------------------------------+----------------------------------------------------------------+
| Operator | Details |
+--------------------------------+----------------------------------------------------------------+
| +CreateConstraint | CONSTRAINT uniqueness ON (c:Country) ASSERT (c.name) IS UNIQUE |
| | +----------------------------------------------------------------+
| +DoNothingIfExists(CONSTRAINT) | CONSTRAINT uniqueness ON (c:Country) ASSERT (c.name) IS UNIQUE |
+--------------------------------+----------------------------------------------------------------+
Total database accesses: ?Create Node Property Existence Constraint
The CreateNodePropertyExistenceConstraint operator creates an existence constraint with the name existence on a property for all nodes having a certain label.
This will only appear in Enterprise Edition.
Query
CREATE CONSTRAINT existence ON (p:Person) ASSERT p.name IS NOT NULLQuery Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+-------------------+----------------------------------------------------------------+
| Operator | Details |
+-------------------+----------------------------------------------------------------+
| +CreateConstraint | CONSTRAINT existence ON (p:Person) ASSERT (p.name) IS NOT NULL |
+-------------------+----------------------------------------------------------------+
Total database accesses: ?Drop Node Property Existence Constraint
The DropNodePropertyExistenceConstraint operator removes an existence constraint from a property for all nodes having a certain label.
This will only appear in Enterprise Edition.
Query
DROP CONSTRAINT ON (p:Person) ASSERT exists(p.name)Query Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+-----------------+------------------------------------------------+
| Operator | Details |
+-----------------+------------------------------------------------+
| +DropConstraint | CONSTRAINT ON (p:Person) ASSERT exists(p.name) |
+-----------------+------------------------------------------------+
Total database accesses: ?Create Node Key Constraint
The CreateNodeKeyConstraint operator creates a node key constraint with the name node_key which ensures
that all nodes with a particular label have a set of defined properties whose combined value is unique, and where all properties in the set are present.
This will only appear in Enterprise Edition.
Query
CREATE CONSTRAINT node_key ON (e:Employee) ASSERT (e.firstname, e.surname) IS NODE KEYQuery Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+-------------------+---------------------------------------------------------------------------------+
| Operator | Details |
+-------------------+---------------------------------------------------------------------------------+
| +CreateConstraint | CONSTRAINT node_key ON (e:Employee) ASSERT (e.firstname, e.surname) IS NODE KEY |
+-------------------+---------------------------------------------------------------------------------+
Total database accesses: ?Drop Node Key Constraint
The DropNodeKeyConstraint operator removes a node key constraint from a set of properties for all nodes having a certain label.
This will only appear in Enterprise Edition.
Query
DROP CONSTRAINT ON (e:Employee) ASSERT (e.firstname, e.surname) IS NODE KEYQuery Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+-----------------+------------------------------------------------------------------------+
| Operator | Details |
+-----------------+------------------------------------------------------------------------+
| +DropConstraint | CONSTRAINT ON (e:Employee) ASSERT (e.firstname, e.surname) IS NODE KEY |
+-----------------+------------------------------------------------------------------------+
Total database accesses: ?Create Relationship Property Existence Constraint
The CreateRelationshipPropertyExistenceConstraint operator creates an existence constraint with the name existence on a property for all relationships of a certain type.
This will only appear in Enterprise Edition.
Query
CREATE CONSTRAINT existence ON ()-[l:LIKED]-() ASSERT l.when IS NOT NULLQuery Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+-------------------+---------------------------------------------------------------------+
| Operator | Details |
+-------------------+---------------------------------------------------------------------+
| +CreateConstraint | CONSTRAINT existence ON ()-[l:LIKED]-() ASSERT (l.when) IS NOT NULL |
+-------------------+---------------------------------------------------------------------+
Total database accesses: ?Drop Relationship Property Existence Constraint
The DropRelationshipPropertyExistenceConstraint operator removes an existence constraint from a property for all relationships of a certain type.
This will only appear in Enterprise Edition.
Query
DROP CONSTRAINT ON ()-[l:LIKED]-() ASSERT exists(l.when)Query Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+-----------------+-----------------------------------------------------+
| Operator | Details |
+-----------------+-----------------------------------------------------+
| +DropConstraint | CONSTRAINT ON ()-[l:LIKED]-() ASSERT exists(l.when) |
+-----------------+-----------------------------------------------------+
Total database accesses: ?Drop Constraint by name
The DropConstraint operator removes a constraint using the name of the constraint, no matter the type.
Query
DROP CONSTRAINT nameQuery Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+-----------------+-----------------+
| Operator | Details |
+-----------------+-----------------+
| +DropConstraint | CONSTRAINT name |
+-----------------+-----------------+
Total database accesses: ?Listing constraints
The ShowConstraints operator lists constraints. It may include filtering on constraint type and can have either default or full output.
Query
SHOW CONSTRAINTSQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+------------------+---------------------------------------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+------------------+---------------------------------------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | id, name, type, entityType, labelsOrTypes, properties, ownedIndexId | 10 | 3 | 0 | 0/0 |
| | +---------------------------------------------------------------------+----------------+------+---------+------------------------+
| +ShowConstraints | allConstraints, defaultColumns | 10 | 3 | 1 | 0/0 |
+------------------+---------------------------------------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 1, total allocated memory: 64Create Index
The CreateIndex operator creates an index. This index can either be a b-tree, fulltext, or token lookup index.
The following query will create an index with the name my_index on the name property of nodes with the Country label.
Query
CREATE INDEX my_index FOR (c:Country) ON (c.name)Query Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+--------------+-----------------------------------------+
| Operator | Details |
+--------------+-----------------------------------------+
| +CreateIndex | INDEX my_index FOR (:Country) ON (name) |
+--------------+-----------------------------------------+
Total database accesses: ?Create Index only if it does not already exist
To not get an error creating the same index twice, we use the DoNothingIfExists operator for indexes.
This will make sure no other index with the given name or schema already exists before the CreateIndex operator creates an index.
If it finds an index with the given name or schema it will stop the execution and no new index is created.
The following query will create an index with the name my_index on the since property of relationships with the KNOWS relationship type only if no such index already exists.
Query
CREATE INDEX my_index IF NOT EXISTS FOR ()-[k:KNOWS]-() ON (k.since)Query Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+---------------------------+----------------------------------------------+
| Operator | Details |
+---------------------------+----------------------------------------------+
| +CreateIndex | INDEX my_index FOR ()-[:KNOWS]-() ON (since) |
| | +----------------------------------------------+
| +DoNothingIfExists(INDEX) | INDEX my_index FOR ()-[:KNOWS]-() ON (since) |
+---------------------------+----------------------------------------------+
Total database accesses: ?Drop Index by schema
The DropIndex operator removes an index from a property for all nodes having a certain label.
The following query will drop an index on the name property of nodes with the Country label.
Query
DROP INDEX ON :Country(name)Query Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+------------+--------------------------------+
| Operator | Details |
+------------+--------------------------------+
| +DropIndex | INDEX FOR (:Country) ON (name) |
+------------+--------------------------------+
Total database accesses: ?Drop Index by name
The DropIndex operator removes an index using the name of the index.
Query
DROP INDEX nameQuery Plan
Compiler CYPHER 4.3
Planner ADMINISTRATION
Runtime SCHEMA
Runtime version 4.3
+------------+------------+
| Operator | Details |
+------------+------------+
| +DropIndex | INDEX name |
+------------+------------+
Total database accesses: ?Listing indexes
The ShowIndexes operator lists indexes. It may include filtering on index type and can have either default or full output.
Query
SHOW INDEXESQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-----------------+----------------------------------------------------------------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+-----------------+----------------------------------------------------------------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | id, name, state, populationPercent, uniqueness, type, entityType, labelsOrTypes, properties, | 10 | 7 | 0 | 0/0 |
| | | indexProvider | | | | |
| | +----------------------------------------------------------------------------------------------+----------------+------+---------+------------------------+
| +ShowIndexes | allIndexes, defaultColumns | 10 | 7 | 1 | 0/0 |
+-----------------+----------------------------------------------------------------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 1, total allocated memory: 64Listing functions
The ShowFunctions operator lists functions.
It may include filtering on built-in vs user-defined functions as well as if a given user can execute the function.
The output can either be default or full output.
Query
SHOW FUNCTIONSQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-----------------+-----------------------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+-----------------+-----------------------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | name, category, description | 10 | 142 | 0 | 0/0 |
| | +-----------------------------------------------------+----------------+------+---------+------------------------+
| +ShowFunctions | allFunctions, functionsForUser(all), defaultColumns | 10 | 142 | 0 | 0/0 |
+-----------------+-----------------------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 0, total allocated memory: 64Listing procedures
The ShowProcedures operator lists procedures.
It may include filtering on whether a given user can execute the procedure and can have either default or full output.
Query
SHOW PROCEDURESQuery Plan
Compiler CYPHER 4.3
Planner COST
Runtime SLOTTED
Runtime version 4.3
+-----------------+----------------------------------------+----------------+------+---------+------------------------+
| Operator | Details | Estimated Rows | Rows | DB Hits | Page Cache Hits/Misses |
+-----------------+----------------------------------------+----------------+------+---------+------------------------+
| +ProduceResults | name, description, mode, worksOnSystem | 10 | 73 | 0 | 0/0 |
| | +----------------------------------------+----------------+------+---------+------------------------+
| +ShowProcedures | proceduresForUser(all), defaultColumns | 10 | 73 | 0 | 0/0 |
+-----------------+----------------------------------------+----------------+------+---------+------------------------+
Total database accesses: 0, total allocated memory: 64