mo115OSMOSIS Performance - Average
Updated 2022-07-21
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_id))/1440 as tx_per_sec ,
TX_STATUS
from osmosis.core.fact_transactions
where date > CURRENT_DATE - 60
and TX_STATUS='SUCCEEDED'
group by 1,3),
B as(select date_trunc('day',BLOCK_TIMESTAMP) as date , (count(TX_id))/1440 as tx_per_sec ,
TX_STATUS
from osmosis.core.fact_transactions
where date > CURRENT_DATE - 60
and TX_STATUS='FAILED'
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
Run a query to Download Data