Traces
The base.traces table provides indexed views of all traces.
Columns
| Name | Type | Description |
|---|---|---|
| block_number | integer |
The block number the parent transaction was included in. |
| contract_address | text |
The address of the contract created by the transaction, if any. |
| from_address | text |
The address of the transaction's sender. |
| input | text |
The input data for the trace. |
| output | text |
The output 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. |
Indexes
| Index |
|---|
| 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.