Introduction

SushiSwap is an automated market-making (AMM) decentralized exchange (DEX). In addition to DEX, SushiSwap involves a collection of governance, Lending, borrowing, operations, and reward contracts that help grow the SushiSwap ecosystem and utilization.

In this dashboard, we see Which user action results in the highest rate of failed transactions?

Method

The highest rate of failed transactions was found using ethereum.core.fact_transactions for all actions (swapping, borrowing, lending, and adding or removing liquidity).

To find the appropriate data for each action, we define a condition:

• adding or removing liquidity: TO_ADDRESS IN (SELECT pool_address FROM ethereum.core.dim_dex_liquidity_pools WHERE platform = 'sushiswap')

• swapping: ORIGIN_FUNCTION_SIGNATURE in (select ORIGIN_FUNCTION_SIGNATURE from ethereum.sushi.ez_swaps)

• lending: ORIGIN_FUNCTION_SIGNATURE in (select ORIGIN_FUNCTION_SIGNATURE from ethereum.sushi.ez_lending)

• borrowing: ORIGIN_FUNCTION_SIGNATURE in (select ORIGIN_FUNCTION_SIGNATURE from ethereum.sushi.ez_borrowing)

  The year 2022 has been selected for analysis.

Results

During this part, we visualized the results and explained more about the method of analysis.

The following charts show the total, success, and, failed transactions for each action.

In all three charts, swapping has the highest amount.

It is noticeable that there are a large number of failed transactions for borrowing.

MEV bots have a huge role in failed transactions.

The following charts show the percentage of failed transactions, success transactions fee, and, failed transactions fee for each action.

Borrowing has the highest failure rate, as we mentioned above. The failure rate of borrowing transactions was 13 percent.

The failure rate of lending transactions was 3 percent.

The failure rate of swapping transactions was 2.6 percent.

The failure rate of add-remove liquidity transactions was 1.65 percent which is the lowest rate.

The following charts show the metrics on daily basis.

In the below charts, we see the uptick in the percentage rate of failed transactions chart belongs to the add or remove liquidity and borrowing.

Lending and swapping have a constant daily rate.

Top five addresses in each action

To find the appropriate data for this section, we consider addresses with more than 10 transactions.

the below charts and tables show the top 5 addresses with the highest number of failed transactions for swapping, borrowing, lending, and adding or removing liquidity.

Conclusion

During the year 2022:

• Borrowing has the highest failure rate.
• Lending and swapping have an almost constant daily rate of failed transactions.
• MEV bots have a huge role in failed transactions.
• swapping has the highest number of failed transactions.
• there are addresses with 100 percent of failed transactions, especially in add or remove liquidity action.