feyikemiKaia TPS
Updated 2024-10-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
WITH tb1 AS(
SELECT
count(distinct tx_hash) AS transactions
FROM
kaia.core.fact_transactions
WHERE
block_timestamp > trunc(current_date, 'month')
AND tx_succeeded = 'True'
)
SELECT
AVG(transactions / 86400) AS TPS
FROM tb1
QueryRunArchived: QueryRun has been archived