Slow Neo4j queries 2,147
Individual slow Cypher on master over the last 6h —
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 |
|---|---|---|---|---|---|---|---|
| 4h ago | docproc | 160 ms | 160 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 (
|
| 4h ago | docproc | 160 ms | 160 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 (
|
| 4h ago | docproc | 160 ms | 160 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 (
|
| 4h ago | docproc | 160 ms | 160 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 (
|
| 4h ago | docproc | 160 ms | 160 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 (
|
| 4h ago | docproc | 160 ms | 160 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 (
|
| 4h ago | docproc | 160 ms | 160 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 (
|
| 5h ago | docproc | 160 ms | 160 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 (
|
| 5h ago | docproc | 160 ms | 160 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 (
|
| 5h ago | docproc | 160 ms | 160 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 (
|
| 5h ago | docproc | 160 ms | 160 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 (
|
| 5h ago | docproc | 160 ms | 160 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 (
|
| 5h ago | docproc | 160 ms | 159 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 (
|
| 5h ago | docproc | 160 ms | 160 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 (
|
| 49m ago | docproc | 159 ms | 159 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 (
|
| 2h ago | docproc | 159 ms | 159 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 (
|
| 2h ago | docproc | 159 ms | 159 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 (
|
| 2h ago | docproc | 159 ms | 159 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 (
|
| 3h ago | docproc | 159 ms | 158 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 (
|
| 3h ago | docproc | 159 ms | 159 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 (
|
| 3h ago | docproc | 159 ms | 159 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 (
|
| 3h ago | docproc | 159 ms | 159 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 (
|
| 3h ago | docproc | 159 ms | 159 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 (
|
| 3h ago | docproc | 159 ms | 159 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 (
|
| 4h ago | docproc | 159 ms | 159 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 (
|
| 4h ago | docproc | 159 ms | 159 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 (
|
| 4h ago | docproc | 159 ms | 159 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 (
|
| 4h ago | docproc | 159 ms | 159 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 (
|
| 4h ago | docproc | 159 ms | 159 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 (
|
| 4h ago | docproc | 159 ms | 159 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 (
|
| 4h ago | docproc | 159 ms | 159 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 (
|
| 5h ago | docproc | 159 ms | 159 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 (
|
| 5h ago | docproc | 159 ms | 159 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 (
|
| 5h ago | docproc | 159 ms | 159 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 (
|
| 5h ago | docproc | 159 ms | 159 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 (
|
| 18m ago | docproc | 158 ms | 157 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 (
|
| 3h ago | docproc | 158 ms | 158 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 (
|
| 4h ago | docproc | 158 ms | 158 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 (
|
| 4h ago | docproc | 158 ms | 158 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 (
|
| 4h ago | docproc | 158 ms | 158 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 (
|
| 5h ago | docproc | 158 ms | 158 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 (
|
| 5h ago | docproc | 158 ms | 158 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 (
|
| 5h ago | docproc | 158 ms | 158 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 (
|
| 1h ago | execsvc | 157 ms | 157 ms | 0 ms | 51k | read |
MATCH (pv:ParticipantVisit)
WHERE (pv.edcStatus IS NULL OR pv.edcStatus = "" OR pv.edcStatus = "Not Started" OR pv.edcStatus = "InProgress")
AND (pv.status = "InProgress" OR pv.status = "CompletedOffline")
AND pv.deltimestamp = 0
MATCH (cp:CarePlan {tildaid: pv.carePlanId})-[:EXECUTE_SOA]-
(soa:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]-
(pd:DslPlanDefinition)
MATCH (pd)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study)
MATCH (pd)-[:PLAN_DEFINITION_TO_SITE]-(site:Site)-[:SIT |
| 4h ago | docproc | 157 ms | 157 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 (
|
| 18m ago | docproc | 156 ms | 156 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 (
|
| 4h ago | docproc | 156 ms | 156 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 (
|
| 4h ago | docproc | 156 ms | 156 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 (
|
| 4h ago | docproc | 156 ms | 156 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 (
|
| 24m ago | docproc | 154 ms | 147 ms | 0 ms | 1k | read |
MATCH (s:Study {tildaid:$studyId})-[:USES]->(fm:FolderManager {name:'StudyInstance'})
MATCH (fm)-[:INCLUDES]->(f0:Folder)
MATCH (f0)-[:INCLUDES]->(zone:Folder)
MATCH (zone)-[:INCLUDES]->(section:Folder)
MATCH (section)-[:INCLUDES]->(artifact:Folder)
WHERE zone.number = $zoneNum AND section.number = $sectionNum AND artifact.number = $artifactNum
OPTIONAL MATCH (artifact)-[:INCLUDES]->(sa:SubArtifact)
OPTIONAL MATCH (sa)-[:HAS]->(saFC:Fold |
| 1h ago | docproc | 135 ms | 135 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 |
| 4h ago | virtual-assistant | 135 ms | 1 ms | 0 ms | 7 | read |
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact)
WHERE f.delpending = false
RETURN f
ORDER BY f.createdat ASC
|
| 3h ago | docproc | 134 ms | 134 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 |
| 3h ago | tusker | 134 ms | 133 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 |
| 5h ago | docproc | 134 ms | 134 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 |
| 1h ago | docproc | 133 ms | 133 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 |
| 2h ago | docproc | 133 ms | 133 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 |
| 1h ago | virtual-assistant | 132 ms | 2 ms | 0 ms | 7 | read |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity)
WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses
RETURN count(a) as total
|
| 4h ago | virtual-assistant | 132 ms | 0 ms | 0 ms | 7 | read |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity)
WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses
RETURN count(a) as total
|
| 1h ago | docproc | 131 ms | 130 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
|
| 2h ago | docproc | 131 ms | 131 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 |
| 45m ago | virtual-assistant | 130 ms | 0 ms | 0 ms | 7 | read |
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact)
WHERE f.delpending = false
RETURN f
ORDER BY f.createdat ASC
|
| 4h ago | docproc | 129 ms | 128 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 |
| 3h ago | docproc | 127 ms | 127 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 |
| 2h ago | tusker | 126 ms | 126 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 |
| 4h ago | tusker | 126 ms | 125 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 |
| 5h ago | docproc | 125 ms | 125 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 |
| 1h ago | tusker | 122 ms | 122 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 |
| 4h ago | docproc | 122 ms | 122 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 |
| 1h ago | tusker | 119 ms | 119 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 |
| 1h ago | docproc | 118 ms | 118 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 |
| 5h ago | docproc | 118 ms | 118 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 |
| 2h ago | tusker | 117 ms | 117 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 |
| 3h ago | tusker | 117 ms | 116 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 |
| 5h ago | tusker | 117 ms | 117 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 |
| 1h ago | docproc | 116 ms | 115 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 |
| 1h ago | docproc | 116 ms | 116 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 |
| 2h ago | virtual-assistant | 116 ms | 0 ms | 0 ms | 9 | read |
MATCH (wo:WorkOrder {tildaid: $wo_id})
OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity {activity_type: 'U_REPLY'})
RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts
|
| 4h ago | docproc | 116 ms | 116 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 |
| 5h ago | docproc | 116 ms | 116 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 |
| 2h ago | docproc | 115 ms | 115 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 |
| 4h ago | virtual-assistant | 115 ms | 1 ms | 0 ms | 5 | read |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity)
WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses
OPTIONAL MATCH (d:Document)
WHERE d.tildaid IN COALESCE(a.docIds, [])
WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents
// Compute latest AI_MSG draft id per work order for gating REGENERATE
OPTIONAL MATCH (w) |
| 3h ago | docproc | 114 ms | 114 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 |
| 5h ago | tusker | 114 ms | 113 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 |
| 5h ago | docproc | 114 ms | 114 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 |
| 1h 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 |
| 2h ago | docproc | 113 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 |
| 3h 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 |
| 4h ago | virtual-assistant | 113 ms | 0 ms | 0 ms | 8 | read |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity)
WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses
RETURN count(a) as total
|
| 5h ago | tusker | 113 ms | 113 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 |
| 2h 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 |
| 4h ago | tusker | 112 ms | 111 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 |
| 1h ago | tusker | 111 ms | 111 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 |
| 2h 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 |
| 2h 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 |
| 2h 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 |
| 4h 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 |
| 5h 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 |
| 1h ago | docproc | 110 ms | 110 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 |
| 5h ago | docproc | 110 ms | 109 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 |
2,147 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).