Xray
daily rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 3 days▾
Ends now. Anything up to this cluster's 30-day retention.
Start and end times
Cancel
Interpreted in UTC (change it at the right of this bar). Earliest available: 2026-10-19 13:15:51.
› →|
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,164

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

Columns
Views
Export CSV
Query shape Count Avg p95 ▴ Max p95 drift
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
execsvc
9 0 ms <1 ms 0 ms flat
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 (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
24 0 ms <1 ms 0 ms flat
match(a:ParticipantActivity{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:ParticipantActivity{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write execsvc
6 0 ms <1 ms 0 ms flat
MATCH (d:Document) WHERE d.tildaid IN $doc_ids MATCH (d)<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.category IN $categories WITH d, r ORDER BY r.createdat DESC WITH d, r.category AS cat, collect(r)[?] AS latest RETURN d.tild…
MATCH (d:Document) WHERE d.tildaid IN $doc_ids MATCH (d)<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.category IN $categories WITH d, r ORDER BY r.createdat DESC WITH d, r.category AS cat, collect(r)[?] AS latest RETURN d.tildaid AS doc_id, cat AS category, properties(latest) AS rec_map
virtual-assistant
3 0 ms <1 ms 0 ms flat
MATCH (d:Document) WHERE d.tildaid IN $doc_ids RETURN d.tildaid AS tildaid, COALESCE(d.fileName, d.name, d.tildaid) AS fileName, d.contentType AS contentType
MATCH (d:Document) WHERE d.tildaid IN $doc_ids RETURN d.tildaid AS tildaid, COALESCE(d.fileName, d.name, d.tildaid) AS fileName, d.contentType AS contentType
virtual-assistant
3 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
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
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
patientsvc
6 0 ms <1 ms 0 ms flat
MATCH (a:WorkOrderActivity {tildaid:$aid}) RETURN coalesce(a.retry_count,?) AS retry_count, a.last_attempt_at AS last_attempt_at, a.processing_status AS processing_status, coalesce(a.errors,?) AS errors
MATCH (a:WorkOrderActivity {tildaid:$aid}) RETURN coalesce(a.retry_count,?) AS retry_count, a.last_attempt_at AS last_attempt_at, a.processing_status AS processing_status, coalesce(a.errors,?) AS errors
virtual-assistant
2 0 ms <1 ms 0 ms flat
MATCH (a:WorkOrderActivity {tildaid:$aid}) RETURN coalesce(a.attachmentInfo, []) AS attachments
MATCH (a:WorkOrderActivity {tildaid:$aid}) RETURN coalesce(a.attachmentInfo, []) AS attachments
virtual-assistant
1 0 ms <1 ms 0 ms flat
MATCH (o:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{tildaid:$categoryId, delpending:false}) RETURN coalesce(ca.seedKey, ?) AS seedKey
MATCH (o:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{tildaid:$categoryId, delpending:false}) RETURN coalesce(ca.seedKey, ?) AS seedKey
workplansvc
1 0 ms <1 ms 0 ms flat
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
workplansvc
1 0 ms <1 ms 0 ms flat
MATCH (o:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{tildaid:$categoryId, delpending:false}) RETURN coalesce(ca.seedKey, ?) AS seedKey
MATCH (o:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{tildaid:$categoryId, delpending:false}) RETURN coalesce(ca.seedKey, ?) AS seedKey
workplansvc
10 0 ms <1 ms 0 ms flat
MATCH (pqn:ParticipantQuestion)-[:HAS_QUERY]-(q:Query)-[:BELONGS_TO]-(cfg:AutoQueryConfig) WHERE pqn.tildaid IN $pqnIds AND cfg.tildaid IN $cfgIds AND q.state IN $states AND coalesce(q.supersededAt, ?) = ? RETURN DISTINCT pqn.tildaid, cfg.…
MATCH (pqn:ParticipantQuestion)-[:HAS_QUERY]-(q:Query)-[:BELONGS_TO]-(cfg:AutoQueryConfig) WHERE pqn.tildaid IN $pqnIds AND cfg.tildaid IN $cfgIds AND q.state IN $states AND coalesce(q.supersededAt, ?) = ? RETURN DISTINCT pqn.tildaid, cfg.tildaid
execsvc
7 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
CREATE (n:AIRun $properties)
CREATE (n:AIRun $properties)
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:Organization{tildaid:$a_tildaid})-[r:USES]->(b:FolderManager{name:$b_name,scopeId:$b_scopeId}) RETURN b limit $limit
MATCH(a:Organization{tildaid:$a_tildaid})-[r:USES]->(b:FolderManager{name:$b_name,scopeId:$b_scopeId}) RETURN b limit $limit
docsvc
2 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})<-[: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
10 0 ms <1 ms 0 ms flat
match (obj:QuestionnaireV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
match (obj:QuestionnaireV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
execsvc
2 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` RETURN NULL as rel
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` RETURN NULL as rel
execsvc
2 0 ms <1 ms 0 ms flat
MATCH (pobj:ParticipantQuestionnaire{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
MATCH (pobj:ParticipantQuestionnaire{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
execsvc
2 0 ms <1 ms 0 ms flat
MATCH(a:User{tildaid:$a_tildaid})-[r:ACTIVE_SIGNATURE]->(b:ESignature) RETURN b limit $limit
MATCH(a:User{tildaid:$a_tildaid})-[r:ACTIVE_SIGNATURE]->(b:ESignature) RETURN b limit $limit
docsvc
2 0 ms <1 ms 0 ms flat
MATCH (pd:DslPlanDefinition{tildaid:$planDefinitionID})-[:PARTICIPANT_ACTIVITY]->(pa:ParticipantActivity{activityId:$activityID,deltimestamp:?}) RETURN pa LIMIT ?
MATCH (pd:DslPlanDefinition{tildaid:$planDefinitionID})-[:PARTICIPANT_ACTIVITY]->(pa:ParticipantActivity{activityId:$activityID,deltimestamp:?}) RETURN pa LIMIT ?
execsvc
1 0 ms <1 ms 0 ms flat
match (pa:ParticipantActivity {tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]-(pqnr:ParticipantQuestionnaire)-[:BELONGS_TO_QUESTIONNAIRE]-(qnr:QuestionnaireV2|Questionnaire) return case when exists((qnr)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protoc…
match (pa:ParticipantActivity {tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]-(pqnr:ParticipantQuestionnaire)-[:BELONGS_TO_QUESTIONNAIRE]-(qnr:QuestionnaireV2|Questionnaire) return case when exists((qnr)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolId}]-(:GraphNodeRef{tildaid:$refId})) or qnr.title = $title then {qnr:qnr, pqnr:pqnr} end
execsvc
1 0 ms <1 ms 0 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
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
regsvc
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
MATCH(a:Staff)-[r:IS_USER]->(b:User{email:$b_email}) RETURN a limit $limit
MATCH(a:Staff)-[r:IS_USER]->(b:User{email:$b_email}) RETURN a limit $limit
schedsvc
1 0 ms <1 ms 0 ms flat
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
schedsvc
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
1 0 ms <1 ms 0 ms flat
match (o:Organization {tildaid: $objectId}) return o
match (o:Organization {tildaid: $objectId}) return o
tusker
1 0 ms <1 ms 0 ms flat
match (s:Site {tildaid: $objectId}) return s
match (s:Site {tildaid: $objectId}) return s
tusker
1 0 ms <1 ms 0 ms flat
MATCH (e:Event {tildaid: $event_id}) RETURN coalesce(e.type, ?) AS type, coalesce(e.name, ?) AS name, coalesce(e.aiNotes, ?) AS ai_notes, coalesce(e.scratchpad, ?) AS scratchpad, coalesce(e.status, ?) AS status, coalesce(e.keepInSync, fals…
MATCH (e:Event {tildaid: $event_id}) RETURN coalesce(e.type, ?) AS type, coalesce(e.name, ?) AS name, coalesce(e.aiNotes, ?) AS ai_notes, coalesce(e.scratchpad, ?) AS scratchpad, coalesce(e.status, ?) AS status, coalesce(e.keepInSync, false) AS keep_in_sync
virtual-assistant
15 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 (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
10 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
29 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 (: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
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: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
306 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 (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

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