Ask or search…
K

Decoded Logs

This table has 1 row for every log, regardless of whether it is decoded or not.
PSQL
API
Query decoded event logs by contract address/topic0.
select * from ethereum.decoded_logs
where address = '0x29f0096512b4af1d689c1a11a867a6e707a8dcde' limit 10
Coming Soon

Table Columns

Key fields in addition to raw event logs data
  • name - name of the event e.g. Transfer
  • params - json field containing all the arguments of the event log
Partitioned table "evm.decoded_logs"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
-------------------+-----------------------------+-----------+----------+---------+----------+-------------+--------------+-------------
address | character varying(42) | | | | extended | | |
name | character varying | | | | extended | | |
params | jsonb | | | | extended | | |
topic0 | character varying(66) | | | | extended | | |
transaction_hash | character varying(66) | | not null | | extended | | |
log_index | bigint | | not null | | plain | | |
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 | | |
transaction_index | bigint | | | | plain | | |
Partition key: RANGE (block_timestamp)
Indexes:
"decoded_logs_pk" PRIMARY KEY, btree (transaction_hash, log_index, block_timestamp)
"decoded_logs_address_block_timestamp_index" btree (address, block_timestamp DESC)
"decoded_logs_block_index" btree (block_number)
"decoded_logs_block_timestamp_index" btree (block_timestamp DESC)
Last modified 2mo ago