potmoChain compare max single block
    Updated 22 hours ago
    with arbitrum_block_data as (
    select date_trunc('hour',block_timestamp) as hr,
    count(*)/ 3600.0 as blocks_per_second,
    max(tx_count) as max_txs,
    max_txs * blocks_per_second as max_tps
    from arbitrum.core.fact_blocks
    group by 1
    ),
    arbitrum_single_block_max_tps as (
    select 'arbitrum' as chain,
    round(max(max_tps),1) as maximum_single_block_tps
    from arbitrum_block_data
    ),

    avalanche_block_data as (
    select date_trunc('hour',block_timestamp) as hr,
    count(*)/ 3600.0 as blocks_per_second,
    max(tx_count) as max_txs,
    max_txs * blocks_per_second as max_tps
    from avalanche.core.fact_blocks
    group by 1
    ),
    avalanche_single_block_max_tps as (
    select 'avalanche' as chain,
    round(max(max_tps),1) as maximum_single_block_tps
    from avalanche_block_data
    ),

    base_block_data as (
    select date_trunc('hour',block_timestamp) as hr,
    count(*)/ 3600.0 as blocks_per_second,
    max(tx_count) as max_txs,
    max_txs * blocks_per_second as max_tps
    from base.core.fact_blocks
    group by 1
    ),
    Last run: about 22 hours agoAuto-refreshes every 12 hours
    CHAIN
    MAXIMUM_SINGLE_BLOCK_TPS
    1
    monad9886.1
    2
    arbitrum4034.9
    3
    bsc2097.9
    4
    base930
    5
    polygon660.8
    6
    optimism588
    7
    avalanche518.2
    8
    ethereum125.9
    8
    140B
    199s