BLOCK_GROUP | AVG_BLOCK_TIME_SEC | |
|---|---|---|
1 | 2000 | 1 |
2 | 4000 | 235.285714 |
3 | 6000 | 422.6 |
4 | 8000 | 17.035294 |
5 | 10000 | 37.536585 |
6 | 14000 | 3.959669 |
7 | 16000 | 81.904762 |
8 | 18000 | 727 |
9 | 26000 | 2442.5 |
10 | 30000 | 481 |
11 | 34000 | 1846 |
12 | 36000 | 24.487179 |
13 | 38000 | 631.666667 |
14 | 40000 | 84.583333 |
15 | 42000 | 103.65 |
16 | 44000 | 61.75 |
17 | 46000 | 140 |
18 | 48000 | 217.785714 |
19 | 50000 | 133.2 |
20 | 52000 | 1907 |
10Blockchainnecessary-turquoise
Updated 2025-02-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH raw_blocks AS (
SELECT
BLOCK_NUMBER,
BLOCK_TIMESTAMP,
LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_NUMBER) AS PREV_BLOCK_TS
FROM MONAD.TESTNET.FACT_TRANSACTIONS
-- Ajoutez vos éventuels filtres, par exemple :
-- WHERE BLOCK_TIMESTAMP >= '2025-02-17'
),
block_times AS (
SELECT
FLOOR(BLOCK_NUMBER / 2000) * 2000 AS BLOCK_GROUP,
DATEDIFF('SECOND', PREV_BLOCK_TS, BLOCK_TIMESTAMP) AS BLOCK_INTERVAL_SEC
FROM raw_blocks
WHERE PREV_BLOCK_TS IS NOT NULL -- On ignore le tout premier bloc (sans LAG)
)
SELECT
BLOCK_GROUP,
AVG(BLOCK_INTERVAL_SEC) AS AVG_BLOCK_TIME_SEC
FROM block_times
GROUP BY BLOCK_GROUP
ORDER BY BLOCK_GROUP;
Last run: about 2 months ago
...
2771
50KB
30s