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
stored2d agotop 80 of 4,505
Neo4j query shapes on automation over the last 5d, grouped by plan hash.
Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.
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}
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 (f:Folder)-[:INCLUDES]->(n:Folder|SubArtifact{tildaid: $childId}) RETURN f LIMIT ?
MATCH (f:Folder)-[:INCLUDES]->(n:Folder|SubArtifact{tildaid: $childId}) RETURN f LIMIT ?
docsvc
36
0 ms
<1 ms
0 ms
flat
MATCH (a:Actor{tildaid:$id})-[:STUDYSITEACTOR_TO_ACTOR]-(ssa:StudySiteActor) OPTIONAL MATCH (ssa)-[:STUDYSITEACTOR_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition) OPTIONAL MATCH (ssa)-[:STUDYSITEDUTY_TO_STUDYSITEACTOR]-(ssd:StudySiteDuty{delpen…
MATCH (a:Actor{tildaid:$id})-[:STUDYSITEACTOR_TO_ACTOR]-(ssa:StudySiteActor) OPTIONAL MATCH (ssa)-[:STUDYSITEACTOR_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition) OPTIONAL MATCH (ssa)-[:STUDYSITEDUTY_TO_STUDYSITEACTOR]-(ssd:StudySiteDuty{delpending:false})-[:DUTY_TO_STUDYSITEDUTY]-(d:Duty) RETURN ssa.tildaid, ssa.roles, ssa.location, pd.scopeId, pd.scopeName, collect(CASE WHEN d IS NOT NULL THEN {dutyId: d.tildaid, title: d.title, number: d.number, status: ssd.status, startDate: ssd.startDate, endDate: ssd.endDate, removed: ssd.removed} END)
enrollsvc
3
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)
writeenrollsvc
24
0 ms
<1 ms
0 ms
flat
match(org:Organization{tildaid:$orgId})-[r:ORGANIZATION_TO_FORM]->(form:FormV2) where form.type=$formType and (form.scopeid=? ) and (not form.state=? or not exists((form)<-[:PUBLISHED_TO_DRAFT]-())) and not form.state=? and (form.activityT…
match(org:Organization{tildaid:$orgId})-[r:ORGANIZATION_TO_FORM]->(form:FormV2) where form.type=$formType and (form.scopeid=? ) and (not form.state=? or not exists((form)<-[:PUBLISHED_TO_DRAFT]-())) and not form.state=? and (form.activityType is null or not form.activityType in $defaultExcludedActivityTypes) optional match(form)-[:PUBLISHED_TO_DRAFT|ARCHIVED_TO_DRAFT]->(draft:FormV2{orgid:$orgId}) return count(form)
studiosvc
6
0 ms
<1 ms
0 ms
flat
match (obj:QuestionnaireV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
match (obj:QuestionnaireV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
execsvc
18
0 ms
<1 ms
0 ms
flat
match (pa:ParticipantActivity {tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]-(pqnr:ParticipantQuestionnaire)-[:BELONGS_TO_QUESTIONNAIRE]-(qnr:QuestionnaireV2|Questionnaire) return case when exists((qnr)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protoc…
match (pa:ParticipantActivity {tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]-(pqnr:ParticipantQuestionnaire)-[:BELONGS_TO_QUESTIONNAIRE]-(qnr:QuestionnaireV2|Questionnaire) return case when exists((qnr)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolId}]-(:GraphNodeRef{tildaid:$refId})) or qnr.title = $title then {qnr:qnr, pqnr:pqnr} end
execsvc
18
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)
writeenrollsvc
24
0 ms
<1 ms
0 ms
flat
MATCH (u:User{tildaid: $id}) SET u.authzUpdateNum = coalesce(u.authzUpdateNum, ?) + ?, u.updatedat = timestamp() RETURN u.authzUpdateNum, u.updatedat
MATCH (u:User{tildaid: $id}) SET u.authzUpdateNum = coalesce(u.authzUpdateNum, ?) + ?, u.updatedat = timestamp() RETURN u.authzUpdateNum, u.updatedat
writeenrollsvc
12
0 ms
<1 ms
0 ms
flat
match (pobj:WorkflowV2 {tildaid: $objId})-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]- (pd:DslPlanDefinition{studyId:$studyId, scopeId: $scopeId}) return pd
match (pobj:WorkflowV2 {tildaid: $objId})-[:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS]- (pd:DslPlanDefinition{studyId:$studyId, scopeId: $scopeId}) return pd
regsvc
12
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(br:BudgetReport) optional match (br)-[:BUDGET_REPORT_TO_PARTICIPANT_VISIT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActiv…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(br:BudgetReport) optional match (br)-[:BUDGET_REPORT_TO_PARTICIPANT_VISIT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.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 (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pv)-[:BELONGS_TO_VISIT]->(v) where v:Visit or v:VisitV2 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, br, pv, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Visit: v, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
48
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)
writeadvpsvc
9
0 ms
<1 ms
0 ms
flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_MEDIA]->(leaf)
writestudiosvc
394
0 ms
<1 ms
0 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
writestudiosvc
394
0 ms
<1 ms
0 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) and not r.flags is null return apoc.bitwise.op(coalesce(r.flags, ?…
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) and not r.flags is null return apoc.bitwise.op(coalesce(r.flags, ?), ?, $flag)=$flag
studiosvc
394
0 ms
<1 ms
0 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
writestudiosvc
394
0 ms
<1 ms
0 ms
flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_STATEMENT]->(leaf)
writestudiosvc
394
0 ms
<1 ms
0 ms
flat
MATCH (a:AdvRateRule{tildaid:$a_tildaid}),(b:AdvRateRuleSet{tildaid:$b_tildaid}) MERGE (a)-[r:NEXT_RULE]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
MATCH (a:AdvRateRule{tildaid:$a_tildaid}),(b:AdvRateRuleSet{tildaid:$b_tildaid}) MERGE (a)-[r:NEXT_RULE]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
writeadvpsvc
12
0 ms
<1 ms
0 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
finsvc
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}
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.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 (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pv)-[:BELONGS_TO_VISIT]->(v) where v:Visit or v:VisitV2 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, pv, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Visit: v, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
82
0 ms
<1 ms
0 ms
flat
match(a:AdvRateRule) where a.portalorgid=$portalOrgId and a.deleted=false and a.studyid=$fieldId set a.deleted=true, a.deltimestamp=timestamp()
match(a:AdvRateRule) where a.portalorgid=$portalOrgId and a.deleted=false and a.studyid=$fieldId set a.deleted=true, a.deltimestamp=timestamp()
writeadvpsvc
6
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
notifsvc
12
0 ms
<1 ms
0 ms
flat
MATCH (p:Policy {name:$name}) SET p.state = $state
MATCH (p:Policy {name:$name}) SET p.state = $state
writeonboardingsvc
53
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
429
0 ms
<1 ms
0 ms
flat
MATCH (b:Budget) WHERE b.status = ? AND date(b.effectiveDate) <= date() RETURN b.tildaid
MATCH (b:Budget) WHERE b.status = ? AND date(b.effectiveDate) <= date() RETURN b.tildaid
finsvc
6
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{name:$a_name}) RETURN a limit $a_limit
MATCH(a:Job{name:$a_name}) RETURN a limit $a_limit
notifsvc
6
0 ms
<1 ms
0 ms
flat
MATCH (sref:GraphNodeRef)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolId}]->(:VisitV2{tildaid:$visitId}), (sref)-[:ANCHORED_TO{protocolid:$protocolId}]->(ar:GraphNodeRef) WITH ar ORDER BY ar.tildaid LIMIT ? OPTIONAL MATCH (:CarePlan…
MATCH (sref:GraphNodeRef)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolId}]->(:VisitV2{tildaid:$visitId}), (sref)-[:ANCHORED_TO{protocolid:$protocolId}]->(ar:GraphNodeRef) WITH ar ORDER BY ar.tildaid LIMIT ? OPTIONAL MATCH (:CarePlan{tildaid:$cpId})-[:CAREPLAN_TO_ALL_PARTICIPANTVISITS]->(pv:ParticipantVisit)-[:BELONGS_TO_VISIT]->(v:Visit|VisitV2) WHERE EXISTS { (ar)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(v) } RETURN pv, v, [ar.tildaid] as refIds, null as ofl
schedsvc
18
0 ms
<1 ms
0 ms
flat
MATCH(a:Inbox{tildaid:$a_tildaid}) DETACH DELETE a
MATCH(a:Inbox{tildaid:$a_tildaid}) DETACH DELETE a
writetusker
48
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)
writeadvpsvc
18
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
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
writeworkplansvc
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
writeworkplansvc
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)
writestudiosvc
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)
writestudiosvc
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)
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)
writetusker
56
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
writedocproc
4
0 ms
<1 ms
0 ms
flat
MATCH (d:Document {tildaid: $doc_id}) MATCH (ai:AIRun)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(d) WITH ai, d, r, properties(r) AS old_props DELETE r CREATE (ai)-[old_run:AI_RUN_TO_DOCUMENT_OLD]->(d) SET old_run = old_props SET old_run.converted_at…
MATCH (d:Document {tildaid: $doc_id}) MATCH (ai:AIRun)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(d) WITH ai, d, r, properties(r) AS old_props DELETE r CREATE (ai)-[old_run:AI_RUN_TO_DOCUMENT_OLD]->(d) SET old_run = old_props SET old_run.converted_at = timestamp()
writedocproc
5
0 ms
<1 ms
0 ms
flat
UNWIND $changeLogs AS log MATCH (obj:StudySiteActor{tildaid:log.scopeId}) OPTIONAL MATCH (obj)-[r:TAIL_CHANGELOG]-(tcl:ChangeLog) CREATE (cl:ChangeLog { tildaid: randomUUID(), createdat: timestamp(), scopeId: log.scopeId, type: log.type, c…
UNWIND $changeLogs AS log MATCH (obj:StudySiteActor{tildaid:log.scopeId}) OPTIONAL MATCH (obj)-[r:TAIL_CHANGELOG]-(tcl:ChangeLog) CREATE (cl:ChangeLog { tildaid: randomUUID(), createdat: timestamp(), scopeId: log.scopeId, type: log.type, changedBy: log.changedBy, who: log.who, email: log.email, oldValue: log.oldValue, newValue: log.newValue, operation: log.operation, blob: log.blob, reason: log.reason, description: log.description, scribedForUserID: log.scribedForUserID, category: log.category, level: toInteger(log.level) }) DELETE r MERGE (obj)-[r1:TAIL_CHANGELOG]->(cl) ON CREATE SET r1.tildaid = randomUUID(), r1.createdat = timestamp() ON MATCH SET r1.updatedat = timestamp() MERGE (obj)-[r2:ALL_CHANGELOG]->(cl) ON CREATE SET r2.tildaid = randomUUID(), r2.createdat = timestamp() ON MATCH SET r2.updatedat = timestamp()
writeexecsvc
4
0 ms
<1 ms
0 ms
flat
MATCH(a:User{tildaid:$a_tildaid}) RETURN a
MATCH(a:User{tildaid:$a_tildaid}) RETURN a
execsvc
4
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)
writeexecsvc
70
0 ms
<1 ms
0 ms
flat
MATCH(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
MATCH(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
execsvc
5
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
onboardingsvc
109
0 ms
<1 ms
0 ms
flat
match (o:Organization {tildaid: $objectId}) return o
match (o:Organization {tildaid: $objectId}) return o
tusker
2
0 ms
<1 ms
0 ms
flat
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writetusker
2
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
1
0 ms
<1 ms
0 ms
flat
MATCH(a:DocumentAnnotation{tildaid:$a_tildaid})-[r:ANNOTATION_FIELD]->(b:DocumentField{uniqueId:$b_uniqueId}) RETURN b limit $limit
MATCH(a:DocumentAnnotation{tildaid:$a_tildaid})-[r:ANNOTATION_FIELD]->(b:DocumentField{uniqueId:$b_uniqueId}) RETURN b limit $limit
execsvc
21
0 ms
<1 ms
0 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
25
0 ms
<1 ms
0 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
14
0 ms
<1 ms
0 ms
flat
match (t:Task{tildaid:$id})-[:BELONGS_TO]-(i:Inbox{tildaid:$id1}) return i
match (t:Task{tildaid:$id})-[:BELONGS_TO]-(i:Inbox{tildaid:$id1}) return i
execsvc
50
0 ms
<1 ms
0 ms
flat
MATCH(a:User{deltimestamp:$a_deltimestamp,email:$a_email}) RETURN a
MATCH(a:User{deltimestamp:$a_deltimestamp,email:$a_email}) RETURN a
finsvc
30
0 ms
<1 ms
0 ms
flat
MATCH(a:Actor{orgId:$a_orgId,userId:$a_userId,scopeId:$a_scopeId,deltimestamp:$a_deltimestamp}) RETURN a
MATCH(a:Actor{orgId:$a_orgId,userId:$a_userId,scopeId:$a_scopeId,deltimestamp:$a_deltimestamp}) RETURN a
onboardingsvc
115
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)
writeonboardingsvc
134
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).