Xray
hourly rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 48 hours▾
Ends now. Anything up to this cluster's 30-day retention.
Start and end times
Cancel
Interpreted in UTC (change it at the right of this bar). Earliest available: 2026-10-19 13:43:47.
› →|
updated 1d ago
Sample data. This database was generated by scripts/seed_dev_db.py — every service, deploy, person and figure on this page is synthetic. Names are sample.*@seed.invalid and image tags are prefixed SEED-. Nothing here happened.

Query trends 80

stored 27h ago top 80 of 2,382

Neo4j query shapes on master over the last 48h, grouped by plan hash. Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.

Columns
Views
Export CSV
Query shape Count Avg p95 ▴ Max p95 drift
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_MEDIA]->(leaf)
write studiosvc
18 0 ms <1 ms 0 ms flat
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(coalesce(r.flags, ?), ?, $flags)
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(coalesce(r.flags, ?), ?, $flags)
write studiosvc
18 0 ms <1 ms 0 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
41 0 ms <1 ms 0 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 0 ms <1 ms 0 ms flat
MATCH (root:GraphNode{tildaid:$graphId})-[:GRAPH_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->(chain:ActivationRuleChain) MATCH (rule:ActivationRule)-[ruleRel:ACTIVATION_RULE_TO_CHAIN{graphid:$graphId}]->(chain) MATCH (rule)-[:ACTIVATION_R…
MATCH (root:GraphNode{tildaid:$graphId})-[:GRAPH_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->(chain:ActivationRuleChain) MATCH (rule:ActivationRule)-[ruleRel:ACTIVATION_RULE_TO_CHAIN{graphid:$graphId}]->(chain) MATCH (rule)-[:ACTIVATION_RULE_TO_BRANCH_CONFIG{graphid:$graphId}]->(brConfig:BranchConfig) OPTIONAL MATCH (brConfig)-[:BRANCH_CFG_TO_GRAPH_NODE_REF{protocolid:$relPropValue}]->(cfgRef:GraphNodeRef) WITH chain, rule, ruleRel, brConfig, collect(DISTINCT cfgRef.tildaid) as branchCfgRefIds MATCH (ref:GraphNode)-[:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->(chain) OPTIONAL MATCH (ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$relPropValue}]->(gnode:GraphNode) WHERE ref.objtype = ? OPTIONAL MATCH (ref)-[:GRAPH_NODE_REF_TO_QUESTION{protocolid:$relPropValue}]->(question:QuestionV2) WHERE gnode.objtype = ? RETURN {chain:chain, rule:rule, ruleType:ruleRel.type, branchConfig:brConfig, branchCfgRefIds:branchCfgRefIds, refNodeId:CASE WHEN gnode.objtype = ? THEN question.tildaid ELSE coalesce(gnode.tildaid, ref.tildaid) END}
regsvc
3 0 ms <1 ms 0 ms flat
MATCH (pv:ParticipantVisit{tildaid:$pvId})<-[:NEXT_PARTICIPANT_VISIT*]- (prev:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v:Visit|VisitV2) WHERE (v.arm is null or v.arm = ? or v.arm = $arm) AND prev.status <> ? AND prev.status <> ? return head(…
MATCH (pv:ParticipantVisit{tildaid:$pvId})<-[:NEXT_PARTICIPANT_VISIT*]- (prev:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v:Visit|VisitV2) WHERE (v.arm is null or v.arm = ? or v.arm = $arm) AND prev.status <> ? AND prev.status <> ? return head(collect({ParticipantVisit:prev,Visit:v})) as prevPV
schedsvc
3 0 ms <1 ms 0 ms flat
UNWIND $keys AS k MATCH (:Study {tildaid: $study_id})-[:STUDY_TO_ACTOR]->(a:Actor {tildaid: k, delpending: false}) OPTIONAL MATCH (a)-[:FOR_USER]->(member:User) WITH k, head(collect(member)) AS member RETURN k AS key, CASE WHEN trim(coales…
UNWIND $keys AS k MATCH (:Study {tildaid: $study_id})-[:STUDY_TO_ACTOR]->(a:Actor {tildaid: k, delpending: false}) OPTIONAL MATCH (a)-[:FOR_USER]->(member:User) WITH k, head(collect(member)) AS member RETURN k AS key, 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 AS name
virtual-assistant
2 0 ms <1 ms 0 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
4 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
11 0 ms <1 ms 0 ms flat
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL…
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL } DETACH DELETE r
write docproc
5 0 ms <1 ms 0 ms flat
MATCH(a:Study{tildaid:$a_tildaid})-[r:STUDY_TO_NOTIFICATION_DIGEST]->(b:StudyNotificationDigest) RETURN b ORDER BY b.createdat
MATCH(a:Study{tildaid:$a_tildaid})-[r:STUDY_TO_NOTIFICATION_DIGEST]->(b:StudyNotificationDigest) RETURN b ORDER BY b.createdat
enrollsvc
1 0 ms <1 ms 0 ms flat
MATCH (s:Staff{tildaid:$staffId})-[:IS_USER]-(u:User) RETURN u
MATCH (s:Staff{tildaid:$staffId})-[:IS_USER]-(u:User) RETURN u
schedsvc
1 0 ms <1 ms 0 ms flat
MATCH (w:WorkOrder)-[:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE w.delpending = false AND w.status IN $statuses RETURN w ORDER BY coalesce(w.updatedat, w.createdat) DESC LIMIT ?
MATCH (w:WorkOrder)-[:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE w.delpending = false AND w.status IN $statuses RETURN w ORDER BY coalesce(w.updatedat, w.createdat) DESC LIMIT ?
virtual-assistant
1 0 ms <1 ms 0 ms flat
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST|AI_RUN_TO_DOCUMENT_OLD]-(ai:AIRun) RETURN ai ORDER BY ai.createdat DESC
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST|AI_RUN_TO_DOCUMENT_OLD]-(ai:AIRun) RETURN ai ORDER BY ai.createdat DESC
virtual-assistant
4 0 ms <1 ms 0 ms flat
MATCH (a:AIRun {tildaid: $from_id}) MATCH (b:Document {tildaid: $to_id}) CREATE (a)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
MATCH (a:AIRun {tildaid: $from_id}) MATCH (b:Document {tildaid: $to_id}) CREATE (a)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(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 (d:Document {tildaid: $doc_id}) MATCH (ai:AIRun)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(d) WITH ai, d, r, properties(r) AS old_props DELETE r CREATE (ai)-[old_run:AI_RUN_TO_DOCUMENT_OLD]->(d) SET old_run = old_props SET old_run.converted_at…
MATCH (d:Document {tildaid: $doc_id}) MATCH (ai:AIRun)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(d) WITH ai, d, r, properties(r) AS old_props DELETE r CREATE (ai)-[old_run:AI_RUN_TO_DOCUMENT_OLD]->(d) SET old_run = old_props SET old_run.converted_at = timestamp()
write docproc
1 0 ms <1 ms 0 ms flat
MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document {tildaid: $doc_id}) WHERE ai.status IN [?, ?] RETURN ai
MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document {tildaid: $doc_id}) WHERE ai.status IN [?, ?] RETURN ai
docproc
1 0 ms <1 ms 0 ms flat
MATCH(a:Document{tildaid:$a_tildaid})-[r:DOCUMENT_TO_SOURCE]->(b:DocumentSource) RETURN b ORDER BY b.majorVersion DESC limit $limit
MATCH(a:Document{tildaid:$a_tildaid})-[r:DOCUMENT_TO_SOURCE]->(b:DocumentSource) RETURN b ORDER BY b.majorVersion DESC limit $limit
execsvc
2 0 ms <1 ms 0 ms flat
MATCH (s:Site{delpending:false})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization{tildaid:$callerOrgId}) WHERE true WITH COUNT(s) AS numAll, COUNT(CASE WHEN s.status = ? THEN ? END) AS numActive, COUNT(CASE WHEN s.status = ? THEN ? END…
MATCH (s:Site{delpending:false})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization{tildaid:$callerOrgId}) WHERE true WITH COUNT(s) AS numAll, COUNT(CASE WHEN s.status = ? THEN ? END) AS numActive, COUNT(CASE WHEN s.status = ? THEN ? END) AS numOnboarding, COUNT(CASE WHEN s.status = ? THEN ? END) AS numArchived RETURN distinct apoc.create.vNode([?], { numAll: numAll, numActive: numActive, numOnboarding: numOnboarding, numArchived: numArchived }) AS result
write onboardingsvc
2 0 ms <1 ms 0 ms flat
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
write docproc
2 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
35 0 ms <1 ms 0 ms flat
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL…
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL } DETACH DELETE r
write docproc
2 0 ms <1 ms 0 ms flat
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
write docproc
2 0 ms <1 ms 0 ms flat
match(visit:VisitV2{tildaid:$id})-[:VISIT_TO_PREVISIT]->(pre:PrePostVisitV2) with visit, pre match(visit)-[:VISIT_TO_POSTVISIT]->(post:PrePostVisitV2) return pre.tildaid, post.tildaid
match(visit:VisitV2{tildaid:$id})-[:VISIT_TO_PREVISIT]->(pre:PrePostVisitV2) with visit, pre match(visit)-[:VISIT_TO_POSTVISIT]->(post:PrePostVisitV2) return pre.tildaid, post.tildaid
studiosvc
5 0 ms <1 ms 0 ms flat
MATCH (o:Organization {tildaid: $org_id}) RETURN o.emailCcList AS ccList
MATCH (o:Organization {tildaid: $org_id}) RETURN o.emailCcList AS ccList
virtual-assistant
1 0 ms <1 ms 0 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
1 0 ms <1 ms 0 ms flat
MATCH (o:Organization{tildaid: $orgId})-[:USES]->(fm:FolderManager{name:?, scopeId: $studyId}) OPTIONAL MATCH (fm)-[:INSTANTIATED_FROM_TMF_TEMPLATE]->(:TmfTemplate)-[:HAS_PAYLOAD_FOLDER_MANAGER]->(tmplFm:FolderManager) WITH coalesce(tmplFm…
MATCH (o:Organization{tildaid: $orgId})-[:USES]->(fm:FolderManager{name:?, scopeId: $studyId}) OPTIONAL MATCH (fm)-[:INSTANTIATED_FROM_TMF_TEMPLATE]->(:TmfTemplate)-[:HAS_PAYLOAD_FOLDER_MANAGER]->(tmplFm:FolderManager) WITH coalesce(tmplFm, fm) AS dadOwner MATCH (dadOwner)-[:HAS]->(dad:DocAttributeDefinition) RETURN dad ORDER BY toLower(dad.name)
docsvc
1 0 ms <1 ms 0 ms flat
MATCH(a:Document{tildaid:$a_tildaid})-[r:REVIEW_IN]->(b:Task) RETURN b limit $limit
MATCH(a:Document{tildaid:$a_tildaid})-[r:REVIEW_IN]->(b:Task) RETURN b limit $limit
docsvc
29 0 ms <1 ms 0 ms flat
MATCH(a:DocumentShare)-[r:REFERS_TO]->(b:Document{tildaid:$b_tildaid}) RETURN a limit $limit
MATCH(a:DocumentShare)-[r:REFERS_TO]->(b:Document{tildaid:$b_tildaid}) RETURN a limit $limit
docsvc
29 0 ms <1 ms 0 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id}) OPTIONAL MATCH (cfg:WorkOrderConfig {tildaid: w.parent_id}) WITH w, coalesce(cfg.wp_object_id, ?) AS wp_object_id WHERE wp_object_id <> ? MATCH (item:WorkplanInstanceMilestoneItem) WHERE item.t…
MATCH (w:WorkOrder {tildaid: $work_order_id}) OPTIONAL MATCH (cfg:WorkOrderConfig {tildaid: w.parent_id}) WITH w, coalesce(cfg.wp_object_id, ?) AS wp_object_id WHERE wp_object_id <> ? MATCH (item:WorkplanInstanceMilestoneItem) WHERE item.tildaid = wp_object_id OR ( item.cfgMilestoneItemId = wp_object_id AND ( coalesce(item.workOrderId, ?) = w.tildaid OR (coalesce(w.site_id, ?) <> ? AND item.scopeId = w.site_id) ) ) MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone) -[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item) RETURN wp.tildaid AS workplan_id, wp.name AS workplan_name LIMIT ?
virtual-assistant
1 0 ms <1 ms 0 ms flat
MATCH (d:Document {tildaid: $doc_id}) RETURN d.cbrRunStatus AS s
MATCH (d:Document {tildaid: $doc_id}) RETURN d.cbrRunStatus AS s
docproc
5 0 ms <1 ms 0 ms flat
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]…
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]->(clog)
write docsvc
16 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
300 0 ms <1 ms 0 ms flat
MATCH(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
MATCH(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
execsvc
100 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 ?
ontologysvc
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
2,701 0 ms <1 ms 0 ms flat
MATCH (root:GraphNode{tildaid:$graphId})-[:GRAPH_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->(chain:ActivationRuleChain) MATCH (rule:ActivationRule)-[ruleRel:ACTIVATION_RULE_TO_CHAIN{graphid:$graphId}]->(chain) MATCH (rule)-[:ACTIVATION_R…
MATCH (root:GraphNode{tildaid:$graphId})-[:GRAPH_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->(chain:ActivationRuleChain) MATCH (rule:ActivationRule)-[ruleRel:ACTIVATION_RULE_TO_CHAIN{graphid:$graphId}]->(chain) MATCH (rule)-[:ACTIVATION_RULE_TO_BRANCH_CONFIG{graphid:$graphId}]->(brConfig:BranchConfig) OPTIONAL MATCH (brConfig)-[:BRANCH_CFG_TO_GRAPH_NODE_REF{graphid:$relPropValue}]->(cfgRef:GraphNodeRef) WITH chain, rule, ruleRel, brConfig, collect(DISTINCT cfgRef.tildaid) as branchCfgRefIds MATCH (ref:GraphNode)-[:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->(chain) OPTIONAL MATCH (ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{graphid:$relPropValue}]->(gnode:GraphNode) WHERE ref.objtype = ? OPTIONAL MATCH (ref)-[:GRAPH_NODE_REF_TO_QUESTION{graphid:$relPropValue}]->(question:QuestionV2) WHERE gnode.objtype = ? RETURN {chain:chain, rule:rule, ruleType:ruleRel.type, branchConfig:brConfig, branchCfgRefIds:branchCfgRefIds, refNodeId:CASE WHEN gnode.objtype = ? THEN question.tildaid ELSE coalesce(gnode.tildaid, ref.tildaid) END}
execsvc
57 0 ms <1 ms 0 ms flat
MATCH(a:DocumentAnnotation{tildaid:$a_tildaid})-[r:ANNOTATION_FIELD]->(b:DocumentField{uniqueId:$b_uniqueId}) RETURN b limit $limit
MATCH(a:DocumentAnnotation{tildaid:$a_tildaid})-[r:ANNOTATION_FIELD]->(b:DocumentField{uniqueId:$b_uniqueId}) RETURN b limit $limit
execsvc
33 0 ms <1 ms 0 ms flat
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]…
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]->(clog)
write execsvc
32 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
2,701 0 ms <1 ms 0 ms flat
MATCH (e:Event {tildaid: $eventId}) RETURN coalesce(e.type, ?) AS type, coalesce(e.status, ?) AS eventStatus LIMIT ?
MATCH (e:Event {tildaid: $eventId}) RETURN coalesce(e.type, ?) AS type, coalesce(e.status, ?) AS eventStatus LIMIT ?
ontologysvc
1 0 ms <1 ms 0 ms flat
MATCH (e:Event {tildaid: $eventId}) RETURN coalesce(e.type, ?) AS type, coalesce(e.status, ?) AS eventStatus LIMIT ?
MATCH (e:Event {tildaid: $eventId}) RETURN coalesce(e.type, ?) AS type, coalesce(e.status, ?) AS eventStatus LIMIT ?
ontologysvc
1 0 ms <1 ms 0 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pd, site, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, User: u, AssignedUser: auCollected, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, CreatedBy: createdBy}
tusker
2 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
7 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
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, collect(au) as auCollected, st, site, cu as createdBy return {Task: t, AssignedUser: auCollected, Study: st, Site: site, CreatedBy: createdBy}
tusker
31 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
2 0 ms <1 ms 0 ms flat
MATCH (a:WorkOrderActivity {tildaid:$aid}) SET a.last_attempt_at = timestamp()
MATCH (a:WorkOrderActivity {tildaid:$aid}) SET a.last_attempt_at = timestamp()
write virtual-assistant
1 0 ms <1 ms 0 ms flat
MATCH (n:WorkOrderActivity {tildaid: $node_id}) RETURN n
MATCH (n:WorkOrderActivity {tildaid: $node_id}) RETURN n
virtual-assistant
1 0 ms <1 ms 0 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 ?
schedsvc
1 0 ms <1 ms 0 ms flat
MATCH(a:Job{tildaid:$a_tildaid}) RETURN a
MATCH(a:Job{tildaid:$a_tildaid}) RETURN a
schedsvc
1 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 execsvc
2 0 ms <1 ms 0 ms flat
MATCH(a:User{tildaid:$a_tildaid}) RETURN a
MATCH(a:User{tildaid:$a_tildaid}) RETURN a
execsvc
1 0 ms <1 ms 0 ms flat
MATCH (s:Site{tildaid:$siteId})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization) RETURN o
MATCH (s:Site{tildaid:$siteId})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization) RETURN o
onboardingsvc
1 0 ms <1 ms 0 ms flat
MATCH (e:Event {tildaid: $event_id}) RETURN coalesce(e.name, ?) AS name
MATCH (e:Event {tildaid: $event_id}) RETURN coalesce(e.name, ?) AS name
virtual-assistant
2 0 ms <1 ms 0 ms flat
match (t:Task{tildaid:$id})-[:BELONGS_TO]-(i:Inbox{type:?})-[:OWNED_BY]-(u:User) where i.name=u.email return u
match (t:Task{tildaid:$id})-[:BELONGS_TO]-(i:Inbox{type:?})-[:OWNED_BY]-(u:User) where i.name=u.email return u
docsvc
2 0 ms <1 ms 0 ms flat
match (task:Task{tildaid:$taskId})-[:BELONGS_TO]-> (inbox:Inbox{type:?})-[:MANAGED_BY]-> (site:Site) return site
match (task:Task{tildaid:$taskId})-[:BELONGS_TO]-> (inbox:Inbox{type:?})-[:MANAGED_BY]-> (site:Site) return site
docsvc
1 0 ms <1 ms 0 ms flat
match (task:Task{tildaid:$taskId})-[:BELONGS_TO]-> (inbox:Inbox{type:?})-[:MANAGED_BY]-> (study:Study) return study
match (task:Task{tildaid:$taskId})-[:BELONGS_TO]-> (inbox:Inbox{type:?})-[:MANAGED_BY]-> (study:Study) return study
docsvc
1 0 ms <1 ms 0 ms flat
MATCH(a:Task{tildaid:$a_tildaid})-[r:CREATED_BY]->(b:User) RETURN b limit $limit
MATCH(a:Task{tildaid:$a_tildaid})-[r:CREATED_BY]->(b:User) RETURN b limit $limit
docsvc
2 0 ms <1 ms 0 ms flat
MATCH(a:ParticipantActivity{tildaid:$a_tildaid}) RETURN a
MATCH(a:ParticipantActivity{tildaid:$a_tildaid}) RETURN a
regsvc
2 0 ms <1 ms 0 ms flat
match (pa:ParticipantActivity{tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]- (pqnr:ParticipantQuestionnaire)-[:PARTICIPANT_QUESTION]-(pqn:ParticipantQuestion) optional match (pqn)-[:PARTICIPANT_SPECNODE]-(psn:ParticipantSpecNode)-[:BELONGS_…
match (pa:ParticipantActivity{tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]- (pqnr:ParticipantQuestionnaire)-[:PARTICIPANT_QUESTION]-(pqn:ParticipantQuestion) optional match (pqn)-[:PARTICIPANT_SPECNODE]-(psn:ParticipantSpecNode)-[:BELONGS_TO_SPECNODE]- (sn:SpecNode) where psn.status=? and psn.deltimestamp=? with distinct sn as dsn,pqn with count(case when dsn.required=? then ? else null end) as incompleteMandatoryQuestionCount, count(case when dsn.required=? then ? else null end) as incompleteQuestionCount,pqn,pqn.status as oldStatus set pqn.status=case when pqn.status = ? then pqn.status when pqn.tildaid in $notDonePQIds then ? when incompleteMandatoryQuestionCount>? then ? when incompleteQuestionCount>? then ? else ? end return {tildaid: pqn.tildaid, oldStatus: oldStatus}
write regsvc
2 0 ms <1 ms 0 ms flat
match (pa:ParticipantActivity{tildaid:$paId})- [:PARTICIPANT_CONTROL]-(pc:ParticipantControl)- [:PCONTROL_TO_CONTROL]-(c:ControlV2) CALL { with pa, pc, c optional match (pc)-[:PARTICIPANT_TASKLIST]-(ptl:ParticipantTaskList) return ptl as x…
match (pa:ParticipantActivity{tildaid:$paId})- [:PARTICIPANT_CONTROL]-(pc:ParticipantControl)- [:PCONTROL_TO_CONTROL]-(c:ControlV2) CALL { with pa, pc, c optional match (pc)-[:PARTICIPANT_TASKLIST]-(ptl:ParticipantTaskList) return ptl as x, COLLECT(ptl.status) as statuses } with pc, apoc.coll.flatten(COLLECT(statuses)) AS allStatuses where ALL(status IN allStatuses WHERE status = ?) set pc.status = ?
write regsvc
2 0 ms <1 ms 0 ms flat
match (pa:ParticipantActivity{tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]- (pqnr:ParticipantQuestionnaire)-[:BELONGS_TO_QUESTIONNAIRE]-(qnr:QuestionnaireV2) where pqnr.status <> ? and pqnr.status <> ? set pqnr.status=?,pqnr.stopWatchEndTi…
match (pa:ParticipantActivity{tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]- (pqnr:ParticipantQuestionnaire)-[:BELONGS_TO_QUESTIONNAIRE]-(qnr:QuestionnaireV2) where pqnr.status <> ? and pqnr.status <> ? set pqnr.status=?,pqnr.stopWatchEndTime= case when qnr.stopwatchenable and pqnr.stopWatchStartTime > ? then timestamp() else ? end return qnr,pqnr
write regsvc
2 0 ms <1 ms 0 ms flat
MATCH (t:Task{tildaid:$taskId}) -[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig) -[:PARTICIPANT_TASKCONFIG]-(ptl:ParticipantTaskList) MATCH (ptl)-[:PARTICIPANT_TASKCONFIG]-(allptc:ParticipantTaskConfig) WITH ptl, COLLECT(allptc.status) AS…
MATCH (t:Task{tildaid:$taskId}) -[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig) -[:PARTICIPANT_TASKCONFIG]-(ptl:ParticipantTaskList) MATCH (ptl)-[:PARTICIPANT_TASKCONFIG]-(allptc:ParticipantTaskConfig) WITH ptl, COLLECT(allptc.status) AS allStatuses WITH ptl, ALL(status IN allStatuses WHERE status = ?) AS allCompleted WITH ptl, allCompleted, CASE WHEN allCompleted THEN ? ELSE ptl.status END as value SET ptl.status = value, ptl.updatedAt = timestamp() RETURN allCompleted
write regsvc
2 0 ms <1 ms 0 ms flat
match (pa:ParticipantActivity{tildaid:$id})-[:PARTICIPANT_DOCUMENTSET]-> (pds:ParticipantDocumentSet)-[:BELONGS_TO_DOCUMENTSET]-> (ds:DocumentSet|DocumentSetV2) return ds, pds
match (pa:ParticipantActivity{tildaid:$id})-[:PARTICIPANT_DOCUMENTSET]-> (pds:ParticipantDocumentSet)-[:BELONGS_TO_DOCUMENTSET]-> (ds:DocumentSet|DocumentSetV2) return ds, pds
regsvc
2 0 ms <1 ms 0 ms flat
match (obj:Table{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
match (obj:Table{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
execsvc
34 0 ms <1 ms 0 ms flat
match(a:StudyCountryActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:StudyCountryActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write execsvc
7 0 ms <1 ms 0 ms flat
MATCH(a:Inbox{type:$a_type})-[r:MANAGED_BY]->(b:Study{tildaid:$b_tildaid}) RETURN a limit $limit
MATCH(a:Inbox{type:$a_type})-[r:MANAGED_BY]->(b:Study{tildaid:$b_tildaid}) RETURN a limit $limit
tusker
1 0 ms <1 ms 0 ms flat
MATCH (a:AIRun {tildaid: $from_id}) MATCH (b:Recommendation {tildaid: $to_id}) CREATE (a)-[r:AI_RUN_TO_RECOMMENDATION]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
MATCH (a:AIRun {tildaid: $from_id}) MATCH (b:Recommendation {tildaid: $to_id}) CREATE (a)-[r:AI_RUN_TO_RECOMMENDATION]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
write docproc
26 0 ms <1 ms 0 ms flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
patientsvc
2 0 ms <1 ms 0 ms flat
MATCH(a:Patient{tildaid:$a_tildaid}) SET a.updatedat=timestamp(),a.lastcontacted=$a_lastcontacted RETURN count(a)
MATCH(a:Patient{tildaid:$a_tildaid}) SET a.updatedat=timestamp(),a.lastcontacted=$a_lastcontacted RETURN count(a)
write patientsvc
2 0 ms <1 ms 0 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact {key: $key}) WHERE f.delpending = false RETURN f.key AS key, f.value AS value, f.type AS type ORDER BY f.createdat ASC
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact {key: $key}) WHERE f.delpending = false RETURN f.key AS key, f.value AS value, f.type AS type ORDER BY f.createdat ASC
virtual-assistant
58 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
10 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)-[:BELONGS_TO_ACTIVITY]-(obj4:ActivityV2) …
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:BELONGS_TO_ACTIVITY]-(obj4:ActivityV2) return obj4 order by obj4.createdat
docsvc
10 0 ms <1 ms 0 ms flat
MATCH(a:VisitAppointment{tildaid:$a_tildaid}) RETURN a
MATCH(a:VisitAppointment{tildaid:$a_tildaid}) RETURN a
schedsvc
1 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
18,075 <1 ms <1 ms 86 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
2,701 <1 ms <1 ms 1 ms flat
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]…
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]->(clog)
write execsvc
280 <1 ms <1 ms 1 ms flat
MATCH(a:DocumentAnnotation{tildaid:$a_tildaid})-[r:ANNOTATION_FIELD]->(b:DocumentField{uniqueId:$b_uniqueId}) RETURN b limit $limit
MATCH(a:DocumentAnnotation{tildaid:$a_tildaid})-[r:ANNOTATION_FIELD]->(b:DocumentField{uniqueId:$b_uniqueId}) RETURN b limit $limit
execsvc
250 <1 ms <1 ms 13 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).