Introduction

With this dashboard we will be looking at :

• What is the average time between blocks on Polygon?

• What was the maximum and minimum recorded time between two blocks?

• How many transactions are done in a block on average? 

•  How do these numbers compare to L1 such as Flow or other L2 such as Optimism?

Conclusion

• Average time between blocks on Polygon in minute can go up to 15.75.
• Transactions done in a block on hourly average is above 50 transactions.
• Minimum recorded time between two blocks for Polygon is 2 second which is in the behind of Flow and Optimism.
• Polygon has the highest average transaction per block on hourly compared to Optimism and Flow.
• Polygon is doing a good job with handling transactions compared to Optimism and Flow but average time between blocks is little higher than Optimism and little bit Flow because their block time can go as high as 2k second if data on Flipside is correct.

• Maximum time recorded between two blocks on Polygon is 25 second , this time could be higher because

polygon.core.fact_blocks table only covers the data after ‘2022-06-06’

• Minimum time recorded between two blocks on Polygon is 2 second.

Average transactions done in a block is above 50 in the most of the time

Optimism leads the way with time between blocks.

On average time between two blocks On Flow is less than Polygon but Flow can have spikes like 2k seconds or 391 second.

Polygon leads the way in average transactions per block.

Methodology

• Data covers the date starts from ‘2022-06-06’.

• In this dashboard we only used this tables.

polygon.core.fact_blocks, optimism.core.fact_blocks,

flow.core.fact_blocks.

• To find the time between blocks we have used datediff

  (DATEDIFF(second, lag(date_polygon) ignore nulls over(ORDER BY date_polygon ASC),block_timestamp)

  \