AVG TPS | MAX TPS | |
|---|---|---|
1 | 0.548654059376 | 11.5 |
Mrftigood-indigo copy
Updated 1 day 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
›
⌄
-- forked from good-indigo @ https://flipsidecrypto.xyz/studio/queries/9456a8bb-7c57-4c4f-9796-a8908ac7afc0
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
swell.core.fact_transactions
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: 1 day agoAuto-refreshes every 12 hours
1
23B
9s