Xray
daily 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-19 17:57:49.
› →|
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 31h ago top 80 of 787

Neo4j query shapes on delta 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
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 (w:WorkOrder {tildaid:$wo})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity {activity_type:?}) WITH a ORDER BY coalesce(a.last_attempt_at, a.createdat) DESC RETURN a.errors AS errors, a.retry_count AS retry_count LIMIT ?
MATCH (w:WorkOrder {tildaid:$wo})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity {activity_type:?}) WITH a ORDER BY coalesce(a.last_attempt_at, a.createdat) DESC RETURN a.errors AS errors, a.retry_count AS retry_count LIMIT ?
virtual-assistant
2 0 ms <1 ms 0 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
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
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
execsvc
36 <1 ms 2 ms 1 ms flat
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 (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask) RETURN t.status AS status, count(t) AS cnt
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask) RETURN t.status AS status, count(t) AS cnt
virtual-assistant
4 <1 ms 2 ms 1 ms flat
MATCH (o:Organization {tildaid: $org_id}) WHERE o.alias <> ? RETURN o.alias as alias, coalesce(o.aiTeammateName, ?) as aiTeammateName, coalesce(o.aiTeammateEmail, ?) as aiTeammateEmail
MATCH (o:Organization {tildaid: $org_id}) WHERE o.alias <> ? RETURN o.alias as alias, coalesce(o.aiTeammateName, ?) as aiTeammateName, coalesce(o.aiTeammateEmail, ?) as aiTeammateEmail
virtual-assistant
2 <1 ms 2 ms 1 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact) WHERE f.delpending = false RETURN f ORDER BY f.createdat ASC
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact) WHERE f.delpending = false RETURN f ORDER BY f.createdat ASC
virtual-assistant
2 <1 ms 2 ms 1 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE a.activity_type = ? AND a.from_ai_teammate_name IS NOT NULL AND a.from_ai_teammate_name <> ? RETURN a.from_ai_teammate_name AS name ORDER …
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE a.activity_type = ? AND a.from_ai_teammate_name IS NOT NULL AND a.from_ai_teammate_name <> ? RETURN a.from_ai_teammate_name AS name ORDER BY coalesce(a.createdat, a.timestamp) ASC LIMIT ?
virtual-assistant
6 <1 ms 2 ms 1 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
4 <1 ms 2 ms 1 ms 0.5× ↓
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
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 (p:Policy {name:$name}) SET p.state = $state
MATCH (p:Policy {name:$name}) SET p.state = $state
write onboardingsvc
324 <1 ms 2 ms 65 ms 1.7× ↑
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
workplansvc
5 <1 ms 2 ms 1 ms flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? R…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? RETURN wp.tildaid AS instanceId, cfg.tildaid AS cfgId LIMIT $limit
workplansvc
4,815 <1 ms 2 ms 48 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
8 <1 ms 2 ms 1 ms flat
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
workplansvc
4,815 <1 ms 2 ms 53 ms flat
MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n
MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n
virtual-assistant
6 <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 (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND a.activity_type IN $activity_types AND coalesce(a.ignoreType,?) <> ? RETURN count(a) as total
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND a.activity_type IN $activity_types AND coalesce(a.ignoreType,?) <> ? RETURN count(a) as total
virtual-assistant
4 <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
4 <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
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
8 <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(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
1,832 <1 ms 2 ms 110 ms flat
MATCH (hdm:Medication{tildaid:$tildaid})-[:ALL_CHANGELOG]-(cl:ChangeLog) WHERE cl.type IN [?, ?] RETURN cl ORDER BY cl.createdat DESC
MATCH (hdm:Medication{tildaid:$tildaid})-[:ALL_CHANGELOG]-(cl:ChangeLog) WHERE cl.type IN [?, ?] RETURN cl ORDER BY cl.createdat DESC
execsvc
129 <1 ms 2 ms 3 ms flat
match (i:Inbox)-[:OWNED_BY]->(u:User) where u.email = $userEmail return { inbox: i, studyName: null } AS result limit ?
match (i:Inbox)-[:OWNED_BY]->(u:User) where u.email = $userEmail return { inbox: i, studyName: null } AS result limit ?
tusker
3 1 ms 2 ms 1 ms flat
MATCH (o:Organization {tildaid: $org_id})<-[:WORK_ORDER_CONFIG_TO_ORGANIZATION]-(b:WorkOrderConfig) WHERE b.delpending = false AND (b.study_id IN $lists.accessible_study_ids OR coalesce(b.study_id, ?) = ?) AND b.status <> ? OPTIONAL MATCH …
MATCH (o:Organization {tildaid: $org_id})<-[:WORK_ORDER_CONFIG_TO_ORGANIZATION]-(b:WorkOrderConfig) WHERE b.delpending = false AND (b.study_id IN $lists.accessible_study_ids OR coalesce(b.study_id, ?) = ?) AND b.status <> ? OPTIONAL MATCH (b)-[:WORK_ORDER_CONFIG_TO_CHILD_WORK_ORDER]->(w:WorkOrder) WHERE w.delpending = false AND w.status <> ? AND w.status IN $lists.child_statuses WITH b, count(w) as child_count WHERE (child_count > ?) RETURN count(DISTINCT b) as total
virtual-assistant
3 1 ms 2 ms 1 ms flat
match (:StudyNotification{studyId:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return clog order by clog.createdat desc
match (:StudyNotification{studyId:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return clog order by clog.createdat desc
enrollsvc
1 1 ms 2 ms 1 ms flat
match (sn:StudyNotification{studyId:$studyId }) return sn skip $skip limit $limit
match (sn:StudyNotification{studyId:$studyId }) return sn skip $skip limit $limit
enrollsvc
1 1 ms 2 ms 1 ms flat
match(org:Organization{tildaid:$orgId})-[:STUDY_TO_ORG]-(study:Study{tildaid:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return count(clog)
match(org:Organization{tildaid:$orgId})-[:STUDY_TO_ORG]-(study:Study{tildaid:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return count(clog)
enrollsvc
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 (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
2 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 (w:WorkOrder {tildaid: $wo}) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_STUDY]->(s:Study) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_SITE]->(site:Site) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_CREATOR]->(creator:User) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_AS…
MATCH (w:WorkOrder {tildaid: $wo}) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_STUDY]->(s:Study) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_SITE]->(site:Site) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_CREATOR]->(creator:User) OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ASSIGNEE]->(assignee:User) OPTIONAL MATCH (resolver:User {tildaid: w.resolved_by}) OPTIONAL MATCH (lateAcker:User {tildaid: w.late_reply_ack_by}) OPTIONAL MATCH (parentCfg:WorkOrderConfig {tildaid: w.parent_id}) OPTIONAL MATCH (event:Event {tildaid: w.event_id}) OPTIONAL MATCH (partner:Partner {tildaid: w.recipient_key}) OPTIONAL MATCH (:Actor {tildaid: w.recipient_key})-[:FOR_USER]->(member:User) WITH w, s, site, creator, assignee, resolver, lateAcker, parentCfg, event, partner, member, head([(w)-[:WORK_ORDER_TO_EVENT_SCOPE]->(scope:EventScope) | scope]) AS es OPTIONAL MATCH (es_site:Site {tildaid: es.scopeId}) WHERE es.scopeType = ? RETURN s.name AS studyName, s.protocolnumber AS protocolNumber, COALESCE(site.name, null) AS siteName, head([(s)-[:PLAN_DEFINITION_TO_STUDY]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_SITE]-(site) | pd.siteNumber]) AS site_number, COALESCE(creator.firstName + ? + creator.lastName, creator.email, ?) AS creatorName, COALESCE(assignee.firstName + ? + assignee.lastName, assignee.email, ?) AS assigneeName, CASE WHEN w.resolved_by = ? THEN ? ELSE COALESCE(resolver.firstName + ? + resolver.lastName, resolver.email) END AS resolvedByName, COALESCE(lateAcker.firstName + ? + lateAcker.lastName, lateAcker.email) AS lateReplyAckByName, parentCfg.title AS parentTitle, event.name AS eventLabel, // Same fragments as WorkOrderConfigRepository.get_child_work_orders / list_work_order_configs; // a standalone WO (no parent config) has neither. CASE WHEN parentCfg IS NULL THEN null WHEN es IS NOT NULL THEN CASE toLower(es.scopeType) WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE es.scopeType END WHEN coalesce(parentCfg.study_id, ?) = ? THEN ? WHEN toLower(coalesce(parentCfg.entity_type, ?)) = ? THEN ? WHEN toLower(coalesce(parentCfg.entity_type, ?)) = ? THEN ? ELSE ? END AS entityType, CASE WHEN parentCfg IS NULL THEN null WHEN es IS NOT NULL THEN CASE es.scopeType WHEN ? THEN COALESCE(es_site.name, es.name, es.scopeId) WHEN ? THEN COALESCE(es.scopeId, es.name) ELSE COALESCE(s.name, w.study_id) END WHEN w.recipient_key IS NOT NULL AND parentCfg.entity_type = ? THEN coalesce(CASE WHEN partner.name <> ? THEN partner.name END, ?) WHEN w.recipient_key IS NOT NULL AND parentCfg.entity_type = ? THEN coalesce(CASE WHEN trim(coalesce(member.firstName, ?) + ? + coalesce(member.lastName, ?)) <> ? THEN trim(coalesce(member.firstName, ?) + ? + coalesce(member.lastName, ?)) WHEN member.name <> ? THEN member.name WHEN member.email <> ? THEN member.email END, ?) WHEN site IS NOT NULL THEN COALESCE(site.name, w.site_id) ELSE ? END AS entityName, [(w)-[:WORK_ORDER_TO_CONTACT]-(c:User) WHERE c.deltimestamp = ? | {email: c.email, name: c.name}] AS contacts
virtual-assistant
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 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 (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
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
docsvc
1 1 ms 2 ms 1 ms flat
MATCH (t:TmfTemplate) WHERE t.archivedTimestamp IS NULL SET t.archivedTimestamp = ? RETURN count(t)
MATCH (t:TmfTemplate) WHERE t.archivedTimestamp IS NULL SET t.archivedTimestamp = ? RETURN count(t)
write docsvc
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)
docsvc
1 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
1 1 ms 2 ms 1 ms flat
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
5 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
5 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 (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
5 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
MATCH (p:TMFSyncPendingExport) RETURN DISTINCT p.sync_config_id AS sync_config_id
MATCH (p:TMFSyncPendingExport) RETURN DISTINCT p.sync_config_id AS sync_config_id
tmfsync
2,404 <1 ms 2 ms 68 ms flat
MATCH(a:Policy{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
MATCH(a:Policy{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
onboardingsvc
1,810 <1 ms 2 ms 61 ms flat
MATCH (cp:CarePlan {tildaid: $carePlanId}) SET cp._LOCK_ = true REMOVE cp._LOCK_ WITH cp, coalesce(cp.autoQueryEvalClaimUntil, ?) = $until AS held CALL (cp, held) { WITH cp WHERE held SET cp.autoQueryEvalClaimUntil = $next } RETURN held
MATCH (cp:CarePlan {tildaid: $carePlanId}) SET cp._LOCK_ = true REMOVE cp._LOCK_ WITH cp, coalesce(cp.autoQueryEvalClaimUntil, ?) = $until AS held CALL (cp, held) { WITH cp WHERE held SET cp.autoQueryEvalClaimUntil = $next } RETURN held
write execsvc
60 1 ms 2 ms 2 ms flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONA…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) OPTIONAL MATCH (reviewer:User {tildaid: wp.checkpointRejectCascadeReviewerId}) RETURN wp.tildaid AS instanceId, coalesce(wp.checkpointRejectCascadeGateItemId, ?) AS gateItemId, coalesce(wp.checkpointRejectCascadeReviewerId, ?) AS reviewerId, coalesce(reviewer.name, ?) AS reviewerName, coalesce(reviewer.email, ?) AS reviewerEmail, coalesce(wp.checkpointRejectCascadeNotes, ?) AS notes, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
4,815 <1 ms 2 ms 46 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
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
4,815 <1 ms 2 ms 33 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
2,410 <1 ms 2 ms 36 ms flat
MATCH(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
MATCH(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
onboardingsvc
178 <1 ms 2 ms 12 ms flat
MATCH(a:Policy{tildaid:$a_tildaid})-[r:IS_ASSIGNED_TO]->(b:Role) RETURN b limit $limit
MATCH(a:Policy{tildaid:$a_tildaid})-[r:IS_ASSIGNED_TO]->(b:Role) RETURN b limit $limit
onboardingsvc
1,820 <1 ms 2 ms 48 ms flat
CALL { MATCH (ctx:WorkPlanContext) WHERE ctx.delpending = true RETURN ctx UNION MATCH (ctx:WorkPlanContext) WHERE ctx.createdat < $cutoff RETURN ctx } WITH DISTINCT ctx LIMIT $limit DETACH DELETE ctx RETURN count(ctx) AS deleted
CALL { MATCH (ctx:WorkPlanContext) WHERE ctx.delpending = true RETURN ctx UNION MATCH (ctx:WorkPlanContext) WHERE ctx.createdat < $cutoff RETURN ctx } WITH DISTINCT ctx LIMIT $limit DETACH DELETE ctx RETURN count(ctx) AS deleted
write workplansvc
4,815 <1 ms 2 ms 42 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 flat
MATCH (c:TMFSyncConfig) RETURN c {.*} AS c ORDER BY c.created_at DESC SKIP $offset LIMIT $limit
MATCH (c:TMFSyncConfig) RETURN c {.*} AS c ORDER BY c.created_at DESC SKIP $offset LIMIT $limit
tmfsync
4,967 <1 ms 2 ms 30 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND a.activity_type IN $activity_types AND a.status IN $statuses AND coalesce(a.ignoreType,?) <> ? RETURN count(a) as total
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND a.activity_type IN $activity_types AND a.status IN $statuses AND coalesce(a.ignoreType,?) <> ? RETURN count(a) as total
virtual-assistant
1,876 <1 ms 2 ms 133 ms flat
MATCH (w:WorkOrder {tildaid: $wo})-[:WORK_ORDER_TO_ORGANIZATION]->(o:Organization) RETURN CASE WHEN EXISTS { (:WorkOrderConfig {source_type: ?})-[:WORK_ORDER_CONFIG_TO_CHILD_WORK_ORDER]->(w) } THEN false ELSE COALESCE(o.reminderApprovalReq…
MATCH (w:WorkOrder {tildaid: $wo})-[:WORK_ORDER_TO_ORGANIZATION]->(o:Organization) RETURN CASE WHEN EXISTS { (:WorkOrderConfig {source_type: ?})-[:WORK_ORDER_CONFIG_TO_CHILD_WORK_ORDER]->(w) } THEN false ELSE COALESCE(o.reminderApprovalRequired, true) END AS approval_required
virtual-assistant
323 1 ms 2 ms 23 ms 2.9× ↑

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).