potmoCross Chain Theoretical TPS Comparison
    Updated 2025-03-09
    with polygon_theoretical_data as (
    select (select gas_limit
    from polygon.core.fact_blocks
    order by block_timestamp desc
    limit 1) as current_gas_limit,
    -- (select min(gas_used)
    -- from polygon.core.fact_transactions
    -- where gas_used > 0) as min_gas_used,
    21000 as min_gas_used,
    (select count(*)/(60 * 60 * 24)
    from polygon.core.fact_blocks
    where date(block_timestamp) = current_date -1) as blocks_per_second
    ),
    polygon_theoretical_max_tps as (
    select 'polygon' as chain,
    round((current_gas_limit/min_gas_used) * blocks_per_second) as theoretical_max_tps
    from polygon_theoretical_data
    ),

    bsc_theoretical_data as (
    select (select gas_limit
    from bsc.core.fact_blocks
    order by block_timestamp desc
    limit 1) as current_gas_limit,
    -- (select min(gas_used)
    -- from bsc.core.fact_transactions
    -- where gas_used > 0) as min_gas_used,
    21000 as min_gas_used,
    (select count(*)/(60 * 60 * 24)
    from bsc.core.fact_blocks
    where date(block_timestamp) = current_date -1) as blocks_per_second
    ),
    bsc_theoretical_max_tps as (
    select 'bsc' as chain,
    round((current_gas_limit/min_gas_used) * blocks_per_second) as theoretical_max_tps
    from bsc_theoretical_data
    Last run: about 2 months ago
    CHAIN
    THEORETICAL_MAX_TPS
    1
    arbitrum213807427252
    2
    monad14214
    3
    base2667
    4
    bsc2205
    5
    optimism1429
    6
    polygon659
    7
    avalanche389
    8
    ethereum142
    8
    139B
    23s