Polygon Mainnet 範例查詢

本頁提供 Polygon 主網的區塊鏈分析查詢範例。

如需使用 BigQuery 的操作說明，請參閱 BigQuery 說明文件。

查看最早和最近建立索引的區塊

前往 Google Cloud 控制台的「BigQuery」頁面。

前往 BigQuery

下列查詢會載入「編輯器」欄位：

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;

以下是結果範例：

第一階段	最新區塊
0	54794165

計算 Polygon 主網的每月 TPS (每秒交易數)

前往 BigQuery

下列查詢會載入「編輯器」欄位：

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;

以下是結果範例：

TXN_COUNT_PER_MONTH	TXN_PER_SECOND	YEAR	月
113,037,832	43.610274691358022	2024	2
103,680,742	40.0002862654321	2024	1
82,598,612	31.866748456790123	2024	3