DATES | AVG_BLOCK_TIME | |
|---|---|---|
1 | 2025-02-19 17:00:00.000 | 2000 |
2 | 2025-02-19 16:00:00.000 | 2000 |
3 | 2025-02-19 15:00:00.000 | 2000 |
4 | 2025-02-19 14:00:00.000 | 2000 |
5 | 2025-02-19 13:00:00.000 | 2000 |
6 | 2025-02-19 12:00:00.000 | 2000 |
7 | 2025-02-19 11:00:00.000 | 2000 |
8 | 2025-02-19 10:00:00.000 | 2000 |
9 | 2025-02-19 09:00:00.000 | 2000 |
10 | 2025-02-19 08:00:00.000 | 2000 |
11 | 2025-02-19 07:00:00.000 | 2000 |
12 | 2025-02-19 06:00:00.000 | 2000 |
13 | 2025-02-19 05:00:00.000 | 2000 |
14 | 2025-02-19 04:00:00.000 | 2000 |
15 | 2025-02-19 03:00:00.000 | 2000 |
16 | 2025-02-19 02:00:00.000 | 2000 |
17 | 2025-02-19 01:00:00.000 | 2000 |
18 | 2025-02-19 00:00:00.000 | 2000 |
19 | 2025-02-18 23:00:00.000 | 2000 |
20 | 2025-02-18 22:00:00.000 | 2000 |
SocioAnalyticaAVG block time
Updated 2025-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
date_trunc('hour', date) as dates,
avg(avg_time_diff) as avg_block_time
FROM
(
SELECT
date_trunc('hour',a.block_timestamp) as date,
avg(datediff(millisecond , a.block_timestamp,b.block_timestamp)) as avg_time_diff
FROM blast.core.fact_blocks a, blast.core.fact_blocks b
WHERE a.block_number = b.block_number-1
GROUP BY date
)
GROUP BY 1
ORDER BY 1 DESC
Last run: about 2 months ago
...
8661
279KB
16s