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
stored34h agotop 80 of 1,272
Neo4j query shapes on delta over the last 14d, grouped by plan hash.
Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.
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
writeexecsvc
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
writeexecsvc
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
writeexecsvc
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
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
writeexecsvc
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)
writedocsvc
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
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).