princefarzamSolana TPS fluctuation
Updated 2022-02-23
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT DISTINCT
date_trunc('day',block_timestamp) AS DAY,
COUNT(tx_id) AS TXNS_COUNTER,
(TXNS_COUNTER/86400) - 120 AS TPS_fluctuation -- SECONDS IN ONE DAY: 1DAY*(24HR/1DAY)*(3600S/1HR)=86400S
--TXNS_COUNTER /22~=120 as AVG_TPS
FROM solana.events
WHERE block_timestamp::DATE >= '2022-02-01'
AND block_timestamp::DATE <= '2022-02-22'
AND SUCCEEDED = TRUE
AND INSTRUCTION:program <> 'vote' --Except for vote transactions
GROUP BY DAY
ORDER BY DAY ASC
Run a query to Download Data