evm.executions table

Kind: Table
Layer: program_execution
Columns: 41
Queries: 2

Contract and lifecycle

Grain: One contextual candidate association per execution_id. Identifying tuples: (execution_id) and the physical UNIQUE tuple (run_id, candidate_key).
Lifecycle: run publishes this immutable row set atomically with its owning run. Statement failure or caller rollback publishes no durable prefix; direct DML is unsupported because it can corrupt the documented invariants.
Status and NULLs: Interpret nullable payloads only through their owning status fields. Defensive poisoned and engine_error outcomes mean the engine refused to claim a trustworthy normal result; broad view nullability also covers owner alternatives and left-joined evidence.
Join guidance: Join evm.runs on run_id.
Join every execution_* public view on execution_id.
execution_artifact_hash is reusable across contextual execution_id values when complete.
Effect semantics: Access flags describe attempted EVM access, not committed state change.
Effect facts retain attempted evidence and final committed, reverted, discarded, or poisoned disposition.
execution_state_deltas contains committed checkpoint transitions only; observation-call effects are excluded from execution_effect_summary.

Columns

Identity and ownership

Name	Type
`run_id`	UUID Owning invocation
`execution_id`	UUID Contextual execution id
`candidate_key`	VARCHAR Caller candidate key
`execution_artifact_hash`	BYTES32 Reusable artifact identity

Contextual keys and reusable identities that establish row ownership.

Chain context

Name	Type
`chain_id`	UBIGINT EVM chain id
`anchor_block_number`	UBIGINT Pinned anchor number
`anchor_block_hash`	BYTES32 Pinned anchor hash
`anchor_canonicality_at_run`	VARCHAR Canonicality at execution
`chain_profile`	VARCHAR Chain profile

Showing fewer

Pinned chain, block, profile, and revision context.

Ordering and cardinality

Name	Type
`step_count`	UBIGINT Program step count
`executed_step_count`	UBIGINT Attempted step count

Stable indexes and counts used to reconstruct deterministic order.

Payload and evidence

Name	Type
`total_evm_execution_gas`	UBIGINT Attempted-prefix execution gas
`total_transaction_gas_estimate`	UBIGINT Attempted-prefix transaction gas
`physical_strategy`	VARCHAR Physical strategy
`scheduler_kind`	VARCHAR Scheduler kind
`engine_semantics`	VARCHAR Execution semantics identifier

Showing fewer

Operation-specific inputs, outputs, and authenticated evidence.

Status and disposition

Name	Type	Default
`status`	VARCHAR Candidate status
`error_code`	VARCHAR Stable error code
`execution_closure_status`	VARCHAR Executed-prefix closure
`fact_completeness`	VARCHAR Selected fact completeness
`observation_status`	VARCHAR Observation lifecycle status

Showing fewer

Outcome vocabulary and NULL-controlling disposition fields.

Effects

Name	Type	Default
`worker_count`	UINTEGER Effective workers	`0`

Attempted and final effect facts or aggregates.

Commitments

Name	Type
`candidate_request_hash`	BYTES32 Canonical request commitment
`assumption_root`	BYTES32 Semantic assumption commitment
`program_body_root`	BYTES32 Ordered executable body commitment
`program_root`	BYTES32 Frozen PROGRAM commitment
`execution_facts_root`	BYTES32 Selected facts commitment

Showing fewer

Hashes and roots authenticating specifications, facts, state, or results.

Timestamps

Name	Type
`created_at`	TIMESTAMP Context association time

Contextual publication times that are excluded from reusable semantic identity.

Linked joins

Related public objects

Verified queries

Confirm fixture coverage

Confirm that this object has rows owned by the stable seven-candidate public fixture.

SELECT 'evm.executions'::VARCHAR AS object_name, CASE WHEN count(*) > 0 THEN 'PASS' ELSE 'FAIL' END::VARCHAR AS status FROM evm."executions" e WHERE e.candidate_key IN ('complete-effects', 'later-revert', 'ordered-logs', 'create', 'selfdestruct', 'blockhash', 'transient-access');

Example: table.evm.executions.lookup

Check candidate ownership

Diagnose whether this object remains linked to at least one stable fixture candidate through public keys.

SELECT 'evm.executions'::VARCHAR AS object_name, CASE WHEN count(DISTINCT e.candidate_key) > 0 THEN 'PASS' ELSE 'FAIL' END::VARCHAR AS status FROM evm."executions" e WHERE e.candidate_key IN ('complete-effects', 'later-revert', 'ordered-logs', 'create', 'selfdestruct', 'blockhash', 'transient-access');

Example: table.evm.executions.diagnostic