Contoh kueri Polygon Mainnet

Halaman ini memberikan contoh kueri Blockchain Analytics untuk Polygon Mainnet.

Lihat dokumentasi BigQuery untuk mengetahui petunjuk tentang cara menggunakan BigQuery.

Melihat blok yang diindeks paling awal dan terbaru

Di konsol Google Cloud , buka halaman BigQuery.

Buka BigQuery

Kueri berikut dimuat ke dalam kolom Editor:

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;

Berikut contoh hasilnya:

Blok Pertama	Blokir Terbaru
0	54794165

Menghitung TPS (transaksi per detik) menurut bulan di mainnet Polygon

Buka BigQuery

Kueri berikut dimuat ke dalam kolom Editor:

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;

Berikut contoh hasilnya:

TXN_COUNT_PER_MONTH	TXN_PER_SECOND	YEAR	BULAN
113.037.832	43,610274691358022	2024	2
103.680.742	40.0002862654321	2024	1
82.598.612	31.866748456790123	2024	3