AVG TPS | MAX TPS | |
|---|---|---|
1 | 157.683487501945 | 7653 |
Mrftitechnological-violet copy
Updated 17 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
-- forked from technological-violet @ https://flipsidecrypto.xyz/studio/queries/2a92b40c-b035-499d-8b5c-874cb5936f73
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' --all time
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 17 hours agoAuto-refreshes every 12 hours
1
25B
551s