Overview

In this dashboard we wanna see and compare some data about blocks in Polygon vs L1s and L2s

In this case we wanna find out :

• What was the minimum,average and maximum recorded time between two blocks in Polygon,Flow,Solana,Arbitrum,Optimism?
• How many transactions are done in a block on average in Polygon,Flow,Solana,Arbitrum,Optimism?

Analyze

First i used fact_blocks table in all chains and by using lag function showed block_timestamp of two blocks(second after once) in two columns side by side then used datediff function to get time-gap between two blocks , and also got number of transactions in a blocks in each chain

P.S : Because new tables not cover all time i consider after '2022-06-07' as time frame to have good comparison between chains

In below you can see min,average,max time difference between two blocks in Polygon,Flow,Solana

In below you can see min,average,max time difference between two blocks in Polygon,Arbitrum,Optimism

In below you can see average transactions in a block in Polygon,Flow,Solana,Arbitrum,Optimism

Results and conclusion

• Min and average time between blocks in Polygon were a little more than Flow and Solana but max time-gap between two blocks in Flow and Solana were much higher than Polygon and it shows there were some congestion occurred in Solana and Flow but Polygon condition was better

• Average time-gap between two blocks in Polygon was much lower than Arbitrum and Optimism

• Average transactions in a block in Polygon much higher than Flow,Arbitrum,Optimism but still much lower than Solana

Base of all data we saw in charts in my opinion Polygon Block Performance is in a good shape , average number transactions in a block are good and also average time-gap between two blocks is low and most of time was stable