Terra - 3. Terradash Part 1: Activity

create a dashboard that displays the following metrics. Identify any trends or outliers that you see. Transactions, Average Transaction Fee per txn per week, Total Transaction Fees per week, Total number of transactions per week, Average transactions per second (TPS) per week, Average block time per week, Wallets, Total number of new wallets per week, Total number of active wallets per week, Only include senders who initiate transactions, Cumulative number of new wallets per week.

Overview

In this dashboard, I tracked the Terra activity as below steps:

1. Calculating the average transaction fee per transaction per week.

Computing the total and cumulative transaction fees per week.
Counting The total number of weekly transactions.
Calculating the total, cumulative, and average weekly active users.
Measuring The TPS and Block lag times.

Methodology

For doing this bounty, I used the below tables:

terra.core.fact_transactions: For calculating the number of transactions, active users, transaction fees, and TPS.

terra.core.fact_blocks: For measuring the lag time between blocks.

Transaction Fee

The following area chart shows the average transaction fee per transaction per week since May 2022. During this period, the first week of May, with 0.2 $LUNA, had the highest average transaction fee per transaction. The Major trend was descending, but from Sep to Oct, we saw the average weekly transaction fee increase.

The bar and line chart below shows the total and cumulative transaction fees per week since May 2022. In this period, nearly 141k $LUNA was consumed as transaction fees. The first week of May, with 20K $LUNA, the highest fees have been paid to the ecosystem.

Transactions

The following chart shows the total number of weekly transactions since May 2022. In this period, 1.67M transactions occurred, and The week ending May 30 with 181K transactions had the most transactions. The primary trend is descending, as in the previous charts, but since December, the rate of transactions has increased slightly.

Active Users

In this dashboard, we assumed that users with at least one transaction are considered active users. The following chart shows the total, cumulative, and average weekly active users since May 2022. In this period, 436K unique and active wallets were counted. The highest number of users, nearly 76K, were added to the terra network in the week ending May 30. The rate of adding users decreased in this period, and we saw a temporary increase in the first week of September. On average, 15K active users are added to the terra network weekly.

TPS

The following area chart shows the average TPS per week since May 2022. In this period, the average TPS was between 3 and 17. This range of TPS is so low and shows the need for users to use Terra rather than the network capability to process the transactions.

Block Performance

The following line chart shows the weekly average lag time between blocks since May 2022. In this period, the average lag time was between 5.92 to 6,09. The lag time trend was ascending from May to Sep, but after Sep, the trend changed its direction. The below line charts show the minimum and maximum lag time between blocks in this period. From May to Jul, the min lag time was 5s, then decreased to 1s and became stable. For the max lag time, we saw two outliers. The first one was may, with a 284s lag, and the second one was Jul, with a 609s delay. Mostly the max lag time was 11s.

Insights:

In this period, there was no excellent tendency for users to use the Terra network, I think most users don’t believe in Terra anymore, and the roots of fear were planted in their minds.
In terms of Fees, Terra is still a low-cost blockchain.
In terms of Block performance, Terra is very poor because the average lag time between blocks is too high, and its TPS is very low.

flipside