This page provides Blockchain Analytics query examples for Polygon Mainnet.
See the BigQuery documentation for instructions on using BigQuery.
View the earliest and most recently indexed block
In the Google Cloud console, go to the BigQuerypage.
The following query is loaded into the Editorfield:
SELECT
MIN
(
block_number
)
AS
`
First
block
`
,
MAX
(
block_number
)
AS
`
Newest
block
`
,
COUNT
(
1
)
AS
`
Total
number
of
blocks
`
FROM
bigquery
-
public
-
data
.
goog_blockchain_polygon_mainnet_us
.
blocks
;
The following shows an example result:
| First Block | Newest Block |
|---|---|
| 0 | 54794165 |
Calculate TPS (transactions per second) by month on Polygon mainnet
The following query is loaded into the Editorfield:
SELECT
COUNT
(
*
)
AS
TXN_COUNT_PER_MONTH
,
COUNT
(
*
)
/
2592000
.
0
AS
TXN_PER_SECOND
,
#
seconds
in
a
month
EXTRACT
(
YEAR
FROM
txn
.
block_timestamp
)
AS
YEAR
,
EXTRACT
(
MONTH
FROM
txn
.
block_timestamp
)
AS
MONTH
,
FROM
`
bigquery
-
public
-
data
.
goog_blockchain_polygon_mainnet_us
.
transactions
`
AS
txn
GROUP
BY
EXTRACT
(
YEAR
FROM
txn
.
block_timestamp
),
EXTRACT
(
MONTH
FROM
txn
.
block_timestamp
)
ORDER
BY
TXN_COUNT_PER_MONTH
DESC
;
The following shows an example result:
| TXN_COUNT_PER_MONTH | TXN_PER_SECOND | YEAR | MONTH |
|---|---|---|---|
|
113,037,832
|
43.610274691358022 | 2024 | 2 |
|
103,680,742
|
40.0002862654321 | 2024 | 1 |
|
82,598,612
|
31.866748456790123 | 2024 | 3 |
