Introduction

Ethereum is moving to a consensus mechanism called the ( PoS ) participation test from the test work ( PoW ). This has always been the plan, as it is a key part of the community's strategy to scale Ethereum through the updates. However, getting a correct PoS is a great technical challenge and it is not as simple as using PoW to reach consensus across the network. Link

Method

At first, I used the ethereum.core.fact_blocks table and found the daily transaction count since "2022-08-01" to date (2022-09-17, the date of making the dashboard) and the daily count of unique miners per day. Nonetheless, I was unable to make any sense of it that what exactly happened. So I used my previous dashboard to categorize miners to certain miners preferred mining blocks with a lower or higher transaction count, and I tracked their behavior before and after the merge. also all miners who did not fall into those categories. I separated the merge event by block number: 15,537,351. That was the number of the merge event block.

As of my previous dashboard, I categorized miners into those who had mining blocks with more than 50 transactions as miners that only mine the blocks with a high transaction count, those with fewer than 50 transactions as miners that prefer mining blocks with a lower transaction count, and the rest of all miners who were not in these two categories as others. then tried to find which of these miners have had mining transaction after the merge event. 

Finally, I found miners that hadn’t had mining transactions before the merge block number.

Analysis

Daily count of mining transactions and unique miners

✍🏻 Conclusion

• In this dashboard, I tried to find the behavior of miners from some weeks before the merge event to date (2022-09-17).
• I found that most miners that have been categorized as preferring to mine the blocks with the lowest transactions haven’t tended to mine the blocks after the merge event.
• But miners that prefer to mine the blocks with more than 50 transactions per block already continue to do so as before the merge.
• Also, a large number of new unique miners have joined the Ethereum mainnet; less than 1% of them are organizational addresses.
• I couldn’t saw the significant changes in the daily count of miners in some few weeks before the merge.

About:

• Author: HaM☰d

  \

• Discord: 0xHaM☰d#8391

  \

• Twitter: @arjmandi_hamed

  \

• Email: h_arjmandi2012@yahoo.com

Miners Moving?

How have miners reacted to the fast-approaching merge?

Have they stopped mining in recent weeks? Show evidence of miners either stopping work or continuing to mine.

Image

Hey there 👋!

Firstly, I appreciate you sticking with it until the conclusion.

I’m Hamed, Ph.D. In Civil Engineering and interested in data science.

I've made many similar dashboards and visualizations since I started at Flipside in January.

Please have a look at my various contact information and let me know what you think.

🔭 Findings:

In the first two charts on the right side, the daily count of transactions and unique miners were categorized by the number of the merge event block.

As we see, the daily count of transactions after the merge event was raised, and the daily count of unique users has significantly increased. ==But in my opinion, this doesn't make sense.==

So in the next two bar charts, I included miners just to who had mining transactions before the merge event.

I found that after the merge the count of mining transactions and unique miners significantly decreased.

What?! wait a minute, its clearly in contrast with first two charts, what’s happened?!

Its complicated, I completely confused :confused:

Since I had to used the mentioned categorized in methodology as of my previous dashboard. I found that miners who identified as miners prefer mining blocks with lower transaction count had lowest mining transactions count after the merge event and miners only mine blocks with high transaction count plus all rest of miners had most mining transactions count after the merge.

🔭 Findings:

I finally discovered the miners who had mining transactions after the merge but had no mining transactions prior to the event.

I separated them by the merge block number. (15,537,351)

So, I found that less than 1% of these miner addresses are belongs to Celsius network, Gnosis safe, cream finance, ico-wallets and gemini, and rest of them are all unknown.

More than 52% of known mining transactions were belongs to Celsius network that followed by Gnosis safe with 40% of transactions count.