-- ============================================================================ -- G_prod_02 — PRODUCTION AXIS ROLLOUT VERIFY (READ-ONLY, run after G_prod_01) -- ============================================================================ \pset pager off \echo ==================== AXIS_ROLLOUT_VERIFY ==================== SELECT 'substrate_tables' k, (SELECT count()::text FROM information_schema.tables WHERE table_schema='public' AND table_name IN ('axis_registry','axis_value','axis_assignment','coverage_rule','axis_object_ownership','axis_candidate_finding')) v UNION ALL SELECT 'axis_registry_rows', (SELECT count()::text FROM axis_registry) UNION ALL SELECT 'responsibility_active_values', (SELECT count()::text FROM axis_value WHERE axis_code='responsibility' AND status='active') UNION ALL SELECT 'axis_required_cells', (SELECT count()::text FROM v_axis_required_cell) UNION ALL SELECT 'axis_coverage_gap', (SELECT count()::text FROM v_axis_coverage_gap) UNION ALL SELECT 'canonical_gap', (SELECT count()::text FROM v_object_owner_gap) UNION ALL SELECT 'zero_drift_ok', (SELECT ((SELECT count() FROM v_axis_coverage_gap)=(SELECT count() FROM v_object_owner_gap))::text) UNION ALL SELECT 'governance_object_ownership_UNCHANGED', (SELECT count()::text FROM governance_object_ownership) UNION ALL SELECT 'event_outbox_gov', (SELECT count()::text FROM event_outbox WHERE event_domain='governance') ORDER BY 1; \echo EXPECT: substrate_tables=6, responsibility_active_values=6, axis_required_cells=210, \echo axis_coverage_gap == canonical_gap (210 pre-ownership-seed), zero_drift_ok=true.