mlhMinimum, Average and Maximum Time between Blocks on Avalanche (in seconds)
Updated 2022-11-30
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
›
⌄
select avg(time_between_blocks) as "Time Between Blocks",
'Average Time Between Blocks' as "Min, Avg and Max"
from (select
date_trunc('hour', a.block_timestamp) as day,
datediff(second, a.block_timestamp, b.block_timestamp) as time_between_blocks
from avalanche.core.fact_blocks a
join avalanche.core.fact_blocks b
on a.block_number = b.block_number - 1
where a.block_timestamp >= CURRENT_DATE - 90)
union
select max(time_between_blocks),
'Max Time Between Blocks'
from (select
date_trunc('hour', a.block_timestamp) as day,
datediff(second, a.block_timestamp, b.block_timestamp) as time_between_blocks
from avalanche.core.fact_blocks a
join avalanche.core.fact_blocks b
on a.block_number = b.block_number - 1
where a.block_timestamp >= CURRENT_DATE - 90)
union
select min(time_between_blocks),
'Min Time Between Blocks'
from (select
date_trunc('hour', a.block_timestamp) as day,
datediff(second, a.block_timestamp, b.block_timestamp) as time_between_blocks
from avalanche.core.fact_blocks a
join avalanche.core.fact_blocks b
on a.block_number = b.block_number - 1
where a.block_timestamp >= CURRENT_DATE - 90)
order by 1 asc
Run a query to Download Data