ArioKaia Blocks Overview
Updated 2025-02-09
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
›
⌄
SELECT
AVG(
TIMEDIFF(SECOND, BLOCK_TIMESTAMP, NEXT_BLOCK_TIMESTAMP)
) AS "AVG Block Time",
AVG(
TX_COUNT / TIMESTAMPDIFF(SECOND, BLOCK_TIMESTAMP, next_block_timestamp)
) AS "AVG TPS",
MAX(
TX_COUNT / TIMESTAMPDIFF(SECOND, BLOCK_TIMESTAMP, next_block_timestamp)
) AS "MAX TPS",
AVG(tx_count) AS "AVG TPB",
AVG((GAS_USED / GAS_LIMIT) * 100) AS "AVG % of Block Utilization",
COUNT(HASH) / (
SELECT
TIMEDIFF(
SECOND,
MIN(BLOCK_TIMESTAMP),
MAX(BLOCK_TIMESTAMP)
) AS total_block_time_seconds
FROM
kaia.core.fact_blocks
) AS "Block Rate per second"
from
(
SELECT
BLOCK_TIMESTAMP,
HASH,
TX_COUNT,
GAS_USED,
GAS_LIMIT,
BLOCK_NUMBER,
LEAD(BLOCK_TIMESTAMP) OVER (
ORDER BY
BLOCK_NUMBER
) AS NEXT_BLOCK_TIMESTAMP
FROM
QueryRunArchived: QueryRun has been archived