Polygon
As a blockchain compatible with the Ethereum Virtual Machine (EVM) standard, the Polygon tables are very similar to the Ethereum tables in structure.
Table Name | Description |
|---|---|
polygon.blocks | Block headers |
polygon.recent_blocks | Block headers from the last 30 minutes, ~900 blocks |
polygon.transactions | Block transactions |
polygon.recent_transactions | Block transactions from the last 30 minutes, ~900 blocks |
polygon.logs | Transaction event logs |
polygon.recent_logs | Transaction event logs from the last 30 minutes, ~900 blocks |
polygon.contracts | A listing of all contracts |
polygon.traces | All call frames executed during a transaction, also known as internal transactions |
polygon.recent_traces | polygon.traces data from the last 30 minutes, ~900 blocks |
The table list is also available as a SQL query using
show tables. For example:SHOW TABLES IN polygon
The columns and their schema available for each table can be viewed with the
describe <table> command. For example:/* Show the columns available */
DESCRIBE polygon.blocks;
DESCRIBE polygon.transactions;
DESCRIBE polygon.logs;
DESCRIBE polygon.contracts;
DESCRIBE polygon.traces;
Query performance can be significantly improved by adding
WHERE clauses to your query on specific indexed columns.Table Name | Indexed Columns |
|---|---|
polygon.blocks | number timestamp |
polygon.transactions | block_number hash block_timestamp |
polygon.logs | block_number address block_timestamp |
polygon.contracts | block_number block_timestamp |
polygon.traces | block_number block_timestamp |
Last modified 8mo ago