AVG TPS | MAX TPS | |
|---|---|---|
1 | 160.010942253705 | 7653 |
Mrftitechnological-violet
Updated 10 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH block_data AS (
SELECT
block_timestamp,
count(DISTINCT tx_hash) as tx_count,
LEAD(block_timestamp) OVER (ORDER BY block_timestamp) as next_block_timestamp
FROM
monad.testnet.fact_transactions
where block_timestamp > '2025-02-19 15:00:00.000'
GROUP BY
block_timestamp
)
SELECT
AVG(tx_count / NULLIF(DATEDIFF('second', block_timestamp, next_block_timestamp), 0)) AS "AVG TPS",
MAX(tx_count / NULLIF(DATEDIFF('second', block_timestamp, next_block_timestamp), 0)) AS "MAX TPS"
FROM
block_data
WHERE
next_block_timestamp IS NOT NULL
Last run: about 10 hours agoAuto-refreshes every 12 hours
1
25B
236s