Skip to content

Failed Traces

The ethereum.failed_traces table provides indexed views of all failed traces.


Name Type Description
block_number integer The block number the parent transaction was included in.
error text Error data for the trace.
from_address text The address of the transaction's sender.
input text The input data for the trace.
timestamp timestamp The log's timestamp (in ISO-8601 format).
to_address text The address of the transaction's recipient, if any.
trace_address integer[] The address of the trace within the transaction's call stack.
trace_index integer The index of the trace in the transaction.
trace_type text The trace's call type (call, staticcall, delegatecall, callcode, create, or selfdestruct).
transaction_hash text The parent transaction's hash.
transaction_position integer The position of the parent transaction in the block.
value numeric The amount sent by the transaction (in Wei).
__confirmed boolean Flag indicating whether the log has been confirmed.


transaction_hash, trace_index
to_address, block_number, transaction_position
from_address, block_number, transaction_position
block_number, transaction_position
__confirmed WHERE __confirmed = false
left(input, 10), block_number, transaction_position
to_address, left(input, 10), block_number, transaction_position

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.