Query trends 60
Neo4j query shapes on master over the last 1h, 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 (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 ? |
70 | 1 ms | 4 ms | 2 ms | 2.0× ↑ |
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 |
70 | 4 ms | 8 ms | 6 ms | 1.2× ↑ |
MATCH (w:WorkOrder {tildaid: $wo})-[:WORK_ORDER_TO_ORGANIZATION]->(o:Organization) RETURN COALESCE(o.reminderApprovalRequired, true) AS approval_required |
105 | <1 ms | 1 ms | 1 ms | flat |
MATCH (instance:WorkPlanInstance{tildaid:?})-[:WORKPLAN_TO_SITE]->(site:Site) RETURN site.tildaid as siteId |
660 | 1 ms | 2 ms | 3 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]-( |
6 | 100 ms | 190 ms | 104 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 |
140 | <1 ms | 1 ms | 1 ms | flat |
MATCH (wp:WorkPlanInstance) WHERE wp.instanceReadyDeterminationState = ? AND wp.state <> ? RETURN wp.tildaid AS id ORDER BY coalesce(wp.instanceReadyDeterminationUpdatedAt, ?) ASC LIMIT ? |
70 | 1 ms | 2 ms | 2 ms | flat |
match (u:User{tildaid:?})<-[:OWNED_BY]-(i:Inbox{type:?}) where u.email = i.name return i |
42 | <1 ms | 2 ms | 1 ms | flat |
MATCH (org:Organization)<-[:WORK_ORDER_TO_ORGANIZATION]-(w:WorkOrder {status:?}) RETURN org.tildaid AS org_id, collect(w.tildaid) AS wo_ids |
35 | 10 ms | 19 ms | 11 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)-[: |
19 | 549 ms | 974 ms | 681 ms | flat |
RETURN ? |
317 | <1 ms | <1 ms | 1 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact) WHERE f.delpending = false RETURN f ORDER BY f.createdat ASC |
14,508 | <1 ms | 1 ms | 2 ms | flat |
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 |
135 | 168 ms | 197 ms | 219 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 |
22 | 26.52 s | 29.00 s | 28.53 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 |
21 | 36.52 s | 29.00 s | 37.73 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 |
20 | 36.83 s | 29.00 s | 38.55 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 |
20 | 1.85 s | 1.95 s | 1.98 s | 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 |
135 | 64 ms | 98 ms | 89 ms | flat |
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 |
20 | 73 ms | 98 ms | 91 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 |
10 | 6 ms | 10 ms | 6 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 |
9 | 7 ms | 10 ms | 7 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 |
8 | 5 ms | 10 ms | 5 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 |
66 | 6 ms | 10 ms | 8 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 |
66 | 6 ms | 10 ms | 9 ms | flat |
match(a:AdvRateRule{deleted:true})-[r]-(b) with distinct a return a.portalorgid, a.tildaid, a.ruletype limit ? |
403 | 2 ms | 5 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 { |
290 | 1 ms | 2 ms | 1 ms | flat |
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_INSTANCE]->(wp:WorkPlanInstance{tildaid:?}) RETURN org.tildaid as oid |
140 | 1 ms | 2 ms | 1 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 |
18 | 1 ms | 2 ms | 1 ms | flat |
MATCH (b:Budget) WHERE b.status = ? AND date(b.effectiveDate) <= date() RETURN b.tildaid |
39 | 0 ms | <1 ms | 0 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 { |
370 | <1 ms | 2 ms | 2 ms | flat |
MATCH (cfg:WorkplanCfg{tildaid:?})-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) RETURN study.tildaid as studyId |
660 | <1 ms | 2 ms | 2 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]-( |
14 | 104 ms | 194 ms | 117 ms | flat |
MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n |
14,615 | <1 ms | 1 ms | 51 ms | flat |
RETURN ? as health_check |
317 | <1 ms | <1 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 |
8 | 5 ms | 10 ms | 5 ms | flat |
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 |
105 | 171 ms | 198 ms | 321 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 |
14,715 | <1 ms | 2 ms | 57 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 |
14,611 | <1 ms | 1 ms | 63 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 |
14,715 | <1 ms | 2 ms | 4 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 |
105 | 91 ms | 152 ms | 134 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, ?) |
132 | 1 ms | 4 ms | 2 ms | 0.7× ↓ |
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 | 416 ms | 485 ms | 416 ms | flat |
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 |
1 | 42 ms | 48 ms | 42 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 | 24 ms | 47 ms | 46 ms | flat |
match(campaign:AdvCampaign{published:true, active:true})-[r:CURR_CONFIG]->(currconfig:AdvCampaignConfig) where date() > date(currconfig.expirydate) set campaign.active=false return campaign.tildaid write |
1 | 12 ms | 20 ms | 12 ms | flat |
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)- |
1 | 14 ms | 20 ms | 14 ms | flat |
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)- |
3 | 15 ms | 20 ms | 15 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}) |
3 | 8 ms | 18 ms | 18 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 |
18 | 2 ms | 11 ms | 11 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 (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 |
3 | 2 ms | 5 ms | 3 ms | flat |
MATCH (n:WorkOrder {tildaid: $node_id}) SET n += $props, n.updatedat = $updatedat RETURN n write |
2 | 2 ms | 5 ms | 2 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 |
2 | 2 ms | 5 ms | 2 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 |
1 | 1 ms | 2 ms | 1 ms | flat |
MATCH (wo:WorkOrder {tildaid: $wo_id}) UNWIND $changelogs AS cl CREATE (c:ChangeLog { tildaid: cl.tildaid, scopeId: $wo_id, category: ?, type: cl.type, changedBy: cl.changed_by, who: cl.who, email: cl.email, oldValue: cl.old_value, newValue: cl.new_value, description: cl.description, operation: cl.operation, reason: ?, write |
1 | 1 ms | 2 ms | 1 ms | flat |
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask) RETURN t.status AS status, count(t) AS cnt |
3 | 1 ms | 2 ms | 1 ms | flat |
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 |
3 | <1 ms | 2 ms | 1 ms | flat |
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 ? |
3 | <1 ms | 2 ms | 1 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 |
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 RETURN count(a) as total |
2 | <1 ms | 2 ms | 1 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).