mboveiriSolana Block Performance 1
Updated 2022-07-25
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
33
34
35
36
›
⌄
with daily as (select
t1.block_timestamp::date as date,
avg(datediff(second, t1.block_timestamp, t2.block_timestamp)) as average_between_blocks,
max(datediff(second, t1.block_timestamp, t2.block_timestamp)) as max_between_blocks,
min(datediff(second, t1.block_timestamp, t2.block_timestamp)) as min_between_blocks
from solana.core.fact_blocks t1 join solana.core.fact_blocks t2
on t1.block_id = t2.block_id - 1
where date >= '2022-06-06'
group by date) ,
all_time as (
select
avg(datediff(second, t1.block_timestamp, t2.block_timestamp)) as average_all_time,
max(datediff(second, t1.block_timestamp, t2.block_timestamp)) as max_all_time,
min(datediff(second, t1.block_timestamp, t2.block_timestamp)) as min_all_time
from solana.core.fact_blocks t1 join solana.core.fact_blocks t2
on t1.block_id = t2.block_id - 1
where t1.block_timestamp >= '2022-06-06'
),
tpb as (
select
block_timestamp::date as date,
min(tpb) as min_transacation_per_block,
avg(tpb) as average_transacation_per_block,
max(tpb) as max_transacation_per_block
from solana.core.fact_blocks join (select block_id, count(*) as tpb from solana.core.fact_transactions group by 1) tr_count
on tr_count.block_id = solana.core.fact_blocks.block_id
where block_timestamp >= '2022-06-06'
group by 1
),
avg_tpb_alltime as (
select
avg(tpb) as average_transacation_per_block_alltime
Run a query to Download Data