mo115BSC Performance - Average
Updated 2024-08-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with C as (with A as(select date_trunc('day',BLOCK_TIMESTAMP) as date , (count(TX_HASH))/1440 as tx_per_sec ,
status
from bsc.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 bsc.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 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
)
select (sum(successful_tx_per_min)/count(successful_tx_per_min))as average_successful_tx_per_min,
(sum(failed_tx_per_min)/count(failed_tx_per_min))as average_failed_tx_per_min,
(sum(success_rate)/count(success_rate))as average_success_rate,(1-average_success_rate)as average_failure_rate
from C
QueryRunArchived: QueryRun has been archived