Logs
The logs
table provides indexed views of all logs emitted for a specified chain.
Columns
Name | Description | Type |
---|---|---|
block_number | The block number the parent transaction was included in. | integer |
timestamp | The log's timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The parent transaction's hash. | text |
transaction_position | The position of the parent transaction in the block. | integer |
log_index | The index of the log in the block. | integer |
address | The address of the smart contract that emitted the log. | text |
topic_0 | The first log topic. | text |
topic_1 | The second log topic. | text |
topic_2 | The third log topic. | text |
topic_3 | The fourth log topic. | text |
data | The data of the log (bytes data as a hex string). | text |
__confirmed | Flag indicating whether the log has been confirmed. | boolean |
Indexes
The following indexes are available for this table:
(__confirmed) WHERE __confirmed = false
(block_number, log_index)
(address, block_number, log_index)
(topic_0 NULLS LAST, block_number, log_index)
(address, topic_0 NULLS LAST, block_number, log_index)
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.