CryptoIcicleOsmo-6.Transaction Failures - Failed
Updated 2022-05-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- Transaction Failures
-- Q6. Establish the failed transaction rate for Osmosis over the last 4 months.
-- Make a case for what is causing the failed transaction rate that you assess and
-- provide recommendations to mitigate it.
-- Hint: Look at the msg_types of failed transactions to determine what type of transaction results
-- in the most failures.
-- Payout 29.76 OSMO
-- Grand Prize 89.29 OSMO
-- Level Beginner
select
t.block_timestamp::date as date,
m.msg_type,
count(m.tx_id) as n_txns
from osmosis.core.fact_transactions t join osmosis.core.fact_msg_attributes m on t.tx_id = m.tx_id
where t.block_timestamp > CURRENT_DATE - 120 and t.tx_status = 'FAILED'
group by date, t.tx_status, msg_type
Run a query to Download Data