Xray · see through your fleet
1h 6h 24h 48h 3d
custom ▾
updated 5m ago

Slow Neo4j queries 433

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
59m ago docproc 113 ms 113 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
39m ago docproc 112 ms 112 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
15m ago docproc 111 ms 111 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
54m ago tusker 109 ms 109 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
24m ago docproc 108 ms 62 ms 0 ms 67k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) RETURN count(ai) AS total
25m ago docproc 108 ms 107 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
27m ago tusker 107 ms 106 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
32m ago tusker 107 ms 106 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
42m ago docproc 107 ms 107 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
16m ago tusker 106 ms 106 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
46m ago tusker 106 ms 106 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
27m ago docproc 105 ms 105 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
28m ago docproc 105 ms 105 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
32m ago tusker 104 ms 104 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
47m ago tusker 104 ms 103 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
49m ago docproc 104 ms 103 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
51m ago tusker 104 ms 103 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
51m ago tusker 104 ms 104 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
12m ago docproc 103 ms 102 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
35m ago tusker 103 ms 102 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
47m ago docproc 103 ms 102 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
29m ago docproc 102 ms 102 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
29m ago docproc 102 ms 102 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
29m ago docproc 102 ms 102 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
35m ago tusker 102 ms 101 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
56m ago tusker 102 ms 102 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
14m ago docproc 101 ms 101 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
18m ago tusker 101 ms 101 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
25m ago tusker 101 ms 101 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
34m ago docproc 101 ms 101 ms 0 ms 90k read MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = "in_progress" AND ($cutoff_ms <= 0 OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = "aborted" ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type, o.tildaid AS org_id, o.alias AS or
37m ago tusker 101 ms 101 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
59m ago tusker 101 ms 100 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC
47m ago tusker 100 ms 100 ms 0 ms 72k read match (task:Task{assignment:'automatic'}) where (task.state = "ready" or task.state = "draft") and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:'User'})) and coalesce(task.dist_deferred, false) = false 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_PARTIC

433 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).