Min Block Time | Max Block Time | Average Block Time | Min TX count per block | Max TX count per block | Average TX count per block | |
|---|---|---|---|---|---|---|
1 | 0 | 3115 | 2.047258 | 1 | 712 | 12.16 |
elsina✅ Performance: total info
Updated 2024-01-29
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
›
⌄
with blocktage_diff as (
select
block_number as "Block Number",
TX_COUNT as "TX count",
date_trunc('day', block_timestamp) as "Day",
block_timestamp as "current block time",
lag(block_timestamp,1) over(order by block_number) as "previous block time",
DATEDIFF(second , "previous block time" , "current block time" ) as "Block Age"
from avalanche.core.fact_blocks
where block_timestamp::date >= '2022-01-01'
)
select
min("Block Age") as "Min Block Time",
max("Block Age") as "Max Block Time",
avg("Block Age") as "Average Block Time",
round(min("TX count"),2) as "Min TX count per block",
round(max("TX count"),2) as "Max TX count per block",
round(avg("TX count"),2) as "Average TX count per block"
from blocktage_diff
where "Block Age" is not null -- first row have null age becuse we don't have prev
Last run: about 1 year agoAuto-refreshes every 24 hours
1
31B
15s