hour | blocks produced | avg block time (seconds) | min block time (seconds) | max block time (seconds) | |
|---|---|---|---|---|---|
1 | 2025-03-28 18:00:00.000 | 857 | 3.681447 | 3 | 9 |
2 | 2025-03-28 19:00:00.000 | 987 | 3.64843 | 3 | 4 |
3 | 2025-03-28 20:00:00.000 | 988 | 3.645749 | 3 | 4 |
4 | 2025-03-28 21:00:00.000 | 986 | 3.650101 | 3 | 4 |
5 | 2025-03-28 22:00:00.000 | 984 | 3.65752 | 3 | 4 |
6 | 2025-03-28 23:00:00.000 | 987 | 3.64843 | 3 | 4 |
7 | 2025-03-29 00:00:00.000 | 984 | 3.65752 | 3 | 4 |
8 | 2025-03-29 01:00:00.000 | 985 | 3.653807 | 3 | 4 |
9 | 2025-03-29 02:00:00.000 | 987 | 3.64843 | 3 | 4 |
10 | 2025-03-29 03:00:00.000 | 985 | 3.654822 | 3 | 4 |
11 | 2025-03-29 04:00:00.000 | 986 | 3.651116 | 3 | 4 |
12 | 2025-03-29 05:00:00.000 | 986 | 3.653144 | 3 | 4 |
13 | 2025-03-29 06:00:00.000 | 985 | 3.652792 | 3 | 4 |
14 | 2025-03-29 07:00:00.000 | 985 | 3.656853 | 3 | 4 |
15 | 2025-03-29 08:00:00.000 | 984 | 3.65752 | 3 | 4 |
16 | 2025-03-29 09:00:00.000 | 984 | 3.65752 | 3 | 4 |
17 | 2025-03-29 10:00:00.000 | 983 | 3.662258 | 3 | 4 |
18 | 2025-03-29 11:00:00.000 | 983 | 3.663276 | 3 | 4 |
19 | 2025-03-29 12:00:00.000 | 981 | 3.667686 | 3 | 4 |
20 | 2025-03-29 13:00:00.000 | 986 | 3.653144 | 3 | 4 |
defi__joshBlock Production Metrics (Network performance through block times)
Updated 2025-06-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
---Network performance through block times
WITH block_times AS (
SELECT
block_number,
block_timestamp,
LAG(block_timestamp) OVER (ORDER BY block_number) as prev_block_timestamp
FROM mezo.testnet.fact_blocks
WHERE block_timestamp >= (
SELECT MIN(block_timestamp)
FROM mezo.testnet.fact_transactions
)
)
SELECT
DATE_TRUNC('hour', block_timestamp) as "hour",
COUNT(*) as "blocks produced",
AVG(DATEDIFF('second', prev_block_timestamp, block_timestamp)) as "avg block time (seconds)",
MIN(DATEDIFF('second', prev_block_timestamp, block_timestamp)) as "min block time (seconds)",
MAX(DATEDIFF('second', prev_block_timestamp, block_timestamp)) as "max block time (seconds)"
FROM block_times
WHERE prev_block_timestamp IS NOT NULL
GROUP BY 1
ORDER BY 1;
Last run: 10 days ago
...
1574
69KB
6s