Logs
Logs (or event logs), is a way for smart contracts to communicate with the outside world by "documenting" small pieces of information.
Event logs allow other people to know that something has happened without them having to query the contract directly. The most common form of event logs today are ERC20 (and ERC721) token transfer events.
Query raw logs data by contract address/topic0.
select * from polygon.logs
where address = '0x881d40237659c251811cec9c364ef91dc08d300c' limit 10Coming Soon.
Table Columns
Partitioned table "evm.logs"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
-------------------+-----------------------------+-----------+----------+---------+----------+-------------+--------------+-------------
transaction_hash | character varying(66) | | not null | | extended | | |
log_index | bigint | | not null | | plain | | |
transaction_index | bigint | | | | plain | | |
address | character varying(42) | | | | extended | | |
data | text | | | | extended | | |
topic0 | character varying(66) | | | | extended | | |
topic1 | character varying(66) | | | | extended | | |
topic2 | character varying(66) | | | | extended | | |
topic3 | character varying(66) | | | | extended | | |
block_timestamp | timestamp without time zone | | not null | | plain | | |
block_number | bigint | | | | plain | | |
block_hash | character varying(66) | | | | extended | | |
_created_at | timestamp without time zone | | | | plain | | |
_updated_at | timestamp without time zone | | | | plain | | |
Partition key: RANGE (block_timestamp)
Indexes:
"logs_pk" PRIMARY KEY, btree (transaction_hash, log_index, block_timestamp)
"logs_address_block_timestamp_index" btree (address, block_timestamp DESC)
"logs_block_index" btree (block_number)
"logs_block_timestamp_index" btree (block_timestamp DESC)Last updated