CryptoIcicleAlgo-Algorand Blockchain Block Performance - Block Stats
Updated 2022-01-22
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
›
⌄
-- Let's take a deeper dive into Algorand's blockchain performance! First, let's look at block times:
-- What’s the average time between block and how has this changed over time
-- What’s the max recorded time between two blocks?
-- What’s the minimum recorded time between blocks?
-- Next, let's look at block size:
-- How many transactions did the biggest block have? And what was the make up of this block(i.e. what type of transactions did it contain?)?
-- Has the number of transactions per block increased as network adoption increased(Chart the number of transactions per block over time)?"
-- Payout 35.97 ALGO
-- Grand Prize 107.91 ALGO
-- Difficulty Beginner
with block_timings as (
select
block_id,
block_timestamp,
datediff(seconds,lag(block_timestamp, 1) ignore nulls over (order by block_timestamp asc),block_timestamp) as block_timestamp_diff
from algorand.block
order by block_id
)
select
avg(block_timestamp_diff) as avg_block_timestamp_diff,
max(block_timestamp_diff) as max_block_timestamp_diff,
min(block_timestamp_diff) as min_block_timestamp_diff,
median(block_timestamp_diff) as median_block_timestamp_diff,
'Block Timings' as type
from block_timings
Run a query to Download Data