Skip to content

Failed Transactions

The ethereum.failed_transactions table provides indexed views of all transactions that failed (transactions that had no successful internal transactions).

Columns

Name Type Description
base_fee_per_gas numeric The base fee to include a transaction in the block (in Wei per gas unit).
block_number integer The block number the transaction was included in.
error text Error data for the transaction.
fees_burned numeric The amount of transaction fees burned by the transaction (see EIP-1559) (in Wei).
fees_rewarded numeric The amount of transaction fees rewarded to the miner of the transaction (in Wei).
fees_saved numeric The amount of transaction fees saved by the transaction (in Wei).
from_address text The address of the transaction's sender.
gas_limit numeric The maximum amount of gas that can be used in the transaction (in gas units).
gas_price numeric The actual price of gas used in the transaction (in Wei per gas unit).
gas_used numeric The amount of gas used in the transaction (in gas units).
input text The input data for the transaction.
internal_failed_transaction_count integer The number of internal transactions that failed in the transaction.
internal_transaction_count integer The number of successful internal transactions produced in the transaction.
max_fee_per_gas numeric The maximum fee used by the transaction (in Wei per gas unit).
max_priority_fee_per_gas numeric The maximum priority fee used by the transaction (in Wei per gas unit).
nonce integer The transaction sender's nonce.
position integer The position of the transaction in the block.
timestamp timestamp The transaction's timestamp (in ISO-8601 format).
to_address text The address of the transaction's recipient, if any.
transaction_fee numeric The gas fee paid by the transaction (in Wei).
transaction_hash text The transaction's hash.
type integer The type of the transaction (see EIP-1559, EIP-2718).
value numeric The amount sent by the transaction (in Wei).
__confirmed boolean Flag indicating whether the transaction has been confirmed.

Indexes

Index
transaction_hash
to_address, left(input, 10), block_number, position
left(input, 10), block_number, position
to_address, block_number, position
from_address, block_number, position
timestamp, position
block_number, position
__confirmed WHERE __confirmed = false

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.