25000x · 07 — Cross-template observability hardening

Final observability state (after Phase B + C + E)

collection_key             | version | status     | inst | digest_match | diverge | active_pcs | tpl_without_version
tpl:file:status-report/v1  | v1      | superseded |    0 |            0 |       0 |          5 | f  (cleared)
tpl:file:status-report/v2  | v2      | current    |    4 |            4 |       0 |          6 | f
tpl:wf:onboarding/v1       | v1      | superseded |    1 |            1 |       0 |          5 | f
tpl:wf:onboarding/v2       | v2      | current    |   12 |           12 |       0 |          5 | f

Health check	Before 25000x	After 25000x
Unversioned current templates	1 (file/v1)	0
Template-without-version flag	1 row true	0 rows true
Version-without-template-marker flag	0	0
Orphan instances	0	0
Digest drift between instance and template	0	0
Auto-instantiate log rows	n/a	13
100% digest match across auto-log	n/a	13/13
100% live mode across auto-log	n/a	13/13
Templates in registry	3	4
Templates with version chain row	2	4

Surfaces covered

• v_iu_product_template (mig 031)
• v_iu_product_template_instance (mig 031)
• v_iu_template_version_chain (mig 032)
• v_iu_template_observability (mig 032)
• v_iu_auto_instantiate_event_log (mig 033)
• v_iu_auto_instantiate_event_summary (mig 033)

Operator query patterns

-- Product Factory state
SELECT * FROM v_iu_template_observability ORDER BY collection_key;

-- Last hour throughput
SELECT template_collection_key, emit_mode, instances_last_hour
  FROM v_iu_auto_instantiate_event_summary WHERE instances_last_hour > 0;

-- Per-event traceability
SELECT instance_collection_key, template_collection_key, event_id, event_type, triggered_by
  FROM v_iu_auto_instantiate_event_log ORDER BY created_at DESC;

-- Per-actor rollback addressability
SELECT triggered_by, count(*), count(DISTINCT event_id)
  FROM iu_auto_instantiate_event_log GROUP BY 1;

-- Observability issues (returns 0 rows after 25000x)
SELECT collection_key, template_without_version, version_without_template_marker, digest_diverged_instances
  FROM v_iu_template_observability
 WHERE template_without_version OR version_without_template_marker OR digest_diverged_instances > 0;

Carry-forward not addressed (deferred to 30000x+)

• No consolidated v_iu_product_factory_dashboard view JOINing all six surfaces.
• Auto-refresh of 3-axis envelope after auto-instantiation not wired (gate three_axis_auto_refresh_enabled=false).
• Auto-instantiate log retention not configured.