> Getting to know Ethereum merge

• The merger stage can be considered the next and important step of the management team of the Ethereum network in the evolution of this popular network.
• In this upcoming event, we will see the integration of the existing execution layer with the recently deployed consensus layer called Beacon Chain, and during this major update, the Proof of Work (PoW) consensus algorithm will be changed to the Proof of Stake (PoS) consensus, but However, the main status of the Ethereum network and its native coin, Ether, is still maintained.

Advantages of ethereum merge

• In general, the purpose of implementing the Ethereum merge update is to significantly improve the performance of the Ethereum network by eliminating the need for extraction and mining that consume significant energy and cost a lot.

> method

• Check blocks and transactions before and after merge
• Using ethereum.core.fact_blocks and ethereum.core.fact_transactions table
• Choose a 20-day period to compare 10 days after the merger and 10 days before the merge
• Using the case when function

> Review of unique miners ten days before and after merge

This graph shows the number of unique miners and it shows that after the merge happened, the number suddenly increased by about 10 times, and it can be said that the most changes after the merge in the blocks section are related to this section.

To make a transaction, the user first specifies the gas limit. Gas limit is the maximum amount of gas that the sender is willing to pay to process his transaction, and when we talk about gas alone, it means the same gas limit, and we do not see any changes in these charts, and before and after merge No specific change has occurred

Blocks are the main part of blockchain technology. They can be considered the pages of the distributed ledger of the blockchain. Each block contains information such as transactions made on the blockchain platform, which include: the time of the transaction, the public address of the sender and the public address of the receiver, its own hash and the hash of the previous block.

All this information is permanently stored on the blocks and cannot be changed or deleted in any way. This feature is created by the network encryption system in blocks. In this chart, it goes through a constant trend before the merge, but after that we see a slight increase

The size of each block in the blockchain can potentially have a great impact on the speed and capacity of the network. In this graph, we can see a very small increase in its value after the merge compared to before the merge.

By looking at this graph, which examines the number of transactions in this 20-day period, we understand that the number of transactions has increased slightly when approaching the merge time, as well as the first 3 days after that.

Every transaction that occurs in the blockchain system has a unique identifier. This identifier is called transaction hash or Tx Hash. Tx Hash is actually a sequential and random set of numbers, letters and characters.

Transaction Hash, which is also known by other names such as transaction ID, transaction hash, or Transaction ID, is actually a code that contains specific information about the transaction. In this graph, the number of Tx Hashs has increased slightly when approaching the merge time and also in the early days.

In this graph, as in the previous graph, the number of users has increased during the period when the merge happened, with the difference that there was a significant jump on 2022-09-17 and it jumped up to 562k.

Examining the average gas chart, we come to the conclusion that, unlike the transaction charts, as the merge time approaches and in the early days after that, this time, the low gas amount is ready.

Examining the two graphs above, which represent transaction fees, the effect of merge in lowering the amount of transaction fee during the execution of merge and the time after that is clearly evident

> Conclusion

> - [ ] After the merger > - [ ] 10 times increase of unique miners > - [ ] Slight increase in block_numbers > - [ ] Not changing gas_limits > - [ ] Increase in transactions when approaching the merger > - [ ] Reduction of transaction fees when approaching the merger

> source

In some cases inspired by

> blocks

> Review block_numbers ten days before and after the merger

> Checking the avg_gas limit ten days before and after the merger

> Checking avg _size ten days before and after the merge

> Checking the avg _tax_count ten days before and after the merger

> Transactions

> Checking the unique tx_hashes ten days before and after the merge

> Review users ten days before and after integration

> Checking gas_used ten days before and 10 days after merge

> Check the transaction fees ten days before and 10 days after the merge