Query trends 79
Neo4j query shapes on master over the last 48h, grouped by plan hash.
Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.
| Query shape | Count | Avg | p95 | Max | p95 drift ▾ |
|---|---|---|---|---|---|
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask)-[:TASK_HAS_SUBTASK]->(s:WorkOrderSubtask) WHERE coalesce(t.status, ?) <> ? AND coalesce(s.is_optional, false) = false AND coalesce(s.status, ?) <> ? AND (coalesce(s.expects_document, false) = true OR s.expects_document IS NULL OR s.p |
21 | <1 ms | 2 ms | 1 ms | 1.6× ↑ |
MATCH (org:Organization) WITH org MATCH (task:Task)-[:BELONGS_TO]->(inbox:Inbox{type:?})-[:MANAGED_BY]->(org) WHERE task.task_number IS NULL OR task.task_number = ? WITH org, task ORDER BY org.alias, task.createdat WITH org, collect(task) as tasks CALL { WITH org MATCH (t:Task)-[:BELONGS_TO]->(:Inbox{type:?})-[:MANAGED write |
80 | 76 ms | 143 ms | 109 ms | 1.5× ↑ |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask) RETURN t.status AS status, count(t) AS cnt |
21 | <1 ms | 1 ms | 1 ms | 1.5× ↑ |
MATCH (b:Budget) WHERE b.status = ? AND date(b.effectiveDate) <= date() RETURN b.tildaid |
156 | <1 ms | 2 ms | 2 ms | 1.3× ↑ |
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact) WHERE f.delpending = false RETURN f ORDER BY f.createdat ASC |
60,215 | <1 ms | 1 ms | 135 ms | 1.2× ↑ |
MATCH (wo:WorkOrder {tildaid: $wo_id}) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity {activity_type: ?}) RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts |
56,875 | <1 ms | 2 ms | 92 ms | flat |
MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n |
60,662 | <1 ms | 2 ms | 204 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND a.activity_type IN $activity_types AND a.status IN $statuses RETURN count(a) as total |
57,285 | <1 ms | 2 ms | 200 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? 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, contentTy |
61,068 | <1 ms | 2 ms | 115 ms | flat |
MATCH (w:WorkOrder {tildaid: $wo})-[:WORK_ORDER_TO_ORGANIZATION]->(o:Organization) RETURN COALESCE(o.reminderApprovalRequired, true) AS approval_required |
437 | <1 ms | 1 ms | 1 ms | flat |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task) WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:?})) CALL { WITH t MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:Parti |
83 | 1.91 s | 4.11 s | 2.38 s | flat |
match (task:Task{assignment:?}) where (task.state = ? or task.state = ?) and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:?})) and coalesce(task.dist_deferred, false) = false and not exists ( (task)-[:CREATED_FROM_SPEC]-(:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-( |
41 | 105 ms | 192 ms | 170 ms | flat |
UNWIND $site_ids AS sid OPTIONAL MATCH (s:Site {tildaid: sid, delpending: false}) OPTIONAL MATCH (s)<-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study {tildaid: $study_id, delpending: false}) OPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]->(actor:Actor { |
1,200 | <1 ms | 2 ms | 3 ms | flat |
MATCH (r:TmfEvaluationRun {status: $running}) WHERE r.deltimestamp = ? AND coalesce(r.updatedat, r.createdat) < $cutoff RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion ORDER BY coalesce(r.updatedat, r.createdat) ASC LIMIT $limit |
72 | <1 ms | 2 ms | 1 ms | flat |
match (task:Task{assignment:?}) where (task.state = ? or task.state = ?) and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:?})) and coalesce(task.dist_deferred, false) = false and not exists ( (task)-[:CREATED_FROM_SPEC]-(:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-( |
37 | 105 ms | 194 ms | 126 ms | flat |
MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = ? AND ($cutoff_ms <= ? OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = ? ) RETURN count(ai) AS total |
564 | 68 ms | 98 ms | 313 ms | flat |
match (u:User{tildaid:?})<-[:OWNED_BY]-(i:Inbox{type:?}) where u.email = i.name return i |
168 | <1 ms | 2 ms | 1 ms | flat |
RETURN ? as health_check |
1,312 | <1 ms | <1 ms | 4 ms | flat |
MATCH (cfg:WorkplanCfg{tildaid:?})-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) RETURN study.tildaid as studyId |
2,735 | <1 ms | 2 ms | 2 ms | flat |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task) WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:?})) CALL { WITH t MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:Parti |
84 | 37.36 s | 29.00 s | 43.34 s | flat |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task) WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:?})) CALL { WITH t MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:Parti |
81 | 37.62 s | 29.00 s | 44.11 s | flat |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task) WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:?})) CALL { WITH t MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:Parti |
83 | 27.24 s | 29.00 s | 31.32 s | flat |
MATCH (t:Task)-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(ptl:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(pa:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]->(pw:ParticipantWorkflow) WHERE t.state IN [?, ?] AND ptc.status <> ? RETURN DISTINCT t.tildaid UNION MATCH (t:Task)-[:CREATED_FROM |
40 | 7 ms | 10 ms | 9 ms | flat |
MATCH (t:Task)-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(ptl:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(pa:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]->(pw:ParticipantWorkflow) WHERE t.state IN [?, ?] AND ptc.status <> ? RETURN DISTINCT t.tildaid UNION MATCH (t:Task)-[:CREATED_FROM |
37 | 6 ms | 10 ms | 8 ms | flat |
MATCH (wo:WorkOrder)-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity {activity_type:?}) WHERE a.processing_status = ? AND coalesce(a.retry_count,?) < ? AND (a.last_attempt_at IS NULL OR a.last_attempt_at < $cutoff) AND a.timestamp < $cutoff WITH wo, a ORDER BY a.timestamp ASC WITH wo, head(collect(a)) AS oldest RETURN |
28 | 5 ms | 10 ms | 7 ms | flat |
MATCH (w:WorkOrder {tildaid: $wo}) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_STUDY]->(s:Study) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_SITE]->(site:Site) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_CREATOR]->(creator:User) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ASSIGNEE]->(assignee:User) OPTIONAL MATCH (resolver:User {tildaid: w.resolved_by}) |
21 | 2 ms | 5 ms | 4 ms | flat |
// First part for StudySiteUser scope match (o:Organization{orgType:?})-[:STUDY_TO_ORG]-(st:Study) match (st)-[:STUDY_TO_ACTOR]-(actor:Actor{delpending:false})-[:STUDYSITEACTOR_TO_ACTOR]-(scopeUser:StudySiteActor{delpending:false})--(sitePd:DslPlanDefinition{type:?})-[:PLAN_DEFINITION_TO_SITE]-(site:Site) match (st)-[: |
78 | 567 ms | 974 ms | 869 ms | flat |
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_INSTANCE]->(wp:WorkPlanInstance{tildaid:?}) RETURN org.tildaid as oid |
579 | 1 ms | 2 ms | 2 ms | flat |
match(a:AdvRateRule{deleted:true})-[r]-(b) with distinct a return a.portalorgid, a.tildaid, a.ruletype limit ? |
1,688 | 2 ms | 5 ms | 6 ms | flat |
MATCH (wp:WorkPlanInstance) WHERE wp.instanceReadyDeterminationState = ? AND wp.state <> ? RETURN wp.tildaid AS id ORDER BY coalesce(wp.instanceReadyDeterminationUpdatedAt, ?) ASC LIMIT ? |
290 | 1 ms | 2 ms | 4 ms | flat |
UNWIND $site_ids AS sid OPTIONAL MATCH (s:Site {tildaid: sid, delpending: false}) OPTIONAL MATCH (s)<-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study {tildaid: $study_id, delpending: false}) OPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]->(actor:Actor { |
1,535 | 1 ms | 2 ms | 2 ms | flat |
MATCH (wo:WorkOrder)-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity {activity_type:?}) WHERE a.processing_status = ? AND coalesce(a.retry_count,?) < ? AND (a.last_attempt_at IS NULL OR a.last_attempt_at < $cutoff) WITH wo, a ORDER BY a.timestamp ASC WITH wo, head(collect(a)) AS oldest RETURN wo.tildaid AS work_order_i |
28 | 5 ms | 10 ms | 6 ms | flat |
MATCH (org:Organization)<-[:WORK_ORDER_TO_ORGANIZATION]-(w:WorkOrder {status:?}) RETURN org.tildaid AS org_id, collect(w.tildaid) AS wo_ids |
138 | 10 ms | 19 ms | 15 ms | flat |
RETURN EXISTS { MATCH (inst:WorkPlanInstance) WHERE coalesce(inst.progressSummariesPending, false) = true } AS progressPending, EXISTS { MATCH (item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.workOrderId, ?) <> ? AND coalesce(item.activationPending, false) = true AND coalesce(item.activati |
290 | 5 ms | 9 ms | 8 ms | flat |
RETURN ? |
1,312 | <1 ms | <1 ms | 3 ms | flat |
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(m:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.workOrderActivationFailedAt, ?) > ? AND coalesce(item.workOrderAc |
273 | 6 ms | 10 ms | 13 ms | flat |
MATCH (wp:WorkPlanInstance) WHERE wp.instanceReadyDeterminationState IN [?, ?] AND wp.state <> ? OPTIONAL MATCH (wp)<-[:WORKPLAN_JOB_TO_OBJ]-(job:WorkplanJob) WITH wp, count(job) AS jobN WHERE jobN = ? RETURN wp.tildaid AS id LIMIT ? |
290 | 1 ms | 4 ms | 6 ms | flat |
MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND wp.state <> ? AND coalesce(item.workOrderId, ?) <> ? AND coalesce(item.activationPending, false) = true AND coalesce(item.activ |
274 | 7 ms | 10 ms | 13 ms | flat |
CREATE (a:WorkplanInstanceEvent{deltimestamp:?}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=?,a.delpending=false,a.instanceId=?,a.orgId=?,a.eventType=?,a.requestId=?,a.summary=?,a.payloadJson=? RETURN a.tildaid, a.createdat write |
578 | <1 ms | <1 ms | 1 ms | flat |
MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document) WHERE d.aiEnabled = true AND ( (ai.status = ? AND ($cutoff_ms <= ? OR COALESCE(ai.updatedat, ai.createdat) < $cutoff_ms)) OR ai.status = ? ) MATCH (d)-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id, ai.tildaid |
436 | 94 ms | 173 ms | 235 ms | flat |
MATCH (instance:WorkPlanInstance{tildaid:?})-[:WORKPLAN_TO_SITE]->(site:Site) RETURN site.tildaid as siteId |
2,735 | 1 ms | 2 ms | 186 ms | flat |
MATCH (wp:WorkPlanInstance{tildaid:?})-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.workOrderCompletedAt, ?) |
547 | 1 ms | 4 ms | 2 ms | flat |
MATCH (o:Organization {tildaid: $org_id}) WHERE o.alias <> ? RETURN o.alias as alias, coalesce(o.aiTeammateName, ?) as aiTeammateName, coalesce(o.aiTeammateEmail, ?) as aiTeammateEmail |
23 | <1 ms | <1 ms | 1 ms | 0.8× ↓ |
MATCH (o:Organization{orgType:?})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder) WHERE f.name IN [?, ?] 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 |
436 | 175 ms | 299 ms | 554 ms | 0.8× ↓ |
MATCH (o:Organization{orgType:?})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder) WHERE f.name IN [?, ?] 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 |
564 | 176 ms | 331 ms | 367 ms | 0.7× ↓ |
MATCH (a:WorkOrderActivity {tildaid: ?}) WHERE a.activity_type <> ? OPTIONAL MATCH (wo:WorkOrder)-[:WORK_ORDER_TO_ACTIVITY]->(a) WITH a, head(collect(wo)) AS wo OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ORGANIZATION]->(org:Organization) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_STUDY]->(study:Study) OPTIONAL MATCH (wo)-[:WORK_ORDE write |
2 | 46 ms | 95 ms | 54 ms | 0.5× ↓ |
MATCH (w:WorkOrder {tildaid: $work_order_id}) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ORGANIZATION]->(org:Organization) OPTIONAL MATCH (w)-[r:WORK_ORDER_TO_DOCUMENT]->(doc:Document) OPTIONAL MATCH (doc)<-[:RECOMMENDATION_TO_DOCUMENT]-(rec:Recommendation) WHERE toLower(coalesce(rec.category,?)) = ? AND toLower(coalesce(rec.s |
21 | 3 ms | 8 ms | 7 ms | 0.5× ↓ |
match (pv:ParticipantVisit)-[:BELONGS_TO_PARTICIPANT_VISIT]-(v:VisitAppointment)-[:VISIT_APPOINTMENT_TO_CARE_PLAN]-(c:CarePlan)-[:RESEARCH_SUBJECT] -(p:Patient)-[:HAS_PROTECTED_DATA_IN]-(phi:Phi) where c.status IN [?,?] and v.startTime >= datetime({epochMillis:?}) and v.startTime <= datetime({epochMillis:?}) match (c)- |
11 | 17 ms | 42 ms | 23 ms | 0.4× ↓ |
match (pv:ParticipantVisit)-[:BELONGS_TO_PARTICIPANT_VISIT]-(v:VisitAppointment)-[:VISIT_APPOINTMENT_TO_CARE_PLAN]-(c:CarePlan)-[:RESEARCH_SUBJECT] -(p:Patient)-[:HAS_PROTECTED_DATA_IN]-(phi:Phi) where c.status IN [?,?] and v.startTime >= datetime({epochMillis:?}) and v.startTime <= datetime({epochMillis:?}) match (c)- |
9 | 18 ms | 77 ms | 52 ms | 0.2× ↓ |
MATCH (w:WorkOrder {tildaid:$wo})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity {activity_type:?}) WITH a ORDER BY coalesce(a.last_attempt_at, a.createdat) DESC RETURN a.errors AS errors, a.retry_count AS retry_count LIMIT ? |
21 | 3 ms | 2 ms | 67 ms | 0.0× ↓ |
MATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task) WHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:?})) CALL { WITH t MATCH (t)<-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:Parti |
1 | 44.05 s | 29.00 s | 44.05 s | flat |
WITH ? as total, null as vector MATCH (doc:Document) WHERE doc.tildaid in [?] MATCH (org:Organization{tildaid:?}) OPTIONAL MATCH (study:Study{tildaid:doc.studyId}) CALL { RETURN [] AS policies, [] AS userSiteIds, [] AS userCountryIds, false AS hasReadOnlyRole } CALL { with org, doc WITH org, doc as doc0 match (org)<-[: |
2 | 494 ms | 950 ms | 503 ms | flat |
WITH ? as total, null as vector MATCH (doc:Document) WHERE doc.tildaid in [?] MATCH (org:Organization{tildaid:?}) OPTIONAL MATCH (study:Study{tildaid:doc.studyId}) CALL { RETURN [] AS policies, [] AS userSiteIds, [] AS userCountryIds, false AS hasReadOnlyRole } CALL { with org, doc WITH org, doc as doc0 match (org)<-[: |
4 | 270 ms | 485 ms | 284 ms | flat |
MATCH (pv:ParticipantVisit) WHERE (pv.edcStatus IS NULL OR pv.edcStatus = ? OR pv.edcStatus = ? OR pv.edcStatus = ?) AND (pv.status = ? OR pv.status = ?) AND pv.deltimestamp = ? MATCH (cp:CarePlan {tildaid: pv.carePlanId})-[:EXECUTE_SOA]- (soa:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]- (pd:DslPlanDefinition) MATC |
1 | 134 ms | 195 ms | 134 ms | flat |
MATCH (wo:WorkOrder {tildaid: ?}) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ORGANIZATION]->(org:Organization) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_STUDY]->(study:Study) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_SITE]->(site:Site) // Template lineage: WorkOrder.parent_id -> WorkOrderConfig -> WorkOrderTemplate. // Null for standalon write |
1 | 46 ms | 48 ms | 46 ms | flat |
MATCH (wo:WorkOrder {tildaid: ?}) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ORGANIZATION]->(org:Organization) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_STUDY]->(study:Study) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_SITE]->(site:Site) // Template lineage: WorkOrder.parent_id -> WorkOrderConfig -> WorkOrderTemplate. // Null for standalon write |
2 | 27 ms | 48 ms | 30 ms | flat |
MATCH (wo:WorkOrder {tildaid: ?}) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ORGANIZATION]->(org:Organization) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_STUDY]->(study:Study) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_SITE]->(site:Site) // Template lineage: WorkOrder.parent_id -> WorkOrderConfig -> WorkOrderTemplate. // Null for standalon write |
4 | 8 ms | 44 ms | 27 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[r:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $document_id}) OPTIONAL MATCH (a:WorkOrderActivity)-[:WORK_ORDER_ACTIVITY_TO_DOCUMENT]->(d) WITH d, r, collect(a) AS acts WITH d, r, head([x IN acts WHERE coalesce(x.sender,?) <> ? | x.sender]) AS sender_value OPTIONAL MATCH |
12 | 4 ms | 32 ms | 21 ms | flat |
MATCH(a:Task{tildaid:?}) WHERE a.updatedat=? SET a.updatedat=timestamp(),a.holdbitmap=?,a.delpending=false,a.title=?,a.description=?,a.category=?,a.active_after=datetime({epochMillis:?}),a.due_before=datetime({epochMillis:?}),a.priority=?,a.state=?,a.blob=?,a.assignment=?,a.closedBy=?,a.relationshipContext=?,a.task_num write |
1 | 15 ms | 20 ms | 15 ms | flat |
MATCH(a:Task{tildaid:?}) WHERE a.updatedat=? SET a.updatedat=timestamp(),a.holdbitmap=?,a.delpending=false,a.title=?,a.description=?,a.category=?,a.active_after=datetime({epochMillis:?}),a.due_before=datetime({epochMillis:?}),a.priority=?,a.state=?,a.blob=?,a.assignment=?,a.closedBy=?,a.relationshipContext=?,a.task_num write |
1 | 19 ms | 20 ms | 19 ms | flat |
MATCH (i:EmailIntake) WHERE i.state = $state AND coalesce(i.last_user_reply_at, i.created_at_ms) IS NOT NULL AND coalesce(i.last_user_reply_at, i.created_at_ms) < $cutoff RETURN i AS i |
2 | 8 ms | 19 ms | 17 ms | flat |
MATCH (item:WorkplanInstanceMilestoneItem{workOrderId:?})<-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]-(m:WorkPlanMilestone)<-[:WORKPLAN_INSTANCE_TO_MILESTONE]-(wp:WorkPlanInstance) RETURN wp.tildaid as instanceId, item.tildaid as instanceMilestoneItemId |
1 | 9 ms | 10 ms | 9 ms | flat |
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:?}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) MATCH (o:Organization{delpending:false, alias:?}) return currentUser as user, o as org, currentUser as tokenUser |
2 | 4 ms | 10 ms | 6 ms | flat |
MATCH(a:Actor{orgId:?,scopeId:?,userId:?,delpending:false}) RETURN a |
3 | 2 ms | 9 ms | 5 ms | flat |
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:?}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) MATCH (o:Organization{delpending:false, alias:?}) return currentUser as user, o as org, currentUser as tokenUser |
4 | 3 ms | 9 ms | 9 ms | flat |
MATCH (a:WorkOrder {tildaid: $from_id}) MATCH (b:Document {tildaid: $to_id}) MERGE (a)-[r:WORK_ORDER_TO_DOCUMENT]->(b) ON CREATE SET r = $properties, r.createdat = timestamp() RETURN r write |
6 | 2 ms | 8 ms | 7 ms | flat |
MATCH (a:WorkOrderActivity {tildaid: $from_id}) MATCH (b:Document {tildaid: $to_id}) MERGE (a)-[r:WORK_ORDER_ACTIVITY_TO_DOCUMENT]->(b) ON CREATE SET r = $properties, r.createdat = timestamp() RETURN r write |
6 | 1 ms | 8 ms | 6 ms | flat |
MATCH (wo:WorkOrder {tildaid: ?}) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ORGANIZATION]->(org:Organization) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_STUDY]->(study:Study) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_SITE]->(site:Site) // Template lineage: WorkOrder.parent_id -> WorkOrderConfig -> WorkOrderTemplate. // Null for standalon write |
9 | 3 ms | 8 ms | 8 ms | flat |
MATCH(a:Actor{orgId:?,scopeId:?,userId:?,delpending:false}) RETURN a |
3 | 1 ms | 5 ms | 3 ms | flat |
MATCH (w:WorkOrder {tildaid: $wo})-[:WORK_ORDER_TO_ORGANIZATION]->(org:Organization) RETURN org.alias AS org_alias |
7 | <1 ms | 4 ms | 4 ms | flat |
MATCH (st:Study {tildaid: $study_id})-[:USES]->(:FolderManager)-[:INCLUDES]->(tmf:Folder {name:?}) WHERE tmf.level = ? MATCH (d:Document {tildaid: $doc_id}) RETURN EXISTS( (tmf)-[:INCLUDES*?..?]->(d) ) AS in_tmf |
96 | <1 ms | 2 ms | 2 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? 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 i |
2 | 1 ms | 2 ms | 1 ms | flat |
MATCH (st:Study {tildaid: $study_id})-[:USES]->(:FolderManager)-[:INCLUDES]->(tmf:Folder {name:?}) WHERE tmf.level = ? MATCH (d:Document {tildaid: $doc_id}) RETURN EXISTS( (tmf)-[:INCLUDES*?..?]->(d) ) AS in_tmf |
6 | 1 ms | 2 ms | 1 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND a.activity_type IN $activity_types 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 doc |
4 | <1 ms | 2 ms | 1 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? RETURN count(a) as total |
2 | <1 ms | 2 ms | 1 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND a.activity_type IN $activity_types RETURN count(a) as total |
4 | <1 ms | 2 ms | 1 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND a.activity_type IN $activity_types AND a.status IN $statuses RETURN count(a) as total |
3,782 | <1 ms | 1 ms | 77 ms | flat |
MATCH (wo:WorkOrder {tildaid: $wo_id}) OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity {activity_type: ?}) RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts |
3,755 | <1 ms | <1 ms | 3 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask) RETURN count(t) as total |
2 | 0 ms | <1 ms | 0 ms | flat |
p95 drift compares the query's p95 in the recent half of the window to the earlier half — ≥1.2× means it's slowing down. Click a row for its p50/p95 latency trend over time. Latency percentiles come from per-bucket histograms (no individual queries stored).