Xray
hourly rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 48 hours▾
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-19 13:48:52.
› →|
updated 1d 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 27h ago top 80 of 820

Neo4j query shapes on delta over the last 48h, 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
WITH $`t` as `t` 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, u, collect(au) as auCollected, cu as createdBy return {Task: …
WITH $`t` as `t` 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, u, collect(au) as auCollected, cu as createdBy return {Task: t, User: u, AssignedUser: auCollected, CreatedBy: createdBy}
tusker
3 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
write execsvc
5 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
execsvc
5 0 ms <1 ms 0 ms flat
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
workplansvc
2 0 ms <1 ms 0 ms flat
CREATE INDEX insight_scope IF NOT EXISTS FOR (i:Insight) ON (i.group_id, i.category)
CREATE INDEX insight_scope IF NOT EXISTS FOR (i:Insight) ON (i.group_id, i.category)
write chat-agent
2 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
write execsvc
5 <1 ms 2 ms 1 ms flat
MATCH (hdm:Procedure) WHERE hdm.tildaid IN [?] OPTIONAL MATCH (hdm)-[:PARTICIPANT_TABLE]-(:ParticipantTable)-[:PARTICIPANT_QUESTION|PARTICIPANT_DOC_UPLOAD]-(pobj)-[:HAS_QUERY]-(q:Query) WHERE pobj.hdmClassId = hdm.tildaid AND q.delpending …
MATCH (hdm:Procedure) WHERE hdm.tildaid IN [?] OPTIONAL MATCH (hdm)-[:PARTICIPANT_TABLE]-(:ParticipantTable)-[:PARTICIPANT_QUESTION|PARTICIPANT_DOC_UPLOAD]-(pobj)-[:HAS_QUERY]-(q:Query) WHERE pobj.hdmClassId = hdm.tildaid AND q.delpending = false AND q.state <> ? AND q.state <> ? AND coalesce(q.supersededAt, ?) = ? RETURN hdm.tildaid as id, hdm.edcBitMap as edcBitMap, count(q) as openQueryCount
write execsvc
4 <1 ms 2 ms 1 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(ae:AdverseEvent) optional match (cp:CarePlan{tildaid: ae.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(ae:AdverseEvent) optional match (cp:CarePlan{tildaid: ae.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 (ae)<-[:OBJ_TO_ADVERSE_EVENT]-(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, ae, 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
3 <1 ms 2 ms 1 ms flat
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = $inProgress AND NOT j.tildaid IN $exclude RETURN j.tildaid LIMIT ?
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = $inProgress AND NOT j.tildaid IN $exclude RETURN j.tildaid LIMIT ?
docsvc
3 <1 ms 2 ms 1 ms 2.1× ↑
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_EMAIL_NOTIFICATION]->(b:EmailNotification) RETURN a, b limit ?
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_EMAIL_NOTIFICATION]->(b:EmailNotification) RETURN a, b limit ?
schedsvc
3 <1 ms 2 ms 1 ms 0.5× ↓
MATCH (hdm:MedicalCondition) WHERE hdm.tildaid IN [?] OPTIONAL MATCH (hdm)-[:PARTICIPANT_TABLE]-(:ParticipantTable)-[:PARTICIPANT_QUESTION|PARTICIPANT_DOC_UPLOAD]-(pobj)-[:HAS_QUERY]-(q:Query) WHERE pobj.hdmClassId = hdm.tildaid AND q.delp…
MATCH (hdm:MedicalCondition) WHERE hdm.tildaid IN [?] OPTIONAL MATCH (hdm)-[:PARTICIPANT_TABLE]-(:ParticipantTable)-[:PARTICIPANT_QUESTION|PARTICIPANT_DOC_UPLOAD]-(pobj)-[:HAS_QUERY]-(q:Query) WHERE pobj.hdmClassId = hdm.tildaid AND q.delpending = false AND q.state <> ? AND q.state <> ? AND coalesce(q.supersededAt, ?) = ? RETURN hdm.tildaid as id, hdm.edcBitMap as edcBitMap, count(q) as openQueryCount
write execsvc
4 <1 ms 2 ms 1 ms flat
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
execsvc
4 <1 ms 2 ms 1 ms flat
MATCH(a:Staff)-[r:IS_USER]->(b:User{email:$b_email}) RETURN a limit $limit
MATCH(a:Staff)-[r:IS_USER]->(b:User{email:$b_email}) RETURN a limit $limit
schedsvc
4 <1 ms 2 ms 1 ms flat
DROP CONSTRAINT config_finding_key IF EXISTS
DROP CONSTRAINT config_finding_key IF EXISTS
write ontologysvc
4 <1 ms 2 ms 1 ms flat
CREATE INDEX about_ext IF NOT EXISTS FOR ()-[a:ABOUT]-() ON (a.external_id)
CREATE INDEX about_ext IF NOT EXISTS FOR ()-[a:ABOUT]-() ON (a.external_id)
write chat-agent
2 <1 ms 2 ms 1 ms flat
CREATE INDEX insight_inval IF NOT EXISTS FOR (i:Insight) ON (i.invalid_at)
CREATE INDEX insight_inval IF NOT EXISTS FOR (i:Insight) ON (i.invalid_at)
write chat-agent
2 <1 ms 2 ms 1 ms flat
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
studiosvc
2 <1 ms 2 ms 1 ms flat
CREATE INDEX tmfsync_job_tenant IF NOT EXISTS FOR (j:TMFSyncJob) ON (j.org_alias, j.study_id)
CREATE INDEX tmfsync_job_tenant IF NOT EXISTS FOR (j:TMFSyncJob) ON (j.org_alias, j.study_id)
write tmfsync
2 <1 ms 2 ms 1 ms flat
RETURN ? as health_check
RETURN ? as health_check
virtual-assistant
2 <1 ms 2 ms 1 ms flat
MATCH (g:MemberLabelGroup{scopeId:$orgId, scopeType:?}) WHERE g.delpending = false RETURN g{.*} AS result ORDER BY toLower(g.name)
MATCH (g:MemberLabelGroup{scopeId:$orgId, scopeType:?}) WHERE g.delpending = false RETURN g{.*} AS result ORDER BY toLower(g.name)
onboardingsvc
2 <1 ms 2 ms 1 ms flat
MATCH (wpt:WorkPlanTemplate) WHERE coalesce(wpt.status, ?) = ? SET wpt.status = $status, wpt.managedBy = coalesce(wpt.managedBy, $managedByOrganization), wpt.updatedat = timestamp() RETURN count(wpt)
MATCH (wpt:WorkPlanTemplate) WHERE coalesce(wpt.status, ?) = ? SET wpt.status = $status, wpt.managedBy = coalesce(wpt.managedBy, $managedByOrganization), wpt.updatedat = timestamp() RETURN count(wpt)
write workplansvc
3 <1 ms 2 ms 1 ms flat
MATCH (fm:FolderManager)-[:INSTANTIATED_FROM_TMF_TEMPLATE]->(:TmfTemplate) WHERE fm.structureVersion IS NULL OR fm.structureVersion = ? SET fm.structureVersion = ? RETURN count(fm)
MATCH (fm:FolderManager)-[:INSTANTIATED_FROM_TMF_TEMPLATE]->(:TmfTemplate) WHERE fm.structureVersion IS NULL OR fm.structureVersion = ? SET fm.structureVersion = ? RETURN count(fm)
write docsvc
3 <1 ms 2 ms 1 ms flat
MATCH(a:Role{tildaid:$a_tildaid}) WHERE a.updatedat=$a_lastUpdated SET a.updatedat=timestamp(),a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.deltimestamp=$a_deltimestamp,a.name=$a_name,a.displayName=$a_displayName,a.listed=$a_lis…
MATCH(a:Role{tildaid:$a_tildaid}) WHERE a.updatedat=$a_lastUpdated SET a.updatedat=timestamp(),a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.deltimestamp=$a_deltimestamp,a.name=$a_name,a.displayName=$a_displayName,a.listed=$a_listed,a.assignDuty=$a_assignDuty,a.piiAccess=$a_piiAccess,a.description=$a_description,a.tags=$a_tags,a.external=$a_external RETURN count(a)
write onboardingsvc
3 <1 ms 2 ms 1 ms flat
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_SMS_NOTIFICATION]->(b:SMSNotification) RETURN a, b limit ?
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_SMS_NOTIFICATION]->(b:SMSNotification) RETURN a, b limit ?
schedsvc
3 <1 ms 2 ms 1 ms flat
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
execsvc
19 <1 ms 2 ms 1 ms flat
MATCH(a:Policy{tildaid:$a_tildaid}) WHERE a.updatedat=$a_lastUpdated SET a.updatedat=timestamp(),a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.description=$a_description,a.objectTypeList=$a_objectTypeList,a.allowedOps=$a_allowedO…
MATCH(a:Policy{tildaid:$a_tildaid}) WHERE a.updatedat=$a_lastUpdated SET a.updatedat=timestamp(),a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.description=$a_description,a.objectTypeList=$a_objectTypeList,a.allowedOps=$a_allowedOps RETURN count(a)
write onboardingsvc
4 <1 ms 2 ms 1 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask)-[:TASK_HAS_SUBTASK]->(s:WorkOrderSubtask) WHERE coalesce(t.status, ?) <> ? AND coalesce(s.is_optional, false) = false AND coalesce(s.status, ?) <> ? AND…
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask)-[:TASK_HAS_SUBTASK]->(s:WorkOrderSubtask) WHERE coalesce(t.status, ?) <> ? AND coalesce(s.is_optional, false) = false AND coalesce(s.status, ?) <> ? AND (coalesce(s.expects_document, false) = true OR s.expects_document IS NULL OR s.placeholder_id IS NOT NULL OR s.sent_doc_id IS NOT NULL OR s.received_doc_id IS NOT NULL) RETURN count(s) AS cnt
virtual-assistant
15 <1 ms 2 ms 1 ms flat
MATCH (f:Finding {study_id: $study_id, careplan_id: $careplan_id, instruction_id: $instruction_id}) WHERE f.status = ? RETURN f.tildaid AS finding_id, f.fingerprint AS fingerprint, f.execsvc_ref AS execsvc_ref ORDER BY f.at, f.tildaid
MATCH (f:Finding {study_id: $study_id, careplan_id: $careplan_id, instruction_id: $instruction_id}) WHERE f.status = ? RETURN f.tildaid AS finding_id, f.fingerprint AS fingerprint, f.execsvc_ref AS execsvc_ref ORDER BY f.at, f.tildaid
data_monitor
30 <1 ms 2 ms 1 ms flat
UNWIND $aqIds AS aqId CALL (aqId) { MATCH (hostRef:GraphNodeRef)-[h:QUESTION_TO_AUTO_QUERY {protocolid: $versionId}]-> (aq:AutoQueryConfig {tildaid: aqId})-[:AUTO_QUERY_TO_BRANCH_CONFIG]->(cfg:BranchConfig) WHERE h.sourceprotocolid IS NULL…
UNWIND $aqIds AS aqId CALL (aqId) { MATCH (hostRef:GraphNodeRef)-[h:QUESTION_TO_AUTO_QUERY {protocolid: $versionId}]-> (aq:AutoQueryConfig {tildaid: aqId})-[:AUTO_QUERY_TO_BRANCH_CONFIG]->(cfg:BranchConfig) WHERE h.sourceprotocolid IS NULL WITH cfg, collect(DISTINCT hostRef.tildaid) AS hostRefIds OPTIONAL MATCH (cfg)-[:BRANCH_CG_ALL_NEXT|BRANCH_CG_ANY_NEXT*?..]->(:BranchConditionGroup) -[:CG_TO_CONDITION*?..]->(c:BranchCondition) RETURN hostRefIds, collect(DISTINCT CASE WHEN c IS NOT NULL THEN {id: c.tildaid, refid: c.refid, operator: c.operator, choices: c.choices, choicevaluesjson: c.choicevaluesjson} END) AS conds } RETURN aqId, hostRefIds, conds
execsvc
12 <1 ms 2 ms 1 ms flat
MATCH (p:Policy {name:$name}) SET p.state = $state
MATCH (p:Policy {name:$name}) SET p.state = $state
write onboardingsvc
188 <1 ms 2 ms 25 ms 1.7× ↑
CREATE CONSTRAINT ZipExtractionJob_zipDocId IF NOT EXISTS FOR (n:ZipExtractionJob) REQUIRE (n.zipDocId) IS NODE KEY
CREATE CONSTRAINT ZipExtractionJob_zipDocId IF NOT EXISTS FOR (n:ZipExtractionJob) REQUIRE (n.zipDocId) IS NODE KEY
write docproc
3 1 ms 2 ms 1 ms flat
CREATE INDEX ZipExtractionMember_zipDocId IF NOT EXISTS FOR (n:ZipExtractionMember) ON (n.zipDocId)
CREATE INDEX ZipExtractionMember_zipDocId IF NOT EXISTS FOR (n:ZipExtractionMember) ON (n.zipDocId)
write docproc
3 1 ms 2 ms 1 ms flat
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_JOBSTATE]->(b:JobState) RETURN b limit $limit
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_JOBSTATE]->(b:JobState) RETURN b limit $limit
notifsvc
3 1 ms 2 ms 1 ms flat
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_EMAIL_NOTIFICATION]->(b:EmailNotification) RETURN a, b limit ?
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_EMAIL_NOTIFICATION]->(b:EmailNotification) RETURN a, b limit ?
notifsvc
3 1 ms 2 ms 1 ms flat
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
execsvc
1 1 ms 2 ms 1 ms flat
MATCH(a:ParticipantVisit{tildaid:$a_tildaid})-[r:ALL_CHANGELOG]->(b:ChangeLog{scopeId:$b_scopeId,type:$b_type}) RETURN b ORDER BY b.createdat DESC limit $limit
MATCH(a:ParticipantVisit{tildaid:$a_tildaid})-[r:ALL_CHANGELOG]->(b:ChangeLog{scopeId:$b_scopeId,type:$b_type}) RETURN b ORDER BY b.createdat DESC limit $limit
execsvc
1 1 ms 2 ms 1 ms flat
MATCH (p:Partner{delpending:false}) WITH COUNT(p) AS numAll, COUNT(CASE WHEN p.status = ? THEN ? END) AS numActive, COUNT(CASE WHEN p.status = ? THEN ? END) AS numInactive RETURN distinct ({numAll: numAll, numActive: numActive, numInactive…
MATCH (p:Partner{delpending:false}) WITH COUNT(p) AS numAll, COUNT(CASE WHEN p.status = ? THEN ? END) AS numActive, COUNT(CASE WHEN p.status = ? THEN ? END) AS numInactive RETURN distinct ({numAll: numAll, numActive: numActive, numInactive: numInactive }) AS result
onboardingsvc
1 1 ms 2 ms 1 ms flat
MATCH (:Study{tildaid:$studyId,delpending:false})-[:FOR_STUDY]-(sp:StudyPartnership{delpending:false})-[:FOR_PARTNER]-(:Partner{delpending:false}) WITH COUNT(sp) AS numAll, COUNT(CASE WHEN sp.status = ? THEN ? END) AS numPending, COUNT(CAS…
MATCH (:Study{tildaid:$studyId,delpending:false})-[:FOR_STUDY]-(sp:StudyPartnership{delpending:false})-[:FOR_PARTNER]-(:Partner{delpending:false}) WITH COUNT(sp) AS numAll, COUNT(CASE WHEN sp.status = ? THEN ? END) AS numPending, COUNT(CASE WHEN sp.status = ? THEN ? END) AS numApproved, COUNT(CASE WHEN sp.status = ? THEN ? END) AS numRejected RETURN distinct ({ numAll: numAll, numPending: numPending, numApproved: numApproved, numRejected: numRejected }) AS result
onboardingsvc
1 1 ms 2 ms 1 ms flat
match (cp:CarePlan{tildaid:$careplanId})-[:PARTICIPANT_ACTIVITY]-(pa:ParticipantActivity)-[:BELONGS_TO_ACTIVITY]-(a:ActivityV2{activityType:$activityType}) return {a:a}
match (cp:CarePlan{tildaid:$careplanId})-[:PARTICIPANT_ACTIVITY]-(pa:ParticipantActivity)-[:BELONGS_TO_ACTIVITY]-(a:ActivityV2{activityType:$activityType}) return {a:a}
execsvc
4 1 ms 2 ms 1 ms flat
match (vsos:VisitState) return vsos
match (vsos:VisitState) return vsos
execsvc
1 1 ms 2 ms 1 ms flat
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
execsvc
1 1 ms 2 ms 1 ms flat
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
execsvc
1 1 ms 2 ms 1 ms flat
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
tusker
4 1 ms 2 ms 1 ms flat
MATCH(a:Organization{tildaid:$a_tildaid})-[r:USES]->(b:FolderManager{name:$b_name,scopeId:$b_scopeId}) RETURN b limit $limit
MATCH(a:Organization{tildaid:$a_tildaid})-[r:USES]->(b:FolderManager{name:$b_name,scopeId:$b_scopeId}) RETURN b limit $limit
docsvc
2 1 ms 2 ms 1 ms flat
match (n:Cro{orgId:$orgId})-[:PLAN_DEFINITION_TO_CRO]-(pd:DslPlanDefinition{studyId:$studyId,delpending:false}) return pd
match (n:Cro{orgId:$orgId})-[:PLAN_DEFINITION_TO_CRO]-(pd:DslPlanDefinition{studyId:$studyId,delpending:false}) return pd
regsvc
2 1 ms 2 ms 1 ms flat
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
studiosvc
8 1 ms 2 ms 1 ms flat
MATCH (o:Organization {alias: $alias}) RETURN o.tildaid AS tildaid, o.alias AS alias, o.name AS name LIMIT ?
MATCH (o:Organization {alias: $alias}) RETURN o.tildaid AS tildaid, o.alias AS alias, o.name AS name LIMIT ?
tmfsync
1 1 ms 2 ms 1 ms flat
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
workplansvc
2 1 ms 2 ms 1 ms flat
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
docsvc
2 1 ms 2 ms 1 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
2 1 ms 2 ms 1 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
2 1 ms 2 ms 1 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
2 1 ms 2 ms 1 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
2 1 ms 2 ms 1 ms flat
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
workplansvc
1 1 ms 2 ms 1 ms flat
MERGE (a:JobState{tildaid:$a_tildaid}) ON CREATE SET a.createdat = timestamp(), a.tildaid = randomUUID() ON MATCH SET a.updatedat = timestamp() SET a.status=$a_status,a.substatus=$a_substatus,a.numOfTimesSuccessful=$a_numOfTimesSuccessful,…
MERGE (a:JobState{tildaid:$a_tildaid}) ON CREATE SET a.createdat = timestamp(), a.tildaid = randomUUID() ON MATCH SET a.updatedat = timestamp() SET a.status=$a_status,a.substatus=$a_substatus,a.numOfTimesSuccessful=$a_numOfTimesSuccessful,a.numOfTimesFailed=$a_numOfTimesFailed,a.lastFailedReason=$a_lastFailedReason,a.lastFailedTimeStamp=null RETURN a.tildaid
write notifsvc
1 1 ms 2 ms 1 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 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT fd_id IF NOT EXISTS FOR (n:Finding) REQUIRE n.tildaid IS UNIQUE
CREATE CONSTRAINT fd_id IF NOT EXISTS FOR (n:Finding) REQUIRE n.tildaid IS UNIQUE
write data_monitor
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT rv_idem_org IF NOT EXISTS FOR (n:Review) REQUIRE (n.org_id, n.idempotency_key) IS UNIQUE
CREATE CONSTRAINT rv_idem_org IF NOT EXISTS FOR (n:Review) REQUIRE (n.org_id, n.idempotency_key) IS UNIQUE
write data_monitor
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT lease_key IF NOT EXISTS FOR (n:SweepLease) REQUIRE n.key IS UNIQUE
CREATE CONSTRAINT lease_key IF NOT EXISTS FOR (n:SweepLease) REQUIRE n.key IS UNIQUE
write data_monitor
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT ms_study IF NOT EXISTS FOR (n:MonitoringSchedule) REQUIRE n.study_id IS UNIQUE
CREATE CONSTRAINT ms_study IF NOT EXISTS FOR (n:MonitoringSchedule) REQUIRE n.study_id IS UNIQUE
write data_monitor
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT ledger_key IF NOT EXISTS FOR (n:TokenLedger) REQUIRE (n.study_id, n.day) IS UNIQUE
CREATE CONSTRAINT ledger_key IF NOT EXISTS FOR (n:TokenLedger) REQUIRE (n.study_id, n.day) IS UNIQUE
write data_monitor
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT mi_id IF NOT EXISTS FOR (n:MonitoringInstruction) REQUIRE n.tildaid IS UNIQUE
CREATE CONSTRAINT mi_id IF NOT EXISTS FOR (n:MonitoringInstruction) REQUIRE n.tildaid IS UNIQUE
write data_monitor
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT msl_key IF NOT EXISTS FOR (n:MonitoringStudyLink) REQUIRE (n.study_id, n.instruction_id) IS UNIQUE
CREATE CONSTRAINT msl_key IF NOT EXISTS FOR (n:MonitoringStudyLink) REQUIRE (n.study_id, n.instruction_id) IS UNIQUE
write data_monitor
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT rv_idem IF NOT EXISTS FOR (n:Review) REQUIRE n.idempotency_key IS UNIQUE
CREATE CONSTRAINT rv_idem IF NOT EXISTS FOR (n:Review) REQUIRE n.idempotency_key IS UNIQUE
write data_monitor
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT lp_key IF NOT EXISTS FOR (n:LastPrompt) REQUIRE (n.study_id, n.careplan_id, n.instructions) IS UNIQUE
CREATE CONSTRAINT lp_key IF NOT EXISTS FOR (n:LastPrompt) REQUIRE (n.study_id, n.careplan_id, n.instructions) IS UNIQUE
write data_monitor
2 1 ms 2 ms 1 ms flat
match (patient:Patient{tildaid: $patientId})-[:HAS_PROTECTED_DATA_IN]->(phi:Phi) return phi
match (patient:Patient{tildaid: $patientId})-[:HAS_PROTECTED_DATA_IN]->(phi:Phi) return phi
notifsvc
2 1 ms 2 ms 1 ms flat
MATCH (p:Patient {tildaid: $patientId})-[:LEAD_TO_PATIENT]-(l:Lead)-[:LEAD_TO_STUDY]-(st:Study) -[:STUDY_TO_ORG]-(o:Organization) with distinct o order by o.name return o.twilioNumber,o.contactPhone limit ?
MATCH (p:Patient {tildaid: $patientId})-[:LEAD_TO_PATIENT]-(l:Lead)-[:LEAD_TO_STUDY]-(st:Study) -[:STUDY_TO_ORG]-(o:Organization) with distinct o order by o.name return o.twilioNumber,o.contactPhone limit ?
notifsvc
2 1 ms 2 ms 1 ms flat
CREATE INDEX tmfsync_item_tenant_config IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.org_alias, i.study_id, i.sync_config_id)
CREATE INDEX tmfsync_item_tenant_config IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.org_alias, i.study_id, i.sync_config_id)
write tmfsync
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT tmfsync_item_idempotency_key_unique IF NOT EXISTS FOR (i:TMFSyncItem) REQUIRE i.idempotency_key IS UNIQUE
CREATE CONSTRAINT tmfsync_item_idempotency_key_unique IF NOT EXISTS FOR (i:TMFSyncItem) REQUIRE i.idempotency_key IS UNIQUE
write tmfsync
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT tmfsync_org_settings_unique IF NOT EXISTS FOR (o:OrgSyncSettings) REQUIRE (o.org_alias, o.connector_type) IS UNIQUE
CREATE CONSTRAINT tmfsync_org_settings_unique IF NOT EXISTS FOR (o:OrgSyncSettings) REQUIRE (o.org_alias, o.connector_type) IS UNIQUE
write tmfsync
2 1 ms 2 ms 1 ms flat
CREATE CONSTRAINT tmfsync_job_id_unique IF NOT EXISTS FOR (j:TMFSyncJob) REQUIRE j.id IS UNIQUE
CREATE CONSTRAINT tmfsync_job_id_unique IF NOT EXISTS FOR (j:TMFSyncJob) REQUIRE j.id IS UNIQUE
write tmfsync
2 1 ms 2 ms 1 ms flat
CREATE INDEX tmfsync_item_tenant IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.org_alias, i.study_id)
CREATE INDEX tmfsync_item_tenant IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.org_alias, i.study_id)
write tmfsync
2 1 ms 2 ms 1 ms flat
MATCH (v:VAMigrationVersion) RETURN v.version AS version
MATCH (v:VAMigrationVersion) RETURN v.version AS version
virtual-assistant
2 1 ms 2 ms 1 ms flat
MATCH (r:Review {tildaid: $review_id}) SET r += $context RETURN r.tildaid AS review_id
MATCH (r:Review {tildaid: $review_id}) SET r += $context RETURN r.tildaid AS review_id
write data_monitor
5 1 ms 2 ms 1 ms flat
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
docsvc
1 1 ms 2 ms 1 ms flat
MATCH (l:SweepLease {key: $key}) RETURN coalesce(l.swept_at, ?) > ? AS swept
MATCH (l:SweepLease {key: $key}) RETURN coalesce(l.swept_at, ?) > ? AS swept
data_monitor
161 1 ms 2 ms 15 ms flat
MERGE (a:Sponsor{deltimestamp:$a_deltimestamp,name:$a_name}) ON CREATE SET a.createdat = timestamp(), a.tildaid = randomUUID() ON MATCH SET a.updatedat = timestamp() SET a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.alias=$a_alia…
MERGE (a:Sponsor{deltimestamp:$a_deltimestamp,name:$a_name}) ON CREATE SET a.createdat = timestamp(), a.tildaid = randomUUID() ON MATCH SET a.updatedat = timestamp() SET a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.alias=$a_alias,a.url=$a_url,a.streetAddress=$a_streetAddress,a.suite=$a_suite,a.country=$a_country,a.state=$a_state,a.city=$a_city,a.postalCode=$a_postalCode,a.bucket=$a_bucket,a.filename=$a_filename RETURN a.tildaid
write enrollsvc
213 <1 ms 2 ms 9 ms flat
MATCH (pqn:ParticipantQuestion)-[:HAS_QUERY]-(q:Query)-[:BELONGS_TO]-(cfg:AutoQueryConfig) WHERE pqn.tildaid IN $pqnIds AND cfg.tildaid IN $cfgIds AND q.state IN $states AND coalesce(q.supersededAt, ?) = ? RETURN DISTINCT pqn.tildaid, cfg.…
MATCH (pqn:ParticipantQuestion)-[:HAS_QUERY]-(q:Query)-[:BELONGS_TO]-(cfg:AutoQueryConfig) WHERE pqn.tildaid IN $pqnIds AND cfg.tildaid IN $cfgIds AND q.state IN $states AND coalesce(q.supersededAt, ?) = ? RETURN DISTINCT pqn.tildaid, cfg.tildaid
execsvc
23 <1 ms 2 ms 2 ms 0.6× ↓
MATCH (s:MonitoringSchedule {study_id: $study_id}) RETURN s
MATCH (s:MonitoringSchedule {study_id: $study_id}) RETURN s
data_monitor
48 1 ms 2 ms 10 ms flat
MATCH(a:Policy{tildaid:$a_tildaid})-[r:APPLICABLE_IN]->(b:Scope{version:$b_version}) RETURN b limit $limit
MATCH(a:Policy{tildaid:$a_tildaid})-[r:APPLICABLE_IN]->(b:Scope{version:$b_version}) RETURN b limit $limit
onboardingsvc
921 <1 ms 2 ms 37 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).