kaibladeAverage TPS Per Month
Updated 2022-07-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH daily_tps AS
(SELECT DATE_TRUNC('day', block_timestamp) AS days, COUNT(tx_id)/86400 AS TPS
FROM
solana.core.fact_transactions
WHERE block_timestamp >= '2022-01-01 00:00:00.000'
-- AND '2022-03-01 00:00:00.000'
GROUP BY days
ORDER BY days)
SELECT DATE_TRUNC('month', days) AS months, AVG(TPS) AS TPS_per_month
FROM
daily_tps
GROUP BY months
ORDER BY months
Run a query to Download Data