Logs

{
  "allocatedBytes": 488.0,
  "cpu": 62.0,
  "elapsedTimeMs": 108.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24651509",
  "pageFaults": 0.0,
  "pageHits": 66849.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:10:06.675Z",
  "transactionId": 12029947.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 169.0,
  "elapsedTimeMs": 169.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24649290",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785110086366}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:46.538Z",
  "transactionId": 12028773.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 97.0,
  "elapsedTimeMs": 97.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24649284",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110386264}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:46.364Z",
  "transactionId": 12028772.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 212.0,
  "elapsedTimeMs": 228.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24648871",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785110075558}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:35.788Z",
  "transactionId": 12028763.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 80.0,
  "elapsedTimeMs": 80.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24648864",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:35.556Z",
  "transactionId": 12028762.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 164.0,
  "elapsedTimeMs": 164.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24648508",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785110065828}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:25.995Z",
  "transactionId": 12028757.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 90.0,
  "elapsedTimeMs": 90.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24648506",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110365732}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:25.826Z",
  "transactionId": 12028756.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 177.0,
  "elapsedTimeMs": 177.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24648289",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785110060003}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:20.183Z",
  "transactionId": 12028746.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 65.0,
  "elapsedTimeMs": 65.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24648285",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:19.996Z",
  "transactionId": 12028745.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 176.0,
  "elapsedTimeMs": 176.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24646892",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785110045313}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:05.492Z",
  "transactionId": 12028131.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 107.0,
  "elapsedTimeMs": 108.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24646872",
  "pageFaults": 0.0,
  "pageHits": 89963.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110345201}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:05.311Z",
  "transactionId": 12028117.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 182.0,
  "elapsedTimeMs": 182.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24646737",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785110044464}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:04.649Z",
  "transactionId": 12028036.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 85.0,
  "elapsedTimeMs": 85.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24646722",
  "pageFaults": 0.0,
  "pageHits": 66849.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:09:04.462Z",
  "transactionId": 12028025.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 800.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "95899445",
  "id": "24645172",
  "pageFaults": 0.0,
  "pageHits": 21.0,
  "planning": 0.0,
  "query": "\n    MATCH (r:TmfEvaluationRun {status: $running})\n    WHERE r.deltimestamp = 0 AND coalesce(r.updatedat, r.createdat) \u003c $cutoff\n    RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion\n    ORDER BY coalesce(r.updatedat, r.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{running: \u0027running\u0027, limit: 50, cutoff: 1785110631234}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:51.238Z",
  "transactionId": 12027079.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 183.0,
  "elapsedTimeMs": 183.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24644961",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785110028886}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:49.072Z",
  "transactionId": 12027076.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 67.0,
  "elapsedTimeMs": 67.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24644954",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:48.885Z",
  "transactionId": 12027075.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 174.0,
  "elapsedTimeMs": 174.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24644777",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785110025771}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:45.949Z",
  "transactionId": 12027070.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 94.0,
  "elapsedTimeMs": 94.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24644773",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110325672}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:45.769Z",
  "transactionId": 12027069.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 182.0,
  "elapsedTimeMs": 182.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24644453",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785110013348}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:33.533Z",
  "transactionId": 12027058.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 96.0,
  "elapsedTimeMs": 96.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24644451",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:33.346Z",
  "transactionId": 12027057.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 166.0,
  "elapsedTimeMs": 167.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24644439",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785110005234}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:25.404Z",
  "transactionId": 12027053.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 88.0,
  "elapsedTimeMs": 88.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24644438",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110305141}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:25.233Z",
  "transactionId": 12027052.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 163.0,
  "elapsedTimeMs": 163.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24644384",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109997794}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:17.960Z",
  "transactionId": 12027041.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 61.0,
  "elapsedTimeMs": 61.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24644383",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:17.792Z",
  "transactionId": 12027040.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 172.0,
  "elapsedTimeMs": 173.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24643467",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109984717}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:04.892Z",
  "transactionId": 12026365.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 95.0,
  "elapsedTimeMs": 95.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24643451",
  "pageFaults": 0.0,
  "pageHits": 89963.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110284617}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:04.716Z",
  "transactionId": 12026352.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 169.0,
  "elapsedTimeMs": 169.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24643104",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109982284}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:02.456Z",
  "transactionId": 12026075.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 65.0,
  "elapsedTimeMs": 65.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24643093",
  "pageFaults": 0.0,
  "pageHits": 66849.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:08:02.283Z",
  "transactionId": 12026066.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 161.0,
  "elapsedTimeMs": 161.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24642170",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109966783}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:46.947Z",
  "transactionId": 12025372.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 60.0,
  "elapsedTimeMs": 60.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24642169",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:46.781Z",
  "transactionId": 12025371.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 162.0,
  "elapsedTimeMs": 162.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24642164",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109964223}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:44.388Z",
  "transactionId": 12025368.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 105.0,
  "elapsedTimeMs": 105.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24642160",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110264078}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:44.221Z",
  "transactionId": 12025364.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 163.0,
  "elapsedTimeMs": 163.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24641309",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109951236}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:31.401Z",
  "transactionId": 12025355.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 63.0,
  "elapsedTimeMs": 63.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24641308",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:31.235Z",
  "transactionId": 12025354.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 163.0,
  "elapsedTimeMs": 163.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24641293",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109943640}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:23.806Z",
  "transactionId": 12025346.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 88.0,
  "elapsedTimeMs": 88.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24641292",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110243547}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:23.638Z",
  "transactionId": 12025345.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 171.0,
  "elapsedTimeMs": 171.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24641275",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109935708}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:15.882Z",
  "transactionId": 12025338.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 64.0,
  "elapsedTimeMs": 64.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24641274",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:15.706Z",
  "transactionId": 12025337.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 206.0,
  "elapsedTimeMs": 207.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24640359",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109924136}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:04.345Z",
  "transactionId": 12024625.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 94.0,
  "elapsedTimeMs": 94.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24640341",
  "pageFaults": 0.0,
  "pageHits": 89963.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110224017}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:04.114Z",
  "transactionId": 12024610.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 161.0,
  "elapsedTimeMs": 161.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24639790",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109920205}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:00.374Z",
  "transactionId": 12024174.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 64.0,
  "elapsedTimeMs": 65.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24639778",
  "pageFaults": 0.0,
  "pageHits": 66849.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:07:00.204Z",
  "transactionId": 12024164.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 800.0,
  "cpu": 12.0,
  "elapsedTimeMs": 12.0,
  "executionPlanCacheKeyHash": "95899445",
  "id": "24639158",
  "pageFaults": 0.0,
  "pageHits": 21.0,
  "planning": 12.0,
  "query": "\n    MATCH (r:TmfEvaluationRun {status: $running})\n    WHERE r.deltimestamp = 0 AND coalesce(r.updatedat, r.createdat) \u003c $cutoff\n    RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion\n    ORDER BY coalesce(r.updatedat, r.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{running: \u0027running\u0027, limit: 50, cutoff: 1785110511216}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:51.232Z",
  "transactionId": 12023674.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 162.0,
  "elapsedTimeMs": 163.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24639105",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109904732}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:44.897Z",
  "transactionId": 12023666.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 62.0,
  "elapsedTimeMs": 62.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24639104",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:44.730Z",
  "transactionId": 12023665.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 162.0,
  "elapsedTimeMs": 163.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24639099",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109904081}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:44.246Z",
  "transactionId": 12023660.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 87.0,
  "elapsedTimeMs": 88.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24639098",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110203987}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:44.079Z",
  "transactionId": 12023659.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 172.0,
  "elapsedTimeMs": 172.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24638892",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109889202}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:29.377Z",
  "transactionId": 12023651.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 63.0,
  "elapsedTimeMs": 63.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24638888",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:29.201Z",
  "transactionId": 12023650.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 202.0,
  "elapsedTimeMs": 203.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24638718",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109884567}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:24.773Z",
  "transactionId": 12023648.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 105.0,
  "elapsedTimeMs": 105.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24638707",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110184456}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:24.565Z",
  "transactionId": 12023647.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 169.0,
  "elapsedTimeMs": 169.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24638288",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109873712}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:13.884Z",
  "transactionId": 12023633.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 61.0,
  "elapsedTimeMs": 62.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24638284",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:13.683Z",
  "transactionId": 12023632.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 190.0,
  "elapsedTimeMs": 190.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24637252",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109864022}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:04.214Z",
  "transactionId": 12022874.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 91.0,
  "elapsedTimeMs": 91.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24637237",
  "pageFaults": 0.0,
  "pageHits": 89963.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110163924}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:06:04.020Z",
  "transactionId": 12022863.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 178.0,
  "elapsedTimeMs": 178.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24636415",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109858163}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:58.348Z",
  "transactionId": 12022212.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 70.0,
  "elapsedTimeMs": 70.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24636404",
  "pageFaults": 0.0,
  "pageHits": 66849.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:58.162Z",
  "transactionId": 12022202.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 191.0,
  "elapsedTimeMs": 191.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24636052",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 21.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109843499}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:43.693Z",
  "transactionId": 12021959.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 102.0,
  "elapsedTimeMs": 102.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24636051",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 14.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110143392}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:43.497Z",
  "transactionId": 12021958.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 183.0,
  "elapsedTimeMs": 183.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24636050",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 18.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109842592}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:42.777Z",
  "transactionId": 12021957.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 70.0,
  "elapsedTimeMs": 71.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24636049",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 8.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:42.590Z",
  "transactionId": 12021956.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 167.0,
  "elapsedTimeMs": 167.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24636010",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109827073}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:27.247Z",
  "transactionId": 12021948.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 62.0,
  "elapsedTimeMs": 62.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24636009",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:27.071Z",
  "transactionId": 12021947.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 199.0,
  "elapsedTimeMs": 199.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24636001",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109822967}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:23.170Z",
  "transactionId": 12021941.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 102.0,
  "elapsedTimeMs": 102.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24636000",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110122860}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:22.965Z",
  "transactionId": 12021940.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 183.0,
  "elapsedTimeMs": 183.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24635972",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109811548}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:11.734Z",
  "transactionId": 12021930.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 62.0,
  "elapsedTimeMs": 63.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24635961",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:11.547Z",
  "transactionId": 12021922.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 184.0,
  "elapsedTimeMs": 184.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24634949",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109803436}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:03.623Z",
  "transactionId": 12021124.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 102.0,
  "elapsedTimeMs": 102.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24634932",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110103329}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:05:03.434Z",
  "transactionId": 12021111.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 166.0,
  "elapsedTimeMs": 166.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24633881",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109796053}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:56.222Z",
  "transactionId": 12020276.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 63.0,
  "elapsedTimeMs": 63.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24633880",
  "pageFaults": 0.0,
  "pageHits": 66849.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:56.051Z",
  "transactionId": 12020275.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 800.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "95899445",
  "id": "24633872",
  "pageFaults": 0.0,
  "pageHits": 21.0,
  "planning": 0.0,
  "query": "\n    MATCH (r:TmfEvaluationRun {status: $running})\n    WHERE r.deltimestamp = 0 AND coalesce(r.updatedat, r.createdat) \u003c $cutoff\n    RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion\n    ORDER BY coalesce(r.updatedat, r.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{running: \u0027running\u0027, limit: 50, cutoff: 1785110391207}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:51.213Z",
  "transactionId": 12020271.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 167.0,
  "elapsedTimeMs": 167.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24633847",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109783893}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:44.063Z",
  "transactionId": 12020259.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 88.0,
  "elapsedTimeMs": 89.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24633846",
  "pageFaults": 0.0,
  "pageHits": 89963.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110083800}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:43.892Z",
  "transactionId": 12020258.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 161.0,
  "elapsedTimeMs": 162.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24633843",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109780528}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:40.692Z",
  "transactionId": 12020256.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 64.0,
  "elapsedTimeMs": 64.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24633841",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:40.526Z",
  "transactionId": 12020255.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 163.0,
  "elapsedTimeMs": 163.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24633600",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109749463}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:09.627Z",
  "transactionId": 12020147.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 63.0,
  "elapsedTimeMs": 63.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24633586",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:09.461Z",
  "transactionId": 12020138.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 159.0,
  "elapsedTimeMs": 160.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24632728",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109743833}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:03.995Z",
  "transactionId": 12019486.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 91.0,
  "elapsedTimeMs": 91.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24632711",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110043737}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:04:03.831Z",
  "transactionId": 12019474.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 162.0,
  "elapsedTimeMs": 163.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24631535",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109733959}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:03:54.126Z",
  "transactionId": 12018571.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 60.0,
  "elapsedTimeMs": 60.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24631534",
  "pageFaults": 0.0,
  "pageHits": 66849.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:03:53.957Z",
  "transactionId": 12018570.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 165.0,
  "elapsedTimeMs": 166.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24631455",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785109723300}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:03:43.469Z",
  "transactionId": 12018558.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 90.0,
  "elapsedTimeMs": 90.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24631454",
  "pageFaults": 0.0,
  "pageHits": 89963.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785110023206}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:03:43.299Z",
  "transactionId": 12018557.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 163.0,
  "elapsedTimeMs": 164.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24631441",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785109718459}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:03:38.630Z",
  "transactionId": 12018554.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 63.0,
  "elapsedTimeMs": 63.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24631438",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:59818\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T00:03:38.457Z",
  "transactionId": 12018553.0,
  "waiting": 0.0
}