The aim of this dashboard is to answer the following questions:

• How much gas was used by delegates voting in Aave in the past 90 days? In the past 180?
• How much gas on average is spent by voters in a single vote?

Below are the processes involved in obtaining the data used to create this dashboard:

1. Vote delegatees were extracted from the ethereum.core.ez_decoded_event_logs table by using the event_name DelegateChanged , along with interactions with AAVE and STKAAVE token contract addresses in the past 90 and 180 days. The resulting generated table was put in a CTE.
2. Next, vote transactions in the past 90 and 180 days associated with the ethereum.core.ez_decoded_event_logs table with the gathered vote delegatees were extracted by finding interactions with the AAVE governance v2 contract address using the VoteEmitted event.
3. The CTE containing the resulting table above was joined with the ethereum.core.fact_transactions table to get the gas used for each vote transaction. The resulting table is then contained in another CTE.
4. Finally, joining the CTE above with a CTE containing registered ENS domain names obtained by using the ETHRegistrarController contract address and the NameRegistered event. This is to enable the vote delegatee addresses to be more readable.
5. Queries required to answer the questions were generated using the CTEs created above.

The two charts (that is, the past 90 days and the past 180 days) above show a strong correlation between gas usage and the number of votes. This means gas usage depends heavily on the number of votes.

In both charts above, it can be observed that the vote type that consumed the most gas are Support For votes, only a tiny amount of gas was consumed by Support Against votes. It can also be observed that the 90 days chart that fewer Support For votes than 180 days chart. This observation is reflected in the single number stats just below them, where, the percentage of Support For (Approve) votes is slightly higher in the past 90 days than in the past 180 days.

The Donuts above depicts the top 5 vote delegatees with the highest gas usage amount in the past 90 days and 180 days respectively. gotoalaska.eth dominates in the 90 days donut, while franklindao.eth dominates in the 180 days dominates.

Now, to answer one of the questions, the total gas used by vote delegatees in the past 90 days is 38.9 million units, while the total gas used by vote delegates in the past 180 days is 123.1 million units, these stats are shown above. In other words, in double the duration, the total gas units used in the past 180 days is about 3 times the total gas units used in the past 90 days. Since the amount of gas used strongly correlates with the number of votes, it also means the total number of votes cast in the past 180 days should be 3 times more than the total number of votes cast in the past 90 days.

From the stats above, it can be seen that the average gas used per day in the past 90 days is much lower than the average gas used per day in the past 180 days. However, the opposite can be observed in the average gas used per delegate, where the value in the past 90 days is higher than the value in the past 180 days. This indicates delegatees voted more on average in the past 90 days than in the past 180 days.

To answer the second question, on average in the last 90 days, about 99,100 units of gas were spent by delegates on average on a single vote, while about 97,600 units of gas were spent by delegates on average in the last 180 days.