AVERAGE_BLOCK_TIME_MS | |
|---|---|
1 | 367.347468 |
moonshot21Average Block Time
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
WITH block_times AS (
SELECT
BLOCK_TIMESTAMP,
LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_HEIGHT) AS previous_block_time
FROM eclipse.core.fact_blocks
WHERE DATE_TRUNC('day', BLOCK_TIMESTAMP) = CURRENT_DATE
)
SELECT
AVG(DATEDIFF(second, previous_block_time, BLOCK_TIMESTAMP) * 1000) AS average_block_time_ms
FROM block_times
WHERE previous_block_time IS NOT NULL;
Last run: 11 days ago
1
14B
3s