Slow Neo4j queries 386
Individual slow Cypher on master over the last 1h —
by elapsed time, with the CPU / wait / page-hit profile so you can tell genuine compute from
lock-wait. Click a column to sort. Endpoint latency is a whole-request concern — see Calls.
| When | Service | Elapsed ▾ | CPU | Wait | Page hits | R/W | Query |
|---|---|---|---|---|---|---|---|
| 14m ago | tusker | 41.87 s | 41.14 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 15m ago | tusker | 41.77 s | 41.16 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 12m ago | tusker | 41.16 s | 40.54 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 43m ago | tusker | 39.94 s | 39.40 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 13m ago | tusker | 39.68 s | 39.30 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 54m ago | tusker | 39.52 s | 39.19 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 53m ago | tusker | 39.44 s | 39.00 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 39m ago | tusker | 39.40 s | 39.24 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 42m ago | tusker | 39.00 s | 38.69 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 46m ago | tusker | 38.80 s | 38.47 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 23m ago | tusker | 38.74 s | 38.61 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 49m ago | tusker | 38.49 s | 38.11 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 16m ago | tusker | 38.22 s | 37.93 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 41m ago | tusker | 37.99 s | 37.77 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 44m ago | tusker | 37.93 s | 37.69 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 19m ago | tusker | 37.79 s | 37.68 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 44m ago | tusker | 37.68 s | 37.53 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 38m ago | tusker | 37.68 s | 37.57 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 28m ago | tusker | 37.67 s | 37.53 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 30m ago | tusker | 37.62 s | 37.47 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 53m ago | tusker | 37.59 s | 37.47 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 25m ago | tusker | 37.46 s | 37.44 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 25m ago | tusker | 37.44 s | 37.34 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 52m ago | tusker | 37.40 s | 37.24 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 40m ago | tusker | 37.31 s | 37.16 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 26m ago | tusker | 37.30 s | 37.15 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 51m ago | tusker | 37.29 s | 36.97 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 17m ago | tusker | 37.19 s | 37.06 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 30m ago | tusker | 37.07 s | 36.91 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 55m ago | tusker | 36.98 s | 36.77 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 18m ago | tusker | 36.97 s | 36.80 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 37m ago | tusker | 36.76 s | 36.74 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 29m ago | tusker | 36.72 s | 36.58 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 20m ago | tusker | 36.68 s | 36.62 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 23m ago | tusker | 36.50 s | 36.48 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 27m ago | tusker | 36.45 s | 36.43 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 18m ago | tusker | 36.25 s | 36.23 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 50m ago | tusker | 35.59 s | 35.57 s | 0 ms | 76.2M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 13m ago | tusker | 31.81 s | 31.19 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 15m ago | tusker | 31.71 s | 31.17 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 43m ago | tusker | 30.41 s | 30.08 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 22m ago | tusker | 28.93 s | 28.78 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 17m ago | tusker | 28.21 s | 27.88 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 41m ago | tusker | 28.14 s | 27.91 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 45m ago | tusker | 28.13 s | 27.97 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 56m ago | tusker | 28.12 s | 27.91 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 49m ago | tusker | 27.95 s | 27.76 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 21m ago | tusker | 27.56 s | 27.45 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 26m ago | tusker | 27.52 s | 27.38 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 29m ago | tusker | 27.33 s | 27.23 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 28m ago | tusker | 27.18 s | 27.09 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 50m ago | tusker | 26.89 s | 26.76 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 54m ago | tusker | 26.89 s | 26.78 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 40m ago | tusker | 26.74 s | 26.61 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 19m ago | tusker | 26.47 s | 26.46 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 24m ago | tusker | 26.33 s | 26.32 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 38m ago | tusker | 26.15 s | 26.00 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 52m ago | tusker | 25.79 s | 25.78 s | 0 ms | 55.5M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 40m ago | tusker | 4.69 s | 4.68 s | 0 ms | 6.5M | read | MATCH (u:User) WHERE u.tildaid IN ["802e09b6-a691-43e8-b074-eeebe7fd84a8", "fe574b52-6583-4adb-934c-134557a1ae58", "76a0dd26-fcbb-4302-b3f7-2e6a97a5d2e6", "fe2807db-be4c-4bf8-be76-8f0e3cd38be6", "54360308-c922-4469-b092-b7557d745d3c", "5bb7a615-fac8-45ad-be2e-895996478e63", "1f7490de-da81-4d3c-a392-81846c981d31", "0c571e83-7b98-4eb9-a54e-25b9308a1e97", "18c4d845-1e69-4c35-af93-3a44e0845c3b", "c4f8ee50-af74-449d-ac9a-f1a6a43e40d1", "e6286ace-3a5c-4d3b-85da-ec7419555a78", "f53af341-2d24-4bdb-a494- |
| 14m ago | tusker | 2.52 s | 2.52 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 42m ago | tusker | 2.26 s | 2.13 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 16m ago | tusker | 2.08 s | 2.07 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 53m ago | tusker | 2.06 s | 1.92 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 18m ago | tusker | 2.01 s | 2.01 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 46m ago | tusker | 2.01 s | 2.01 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 25m ago | tusker | 1.98 s | 1.98 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 44m ago | tusker | 1.96 s | 1.87 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 49m ago | tusker | 1.95 s | 1.95 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 23m ago | tusker | 1.93 s | 1.93 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 12m ago | tusker | 1.92 s | 1.92 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 30m ago | tusker | 1.90 s | 1.90 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 19m ago | tusker | 1.86 s | 1.86 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 51m ago | tusker | 1.86 s | 1.86 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 38m ago | tusker | 1.86 s | 1.86 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 54m ago | tusker | 1.86 s | 1.86 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 28m ago | tusker | 1.85 s | 1.84 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 26m ago | tusker | 1.83 s | 1.83 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 40m ago | tusker | 1.82 s | 1.82 s | 0 ms | 3.8M | read |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)
WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:"User"}))
CALL {
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)
RETURN ptc, pw
UNION ALL
WITH t
MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskC |
| 40m ago | tusker | 1.26 s | 1.25 s | 0 ms | 1.4M | read | MATCH (u:User) WHERE u.tildaid IN ["6d40cfe3-9962-416c-b8bc-1e09e7b618bd", "0c571e83-7b98-4eb9-a54e-25b9308a1e97", "b0e3095c-7d89-4eb0-822b-48389b955d10", "c4f8ee50-af74-449d-ac9a-f1a6a43e40d1", "00e5b984-bfaa-4082-89ad-292f6c92da64", "3545204e-b5ed-4b7d-9a68-3e92605d83d7", "d58fd312-3825-4c84-8ed0-12b29d29d566", "a7f0e051-1555-4dcb-bad7-960ed04c8521", "e6286ace-3a5c-4d3b-85da-ec7419555a78", "e61e9e50-847e-40a8-b5eb-b634dd7d3149", "28fe4c9d-23c7-40ec-b74b-3196aabfd486", "39ecdc50-faf3-468a-ad73- |
| 55m ago | regsvc | 1.19 s | 1.02 s | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 43m ago | regsvc | 1.17 s | 997 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 40m ago | tusker | 876 ms | 875 ms | 0 ms | 46k | read | match (task:Task) where task.tildaid in ["573cdd4d-582a-4bd1-a7d8-638fe9e8a237","c1ce1409-e3ad-4b29-91a5-ce006c2e2ad6","092dddf6-1928-4525-adf2-36a3b07ac8a4","d0006b97-758a-4d33-b789-1c92db5748de","d75c20f7-214b-4fb3-b762-3b98cd97b7c4","e8471d7e-0882-490d-ad78-33865cb3c48c","bc7d6575-86d7-4edb-bf12-7710fbb78aa2","926e710d-bb17-41d9-8226-43dcce15e4e8","a525d1ee-cc37-4934-8562-65d50b8a21dd","aa68abfb-73f7-4a33-90cc-c50d2d30facf","2b97b52f-587b-4f49-a118-dd848915fdd3","754f35b2-dc01-4a55-9dd1-cda03 |
| 40m ago | docproc | 748 ms | 748 ms | 0 ms | 156k | read |
MATCH (o:Organization{orgType:"CRO"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)
WHERE f.name IN ['Staging', 'Pre-Staging']
AND d.delpending = false AND d.aiEnabled = true AND d.studyId <> ""
AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId <> ""
OPTIONAL MATCH (d)<-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)
WITH o, d, ai
ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC
WITH o, d, collect(ai)[0] AS latest_ai
WHERE (
|
| 23m ago | regsvc | 725 ms | 724 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 13m ago | regsvc | 637 ms | 637 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 53m ago | regsvc | 619 ms | 618 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 40m ago | tusker | 616 ms | 615 ms | 0 ms | 787k | read | MATCH (u:User) WHERE u.tildaid IN ["4c94903b-a875-4c88-8bd2-3b6acaf96642", "0c571e83-7b98-4eb9-a54e-25b9308a1e97", "3545204e-b5ed-4b7d-9a68-3e92605d83d7", "d58fd312-3825-4c84-8ed0-12b29d29d566", "a7f0e051-1555-4dcb-bad7-960ed04c8521", "e6286ace-3a5c-4d3b-85da-ec7419555a78", "54360308-c922-4469-b092-b7557d745d3c", "7c6069b8-9ea8-40b4-a4ed-0c23b0a53721", "8b63a938-e48f-4314-8d00-fac613837ceb", "544a29e9-6ce6-4ada-9ded-5a6148a50cc9", "a7c3b005-ea12-4235-9cf1-8f24e1e9216e", "2c5c9a15-b2e1-4113-b9dc- |
| 51m ago | regsvc | 614 ms | 614 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 49m ago | regsvc | 599 ms | 599 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 17m ago | regsvc | 596 ms | 595 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 21m ago | regsvc | 575 ms | 574 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 15m ago | regsvc | 573 ms | 573 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 45m ago | regsvc | 568 ms | 567 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 27m ago | regsvc | 563 ms | 563 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 41m ago | regsvc | 539 ms | 539 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 29m ago | regsvc | 533 ms | 533 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 39m ago | regsvc | 530 ms | 529 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 19m ago | regsvc | 516 ms | 516 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 25m ago | regsvc | 511 ms | 511 ms | 0 ms | 613k | read |
// First part for StudySiteUser scope
match (o:Organization{orgType:"SMO"})-[:STUDY_TO_ORG]-(st:Study)
match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:"Site"})-[:PLAN_DEFINITION_TO_SITE]-(site:Site)
match (st)-[:PLAN_DEFINITION_TO_STUDY]-(sitePd)
match (sitePd)-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]-(w:WorkflowV2)
match (t:Trigger{scope:"StudySiteUser"})-[:TRIGGER_TO_WORKF |
| 40m ago | tusker | 499 ms | 278 ms | 0 ms | 273k | read |
match (task:Task{assignment:'automatic'})
where (task.state = "ready" or task.state = "draft")
and not exists (
(task)-[:CREATED_FROM_SPEC]-(:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)
)
and not exists (
(task)<-[:CREATED_FROM_SPEC]-(:ParticipantDslSpecNode)<-[:PARTICIPANT_DSLTASK_TO_ALL_PARTICIPANT_DSLSPECNODE]-(:ParticipantDslTask)<-[:PARTICIPANT_DSLTASK]-(:ParticipantControl)
)
match ( |
386 slow queries · 100/page · Elapsed total; CPU ≈ elapsed (red) = genuine compute — check Page hits (millions = full scan / missing index); high Wait (amber) = blocked on locks. A — profile is an older row awaiting backfill (new rows are profiled at ingest).