Xray
daily rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 14 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 13:32:32.
› →|
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 26h ago top 80 of 2,313

Neo4j query shapes on test27 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.

Columns
Views
Export CSV
Query shape Count Avg p95 ▴ Max p95 drift
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) SET cfg.instanceItemCreationClaimedAtMs = ?, cfg.updatedat = timestamp()
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) SET cfg.instanceItemCreationClaimedAtMs = ?, cfg.updatedat = timestamp()
write workplansvc
273 0 ms <1 ms 0 ms flat
match(smoOrg:Organization{alias:$orgAlias, orgType:?}) with smoOrg match(study:Study{tildaid:$studyId}) with smoOrg, study return smoOrg.tildaid, study.srcorgid
match(smoOrg:Organization{alias:$orgAlias, orgType:?}) with smoOrg match(study:Study{tildaid:$studyId}) with smoOrg, study return smoOrg.tildaid, study.srcorgid
advpsvc
3 0 ms <1 ms 0 ms flat
MATCH (cp:CarePlan {tildaid: $carePlanId})-[:EXECUTE_SOA]->(:ScheduleOfActivities) -[:SOA_TO_PROTOCOL_VERSION]->(pv:ProtocolVersion|ProtocolVersionV2) RETURN DISTINCT pv.tildaid AS pvId, pv:ProtocolVersionV2 AS isV2
MATCH (cp:CarePlan {tildaid: $carePlanId})-[:EXECUTE_SOA]->(:ScheduleOfActivities) -[:SOA_TO_PROTOCOL_VERSION]->(pv:ProtocolVersion|ProtocolVersionV2) RETURN DISTINCT pv.tildaid AS pvId, pv:ProtocolVersionV2 AS isV2
execsvc
12 0 ms <1 ms 0 ms flat
MATCH (a:Patient{tildaid:$a_tildaid}),(b:Message{tildaid:$b_tildaid}) MERGE (a)-[r:PATIENT_TO_MESSAGE]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
MATCH (a:Patient{tildaid:$a_tildaid}),(b:Message{tildaid:$b_tildaid}) MERGE (a)-[r:PATIENT_TO_MESSAGE]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
write notifsvc
3 0 ms <1 ms 0 ms flat
MATCH (pObj:ParticipantQuestionnaire{tildaid:$pObjId}) SET pObj.status = $status, pObj.updatedat = timestamp()
MATCH (pObj:ParticipantQuestionnaire{tildaid:$pObjId}) SET pObj.status = $status, pObj.updatedat = timestamp()
write execsvc
3 0 ms <1 ms 0 ms flat
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
dashrsvc
3 0 ms <1 ms 0 ms flat
CALL { MATCH (o:Organization {tildaid: $selectedOrgId})-[:HAS_CLINSITE]->(:ClinSite {deltimestamp: ?})-[:CLINSITE_FOR_SITE]->(site:Site) RETURN site UNION MATCH (o:Organization {tildaid: $selectedOrgId})-[:SITE_TO_ORGANIZATION]-(site:Site)…
CALL { MATCH (o:Organization {tildaid: $selectedOrgId})-[:HAS_CLINSITE]->(:ClinSite {deltimestamp: ?})-[:CLINSITE_FOR_SITE]->(site:Site) RETURN site UNION MATCH (o:Organization {tildaid: $selectedOrgId})-[:SITE_TO_ORGANIZATION]-(site:Site) RETURN site } WITH site WHERE site.delpending = false RETURN site.status AS status, count(*) AS n
onboardingsvc
3 0 ms <1 ms 0 ms flat
match (sc:Scope{name:$name}) where sc.version = $version return sc
match (sc:Scope{name:$name}) where sc.version = $version return sc
onboardingsvc
6 0 ms <1 ms 0 ms flat
MATCH(a:AdvOrg{deltimestamp:$a_deltimestamp,orgid:$a_orgid}) RETURN a
MATCH(a:AdvOrg{deltimestamp:$a_deltimestamp,orgid:$a_orgid}) RETURN a
advpsvc
6 0 ms <1 ms 0 ms flat
UNWIND $sitePDs AS sitePD MATCH (pd:DslPlanDefinition {studyId: sitePD.studyId, scopeId: sitePD.scopeId}) MATCH (newWorkflow:WorkflowV2 {tildaid: $workflowId}) MERGE (pd)-[:PLAN_DEFINITION_TO_PUBLISHED_WORKFLOWS]->(newWorkflow) RETURN site…
UNWIND $sitePDs AS sitePD MATCH (pd:DslPlanDefinition {studyId: sitePD.studyId, scopeId: sitePD.scopeId}) MATCH (newWorkflow:WorkflowV2 {tildaid: $workflowId}) MERGE (pd)-[:PLAN_DEFINITION_TO_PUBLISHED_WORKFLOWS]->(newWorkflow) RETURN sitePD.scopeId AS siteId
write regsvc
1 0 ms <1 ms 0 ms flat
MATCH(a:WorkflowV2{tildaid:$a_tildaid}) RETURN a
MATCH(a:WorkflowV2{tildaid:$a_tildaid}) RETURN a
regsvc
1 0 ms <1 ms 0 ms flat
MATCH (t:Trigger)-[:TRIGGER_TO_WORKFLOW]-(w:WorkflowV2{tildaid:$workflowId}) RETURN t.scope, t.operation
MATCH (t:Trigger)-[:TRIGGER_TO_WORKFLOW]-(w:WorkflowV2{tildaid:$workflowId}) RETURN t.scope, t.operation
regsvc
1 0 ms <1 ms 0 ms flat
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
workplansvc
62 0 ms <1 ms 0 ms flat
MATCH (d:Document {tildaid: $doc_id})-[:DOC_TO_ORG]->(o:Organization) RETURN o.tildaid as org_id
MATCH (d:Document {tildaid: $doc_id})-[:DOC_TO_ORG]->(o:Organization) RETURN o.tildaid as org_id
docproc
1 0 ms <1 ms 0 ms flat
MATCH (n:AIRun {tildaid: $node_id}) RETURN n
MATCH (n:AIRun {tildaid: $node_id}) RETURN n
docproc
1 0 ms <1 ms 0 ms flat
MATCH (a:Recommendation {tildaid: $from_id}) MATCH (b:Organization {tildaid: $to_id}) CREATE (a)-[r:RECOMMENDATION_TO_ORGANIZATION]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
MATCH (a:Recommendation {tildaid: $from_id}) MATCH (b:Organization {tildaid: $to_id}) CREATE (a)-[r:RECOMMENDATION_TO_ORGANIZATION]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
write docproc
1 0 ms <1 ms 0 ms flat
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
write docproc
1 0 ms <1 ms 0 ms flat
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
workplansvc
7 0 ms <1 ms 0 ms flat
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
write advpsvc
2 0 ms <1 ms 0 ms flat
MATCH (a:VisitAppointment{tildaid:$a_tildaid}),(b:Message{tildaid:$b_tildaid}) MERGE (a)-[r:VISIT_APPT_TO_MESSAGE]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
MATCH (a:VisitAppointment{tildaid:$a_tildaid}),(b:Message{tildaid:$b_tildaid}) MERGE (a)-[r:VISIT_APPT_TO_MESSAGE]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
write notifsvc
2 0 ms <1 ms 0 ms flat
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
execsvc
2 0 ms <1 ms 0 ms flat
MATCH (proto:FormV2{tildaid:$protocolID})-[:CONTAINS_FORM*?..]->(f:FormV2{tildaid:$descendantFormID}) RETURN ? LIMIT ?
MATCH (proto:FormV2{tildaid:$protocolID})-[:CONTAINS_FORM*?..]->(f:FormV2{tildaid:$descendantFormID}) RETURN ? LIMIT ?
studiosvc
4 0 ms <1 ms 0 ms flat
MATCH (proto:FormV2{tildaid:$protocolID})-[:CONTAINS_FORM*?..]->(f:FormV2{tildaid:$descendantFormID}) RETURN ? LIMIT ?
MATCH (proto:FormV2{tildaid:$protocolID})-[:CONTAINS_FORM*?..]->(f:FormV2{tildaid:$descendantFormID}) RETURN ? LIMIT ?
studiosvc
2 0 ms <1 ms 0 ms flat
match(p:FormV2{delpending:true}) where p.type = $type and not exists { (:Organization)-[:ORGANIZATION_TO_FORM]->(p) } return p.tildaid order by p.deltimestamp limit $limit
match(p:FormV2{delpending:true}) where p.type = $type and not exists { (:Organization)-[:ORGANIZATION_TO_FORM]->(p) } return p.tildaid order by p.deltimestamp limit $limit
studiosvc
1 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
1 0 ms <1 ms 0 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
1 0 ms <1 ms 0 ms flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
advpsvc
2 0 ms <1 ms 0 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
docsvc
4 0 ms <1 ms 0 ms flat
MATCH(a:DslPlanDefinition{deltimestamp:$a_deltimestamp,studyId:$a_studyId,scopeId:$a_scopeId}) RETURN a
MATCH(a:DslPlanDefinition{deltimestamp:$a_deltimestamp,studyId:$a_studyId,scopeId:$a_scopeId}) RETURN a
execsvc
2 0 ms <1 ms 0 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 ?
feedsvc
1 0 ms <1 ms 0 ms flat
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write onboardingsvc
2 0 ms <1 ms 0 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 tusker
2 0 ms <1 ms 0 ms flat
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write tusker
2 0 ms <1 ms 0 ms flat
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:TRAINING_PARTICIPANT_ACTIVITY]-(obj4:Tr…
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:TRAINING_PARTICIPANT_ACTIVITY]-(obj4:Training) optional match (obj3)-[:ALL_CHANGELOG]->(cl:ChangeLog{type:?, newValue:?}) with obj4.validUntil as validUntil, obj4.validUntilUnits as validUntilUnits, obj0.createdat as issuedAt, max(cl.createdat) as completedAt return validUntil, validUntilUnits, coalesce(completedAt, issuedAt) as anchorAt
docsvc
1 0 ms <1 ms 0 ms flat
match (obj0:Document{tildaid:$hdmParentId})-[:INCLUDES]-(obj1:Binder)-[:BINDER_FOR]-(obj2:Study) return obj2 order by obj2.createdat
match (obj0:Document{tildaid:$hdmParentId})-[:INCLUDES]-(obj1:Binder)-[:BINDER_FOR]-(obj2:Study) return obj2 order by obj2.createdat
docsvc
1 0 ms <1 ms 0 ms flat
MATCH (d:Document {tildaid: $docId})-[:REFERS_TO]-(sh:DocumentShare) WHERE sh.deltimestamp = ? RETURN sh
MATCH (d:Document {tildaid: $docId})-[:REFERS_TO]-(sh:DocumentShare) WHERE sh.deltimestamp = ? RETURN sh
docsvc
1 0 ms <1 ms 0 ms flat
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:TRAINING_PARTICIPANT_ACTIVITY]-(obj4:Tr…
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:TRAINING_PARTICIPANT_ACTIVITY]-(obj4:Training) return obj4 order by obj4.createdat
docsvc
1 0 ms <1 ms 0 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
2 0 ms <1 ms 0 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
2 0 ms <1 ms 0 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
1 0 ms <1 ms 0 ms flat
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
1 0 ms <1 ms 0 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 ?
docproc
1 0 ms <1 ms 0 ms flat
MATCH(a:Training{tildaid:$a_tildaid}) RETURN a
MATCH(a:Training{tildaid:$a_tildaid}) RETURN a
execsvc
2 0 ms <1 ms 0 ms flat
MATCH (t:Training{tildaid:$trainingId}) RETURN [(t)-[:TRAINING_TO_MEMBER_LABEL]->(l:MemberLabel{delpending:false}) | l.tildaid]
MATCH (t:Training{tildaid:$trainingId}) RETURN [(t)-[:TRAINING_TO_MEMBER_LABEL]->(l:MemberLabel{delpending:false}) | l.tildaid]
execsvc
1 0 ms <1 ms 0 ms flat
MATCH (u:User) WHERE u.tildaid IN $userIds RETURN u.tildaid, u.name
MATCH (u:User) WHERE u.tildaid IN $userIds RETURN u.tildaid, u.name
execsvc
1 0 ms <1 ms 0 ms flat
MATCH(a:ActivityV2{tildaid:$a_tildaid}) RETURN a
MATCH(a:ActivityV2{tildaid:$a_tildaid}) RETURN a
execsvc
1 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
33 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
33 0 ms <1 ms 0 ms flat
RETURN ? as health_check
RETURN ? as health_check
virtual-assistant
1 0 ms <1 ms 0 ms flat
match(a:Study{tildaid:$studyId}) match(b:Organization{tildaid:$orgId}) merge(a)-[r:STUDY_TO_ORG]->(b) set r.inherited=$inherited
match(a:Study{tildaid:$studyId}) match(b:Organization{tildaid:$orgId}) merge(a)-[r:STUDY_TO_ORG]->(b) set r.inherited=$inherited
write enrollsvc
5 0 ms <1 ms 0 ms flat
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write enrollsvc
14 0 ms <1 ms 0 ms flat
CREATE INDEX tmfsync_item_config_rec IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.tilda_rec_id)
CREATE INDEX tmfsync_item_config_rec IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.tilda_rec_id)
write tmfsync
1 0 ms <1 ms 0 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
1 0 ms <1 ms 0 ms flat
CREATE INDEX tmfsync_item_config_external IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.external_id)
CREATE INDEX tmfsync_item_config_external IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.external_id)
write tmfsync
1 0 ms <1 ms 0 ms flat
MATCH (c:CtmsSyncConfig {id: $config_id}) WHERE coalesce(c.last_sync_at, ?) < $last_sync_at SET c.last_sync_at = $last_sync_at, c.updated_at = $last_sync_at
MATCH (c:CtmsSyncConfig {id: $config_id}) WHERE coalesce(c.last_sync_at, ?) < $last_sync_at SET c.last_sync_at = $last_sync_at, c.updated_at = $last_sync_at
write tmfsync
4 0 ms <1 ms 0 ms flat
CREATE CONSTRAINT tmfsync_audit_id_unique IF NOT EXISTS FOR (a:TMFSyncConfigAudit) REQUIRE a.id IS UNIQUE
CREATE CONSTRAINT tmfsync_audit_id_unique IF NOT EXISTS FOR (a:TMFSyncConfigAudit) REQUIRE a.id IS UNIQUE
write tmfsync
1 0 ms <1 ms 0 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
1 0 ms <1 ms 0 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
1 0 ms <1 ms 0 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
1 0 ms <1 ms 0 ms flat
CREATE INDEX tmfsync_item_config_tilda IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.tilda_doc_id)
CREATE INDEX tmfsync_item_config_tilda IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.tilda_doc_id)
write tmfsync
1 0 ms <1 ms 0 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
1 0 ms <1 ms 0 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
1 0 ms <1 ms 0 ms flat
CREATE CONSTRAINT tmfsync_config_id_unique IF NOT EXISTS FOR (c:TMFSyncConfig) REQUIRE c.id IS UNIQUE
CREATE CONSTRAINT tmfsync_config_id_unique IF NOT EXISTS FOR (c:TMFSyncConfig) REQUIRE c.id IS UNIQUE
write tmfsync
1 0 ms <1 ms 0 ms flat
MATCH (c:CtmsSyncConfig {id: $config_id}) SET c.ingress_last_success_at = $ended_at, c.ingress_failed_items = $failed_items, c.ingress_skipped = $skipped REMOVE c.ingress_failing_since, c.ingress_last_error, c.ingress_paused_reason, c.ingr…
MATCH (c:CtmsSyncConfig {id: $config_id}) SET c.ingress_last_success_at = $ended_at, c.ingress_failed_items = $failed_items, c.ingress_skipped = $skipped REMOVE c.ingress_failing_since, c.ingress_last_error, c.ingress_paused_reason, c.ingress_paused_at
write tmfsync
4 0 ms <1 ms 0 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND coalesce(a.ignoreType,?) <> ? RETURN count(a) as total
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND coalesce(a.ignoreType,?) <> ? RETURN count(a) as total
virtual-assistant
1 0 ms <1 ms 0 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 tusker
1 0 ms <1 ms 0 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
4 0 ms <1 ms 0 ms flat
MATCH (p:Policy {name:$name}) SET p.state = $state
MATCH (p:Policy {name:$name}) SET p.state = $state
write onboardingsvc
54 0 ms <1 ms 0 ms flat
MATCH (o:Organization{alias: $alias, deltimestamp: ?}) MATCH (e:Emr{emrname: $emrName, emrversion: $emrVersion, integrationtype: $integrationType, deltimestamp: ?}) MATCH (m:MedicalGroup{emrname: $emrName, emrversion: $emrVersion, integrat…
MATCH (o:Organization{alias: $alias, deltimestamp: ?}) MATCH (e:Emr{emrname: $emrName, emrversion: $emrVersion, integrationtype: $integrationType, deltimestamp: ?}) MATCH (m:MedicalGroup{emrname: $emrName, emrversion: $emrVersion, integrationtype: $integrationType, practicename: $practiceName, deltimestamp: ?}) MERGE (o)-[r1:ORGANIZATION_TO_EMR]->(e) ON CREATE SET r1.tildaid = randomUUID(), r1.createdat = timestamp() MERGE (o)-[r2:ORGANIZATION_TO_MEDICAL_GROUP]->(m) ON CREATE SET r2.tildaid = randomUUID(), r2.createdat = timestamp() RETURN count(o)
write patientsvc
1 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
MATCH (t:TokenLedger {study_id: $study_id, day: $day}) RETURN coalesce(t.tokens, ?) AS tokens
MATCH (t:TokenLedger {study_id: $study_id, day: $day}) RETURN coalesce(t.tokens, ?) AS tokens
data_monitor
64 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
5 0 ms <1 ms 0 ms flat
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
docsvc
1,119 <1 ms <1 ms 1 ms flat
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write onboardingsvc
488 <1 ms <1 ms 1 ms flat
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
write studiosvc
1,556 <1 ms <1 ms 1 ms flat
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write enrollsvc
214 <1 ms <1 ms 1 ms flat
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
write studiosvc
3,197 <1 ms <1 ms 1 ms flat
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
write studiosvc
7,529 <1 ms <1 ms 14 ms flat
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write tusker
182 <1 ms <1 ms 1 ms flat
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write onboardingsvc
722 <1 ms <1 ms 6 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).