KaskoazulSolana Successful TPS
Updated 2022-02-18
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH TPS AS (
SELECT
v.block_timestamp::date as FECHA,
--count(v.block_id) as Blocks_per_day,
sum(v.num_votes) as Total_Vote_tx_per_day,
sum(b.tx_count) as Total_tx_per_day,
(Total_tx_per_day-Total_Vote_tx_per_day)/(24*60*60) as Average_TPS_Non_votes_per_day,
Total_Vote_tx_per_day/(24*60*60) as Average_TPS_Votes_per_day
FROM
solana.votes_block_agg v
INNER JOIN solana.blocks b
ON v.block_id=b.block_id
WHERE
v.block_timestamp >= '2022-02-01'
AND v.block_timestamp < '2022-02-18'
GROUP BY 1
ORDER BY 1
),
Successful_TPS AS (
SELECT
block_timestamp::date as FECHA,
count(tx_id) as Succesful_tx_per_day,
Succesful_tx_per_day/(24*60*60) as Average_successful_TPS_per_day
FROM
solana.transactions
WHERE
FECHA >= '2022-02-01'
AND FECHA < '2022-02-18'
AND succeeded = 'TRUE'
GROUP BY 1
)
SELECT
s.FECHA,
t.Average_TPS_Non_votes_per_day,
Run a query to Download Data