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 optimism.logs
limit 10
Query raw logs data by contract address/topic0.
select * from optimism.logs
limit 10
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)
Responses are generated using AI and may contain mistakes.
