Xray
hourly rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 3 days▾
Ends now. Anything up to this cluster's 30-day retention.
Start and end times
Cancel
Interpreted in UTC (change it at the right of this bar). Earliest available: 2026-10-21 05:50:51.
› →|
updated 2d ago
Sample data. This database was generated by scripts/seed_dev_db.py — every service, deploy, person and figure on this page is synthetic. Names are sample.*@seed.invalid and image tags are prefixed SEED-. Nothing here happened.

Query trends 80

stored 2d ago top 80 of 1,165

Neo4j query shapes on automation over the last 3d, grouped by plan hash. Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.

Columns
Views
Export CSV
Query shape Count Avg p95 ▴ Max p95 drift
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
docproc
3 0 ms <1 ms 0 ms flat
match(crs:ChartReviewStudy{tildaid:$id}) with crs optional match(crs)-[r:PENDING_PATIENTS]->(:Patient) with count(r) as pend, crs with pend, crs optional match(crs)-[r:APPROVED_PATIENTS]->(:Patient) with count(r) as approved, pend, crs wit…
match(crs:ChartReviewStudy{tildaid:$id}) with crs optional match(crs)-[r:PENDING_PATIENTS]->(:Patient) with count(r) as pend, crs with pend, crs optional match(crs)-[r:APPROVED_PATIENTS]->(:Patient) with count(r) as approved, pend, crs with approved, pend, crs optional match(crs)-[r:REJECTED_PATIENTS]->(:Patient) with count(r) as rejected, approved, pend return pend, approved, rejected
enrollsvc
3 0 ms <1 ms 0 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, collect(au) as auCollected, st, site, cu as createdBy return {Task: t, AssignedUser: auCollected, Study: st, Site: site, CreatedBy: createdBy}
tusker
12 0 ms <1 ms 0 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, collect(au) as auCollected, st, site, cu as createdBy return {Task: t, AssignedUser: auCollected, Study: st, Site: site, CreatedBy: createdBy}
tusker
3 0 ms <1 ms 0 ms flat
match(graphNode:GraphNode{tildaid:$graphId}) match(page:GraphPage{tildaid:$pageId}) create(graphNode)-[:GRAPH_NODE_TO_PAGE{graphid:$graphId, path:[$graphId]}]->(page)
match(graphNode:GraphNode{tildaid:$graphId}) match(page:GraphPage{tildaid:$pageId}) create(graphNode)-[:GRAPH_NODE_TO_PAGE{graphid:$graphId, path:[$graphId]}]->(page)
write studiosvc
6 0 ms <1 ms 0 ms flat
MATCH (:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_FORM]->(obj{tildaid:$objId}) RETURN true LIMIT ?
MATCH (:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_FORM]->(obj{tildaid:$objId}) RETURN true LIMIT ?
studiosvc
48 0 ms <1 ms 0 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
notifsvc
6 0 ms <1 ms 0 ms flat
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
write advpsvc
1 0 ms <1 ms 0 ms flat
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
write advpsvc
14 0 ms <1 ms 0 ms flat
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
write docproc
7 0 ms <1 ms 0 ms flat
MATCH (o:Organization {tildaid: $org_id}) OPTIONAL MATCH (o)-[:USES]->(fm:FolderManager {name: ?, scopeId: $study_id}) RETURN o.orgType AS org_type, fm.firstNPages AS first_n_pages, fm.lastMPages AS last_m_pages, fm.qcFirstNPages AS qc_fir…
MATCH (o:Organization {tildaid: $org_id}) OPTIONAL MATCH (o)-[:USES]->(fm:FolderManager {name: ?, scopeId: $study_id}) RETURN o.orgType AS org_type, fm.firstNPages AS first_n_pages, fm.lastMPages AS last_m_pages, fm.qcFirstNPages AS qc_first_n_pages, fm.qcLastMPages AS qc_last_m_pages, fm.qcFullDocument AS qc_full_document
docproc
2 0 ms <1 ms 0 ms flat
MATCH (w:WorkOrder)-[:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE w.delpending = false RETURN w.tildaid AS work_order_id, coalesce(w.title, ?) AS work_order_name ORDER BY coalesce(w.updatedat, w.createdat) DESC LIMIT ?
MATCH (w:WorkOrder)-[:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE w.delpending = false RETURN w.tildaid AS work_order_id, coalesce(w.title, ?) AS work_order_name ORDER BY coalesce(w.updatedat, w.createdat) DESC LIMIT ?
docproc
4 0 ms <1 ms 0 ms flat
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
enrollsvc
5 0 ms <1 ms 0 ms flat
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write execsvc
26 0 ms <1 ms 0 ms flat
match(a:Patient{tildaid:$tildaId}) with a, case when a.ufid is null or a.ufid=? then $ufid else a.ufid end as val set a.ufid=val
match(a:Patient{tildaid:$tildaId}) with a, case when a.ufid is null or a.ufid=? then $ufid else a.ufid end as val set a.ufid=val
write patientsvc
10 0 ms <1 ms 0 ms flat
match(a:Patient{tildaid:$tildaId}) with a, case when a.status is null or a.status=? then $prospect else a.status end as status set a.status=status
match(a:Patient{tildaid:$tildaId}) with a, case when a.status is null or a.status=? then $prospect else a.status end as status set a.status=status
write patientsvc
10 0 ms <1 ms 0 ms flat
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:MedicalDocument{phiid:$b_phiid}) MERGE (a)-[r:INFO_STORED_IN]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() R…
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:MedicalDocument{phiid:$b_phiid}) MERGE (a)-[r:INFO_STORED_IN]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
write patientsvc
4 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
write regsvc
377 0 ms <1 ms 0 ms flat
WITH $`rel2` as `rel2` , $`node` as `node` , $`tildaid` as `tildaid` OPTIONAL MATCH (existing:Inbox{tildaid: $tildaid}) RETURN existing
WITH $`rel2` as `rel2` , $`node` as `node` , $`tildaid` as `tildaid` OPTIONAL MATCH (existing:Inbox{tildaid: $tildaid}) RETURN existing
regsvc
185 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
regsvc
252 0 ms <1 ms 0 ms flat
match (u:User{tildaid:$userId})<-[:OWNED_BY]-(i:Inbox{type:?}) where u.email = i.name return i
match (u:User{tildaid:$userId})<-[:OWNED_BY]-(i:Inbox{type:?}) where u.email = i.name return i
tusker
4 0 ms <1 ms 0 ms flat
MATCH(a:DocumentCheckSum{deltimestamp:$a_deltimestamp,orgId:$a_orgId,studyId:$a_studyId,checksum:$a_checksum}) RETURN a
MATCH(a:DocumentCheckSum{deltimestamp:$a_deltimestamp,orgId:$a_orgId,studyId:$a_studyId,checksum:$a_checksum}) RETURN a
docsvc
2 0 ms <1 ms 0 ms flat
MATCH(a:User{tildaid:$a_tildaid})-[r:ACTIVE_SIGNATURE]->(b:ESignature) RETURN b limit $limit
MATCH(a:User{tildaid:$a_tildaid})-[r:ACTIVE_SIGNATURE]->(b:ESignature) RETURN b limit $limit
onboardingsvc
1 0 ms <1 ms 0 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pd, site, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, User: u, AssignedUser: auCollected, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, CreatedBy: createdBy}
tusker
1 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = fa…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false RETURN coalesce(item.itemId, item.tildaid) AS itemId, coalesce(item.itemConfig, ?) AS itemConfig
workplansvc
47 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE ite…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.expectedAttachmentUnresolvedAt, ?) > ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.workOrderCompletedAt, ?) = ? AND coalesce(item.workOrderId, ?) = ? RETURN DISTINCT inst.tildaid AS instanceId
workplansvc
47 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE ite…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.workOrderActivationFailedAt, ?) > ? AND coalesce(item.workOrderActivationErrorCode, ?) = $code AND coalesce(item.workOrderCompletedAt, ?) = ? AND coalesce(item.workOrderResolvedAt, ?) = ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.workOrderId, ?) <> ? RETURN inst.tildaid AS instanceId, coalesce(item.itemConfig, ?) AS itemConfig
workplansvc
47 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.agentConfigErrorAt, ?) AS at, coalesce(cfg.agentConfigErrorMessage, ?) AS message, coalesce(cfg.agentConfigAuthorMessage, ?) AS authorMessage
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.agentConfigErrorAt, ?) AS at, coalesce(cfg.agentConfigErrorMessage, ?) AS message, coalesce(cfg.agentConfigAuthorMessage, ?) AS authorMessage
workplansvc
47 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = fa…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false AND coalesce(item.edlProvisionFailedAt, ?) > ? RETURN count(item) AS n
workplansvc
47 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE coalesce(item.cfgItemInvalid, false) = false AND coalesce(item.branchCas…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE coalesce(item.cfgItemInvalid, false) = false AND coalesce(item.branchCaseAmbiguity, ?) <> ? RETURN DISTINCT item.branchCaseAmbiguity AS message
workplansvc
47 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = fa…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false RETURN sum(CASE WHEN coalesce(item.workOrderConfigFailedAt, ?) > ? THEN ? ELSE ? END) AS failed, sum(CASE WHEN coalesce(item.workOrderConfigWarningAt, ?) > ? THEN ? ELSE ? END) AS warned
workplansvc
47 0 ms <1 ms 0 ms flat
MATCH (obj:WorkplanCfg{tildaid:$objId})<-[:WORKPLAN_JOB_TO_OBJ]-(job:WorkplanJob) RETURN job ORDER BY job.createdat DESC LIMIT ?
MATCH (obj:WorkplanCfg{tildaid:$objId})<-[:WORKPLAN_JOB_TO_OBJ]-(job:WorkplanJob) RETURN job ORDER BY job.createdat DESC LIMIT ?
workplansvc
50 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
write execsvc
410 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
write execsvc
410 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
execsvc
410 0 ms <1 ms 0 ms flat
MATCH (pobj:ParticipantQuestionnaire{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
MATCH (pobj:ParticipantQuestionnaire{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
execsvc
4 0 ms <1 ms 0 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pd, site, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, User: u, AssignedUser: auCollected, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, CreatedBy: createdBy}
tusker
1 0 ms <1 ms 0 ms flat
MATCH (ctx:WorkPlanContext{tildaid:$tildaid}) SET ctx.delpending = true, ctx.deltimestamp = timestamp() RETURN ctx.tildaid AS id
MATCH (ctx:WorkPlanContext{tildaid:$tildaid}) SET ctx.delpending = true, ctx.deltimestamp = timestamp() RETURN ctx.tildaid AS id
write workplansvc
1 0 ms <1 ms 0 ms flat
MATCH (ctx:WorkPlanContext{tildaid:$contextId}) SET ctx.checkpointGenId = $genId RETURN ctx.tildaid AS id
MATCH (ctx:WorkPlanContext{tildaid:$contextId}) SET ctx.checkpointGenId = $genId RETURN ctx.tildaid AS id
write workplansvc
1 0 ms <1 ms 0 ms flat
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION]->(q:QuestionV2) with distinct q match(proto:FormV2{t…
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION]->(q:QuestionV2) with distinct q match(proto:FormV2{tildaid:$protocolId}) merge(proto)-[:PROTOCOL_TO_QUESTION]->(q)
write studiosvc
5 0 ms <1 ms 0 ms flat
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(rs:ResponseSet) with distinct rs match(proto:FormV2{tildaid:$protocolId}) mer…
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(rs:ResponseSet) with distinct rs match(proto:FormV2{tildaid:$protocolId}) merge(proto)-[:PROTOCOL_TO_RESPONSE_SET]->(rs)
write studiosvc
5 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) OPTIONAL MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) RETURN coalesce(org.alias, ?), coalesce(org.name, ?), coalesce(st…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) OPTIONAL MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) RETURN coalesce(org.alias, ?), coalesce(org.name, ?), coalesce(study.tildaid, cfg.studyId, ?), coalesce(study.name, ?), cfg.tildaid, coalesce(cfg.name, ?)
workplansvc
1 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.variableDeclarations, ?)
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.variableDeclarations, ?)
workplansvc
1 0 ms <1 ms 0 ms flat
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = ? AND j.jobType IN [?, ?, ?] RETURN j.tildaid ORDER BY j.createdat ASC
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = ? AND j.jobType IN [?, ?, ?] RETURN j.tildaid ORDER BY j.createdat ASC
docsvc
1 0 ms <1 ms 0 ms flat
MATCH(a:Site{tildaid:$a_tildaid}) RETURN a
MATCH(a:Site{tildaid:$a_tildaid}) RETURN a
docsvc
4 0 ms <1 ms 0 ms flat
match(a:Site{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Site{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write docsvc
4 0 ms <1 ms 0 ms flat
CREATE (a:EventPlan{deltimestamp:$a_deltimestamp}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.name=$a_name,a.description=$a_des…
CREATE (a:EventPlan{deltimestamp:$a_deltimestamp}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.name=$a_name,a.description=$a_description,a.contextType=$a_contextType,a.status=$a_status,a.orgId=$a_orgId RETURN a.tildaid, a.createdat
write docsvc
4 0 ms <1 ms 0 ms flat
MATCH (o:Organization {alias: $value}) WHERE o.delpending = true AND o.status = $deleted AND coalesce(o.deletionProgress, ?) <> $purged RETURN count(o)
MATCH (o:Organization {alias: $value}) WHERE o.delpending = true AND o.status = $deleted AND coalesce(o.deletionProgress, ?) <> $purged RETURN count(o)
onboardingsvc
1 0 ms <1 ms 0 ms flat
MATCH(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
MATCH(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
onboardingsvc
1 0 ms <1 ms 0 ms flat
match(a:Site{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Site{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write tusker
28 0 ms <1 ms 0 ms flat
MATCH(a:AdvRateRuleSet{portalorgid:$a_portalorgid}) RETURN a limit $a_limit
MATCH(a:AdvRateRuleSet{portalorgid:$a_portalorgid}) RETURN a limit $a_limit
advpsvc
10 0 ms <1 ms 0 ms flat
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write enrollsvc
100 0 ms <1 ms 0 ms flat
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
write advpsvc
25 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.waitingOn = $waitingOn AND wp.state <> ? RETURN wp.tildaid
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.waitingOn = $waitingOn AND wp.state <> ? RETURN wp.tildaid
workplansvc
35 0 ms <1 ms 0 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE ite…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.edlScopeCreateFailedAt, ?) > ? RETURN count(item) AS n
workplansvc
35 0 ms <1 ms 0 ms flat
MATCH(a:Lead{deltimestamp:$a_deltimestamp,patientid:$a_patientid,studyid:$a_studyid}) RETURN a
MATCH(a:Lead{deltimestamp:$a_deltimestamp,patientid:$a_patientid,studyid:$a_studyid}) RETURN a
patientsvc
1 0 ms <1 ms 0 ms flat
match(site:Site{tildaid:$siteId})-[]-(:Smo)-[]-(org:Organization) return org
match(site:Site{tildaid:$siteId})-[]-(:Smo)-[]-(org:Organization) return org
patientsvc
1 0 ms <1 ms 0 ms flat
MATCH (s:Site{tildaid:$siteId})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization) RETURN o
MATCH (s:Site{tildaid:$siteId})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization) RETURN o
regsvc
5 0 ms <1 ms 0 ms flat
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION]->(q:QuestionV2) with distinct q match(act:FormV2{til…
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION]->(q:QuestionV2) with distinct q match(act:FormV2{tildaid:$activityId}) merge(act)-[:ACTIVITY_TO_QUESTION]->(q)
write studiosvc
32 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
write regsvc
314 0 ms <1 ms 0 ms flat
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write onboardingsvc
1,116 <1 ms <1 ms 1 ms flat
WITH $`rel2` as `rel2` , $`existing` as `existing` , $`node` as `node` CALL apoc.create.relationship(node, rel2.relation, {}, existing) yield rel RETURN count(rel)
WITH $`rel2` as `rel2` , $`existing` as `existing` , $`node` as `node` CALL apoc.create.relationship(node, rel2.relation, {}, existing) yield rel RETURN count(rel)
write regsvc
307 <1 ms <1 ms 1 ms flat
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
write studiosvc
1,398 <1 ms <1 ms 1 ms flat
match(a:Room{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Room{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write onboardingsvc
198 <1 ms <1 ms 10 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
170 <1 ms <1 ms 1 ms flat
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
write studiosvc
716 <1 ms <1 ms 1 ms flat
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
docsvc
213 <1 ms <1 ms 6 ms flat
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
workplansvc
365 <1 ms <1 ms 1 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? RETURN wp.tildaid, wp.blockedVariables
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? RETURN wp.tildaid, wp.blockedVariables
workplansvc
86 <1 ms <1 ms 2 ms flat
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(apoc.bitwise.op(r.flags, ?, apoc.bitwi…
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(apoc.bitwise.op(r.flags, ?, apoc.bitwise.op(?, ?,?)), ?, $flags), r.who=$who
write studiosvc
1,396 <1 ms <1 ms 1 ms flat
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
enrollsvc
118 <1 ms <1 ms 1 ms flat
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
write docproc
59 4 ms <1 ms 257 ms flat
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
execsvc
163 <1 ms <1 ms 2 ms flat
UNWIND $ids as fid MATCH (a:ActivityV2{tildaid:fid}) WHERE coalesce(a.deltimestamp,?) = ? RETURN a.tildaid as id, coalesce(a.activityType, a.type, ?) as activityType, coalesce(a.title,?) as title, coalesce(a.name,?) as name
UNWIND $ids as fid MATCH (a:ActivityV2{tildaid:fid}) WHERE coalesce(a.deltimestamp,?) = ? RETURN a.tildaid as id, coalesce(a.activityType, a.type, ?) as activityType, coalesce(a.title,?) as title, coalesce(a.name,?) as name
workplansvc
48 <1 ms <1 ms 1 ms flat
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
workplansvc
377 <1 ms <1 ms 1 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE ite…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? OPTIONAL MATCH (task:Task)-[:WITH_CONTEXT]->(item) WHERE task IS NULL OR (task.category IN $wpTaskCategories AND task.relationshipContext = ?) OPTIONAL MATCH (task)-[:TASK_TO_WORKPLAN_CHECKLIST_TODO]->(todo:WorkplanChecklistTodoItem) WITH inst, item, task, count(DISTINCT todo) AS resolvedTodoCount RETURN inst.tildaid AS instanceId, item, task.tildaid AS taskId, task.category AS taskCategory, resolvedTodoCount
workplansvc
47 <1 ms <1 ms 1 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.waitingOn = $waitingOn AND wp.state <> ? RETURN wp.tildaid
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.waitingOn = $waitingOn AND wp.state <> ? RETURN wp.tildaid
workplansvc
47 <1 ms <1 ms 1 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE ite…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.edlScopeCreateFailedAt, ?) > ? RETURN count(item) AS n
workplansvc
47 <1 ms <1 ms 1 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pa:ParticipantActivity) optional match (cp:CarePlan{tildaid: pa.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pa:ParticipantActivity) optional match (cp:CarePlan{tildaid: pa.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (pa)-[: BELONGS_TO_ACTIVITY]->(a:Activity) optional match (pa)-[:PARTICIPANT_ACTIVITY]-(:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v) where v:Visit or v:VisitV2 optional match (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pa)-[:PARTICIPANT_DOCUMENTSET]-(pds:ParticipantDocumentSet)-[:BELONGS_TO_DOCUMENTSET]-(ds:DocumentSet) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pa, site, v, p, phi, ds, a, cp, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, Phi: phi, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, CarePlan: cp, Activity: a, Visit : v, DocumentSet: ds, Patient: p, CreatedBy: createdBy}
tusker
42 <1 ms <1 ms 1 ms flat
MATCH (o:Organization {tildaid: $orgId}) SET o._LOCK_ = true REMOVE o._LOCK_ WITH o WHERE o.jobRunId = $run AND NOT coalesce(o.deletionProgress, ?) IN [?, ?, ?] SET o.deletionProgress = $step, o.deletionMarkedCount = $total
MATCH (o:Organization {tildaid: $orgId}) SET o._LOCK_ = true REMOVE o._LOCK_ WITH o WHERE o.jobRunId = $run AND NOT coalesce(o.deletionProgress, ?) IN [?, ?, ?] SET o.deletionProgress = $step, o.deletionMarkedCount = $total
write onboardingsvc
2,745 <1 ms <1 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).