LTirrell2022-02-18_solana_TPS_p3
Updated 2022-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- Solana TPS
-- One of Solana's main features is its speed compared to other blockchains. Blockchain performance is usually measured in Transactions per Second (TPS). Measure the TPS of Solana in February (non votes) and 'Successful TPS' per day and create a chart showing how TPS has fluctuated during that time period.
-- Sample Query: Select block_timestamp::date as date, count(_________) From solana.transactions Where block_timestamp::date >='2022-02-01' Group by date
select
date_trunc('second', block_timestamp) as datetime,
count(
case
when succeeded = 'TRUE' then succeeded
else NULL
end
) as success,
count(tx_id) as tx_count,
tx_count - success as fails,
success / (tx_count) as success_rate
from
solana.transactions
where
block_timestamp :: date >= '2022-02-15'
group by
datetime
order by
datetime
Run a query to Download Data