If you wish to set a ‘breakpoint’ in a Cypher statement so as to perform further analysis (i.e. see how many locks are taken, memory utilization) one can add a call to apoc.utils.sleep(XXX) which will result in the query sleeping for XXXX msec.
will run the MERGE statement with its ‘set’ operation and then ‘pause’ for 10000 miliseconds (i.e. 10 seconds) and then return.
Further one could run
which will run the MERGE statement, then ‘pause’ for 10000 miliseconds and then run its ‘set’ operation on the property.