Xray
daily rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 7 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:53.
› →|
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 1,272

Neo4j query shapes on delta over the last 7d, 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(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
1 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(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
MATCH(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
onboardingsvc
3 <1 ms 2 ms 1 ms flat
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
enrollsvc
7 <1 ms 2 ms 1 ms flat
MERGE (c:MemoryEstimateConfig { operation: $operation, attribute: $attribute, content_type: $content_type }) ON CREATE SET c.overhead_mb = $overhead_mb, c.multiplier = $multiplier, c.sample_count = ?, c.confidence_score = ?.?, c.last_updat…
MERGE (c:MemoryEstimateConfig { operation: $operation, attribute: $attribute, content_type: $content_type }) ON CREATE SET c.overhead_mb = $overhead_mb, c.multiplier = $multiplier, c.sample_count = ?, c.confidence_score = ?.?, c.last_updated = timestamp(), c.source = ?
write docproc
41 <1 ms 2 ms 2 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
8,540 <1 ms 2 ms 48 ms flat
MATCH (a:Actor{tildaid:$id})-[:STUDYSITEACTOR_TO_ACTOR]-(ssa:StudySiteActor) OPTIONAL MATCH (ssa)-[:STUDYSITEACTOR_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition) OPTIONAL MATCH (ssa)-[:STUDYSITEDUTY_TO_STUDYSITEACTOR]-(ssd:StudySiteDuty{delpen…
MATCH (a:Actor{tildaid:$id})-[:STUDYSITEACTOR_TO_ACTOR]-(ssa:StudySiteActor) OPTIONAL MATCH (ssa)-[:STUDYSITEACTOR_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition) OPTIONAL MATCH (ssa)-[:STUDYSITEDUTY_TO_STUDYSITEACTOR]-(ssd:StudySiteDuty{delpending:false})-[:DUTY_TO_STUDYSITEDUTY]-(d:Duty) RETURN ssa.tildaid, ssa.roles, ssa.location, pd.scopeId, pd.scopeName, collect(CASE WHEN d IS NOT NULL THEN {dutyId: d.tildaid, title: d.title, number: d.number, status: ssd.status, startDate: ssd.startDate, endDate: ssd.endDate, removed: ssd.removed} END)
enrollsvc
2 <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 (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
onboardingsvc
6 <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
RETURN ? as health_check
RETURN ? as health_check
virtual-assistant
2 <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
6,188 <1 ms 2 ms 53 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
42 <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
96 <1 ms 2 ms 24 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
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
5 <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
4,260 <1 ms 2 ms 68 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 (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
studiosvc
3 <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
2,352 <1 ms 2 ms 3 ms flat
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
execsvc
19 <1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
enrollsvc
7 <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 (j:TMFSyncJob {status: ?}) WHERE j.claim_expires_at < $now_ms RETURN j.id AS id, j.org_alias AS org_alias, j.study_id AS study_id, j.sync_config_id AS sync_config_id, j.connector_type AS connector_type, j.claimed_by AS dead_pod, j.cl…
MATCH (j:TMFSyncJob {status: ?}) WHERE j.claim_expires_at < $now_ms RETURN j.id AS id, j.org_alias AS org_alias, j.study_id AS study_id, j.sync_config_id AS sync_config_id, j.connector_type AS connector_type, j.claimed_by AS dead_pod, j.claim_expires_at AS claim_expires_at, j.lane AS lane LIMIT ?
tmfsync
2,352 <1 ms 2 ms 4 ms flat
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
studiosvc
4 <1 ms 2 ms 1 ms flat
MATCH (j:CtmsSyncJob {status: ?}) WHERE j.claim_expires_at < $now_ms RETURN j.id AS id, j.org_alias AS org_alias, j.study_id AS study_id, j.sync_config_id AS sync_config_id, j.type AS type, coalesce(j.reap_count, ?) AS reap_count, j.claime…
MATCH (j:CtmsSyncJob {status: ?}) WHERE j.claim_expires_at < $now_ms RETURN j.id AS id, j.org_alias AS org_alias, j.study_id AS study_id, j.sync_config_id AS sync_config_id, j.type AS type, coalesce(j.reap_count, ?) AS reap_count, j.claimed_by AS dead_pod, j.claim_expires_at AS claim_expires_at LIMIT ?
tmfsync
2,352 <1 ms 2 ms 9 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
29 <1 ms 2 ms 1 ms flat
MATCH(a:VariableV2)-[r:VARIABLE_TO_QUESTION_SPEC]->(b:QuestionSpec{tildaid:$b_tildaid}) RETURN a limit $limit
MATCH(a:VariableV2)-[r:VARIABLE_TO_QUESTION_SPEC]->(b:QuestionSpec{tildaid:$b_tildaid}) RETURN a limit $limit
studiosvc
5 <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 (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = ? AND j.jobType IN [?, ?, ?] RETURN j.tildaid ORDER BY j.createdat ASC
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = ? AND j.jobType IN [?, ?, ?] RETURN j.tildaid ORDER BY j.createdat ASC
docsvc
78 <1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
17 <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
29 <1 ms 2 ms 1 ms flat
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
enrollsvc
6 <1 ms 2 ms 1 ms flat
UNWIND $refIds AS id CALL (id) { MATCH (ref:GraphNodeRef {tildaid:id}) WHERE EXISTS { MATCH (ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(:VisitV2)<-[:BELONGS_TO_VISIT]-(pv:ParticipantVisit) WHERE pv.status IN $statuses } RETURN ref.tildaid AS s…
UNWIND $refIds AS id CALL (id) { MATCH (ref:GraphNodeRef {tildaid:id}) WHERE EXISTS { MATCH (ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(:VisitV2)<-[:BELONGS_TO_VISIT]-(pv:ParticipantVisit) WHERE pv.status IN $statuses } RETURN ref.tildaid AS started } RETURN started
studiosvc
7 <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
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
10 <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 (i:TMFSyncItem {status: ?, direction: ?}) WHERE i.next_retry_at IS NULL AND coalesce(i.item_kind, ?) = $item_kind RETURN count(i) AS n
MATCH (i:TMFSyncItem {status: ?, direction: ?}) WHERE i.next_retry_at IS NULL AND coalesce(i.item_kind, ?) = $item_kind RETURN count(i) AS n
tmfsync
470 <1 ms 2 ms 4 ms flat
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
notifsvc
25 <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
29 <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 (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
execsvc
3 1 ms 2 ms 1 ms flat
match (vsos:VisitState) return vsos
match (vsos:VisitState) return vsos
execsvc
3 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
studiosvc
3 1 ms 2 ms 1 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 (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
4 1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
docsvc
2 1 ms 2 ms 1 ms flat
match(a:Study{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Study{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write docsvc
1 1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
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
regsvc
5 1 ms 2 ms 1 ms flat
MATCH(a:User{email:$a_email}) RETURN a limit $a_limit
MATCH(a:User{email:$a_email}) RETURN a limit $a_limit
schedsvc
4 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(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
7 1 ms 2 ms 1 ms flat
MATCH (o:Study{tildaid:$scopeId})-[scope:STUDY_TO_ACTOR]->(a:Actor)-[:FOR_USER]->(u:User{tildaid:$userId}) MATCH (a)-[:APPOINTED_AS]->(r:Role) WHERE u.status<>? AND a.state<>? RETURN distinct a
MATCH (o:Study{tildaid:$scopeId})-[scope:STUDY_TO_ACTOR]->(a:Actor)-[:FOR_USER]->(u:User{tildaid:$userId}) MATCH (a)-[:APPOINTED_AS]->(r:Role) WHERE u.status<>? AND a.state<>? RETURN distinct a
enrollsvc
7 1 ms 2 ms 1 ms flat
MATCH(a:Actor{userId:$a_userId,orgId:$a_orgId,scopeId:$a_scopeId,delpending:$a_delpending}) RETURN a
MATCH(a:Actor{userId:$a_userId,orgId:$a_orgId,scopeId:$a_scopeId,delpending:$a_delpending}) RETURN a
execsvc
8 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
schedsvc
2 1 ms 2 ms 1 ms flat
match(prev:GraphNode)-[rel:GRAPH_NEXT{graphid:$formId}]->(b:GraphNode{tildaid:$nodeId}) where rel.path[?]=$formId return count(b)
match(prev:GraphNode)-[rel:GRAPH_NEXT{graphid:$formId}]->(b:GraphNode{tildaid:$nodeId}) where rel.path[?]=$formId return count(b)
studiosvc
5 1 ms 2 ms 1 ms flat
MATCH (proto:FormV2 {tildaid: $protoId})-[pr:PROTOCOL_TO_GRAPH_NODE_REF]->(ref:GraphNodeRef) MATCH (ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION {protocolid: $protoId}]->(target) WHERE (target:QuestionV2 OR target:Respons…
MATCH (proto:FormV2 {tildaid: $protoId})-[pr:PROTOCOL_TO_GRAPH_NODE_REF]->(ref:GraphNodeRef) MATCH (ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION {protocolid: $protoId}]->(target) WHERE (target:QuestionV2 OR target:ResponseSet OR target:FormV2) AND target.tildaid IN $targetIds RETURN target.tildaid AS tid, ref.tildaid AS refId, pr.path AS path
studiosvc
4 1 ms 2 ms 1 ms flat
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
studiosvc
8 1 ms 2 ms 1 ms flat
MATCH(a:QuestionV2{tildaid:$a_tildaid})-[r:QUESTION_TO_QUESTION_SPEC]->(b:QuestionSpec) RETURN b ORDER BY b.pos limit $limit
MATCH(a:QuestionV2{tildaid:$a_tildaid})-[r:QUESTION_TO_QUESTION_SPEC]->(b:QuestionSpec) RETURN b ORDER BY b.pos limit $limit
studiosvc
5 1 ms 2 ms 1 ms flat
MATCH(a:QuestionSpec{tildaid:$a_tildaid})-[r:QUESTION_SPEC_TO_RESPONSE_SET]->(b:ResponseSet) RETURN b ORDER BY b.pos limit $limit
MATCH(a:QuestionSpec{tildaid:$a_tildaid})-[r:QUESTION_SPEC_TO_RESPONSE_SET]->(b:ResponseSet) RETURN b ORDER BY b.pos limit $limit
studiosvc
5 1 ms 2 ms 1 ms flat
match(proto:FormV2{tildaid:$protocolId})-[:PROTOCOL_TO_RESPONSE_SET]->(rs:ResponseSet{state:?}) match(org:Organization{tildaid:$orgId}) where (exists((org)-[:ORGANIZATION_TO_RESPONSE_SET]->(rs)) or rs.orgid = org.tildaid) and rs.shared=tru…
match(proto:FormV2{tildaid:$protocolId})-[:PROTOCOL_TO_RESPONSE_SET]->(rs:ResponseSet{state:?}) match(org:Organization{tildaid:$orgId}) where (exists((org)-[:ORGANIZATION_TO_RESPONSE_SET]->(rs)) or rs.orgid = org.tildaid) and rs.shared=true and coalesce(rs.isyesno, false) = false return count(distinct rs)
studiosvc
1 1 ms 2 ms 1 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).