evm.execution_attempts view

Kind: View
Layer: execution_read_model
Columns: 23
Queries: 2

Contract and lifecycle

Grain: One contextual attempt owner per (execution_id, attempt_kind, step_index or observation_index). The same attempt_id may expand under multiple owners.
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.executions on execution_id for candidate and run context.
Use attempt_id to deduplicate physical facts expanded across contextual owners.
For program owners use step_index; for observation-call owners use observation_index and observation_key.
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
`execution_id`	UUID Contextual execution association identity; do not use it as reusable artifact identity.
`attempt_kind`	VARCHAR Owner kind: program_step or observation_call.
`observation_key`	VARCHAR Byte-exact caller observation identity for an observation_call owner; otherwise NULL.
`attempt_id`	UUID Reusable physical attempt identity; contextual owners may share this value.

Contextual keys and reusable identities that establish row ownership.

Chain context

Name	Type
`chain_id`	UBIGINT EVM chain identifier frozen for the owning execution.
`chain_profile`	VARCHAR Named chain-rules profile frozen for the owning execution.

Pinned chain, block, profile, and revision context.

Ordering and cardinality

Name	Type
`step_index`	UINTEGER Zero-based program order; NULL for observation_call attempt owners.
`observation_index`	UINTEGER Zero-based expanded point order; identifies observation-call ownership.

Stable indexes and counts used to reconstruct deterministic order.

Payload and evidence

Name	Type
`evm_execution_gas`	UBIGINT Gas consumed by EVM execution when a complete measurement is available.
`return_data`	BYTES Successful return bytes when the attempt produced them; otherwise NULL.
`revert_data`	BYTES EVM revert bytes when the attempt reverted with data; otherwise NULL.
`engine_semantics`	VARCHAR Versioned evaluator-semantics identity used for this result.
`evidence_semantics`	VARCHAR Versioned evidence-publication semantics identity used for this result.

Operation-specific inputs, outputs, and authenticated evidence.

Status and disposition

Name	Type
`evm_status`	VARCHAR Physical attempt outcome: success, revert, or failure.
`evm_error_code`	VARCHAR Stable EVM failure code when evm_status is not success; otherwise NULL.
`fact_completeness`	VARCHAR Whether the selected fact relations are complete for the represented result.

Outcome vocabulary and NULL-controlling disposition fields.

Commitments

Name	Type
`input_state_identity_hash`	BYTES32 Identity of the immutable checkpoint supplied to the physical attempt.
`call_message_root`	BYTES32 Commitment to the EVM call message evaluated by the attempt.
`attempt_spec_root`	BYTES32 Commitment to the input state, call message, chain rules, and attempt semantics.
`trace_root`	BYTES32 Commitment to the semantic call-frame trace for the physical attempt.
`attempt_facts_root`	BYTES32 Commitment to the exact retained fact relations for the physical attempt.

Showing fewer

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

Timestamps

Name	Type
`created_at`	TIMESTAMP Context association or publication timestamp; not a reusable semantic identity.

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.execution_attempts'::VARCHAR AS object_name, CASE WHEN count(*) > 0 THEN 'PASS' ELSE 'FAIL' END::VARCHAR AS status FROM evm."execution_attempts" o JOIN evm.executions e USING (execution_id) WHERE e.candidate_key IN ('complete-effects', 'later-revert', 'ordered-logs', 'create', 'selfdestruct', 'blockhash', 'transient-access');

Example: table.evm.execution_attempts.lookup

Check candidate ownership

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

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

Example: table.evm.execution_attempts.diagnostic