Profiling

Profiling a query

Run this query:

cypher
PROFILE MATCH (p:Person)-[:ACTED_IN]->(m:Movie)
WHERE p.name = 'Clint Eastwood'
AND NOT exists {(p)-[:DIRECTED]->(m)}
RETURN m.title

What is the total number of db hits when this query executes?

  • ✓ 489

Hint

When you view the query plan view in Neo4j Browser, the bottom panel displays the total db hits for the query that executed.

Once you have entered the answer, click the Try Again button below to continue.

Solution

The correct answer is: 489

Once you have entered the answer, click the Try Again button below to continue.

Summary

In this challenge, you profiled a query.

In the next lesson, you will learn about using multiple MATCH clauses.