hess2. TPS Daily
    Updated 2025-05-01
    with mezo AS (select block_timestamp,
    tx_hash
    from mezo.testnet.fact_transactions
    where TX_SUCCEEDED = 'TRUE'
    )
    ,
    txns as (select trunc(block_timestamp,'second') as seconds,
    count(DISTINCT tx_hash) as txns
    from mezo
    group by 1
    )

    select seconds::date as date,
    avg(txns) as "Avg TPS",
    median(txns) as "Median TPS",
    max(txns) as "Max TPS"
    from txns
    group by 1
    order by 1 asc



    Last run: 21 days ago
    DATE
    Avg TPS
    Median TPS
    Max TPS
    1
    2025-03-29 00:00:00.0001.43261117
    2
    2025-03-30 00:00:00.0001.73434219
    3
    2025-03-31 00:00:00.0001.0479713
    4
    2025-04-01 00:00:00.0001.10131713
    5
    2025-04-02 00:00:00.0001.12648716
    6
    2025-04-03 00:00:00.0001.10691215
    7
    2025-04-04 00:00:00.0001.0905614
    8
    2025-04-05 00:00:00.0001.115049111
    9
    2025-04-06 00:00:00.0001.10247515
    10
    2025-04-07 00:00:00.0001.11753110
    11
    2025-04-08 00:00:00.0001.520067112
    12
    2025-04-09 00:00:00.0001.472756121
    13
    2025-04-10 00:00:00.0001.433516114
    14
    2025-04-11 00:00:00.0001.308203114
    15
    2025-04-12 00:00:00.0001.514829126
    16
    2025-04-13 00:00:00.0001.327824110
    17
    2025-04-14 00:00:00.0001.550713122
    18
    2025-04-15 00:00:00.0001.477877126
    19
    2025-04-16 00:00:00.0001.546684124
    20
    2025-04-17 00:00:00.0001.610114126
    34
    1KB
    3s