Table description
Theevents table (e.g. polkadot.events) holds all events that occur on the chain, including their pallet section and method, as well as the decoded data involved in the event.
Common queries on the events table will typically filter on block_time, section and method and extract JSON encoded information in
data or decoded_data.
Table Schema
| Column | Type | Description |
|---|---|---|
year | INTEGER | Calendar year of the block (partition column) |
month | INTEGER | Calendar month of the block (partition column) |
section | VARCHAR | The pallet (module) that emitted this event (e.g. Balances, System) |
method | VARCHAR | The event method name within the pallet (e.g. Transfer, ExtrinsicSuccess) |
block_time | TIMESTAMP | The timestamp of the block containing this event |
block_number | BIGINT | The sequential number of the block containing this event |
extrinsic_id | VARCHAR | Identifier of the extrinsic that triggered this event |
event_id | VARCHAR | Unique identifier for this event (format: blockNumber-eventIndex) |
data | VARCHAR | JSON-encoded event data |
extrinsic_hash | VARBINARY | Hash of the extrinsic that triggered this event |
block_hash | VARBINARY | Hash of the block containing this event |
data_decoded | VARCHAR | Human-readable decoded event data |
updated_at | TIMESTAMP | When this record was last updated in the database |
ingested_at | TIMESTAMP | When this record was first ingested into the database |