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
stored26h agotop 80 of 2,490
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.
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)
writestudiosvc
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)
writestudiosvc
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
writestudiosvc
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
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
onboardingsvc
1
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
regsvc
1
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
workplansvc
1
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
writedocproc
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
writedocproc
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
writedocproc
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()
writedocproc
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
writeonboardingsvc
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
writedocproc
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
writedocproc
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
writedocproc
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)
writedocsvc
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)
writeenrollsvc
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
writeexecsvc
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)
writeexecsvc
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()
writevirtual-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)
writeexecsvc
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}
writeregsvc
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 = ?
writeregsvc
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
writeregsvc
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
writeregsvc
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)
writeexecsvc
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
writedocproc
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)
writepatientsvc
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
writeexecsvc
2,701
<1 ms
<1 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).