Monad Metrics Guildtestnet-average-tps
    Updated 1 day ago
    with tps as (
    select
    date_trunc(second, block_timestamp) as sec
    , count(*) as txns
    from monad.testnet.fact_transactions
    where block_timestamp between date_trunc(hour, sysdate()) - interval '7 days' and (date_trunc(hour, sysdate() - interval '1 hour') - interval '1 second')
    and block_timestamp not between '2025-03-20 12:00:00' and '2025-03-20 15:00:00'
    group by 1
    )

    , seconds_table as (
    select dateadd(second, seq4(), date_trunc(hour, sysdate()) - interval '6 days') as sec
    from table(generator(rowcount => 6 * 24 * 60 * 60 - 3600))
    )

    , real_tps as (
    select
    sec
    , coalesce(txns, 0) as txns
    from seconds_table
    left join tps using(sec)
    where sec < date_trunc(hour, sysdate() - interval '1 hour')
    )

    select
    date_trunc(hour, sec) as hour_
    , median(txns) as median_tps
    , percentile_disc(0.95) within group (order by txns) as "95th percentile"
    , percentile_disc(0.05) within group (order by txns) as "5th percentile"
    -- , min(txns) as "Min TPS" useless since it's always 0 for now, every hour has at least 1 second with 0 txns
    , max(txns) as "Max TPS"
    from real_tps
    group by 1
    order by 1 desc

    Last run: about 6 hours agoAuto-refreshes every 12 hours
    HOUR_
    MEDIAN_TPS
    95th percentile
    5th percentile
    Max TPS
    1
    2025-04-11 13:00:00.00021354008617
    2
    2025-04-11 12:00:00.00019653307331
    3
    2025-04-11 11:00:00.00020037803610
    4
    2025-04-11 10:00:00.00021737205065
    5
    2025-04-11 09:00:00.000227469709208
    6
    2025-04-11 08:00:00.00022340505297
    7
    2025-04-11 07:00:00.00020734007040
    8
    2025-04-11 06:00:00.0002123120927
    9
    2025-04-11 05:00:00.00020030007597
    10
    2025-04-11 04:00:00.00019628366809
    11
    2025-04-11 03:00:00.00020032706915
    12
    2025-04-11 02:00:00.000195591010000
    13
    2025-04-11 01:00:00.0001571156010000
    14
    2025-04-11 00:00:00.00015225303367
    15
    2025-04-10 23:00:00.000144247343970
    16
    2025-04-10 22:00:00.0001221900563
    17
    2025-04-10 21:00:00.00012721201008
    18
    2025-04-10 20:00:00.00013733409085
    19
    2025-04-10 19:00:00.0001422260610
    20
    2025-04-10 18:00:00.00016524501470
    ...
    143
    6KB
    5s