rezarwzBlock Generation (per second)
Updated 2024-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
SELECT
date_trunc('hour', BLOCK_TIMESTAMP) AS HOUR,
AVG(
TIMEDIFF(SECOND, BLOCK_TIMESTAMP, NEXT_BLOCK_TIMESTAMP)
) AS AVG_BLOCK_TIME,
MIN(
TIMEDIFF(SECOND, BLOCK_TIMESTAMP, NEXT_BLOCK_TIMESTAMP)
) AS MIN_BLOCK_TIME,
MAX(
TIMEDIFF(SECOND, BLOCK_TIMESTAMP, NEXT_BLOCK_TIMESTAMP)
) AS MAX_BLOCK_TIME,
STDDEV(
TIMEDIFF(SECOND, BLOCK_TIMESTAMP, NEXT_BLOCK_TIMESTAMP)
) AS BLOCK_TIME_STDDEV,
COUNT(*) AS BLOCK_COUNT,
COUNT(*) / 3600 AS BLOCK_RATE
FROM
(
SELECT
BLOCK_TIMESTAMP,
BLOCK_NUMBER,
LEAD(BLOCK_TIMESTAMP) OVER (
ORDER BY
BLOCK_NUMBER
) AS NEXT_BLOCK_TIMESTAMP
FROM
blast.core.fact_blocks
) AS time_diffs
GROUP BY
HOUR
ORDER BY
HOUR ASC;
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived