01 — Live State Before Aggregate Pivots

All values are live at macro start (2026-06-03), verified via query_pg (RO) and ssh contabo → docker exec postgres psql (RW). Old reports were treated as evidence; live wins.

Execution channel

check	result
read	query_pg (directus) RO, AST-validated, 5s timeout, LIMIT 500
write	ssh contabo → host vmi3080463 → docker exec postgres psql -U workflow_admin -d directus
psql user	workflow_admin
is_superuser	on
transaction_read_only	off
rollback test	BEGIN..ROLLBACK with temp INSERT proven net-zero (entry hash == exit hash)
execution mode	EXECUTION_MODE

RP state (accepted = checkpoint matches live exactly)

metric	live
pivot_definitions total / active	37 / 35
parent graph	24 roots / 6 parents / 13 children (dangling 0 / cycle 0 / inactive-parent 0 / self-edge 0)
graph hash (parent_code)	91576fb60f9331d8ae8cb86998504c70
v_registries_pivot_node_contract	live, 26 cols, hierarchical
triggers on pivot_definitions	trg_after_pivot_definitions_change (STMT, full refresh) · trg_birth_pivot_definitions (ROW, birth) · trg_matrix_config_changed (ROW, only when matrix_spec set)

Existence checks (target pivots)

• PIV-311, PIV-313 — absent (confirmed not in pivot_definitions).
• PIV-301, PIV-302, PIV-303, PIV-304, PIV-312, PIV-500 — absent.
• PIV-104 — present, parent_code=PIV-007, filter_spec = status='published', group_spec = group by category.
• PIV-007 — present, DOT total, scalar, count=309.

Live source counts (drive every decision below)

source	live count	used by
information_unit	219	PIV-311
system_issues WHERE status='open'	207,940	PIV-313
system_issues (all)	208,634	context
dot_tools (all)	309	PIV-007
dot_tools WHERE status='published'	16	PIV-104 (old)
v_birth_orphan	59	PIV-301
v_birth_phantom	289	PIV-302
v_count_drift	3 rows	PIV-303
v_kg_edges_all	2,259	PIV-312
birth_registry	1,132,011	birth landing baseline

DOT distributions (the drill evidence)

• by category over all 309 → 25 groups summing to 309 (largest (null)=142).
• by status over all 309 → active 291 / published 16 / null 2 = 309.
• ⇒ The status='published' filter is exactly what collapsed PIV-104's drill to Σ16.

Safety confirmations

• No RP cleanup mutation needed or attempted.
• dot-pivot-update remains invalid/unused (untouched).
• Global guard untouched.
• All mutations limited to pivot aggregate definitions / metadata + additive views.