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,239
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.
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.depende…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.dependencyResolutionRequestedAt, ?) > ? AND $nowMs - item.dependencyResolutionRequestedAt >= $windowMs AND wp.state <> ? AND NOT EXISTS { MATCH (ctx:WorkPlanContext{workplanConfigId: wp.tildaid, contextType:?}) } OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN DISTINCT wp.tildaid AS id, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
3
0 ms
<1 ms
0 ms
flat
MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document {tildaid: $doc_id}) WHERE ai.status IN [?, ?] RETURN ai
MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document {tildaid: $doc_id}) WHERE ai.status IN [?, ?] RETURN ai
docproc
12
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
6
0 ms
<1 ms
0 ms
flat
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) WHERE sca.country = $country RETURN sca
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) WHERE sca.country = $country RETURN sca
match(a:Study{tildaid:$studyId}) match(b:Organization{tildaid:$orgId}) merge(a)-[r:STUDY_TO_ORG]->(b) set r.inherited=$inherited
match(a:Study{tildaid:$studyId}) match(b:Organization{tildaid:$orgId}) merge(a)-[r:STUDY_TO_ORG]->(b) set r.inherited=$inherited
writeenrollsvc
6
0 ms
<1 ms
0 ms
flat
match(a:StudySiteActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:StudySiteActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeexecsvc
24
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(cp:CarePlan) optional match (cp)-[:EXECUTE_SOA]-(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) option…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(cp:CarePlan) optional match (cp)-[:EXECUTE_SOA]-(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) optional match (p:Patient{tildaid:cp.participantId}) optional match (phi:Phi{tildaid:p.phiid}) 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, cp, site, p, phi, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, Phi: phi, User: u, AssignedUser: auCollected, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
9
0 ms
<1 ms
0 ms
flat
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(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
36
0 ms
<1 ms
0 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)
writeonboardingsvc
18
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
24
0 ms
<1 ms
0 ms
flat
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]…
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]->(clog)
writeregsvc
9
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 (pa:ParticipantActivity{tildaid:$paId})-[:ALL_CHANGELOG]- (clog:ChangeLog) return clog order by clog.createdat desc
match (pa:ParticipantActivity{tildaid:$paId})-[:ALL_CHANGELOG]- (clog:ChangeLog) return clog order by clog.createdat desc
regsvc
18
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]->(q:Query) optional match (cp:CarePlan{tildaid: q.careplanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITI…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(q:Query) optional match (cp:CarePlan{tildaid: q.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 (pq:ParticipantQuestion{tildaid:q.scopeId})<-[:PARTICIPANT_QUESTION]-(pqn:ParticipantQuestionnaire)<-[:PARTICIPANT_QUESTIONNAIRE]-(pa:ParticipantActivity) optional match (pa)<-[:PARTICIPANT_ACTIVITY]-(pv:ParticipantVisit) 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, q, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, Visit: v, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
24
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(smoOrg:Organization{alias:$orgAlias, orgType:?}) with smoOrg match(study:Study{tildaid:$studyId}) with smoOrg, study return smoOrg.tildaid, study.srcorgid
match(smoOrg:Organization{alias:$orgAlias, orgType:?}) with smoOrg match(study:Study{tildaid:$studyId}) with smoOrg, study return smoOrg.tildaid, study.srcorgid
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
8
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT ontology_extract_fp_key IF NOT EXISTS FOR (m:OntologyExtractFingerprint) REQUIRE m.key IS UNIQUE
CREATE CONSTRAINT ontology_extract_fp_key IF NOT EXISTS FOR (m:OntologyExtractFingerprint) REQUIRE m.key IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
DROP CONSTRAINT config_finding_key IF EXISTS
DROP CONSTRAINT config_finding_key IF EXISTS
writeontologysvc
2
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT unit_visit_id_unique IF NOT EXISTS FOR (v:UnitVisit) REQUIRE v.visitId IS UNIQUE
CREATE CONSTRAINT unit_visit_id_unique IF NOT EXISTS FOR (v:UnitVisit) REQUIRE v.visitId IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
DROP CONSTRAINT finding_dedupe_key_unique IF EXISTS
DROP CONSTRAINT finding_dedupe_key_unique IF EXISTS
writeontologysvc
2
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT finding_id_unique IF NOT EXISTS FOR (f:Finding) REQUIRE f.findingId IS UNIQUE
CREATE CONSTRAINT finding_id_unique IF NOT EXISTS FOR (f:Finding) REQUIRE f.findingId IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT placeholder_audit_dedupe_unique IF NOT EXISTS FOR (p:PlaceholderAudit) REQUIRE p.dedupeKey IS UNIQUE
CREATE CONSTRAINT placeholder_audit_dedupe_unique IF NOT EXISTS FOR (p:PlaceholderAudit) REQUIRE p.dedupeKey IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT config_finding_key_v2 IF NOT EXISTS FOR (f:ConfigFinding) REQUIRE (f.studyId, f.dedupeKey) IS UNIQUE
CREATE CONSTRAINT config_finding_key_v2 IF NOT EXISTS FOR (f:ConfigFinding) REQUIRE (f.studyId, f.dedupeKey) IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT unit_visit_runid_kind_id_unique IF NOT EXISTS FOR (v:UnitVisit) REQUIRE (v.runId, v.unit_kind, v.unit_id) IS UNIQUE
CREATE CONSTRAINT unit_visit_runid_kind_id_unique IF NOT EXISTS FOR (v:UnitVisit) REQUIRE (v.runId, v.unit_kind, v.unit_id) IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT finding_dedupe_composite_unique IF NOT EXISTS FOR (f:Finding) REQUIRE (f.studyId, f.domain, f.dedupeKey) IS UNIQUE
CREATE CONSTRAINT finding_dedupe_composite_unique IF NOT EXISTS FOR (f:Finding) REQUIRE (f.studyId, f.domain, f.dedupeKey) IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT ontology_audit_active_key IF NOT EXISTS FOR (a:OntologyAudit) REQUIRE a.activeKey IS UNIQUE
CREATE CONSTRAINT ontology_audit_active_key IF NOT EXISTS FOR (a:OntologyAudit) REQUIRE a.activeKey IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT ontology_auditproc_fp_key IF NOT EXISTS FOR (m:OntologyAuditprocFingerprint) REQUIRE m.key IS UNIQUE
CREATE CONSTRAINT ontology_auditproc_fp_key IF NOT EXISTS FOR (m:OntologyAuditprocFingerprint) REQUIRE m.key IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
patientsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:EhrPhi{tildaid:$a_tildaid}) SET a.updatedat=timestamp(),a.phiid=$a_phiid RETURN count(a)
MATCH(a:EhrPhi{tildaid:$a_tildaid}) SET a.updatedat=timestamp(),a.phiid=$a_phiid RETURN count(a)
writepatientsvc
2
0 ms
<1 ms
0 ms
flat
match(org:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_PATIENT]->(:Patient)-[:HAS_PROTECTED_DATA_IN]->(phi:Phi) where phi.dob=$dOB and (tolower(phi.email)=tolower($email) or phi.mobilephone=$mobilePhone ) return phi
match(org:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_PATIENT]->(:Patient)-[:HAS_PROTECTED_DATA_IN]->(phi:Phi) where phi.dob=$dOB and (tolower(phi.email)=tolower($email) or phi.mobilephone=$mobilePhone ) return phi
patientsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
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
writeregsvc
856
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
writeregsvc
1,033
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
684
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
30
0 ms
<1 ms
0 ms
flat
match (c:CarePlan {tildaid: $id})-[:EXECUTE_SOA]-(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) return st
match (c:CarePlan {tildaid: $id})-[:EXECUTE_SOA]-(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) return st
schedsvc
4
0 ms
<1 ms
0 ms
flat
MATCH (pv:ParticipantVisit{tildaid:$pvId})<-[:NEXT_PARTICIPANT_VISIT*]- (prev:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v:Visit|VisitV2) WHERE (v.arm is null or v.arm = ? or v.arm = $arm) AND prev.status <> ? AND prev.status <> ? return head(…
MATCH (pv:ParticipantVisit{tildaid:$pvId})<-[:NEXT_PARTICIPANT_VISIT*]- (prev:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v:Visit|VisitV2) WHERE (v.arm is null or v.arm = ? or v.arm = $arm) AND prev.status <> ? AND prev.status <> ? return head(collect({ParticipantVisit:prev,Visit:v})) as prevPV
schedsvc
1
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
4
0 ms
<1 ms
0 ms
flat
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id, o.alias as alias, o.name as name, o.orgType = ? as is_cro, o.orgType as org_type
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id, o.alias as alias, o.name as name, o.orgType = ? as is_cro, o.orgType as org_type
virtual-assistant
1
0 ms
<1 ms
0 ms
flat
RETURN ? as health_check
RETURN ? as health_check
virtual-assistant
1
0 ms
<1 ms
0 ms
flat
MATCH (v:VAMigrationVersion) RETURN v.version AS version
MATCH (v:VAMigrationVersion) RETURN v.version AS version
virtual-assistant
1
0 ms
<1 ms
0 ms
flat
match (obj:VisitV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
match (obj:VisitV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
execsvc
4
0 ms
<1 ms
0 ms
flat
match (j:Job)-[:JOB_TO_JOBSTATE]-(js:JobState) WHERE (js.status=$doneStatus or j.stopped=true) and j.UpdatedAt < $cutoff optional match (j)-[:JOB_TO_EMAIL_NOTIFICATION]-(e:EmailNotification) optional match (j)-[:JOB_TO_EMAIL_NOTIFICATION]-…
match (j:Job)-[:JOB_TO_JOBSTATE]-(js:JobState) WHERE (js.status=$doneStatus or j.stopped=true) and j.UpdatedAt < $cutoff optional match (j)-[:JOB_TO_EMAIL_NOTIFICATION]-(e:EmailNotification) optional match (j)-[:JOB_TO_EMAIL_NOTIFICATION]-(s:SMSNotification) detach delete j,js,e,s
writenotifsvc
2
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)
writeonboardingsvc
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)
writeonboardingsvc
14
0 ms
<1 ms
0 ms
flat
match(a:SiteLocation{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:SiteLocation{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeonboardingsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (s:Staff) WHERE s.email=$email AND s.deltimestamp=? SET s.status=$status, s.updatedat=timestamp()
MATCH (s:Staff) WHERE s.email=$email AND s.deltimestamp=? SET s.status=$status, s.updatedat=timestamp()
writeonboardingsvc
7
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
writepatientsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:MedicalGroup{tildaid:$b_tildaid}) MERGE (a)-[r:ASSOCIATED_MEDICAL_GROUP]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = ti…
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:MedicalGroup{tildaid:$b_tildaid}) MERGE (a)-[r:ASSOCIATED_MEDICAL_GROUP]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
writepatientsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:Phi{tildaid:$b_tildaid}) MERGE (a)-[r:HAS_PROTECTED_DATA_IN]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RE…
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:Phi{tildaid:$b_tildaid}) MERGE (a)-[r:HAS_PROTECTED_DATA_IN]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
writepatientsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (a:EhrPhi{tildaid:$a_tildaid}),(b:Phi{tildaid:$b_tildaid}) MERGE (a)-[r:ASSOCIATED_PHI]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
MATCH (a:EhrPhi{tildaid:$a_tildaid}),(b:Phi{tildaid:$b_tildaid}) MERGE (a)-[r:ASSOCIATED_PHI]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
writepatientsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:EhrPhi{phiid:$a_phiid}) RETURN a limit $a_limit
MATCH(a:EhrPhi{phiid:$a_phiid}) RETURN a limit $a_limit
patientsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:Emr{tildaid:$b_tildaid}) MERGE (a)-[r:ASSOCIATED_EMR]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:Emr{tildaid:$b_tildaid}) MERGE (a)-[r:ASSOCIATED_EMR]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
writepatientsvc
1
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
writepatientsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST|AI_RUN_TO_DOCUMENT_OLD]-(ai:AIRun) RETURN ai ORDER BY ai.createdat DESC
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST|AI_RUN_TO_DOCUMENT_OLD]-(ai:AIRun) RETURN ai ORDER BY ai.createdat DESC
virtual-assistant
1
0 ms
<1 ms
0 ms
flat
MATCH (a:StudyCountryActor{tildaid:$a_tildaid}),(b:Actor{tildaid:$b_tildaid}) MERGE (a)-[r:STUDYCOUNTRYACTOR_TO_ACTOR]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
MATCH (a:StudyCountryActor{tildaid:$a_tildaid}),(b:Actor{tildaid:$b_tildaid}) MERGE (a)-[r:STUDYCOUNTRYACTOR_TO_ACTOR]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
writeexecsvc
7
0 ms
<1 ms
0 ms
flat
MATCH (obj:StudyCountryActor{tildaid:$scopeId}) SET obj._LOCK_ = true REMOVE obj._LOCK_ WITH obj OPTIONAL MATCH (obj)-[oldTail:TAIL_CHANGELOG]->(:ChangeLog) DELETE oldTail WITH DISTINCT obj UNWIND range(?, size($changeLogs) - ?) AS i WITH …
MATCH (obj:StudyCountryActor{tildaid:$scopeId}) SET obj._LOCK_ = true REMOVE obj._LOCK_ WITH obj OPTIONAL MATCH (obj)-[oldTail:TAIL_CHANGELOG]->(:ChangeLog) DELETE oldTail WITH DISTINCT obj UNWIND range(?, size($changeLogs) - ?) AS i WITH obj, i, $changeLogs[i] AS log CREATE (cl:ChangeLog) SET cl = log, cl.createdat = timestamp() + $seqOffset + i, cl.scopeId = $scopeId CREATE (obj)-[r2:ALL_CHANGELOG]->(cl) SET r2.tildaid = randomUUID(), r2.createdat = timestamp() WITH obj, collect(cl) AS createdLogs WITH obj, createdLogs[-?] AS lastLog CREATE (obj)-[r1:TAIL_CHANGELOG]->(lastLog) SET r1.tildaid = randomUUID(), r1.createdat = timestamp()
writeexecsvc
7
0 ms
<1 ms
0 ms
flat
match(a:StudyCountryActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:StudyCountryActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeexecsvc
7
0 ms
<1 ms
0 ms
flat
MATCH (s:Site{tildaid:$id}) OPTIONAL MATCH (s)-[:STAFF_TO_ACTOR]-(actor:Actor) OPTIONAL MATCH (s)-[:HAS_LOCATION]->(loc:SiteLocation) OPTIONAL MATCH (s)-[:ALL_CHANGELOG]-(clog:ChangeLog) OPTIONAL MATCH (s)-[:MANAGED_BY]-(in:Inbox) DETACH D…
MATCH (s:Site{tildaid:$id}) OPTIONAL MATCH (s)-[:STAFF_TO_ACTOR]-(actor:Actor) OPTIONAL MATCH (s)-[:HAS_LOCATION]->(loc:SiteLocation) OPTIONAL MATCH (s)-[:ALL_CHANGELOG]-(clog:ChangeLog) OPTIONAL MATCH (s)-[:MANAGED_BY]-(in:Inbox) DETACH DELETE actor,loc,clog,in
writeonboardingsvc
4
0 ms
<1 ms
0 ms
flat
match(a:SiteLocation{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:SiteLocation{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeonboardingsvc
8
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
writeonboardingsvc
4
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).