{"refs":{"before":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","after":"19f654326598cc1f7411a56dbb07e651b6b5f254"},"sqlite":{"v":"3.54.0"},"node":"v26.12.1"}
{"boundary":"EXPLAIN QUERY PLAN full BEFORE shell SELECT","plan":[{"id":9,"parent":0,"notused":216,"detail":"SCAN t"},{"id":16,"parent":0,"notused":46,"detail":"SEARCH active USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) LEFT-JOIN"},{"id":19,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 16"},{"id":25,"parent":19,"notused":62,"detail":"SEARCH r USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":57,"parent":0,"notused":46,"detail":"SEARCH presented USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) LEFT-JOIN"},{"id":60,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 17"},{"id":66,"parent":60,"notused":61,"detail":"SEARCH candidate USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":87,"parent":0,"notused":46,"detail":"SEARCH blocked USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) LEFT-JOIN"},{"id":90,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 18"},{"id":96,"parent":90,"notused":61,"detail":"SEARCH candidate USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":124,"parent":90,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"},{"id":153,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 1"},{"id":158,"parent":153,"notused":61,"detail":"SEARCH stop_request USING INDEX orchestration_v2_projection_turn_items_thread_run_idx (thread_id=? AND run_id=?)"},{"id":176,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 2"},{"id":182,"parent":176,"notused":62,"detail":"SEARCH r USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":213,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 3"},{"id":219,"parent":213,"notused":62,"detail":"SEARCH r USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":256,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 4"},{"id":264,"parent":256,"notused":62,"detail":"SEARCH binding USING INDEX orchestration_v2_projection_provider_session_bindings_thread_idx (thread_id=?)"},{"id":270,"parent":256,"notused":46,"detail":"SEARCH session USING INDEX sqlite_autoindex_orchestration_v2_projection_provider_sessions_1 (provider_session_id=?)"},{"id":291,"parent":256,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"},{"id":298,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 5"},{"id":306,"parent":298,"notused":46,"detail":"SEARCH r USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?)"},{"id":314,"parent":298,"notused":60,"detail":"SEARCH item USING INDEX orchestration_v2_projection_turn_items_failed_error_idx (thread_id=? AND run_id=? AND node_id=?)"},{"id":342,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 6"},{"id":347,"parent":342,"notused":61,"detail":"SEARCH stop_request USING INDEX orchestration_v2_projection_turn_items_thread_run_idx (thread_id=? AND run_id=?)"},{"id":363,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 7"},{"id":369,"parent":363,"notused":60,"detail":"SEARCH item USING INDEX orchestration_v2_projection_turn_items_failed_error_idx (thread_id=? AND run_id=? AND node_id=?)"},{"id":386,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 8"},{"id":392,"parent":386,"notused":61,"detail":"SEARCH request USING INDEX orchestration_v2_projection_runtime_requests_thread_status_idx (thread_id=? AND status=?)"},{"id":411,"parent":386,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"},{"id":418,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 9"},{"id":426,"parent":418,"notused":61,"detail":"SEARCH r USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":454,"parent":418,"notused":61,"detail":"SEARCH secret USING INDEX orchestration_v2_projection_turn_items_thread_run_idx (thread_id=? AND run_id=?)"},{"id":479,"parent":418,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"},{"id":486,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 10"},{"id":491,"parent":486,"notused":54,"detail":"SEARCH message USING COVERING INDEX orchestration_v2_projection_messages_latest_user_idx (thread_id=?)"},{"id":502,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 11"},{"id":508,"parent":502,"notused":62,"detail":"SEARCH message USING INDEX orchestration_v2_projection_messages_latest_user_idx (thread_id=?)"},{"id":523,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 12"},{"id":528,"parent":523,"notused":61,"detail":"SEARCH plan USING INDEX orchestration_v2_projection_plans_thread_idx (thread_id=?)"},{"id":544,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 14"},{"id":547,"parent":544,"notused":0,"detail":"CO-ROUTINE per_run"},{"id":553,"parent":547,"notused":54,"detail":"SEARCH i USING COVERING INDEX orchestration_v2_projection_turn_items_thread_run_idx (thread_id=?)"},{"id":588,"parent":544,"notused":82,"detail":"SCAN per_run"},{"id":591,"parent":544,"notused":46,"detail":"SEARCH r USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) LEFT-JOIN"},{"id":618,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 15"},{"id":623,"parent":618,"notused":54,"detail":"SEARCH i USING COVERING INDEX orchestration_v2_projection_turn_items_thread_run_idx (thread_id=? AND run_id=?)"},{"id":654,"parent":0,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"}]}
{"label":"BEFORE isolated interrupt expressions","ms":72.95645100000002,"rows":1000}
{"beforeItemSHA256":"6e14bf65421d8d0e73188efbc35e189a81145cbc215d1b39aacaa73463cb8ca3","rows":{"c":903000}}
[20:09:41.772] INFO (#1): Migrations ran successfully { migrations: [ '68_ShellStopRequestIndex' ] }
{"boundary":"actual runMigrations existing 903000 synthetic items","ms":220.30787299999974,"applied":[[68,"ShellStopRequestIndex"]]}
{"boundary":"actual runMigrations restart","ms":4.415389000000687,"applied":[]}
{"migrationDataUnchanged":true,"itemSHA256":"6e14bf65421d8d0e73188efbc35e189a81145cbc215d1b39aacaa73463cb8ca3","index":{"sql":"CREATE INDEX orchestration_v2_projection_turn_items_stop_request_idx\n    ON orchestration_v2_projection_turn_items(thread_id, run_id)\n    WHERE type = 'run_interrupt_request'\n  "}}
{"boundary":"EXPLAIN QUERY PLAN full AFTER shell SELECT","plan":[{"id":9,"parent":0,"notused":216,"detail":"SCAN t"},{"id":16,"parent":0,"notused":46,"detail":"SEARCH active USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) LEFT-JOIN"},{"id":19,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 13"},{"id":25,"parent":19,"notused":62,"detail":"SEARCH r USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":57,"parent":0,"notused":46,"detail":"SEARCH presented USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) LEFT-JOIN"},{"id":60,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 14"},{"id":66,"parent":60,"notused":61,"detail":"SEARCH candidate USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":87,"parent":0,"notused":46,"detail":"SEARCH blocked USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) LEFT-JOIN"},{"id":90,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 15"},{"id":96,"parent":90,"notused":61,"detail":"SEARCH candidate USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":124,"parent":90,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"},{"id":153,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 1"},{"id":157,"parent":153,"notused":53,"detail":"SEARCH stop_request USING COVERING INDEX orchestration_v2_projection_turn_items_stop_request_idx (thread_id=? AND run_id=?)"},{"id":172,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 2"},{"id":178,"parent":172,"notused":62,"detail":"SEARCH r USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":209,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 3"},{"id":215,"parent":209,"notused":62,"detail":"SEARCH r USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":252,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 4"},{"id":260,"parent":252,"notused":62,"detail":"SEARCH binding USING INDEX orchestration_v2_projection_provider_session_bindings_thread_idx (thread_id=?)"},{"id":266,"parent":252,"notused":46,"detail":"SEARCH session USING INDEX sqlite_autoindex_orchestration_v2_projection_provider_sessions_1 (provider_session_id=?)"},{"id":287,"parent":252,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"},{"id":294,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 5"},{"id":302,"parent":294,"notused":46,"detail":"SEARCH r USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?)"},{"id":310,"parent":294,"notused":60,"detail":"SEARCH item USING INDEX orchestration_v2_projection_turn_items_failed_error_idx (thread_id=? AND run_id=? AND node_id=?)"},{"id":338,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 6"},{"id":342,"parent":338,"notused":53,"detail":"SEARCH stop_request USING COVERING INDEX orchestration_v2_projection_turn_items_stop_request_idx (thread_id=? AND run_id=?)"},{"id":355,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 7"},{"id":361,"parent":355,"notused":60,"detail":"SEARCH item USING INDEX orchestration_v2_projection_turn_items_failed_error_idx (thread_id=? AND run_id=? AND node_id=?)"},{"id":378,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 8"},{"id":384,"parent":378,"notused":61,"detail":"SEARCH request USING INDEX orchestration_v2_projection_runtime_requests_thread_status_idx (thread_id=? AND status=?)"},{"id":403,"parent":378,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"},{"id":410,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 9"},{"id":418,"parent":410,"notused":61,"detail":"SEARCH r USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?)"},{"id":446,"parent":410,"notused":61,"detail":"SEARCH secret USING INDEX orchestration_v2_projection_turn_items_thread_run_idx (thread_id=? AND run_id=?)"},{"id":471,"parent":410,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"},{"id":478,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 10"},{"id":483,"parent":478,"notused":54,"detail":"SEARCH message USING COVERING INDEX orchestration_v2_projection_messages_latest_user_idx (thread_id=?)"},{"id":494,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 11"},{"id":500,"parent":494,"notused":62,"detail":"SEARCH message USING INDEX orchestration_v2_projection_messages_latest_user_idx (thread_id=?)"},{"id":515,"parent":0,"notused":0,"detail":"CORRELATED SCALAR SUBQUERY 12"},{"id":520,"parent":515,"notused":61,"detail":"SEARCH plan USING INDEX orchestration_v2_projection_plans_thread_idx (thread_id=?)"},{"id":552,"parent":0,"notused":0,"detail":"USE TEMP B-TREE FOR ORDER BY"}]}
{"label":"AFTER isolated interrupt expressions","ms":1.6897979999994277,"rows":1000}
{"boundary":"grouped count plan","plan":[{"id":2,"parent":0,"notused":0,"detail":"CO-ROUTINE counts"},{"id":8,"parent":2,"notused":153,"detail":"SEARCH orchestration_v2_projection_turn_items USING COVERING INDEX orchestration_v2_projection_turn_items_thread_run_idx (thread_id=?)"},{"id":3055,"parent":0,"notused":82,"detail":"SCAN counts"},{"id":3058,"parent":0,"notused":46,"detail":"SEARCH r USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) LEFT-JOIN"},{"id":3066,"parent":0,"notused":0,"detail":"USE TEMP B-TREE FOR GROUP BY"}]}
{"label":"old correlated item counts round 0","ms":81.30918399999973,"rows":1000}
{"label":"new grouped item counts round 0","ms":132.55942400000094,"rows":900}
{"label":"old correlated item counts round 1","ms":87.98423000000003,"rows":1000}
{"label":"new grouped item counts round 1","ms":110.5240849999991,"rows":900}
{"label":"old correlated item counts round 2","ms":97.82638599999882,"rows":1000}
{"label":"new grouped item counts round 2","ms":116.70045600000049,"rows":900}
{"label":"old correlated item counts round 3","ms":83.71873199999936,"rows":1000}
{"label":"new grouped item counts round 3","ms":111.39398500000061,"rows":900}
{"label":"BEFORE SELECT shape with AFTER index (not baseline timing)","ms":132.37771299999986,"rows":1000}
{"label":"AFTER SELECT shape with AFTER index","ms":50.91244700000061,"rows":1000}
{"threadSQLFieldsEqual":true,"interruptEqual":true,"countEqual":true,"stopRequestLookups":2,"fileBytes":318722048,"freeBytes":18434306048}
(node:959657) ExperimentalWarning: stripTypeScriptTypes is an experimental feature and might change at any time
(Use `node --trace-warnings ...` to show where the warning was created)
