Controlled base comparison: removed only new index from synthetic DB; migration ledger retained intentionally.
{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","source":{"sha256":"eeec1919823fd14d8b540536c9008153636f8399b6b96b6e4e8edf5bc7a6a7da","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","source":"apps/server/src/orchestration-v2/ProjectionStore.ts","transformedSHA256":"28726270080b5900b93c98c3f470a0b2cb92c62e44fd1b7428f03f7356c454c0"},"node":"v26.12.1","boundary":"actual ProjectionStore layer with current installed dependencies, frozen selected source, direct SQLite client, no transport"}
{"boundary":"selectShellThreadRows","variant":"before","ms":155.034627,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"before","ms":1.5174160000001393,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.5878930000001219,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.7770069999999123,"rows":1,"threadId":"t0001"}
{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","round":0,"boundary":"getShellSnapshot active full decode","ms":315.0820329999999,"threads":998,"sha256":"a713a954347275a65da76cc21e02e34835312e3edbd758a1a401d87c08be3608"}
{"boundary":"selectShellThreadRows","variant":"before","ms":136.15926400000012,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.8034569999999803,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.48283600000013394,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.7399680000000899,"rows":1,"threadId":"t0001"}
{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","round":1,"boundary":"getShellSnapshot active full decode","ms":209.75633599999992,"threads":998,"sha256":"a713a954347275a65da76cc21e02e34835312e3edbd758a1a401d87c08be3608"}
{"boundary":"selectShellThreadRows","variant":"before","ms":137.76636699999995,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.9251940000001468,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.6260540000000674,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.8265499999999975,"rows":1,"threadId":"t0001"}
{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","round":2,"boundary":"getShellSnapshot active full decode","ms":208.59263499999997,"threads":998,"sha256":"a713a954347275a65da76cc21e02e34835312e3edbd758a1a401d87c08be3608"}
{"boundary":"selectShellThreadRows","variant":"before","ms":134.740593,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.8064829999998437,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.6156949999999597,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.8482010000000173,"rows":1,"threadId":"t0001"}
{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","round":3,"boundary":"getShellSnapshot active full decode","ms":205.36021400000004,"threads":998,"sha256":"a713a954347275a65da76cc21e02e34835312e3edbd758a1a401d87c08be3608"}

{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","boundary":"actual ws.subscribeOrchestrationV2Shell() through first snapshot stream item; in-process, real projections+event store, empty synthetic project list, no WebSocket serialization/network/ACK, no reader worker"}
{"boundary":"selectShellThreadRows","variant":"before","ms":139.29148699999996,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"before","ms":1.6786780000002182,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.6845429999998487,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.7714169999999285,"rows":1,"threadId":"t0001"}
{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","round":0,"boundary":"subscribeShell in-process first snapshot","ms":259.2039460000001,"kind":"snapshot","threads":998,"sha256":"85c455bda0ea1d0640b9dc206bb2cc8726732f1cebd595a37f915c784340152c"}
{"boundary":"selectShellThreadRows","variant":"before","ms":133.1092639999997,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.8362790000001041,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.46309800000017276,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.7350189999997383,"rows":1,"threadId":"t0001"}
{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","round":1,"boundary":"subscribeShell in-process first snapshot","ms":212.8159740000001,"kind":"snapshot","threads":998,"sha256":"85c455bda0ea1d0640b9dc206bb2cc8726732f1cebd595a37f915c784340152c"}
{"boundary":"selectShellThreadRows","variant":"before","ms":136.59571300000016,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.9381679999996777,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.5862379999998666,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.7939390000001367,"rows":1,"threadId":"t0001"}
{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","round":2,"boundary":"subscribeShell in-process first snapshot","ms":216.35175299999992,"kind":"snapshot","threads":998,"sha256":"85c455bda0ea1d0640b9dc206bb2cc8726732f1cebd595a37f915c784340152c"}
{"boundary":"selectShellThreadRows","variant":"before","ms":138.29082000000017,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.7317919999995866,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.4698609999995824,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"before","ms":0.7056130000000849,"rows":1,"threadId":"t0001"}
{"variant":"before","sha":"4eae8ae011e2e56ca20159c13f3fb8a2ac49a991","round":3,"boundary":"subscribeShell in-process first snapshot","ms":206.3634950000005,"kind":"snapshot","threads":998,"sha256":"85c455bda0ea1d0640b9dc206bb2cc8726732f1cebd595a37f915c784340152c"}

Controlled HEAD comparison: restored exact migration068 index SQL on same unchanged synthetic rows.
{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","source":{"sha256":"e98f920d32b3975637efe432579b88bf496df3bed526dfb57c6bc5192b44cc95","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","source":"apps/server/src/orchestration-v2/ProjectionStore.ts","transformedSHA256":"893216fe2d19970792d55c25320a4154ab737c535c6b0736581cb327b38f19e0"},"node":"v26.12.1","boundary":"actual ProjectionStore layer with current installed dependencies, frozen selected source, direct SQLite client, no transport"}
{"boundary":"selectShellThreadRows","variant":"after","ms":65.70987400000001,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"after","ms":1.7697389999999587,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.7711359999999559,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.7905120000000352,"rows":1,"threadId":"t0001"}
{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","round":0,"boundary":"getShellSnapshot active full decode","ms":304.2394129999999,"threads":998,"sha256":"a713a954347275a65da76cc21e02e34835312e3edbd758a1a401d87c08be3608"}
{"boundary":"selectShellThreadRows","variant":"after","ms":46.025182000000086,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.7398270000001048,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.502913000000035,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.5590689999999086,"rows":1,"threadId":"t0001"}
{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","round":1,"boundary":"getShellSnapshot active full decode","ms":219.65279400000009,"threads":998,"sha256":"a713a954347275a65da76cc21e02e34835312e3edbd758a1a401d87c08be3608"}
{"boundary":"selectShellThreadRows","variant":"after","ms":44.71738000000005,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.6973669999999856,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.45595400000001973,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.5265470000001642,"rows":1,"threadId":"t0001"}
{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","round":2,"boundary":"getShellSnapshot active full decode","ms":219.25539900000012,"threads":998,"sha256":"a713a954347275a65da76cc21e02e34835312e3edbd758a1a401d87c08be3608"}
{"boundary":"selectShellThreadRows","variant":"after","ms":44.071309000000156,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.6287879999999859,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.39752599999997074,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.5650490000000445,"rows":1,"threadId":"t0001"}
{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","round":3,"boundary":"getShellSnapshot active full decode","ms":230.0378569999998,"threads":998,"sha256":"a713a954347275a65da76cc21e02e34835312e3edbd758a1a401d87c08be3608"}

{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","boundary":"actual ws.subscribeOrchestrationV2Shell() through first snapshot stream item; in-process, real projections+event store, empty synthetic project list, no WebSocket serialization/network/ACK, no reader worker"}
{"boundary":"selectShellThreadRows","variant":"after","ms":46.926972999999634,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"after","ms":1.4967970000002424,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.6765199999999822,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.6138510000000679,"rows":1,"threadId":"t0001"}
{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","round":0,"boundary":"subscribeShell in-process first snapshot","ms":255.3653479999998,"kind":"snapshot","threads":998,"sha256":"85c455bda0ea1d0640b9dc206bb2cc8726732f1cebd595a37f915c784340152c"}
{"boundary":"selectShellThreadRows","variant":"after","ms":45.46857799999998,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.7661159999997835,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.4062619999999697,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.5589279999999235,"rows":1,"threadId":"t0001"}
{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","round":1,"boundary":"subscribeShell in-process first snapshot","ms":223.01010899999983,"kind":"snapshot","threads":998,"sha256":"85c455bda0ea1d0640b9dc206bb2cc8726732f1cebd595a37f915c784340152c"}
{"boundary":"selectShellThreadRows","variant":"after","ms":54.41446300000007,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.9419470000002548,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.6204130000005534,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.6397290000004432,"rows":1,"threadId":"t0001"}
{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","round":2,"boundary":"subscribeShell in-process first snapshot","ms":230.38189199999988,"kind":"snapshot","threads":998,"sha256":"85c455bda0ea1d0640b9dc206bb2cc8726732f1cebd595a37f915c784340152c"}
{"boundary":"selectShellThreadRows","variant":"after","ms":44.71898400000009,"rows":998,"threadId":null}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.725310000000718,"rows":0,"threadId":"t0008"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.4209000000000742,"rows":0,"threadId":"missing-source"}
{"boundary":"selectShellThreadRows","variant":"after","ms":0.5449719999996887,"rows":1,"threadId":"t0001"}
{"variant":"after","sha":"19f654326598cc1f7411a56dbb07e651b6b5f254","round":3,"boundary":"subscribeShell in-process first snapshot","ms":217.7113220000001,"kind":"snapshot","threads":998,"sha256":"85c455bda0ea1d0640b9dc206bb2cc8726732f1cebd595a37f915c784340152c"}

{"equality":"snapshot","byteIdentical":true,"beforeSHA256":"3cb488d99e844fdaf8f94e2a7212882f27a20a90ae9ced338fa6d298e2adc98c","afterSHA256":"3cb488d99e844fdaf8f94e2a7212882f27a20a90ae9ced338fa6d298e2adc98c"}
{"equality":"subscription","byteIdentical":true,"beforeSHA256":"609f9655592e8655c356ead4ed696ad1023b48cb87693eebe01b2a594c100875","afterSHA256":"609f9655592e8655c356ead4ed696ad1023b48cb87693eebe01b2a594c100875"}
