nitsTransaction Failure
Updated 2022-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT day,
count(*)as total_txs,
sum(tx_status_int) as success_txs,
total_txs-success_txs as failed_txs,
failed_txs/success_txs*100 as percent_failed_to_sucess,
failed_txs/total_txs*100 as percent_failed_to_total,
SUM(failed_txs) OVER(ORDER BY DAY) AS Cumulative_failed_txs,
sum(total_txs) over(order by day)as cumulative_total_Txs,
sum(success_txs) over (order by day) as cumulative_success_txs,
Cumulative_failed_txs/Cumulative_success_txs*100 as Cumulative_percent_failed_to_sucess_txs,
Cumulative_failed_txs/Cumulative_total_txs*100 as Cumulative_percent_failed_to_total_txs
from
(SELECT *,date(block_timestamp) as day, case when TX_STATUS = 'SUCCEEDED' then 1 else 0 end as tx_status_int
from terra.msgs
where day > CURRENT_DATE -210 )
GROUP by 1
order by 1
Run a query to Download Data