What is SushiSwap?

SushiSwap is a software application that runs on Ethereum similar to other platforms such as Uniswap and Balancer. Also, it seeks to incentivize users when they buy and sell their crypto assets in its platform This decentralized exchange helps traders to swap their SushiSwap token with another token.

Why do Transactions Fail?

Transaction failures may occur due to a number of different errors, including if transactions are signed by the wrong sender or if someone attempts to send negative funds or when there isn't enough gas to pay for a transaction, or when a smart contract rejects a transaction and etc… . User is still charged for failed transactions because miners need to confirm transactions to the chain whether they succeed or fail.

Methodology

In this dashboard, We are going to check the failure rate of Sushiswap transactions and also break down them by action type (Swap, Lending, Borrow, Add or Remove Liquidity).

The main table we are going to use to identify failed and successful transactions is **ethereum.core.fact_transactions. (**since there is no “tx_status” column in Sushi tables)

• For Swaps, Lendings and Borrow transactions we can extract their origin_function_signature from ethereum.sushi.ez_swaps , ethereum.sushi.ez_lending , ethereum.sushi.ez_borrowing tables and match them with transactions in ethereum.core.fact_transactions table.
• For Adding or Removing Liquidity, the source or the destination of transactions should be one of the Sushiswap liquidity pools. Pools address can be extracted from ethereum.core.dim_dex_liquidity_pools)

Overall

Breakdown by Action Type

According to the above data, the total average failure rate of transactions on Sushiswap is 3.1395% which is quite a low amount and a satisfying result.

on the right chart, we can see in the most number of days, the transactions failure rate on Sushiswap was less than 5% which is really good.

On the above chart, we can see the highest number of failed transactions on Sushiswap was occured during the first months (before the year 2017). After this date, we can see more stabilitiy in failure rate of transactions with few high spikes of failed transactions sometimes. We had also some increasing failure rate during June and July 2022.

On the above charts, we can see “Borrow” and “Lending” actions have the most failure rate among all actions on Sushiswap. Adding or Removing liquidity from Sushiswap have the least failure rate.

Moreover, on the right chart, we can see in the most number of days, failure rate was less than 5%. The interesting thing is that the number of days that Lending actions have high failed transactions is more than all other actions.

As mentioned above, the highest percentage of failed transactions was occured before the year 2017.

Before 2022, we can see most number of failed transactions was occured because of lendings on Sushiswap but after this timespan and especially during recent days, we can see the most number of failed transactions is because of Borrow actions on Sushiswap.

On the above monthly charts, we can see a more clear view of failed and successfull transactions on Sushiswap over time. During the first months (before 2017), despite there was low number of transactions executed on Sushiswap but there were high failure rate. We can see this problem has almost been solved over time to the extent that despite the high number of transactions in May and June 2022 (because of the crypto market crash thanks to the Terra project!), the failure rate of the transaction was not high as the first months before 2017.

Conclusion

• Sushiswap has an average 3.1395% failure rate which is quite low and satisfying result.
• On the most number of days, the average failure rate of transactions was less than 5%.
• Borrow and Lendings are the actions with the highest failed transactions while Adding and Removing Liquidity have the lowest failure rate.
• The number of days that Lending actions had high failed transactions is more than all other actions.
• There is a positive correlation between the number of transactions and the failure rate on Sushiswap.
• In recent days, there is an increasing trend of failed transactions especially because of Borrow actions.
• During the first month (before the year 2017), we had the highest transaction failure rate on Sushiswap but this problem has almost been solved over time.
• The years 2016 and 2022 have the highest transaction failure rate.
• Before 2022, the most number of failed transactions was because of Lending actions but in 2022, the number of failed transactions related to Borrow actions is way more than others.

Discord: Ali3N#8546

On the left chart, in an annualy timespan, we can see the years 2016 and 2022 have the highest transactions failure rate.

Before 2022, most number of failed transactions was because of Lending actions but in 2022, the share of Borrow actions is way more than others.