The plume.event_logs table contains detailed information about contract events.

​
Table Schema

Column NameData TypeDescription
log_indexdecimal(38,0)Log index in transaction
transaction_hashstringTransaction hash
transaction_indexdecimal(38,0)Transaction index in block
block_hashstringBlock hash
block_numberdecimal(38,0)Block number
addressstringContract address
datastringLog data
topicsarrayLog topics
block_timestamptimestampBlock timestamp
event_namestringEvent name
event_signaturestringEvent signature
event_paramsjsonEvent parameters
contract_namestringContract name
contract_addressstringContract address
contract_typestringContract type

​
Sample Query

-- Get the most active contracts by event count
SELECT 
    contract_name,
    COUNT(*) as event_count
FROM plume.event_logs
WHERE block_timestamp >= NOW() - INTERVAL '24' HOUR
GROUP BY contract_name
ORDER BY event_count DESC
LIMIT 10;