When to Use - Query takes unexpectedly long; need root-cause analysis - EXPLAIN/PROFILE output in hand — needs interpretation - Identifying which index is missing or unused - Deciding between slotted / pipelined / parallel runtimes - Monitoring live queries: SHOW QUERIES, SHOW TRANSACTIONS - Cardinality estimates wrong (plan replanning needed) When NOT to Use - Writing Cypher from scratch → - GDS algorithm performance → - Schema design / data modelling → --- EXPLAIN vs PROFILE | | EXPLAIN | PROFILE | |---|---|---| | Executes query? | No | Yes | | Returns data? | No | Yes | | Shows (actual) |…