Skip to content


The logs table provides indexed views of all logs emitted for a specified chain.


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


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.