mo115Avalanche Performance
Updated 2024-08-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with A as(select date_trunc('day',BLOCK_TIMESTAMP) as date , (count(TX_HASH))/1440 as tx_per_sec ,
status
from avalanche.core.fact_transactions
where date > CURRENT_DATE - 60
and STATUS='SUCCESS'
group by 1,3),
B as(select date_trunc('day',BLOCK_TIMESTAMP) as date , (count(TX_HASH))/1440 as tx_per_sec ,
status
from avalanche.core.fact_transactions
where date > CURRENT_DATE - 60
and STATUS='FAIL'
group by 1,3)
select a.date, a.tx_per_sec as successful_tx_per_min , b.tx_per_sec*-1 as failed_tx_per_min,
(successful_tx_per_min)/(successful_tx_per_min-failed_tx_per_min) as success_rate
from A a inner join b B on a.date=b.date
QueryRunArchived: QueryRun has been archived