tron.logs

Tron smart contract event logs — topics and data from TRC-20 transfers and protocol interactions.

Table Description

The logs table represents the logs generated by the Tron Virtual Machine (TVM) when a contract is executed. Logs are a way to store data on the blockchain. Logs originate from events that occur during the execution of a smart contract. A log consists of:

• topic list: a list of 0 to 4 32-byte data topics. Topic0 is the hash of the signature of the event (indexed), and the remaining topics are indexed parameters of the event.
• data: contains non-indexed data.

While working with raw logs is possible, we recommend to work with decoded logs for a more user-friendly experience.

Table Schema

Column	Type	Description
block_time	timestamp(3)	The exact UTC timestamp when the block containing this log was added to the chain
block_number	bigint	The sequential number of the block containing this log
block_hash	varbinary	Unique identifier (hash) of the block containing this log
contract_address	varbinary	Address of the smart contract that emitted this log
topic0	varbinary	First 32-byte topic, typically the keccak256 hash of the event signature
topic1	varbinary	Second 32-byte topic, containing the first indexed event parameter
topic2	varbinary	Third 32-byte topic, containing the second indexed event parameter
topic3	varbinary	Fourth 32-byte topic, containing the third indexed event parameter
data	varbinary	ABI-encoded data containing non-indexed event parameters
tx_hash	varbinary	Unique identifier (hash) of the transaction that generated this log
index	integer	Position of this log within the block
tx_index	integer	Position of the parent transaction within its containing block
block_date	date	The UTC date of the block in which this log was included
tx_from	varbinary	Address of the account that initiated the transaction containing this log
tx_to	varbinary	Address of the recipient account or contract for the transaction containing this log

Table Sample

Examples

Filter the logs for a specific contract

select *
from tron.logs
where contract_address = 0x06012c8cf97bead5deae237070f9587f8e7a266d
limit 10

Filter the logs for a specific topic

select *
from tron.logs
where topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef

Show the logs of a specific block

SELECT *
FROM tron.logs
WHERE evt_block_number = 1000000