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-20 19:15:39.
› →|
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 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.

Columns
Views
Export CSV
Query shape Count Avg p95 ▴ Max p95 drift
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
execsvc
6 0 ms <1 ms 0 ms flat
CREATE (a:DocAttributeDefinition{deltimestamp:$a_deltimestamp,code:$a_code,scopeId:$a_scopeId}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=$a_holdbitmap,a.delpending=$a_d…
CREATE (a:DocAttributeDefinition{deltimestamp:$a_deltimestamp,code:$a_code,scopeId:$a_scopeId}) 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.type=$a_type,a.description=$a_description,a.enumOptions=$a_enumOptions RETURN a.tildaid, a.createdat
write docsvc
24 0 ms <1 ms 0 ms flat
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
write enrollsvc
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)
write execsvc
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}
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: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
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)
write onboardingsvc
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)
write regsvc
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)
write advpsvc
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()
write advpsvc
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
write onboardingsvc
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
write 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)
write advpsvc
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
advpsvc
2 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
8 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
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
write ontologysvc
1 0 ms <1 ms 0 ms flat
DROP CONSTRAINT config_finding_key IF EXISTS
DROP CONSTRAINT config_finding_key IF EXISTS
write ontologysvc
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
write ontologysvc
1 0 ms <1 ms 0 ms flat
DROP CONSTRAINT finding_dedupe_key_unique IF EXISTS
DROP CONSTRAINT finding_dedupe_key_unique IF EXISTS
write ontologysvc
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
write ontologysvc
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
write ontologysvc
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
write ontologysvc
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
write ontologysvc
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
write ontologysvc
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
write ontologysvc
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
write ontologysvc
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)
write patientsvc
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
patientsvc
4 0 ms <1 ms 0 ms flat
CREATE (a:Phi{deltimestamp:$a_deltimestamp}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.ssn=$a_ssn,a.dob=$a_dob,a.firstname=$a_…
CREATE (a:Phi{deltimestamp:$a_deltimestamp}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.ssn=$a_ssn,a.dob=$a_dob,a.firstname=$a_firstname,a.middlename=$a_middlename,a.lastname=$a_lastname,a.nickname=$a_nickname,a.suffix=$a_suffix,a.fullname=$a_fullname,a.preferredname=$a_preferredname,a.address1=$a_address1,a.address2=$a_address2,a.city=$a_city,a.state=$a_state,a.country=$a_country,a.zippostalcode=$a_zippostalcode,a.latitude=$a_latitude,a.longitude=$a_longitude,a.email=$a_email,a.homephone=$a_homephone,a.workphone=$a_workphone,a.mobilephone=$a_mobilephone,a.primaryphonetype=$a_primaryphonetype,a.secondaryphonetype=$a_secondaryphonetype,a.emergencycontactname=$a_emergencycontactname,a.emergencycontactphonenumber=$a_emergencycontactphonenumber,a.emergencycontactrelation=$a_emergencycontactrelation,a.emergencycontactemail=$a_emergencycontactemail,a.haspowerofattorney=$a_haspowerofattorney,a.pofaisemergencycontact=$a_pofaisemergencycontact,a.powerofattorneyname=$a_powerofattorneyname,a.powerofattorneyrelation=$a_powerofattorneyrelation,a.hasstudypartner=$a_hasstudypartner,a.studypartnername=$a_studypartnername,a.studypartnerrelation=$a_studypartnerrelation,a.studypartnerisemergencycontact=$a_studypartnerisemergencycontact,a.studypartneraddress1=$a_studypartneraddress1,a.studypartneraddress2=$a_studypartneraddress2,a.studypartnercity=$a_studypartnercity,a.studypartnerstate=$a_studypartnerstate,a.studypartnerzipcode=$a_studypartnerzipcode,a.studypartnercountry=$a_studypartnercountry,a.studypartneremail=$a_studypartneremail,a.studypartnerphone=$a_studypartnerphone,a.overridekeys=$a_overridekeys RETURN a.tildaid, a.createdat
write patientsvc
2 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
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
write regsvc
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)
write tusker
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
write notifsvc
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)
write onboardingsvc
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 onboardingsvc
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)
write onboardingsvc
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()
write onboardingsvc
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
write patientsvc
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)
write patientsvc
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)
write patientsvc
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)
write patientsvc
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)
write patientsvc
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
write patientsvc
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)
write execsvc
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()
write execsvc
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)
write execsvc
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
write onboardingsvc
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)
write onboardingsvc
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
write onboardingsvc
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).