piperSolana - Network Performance Dashboard: TPS
Updated 2022-07-13
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
›
⌄
⌄
/*
Twitter: @der_piper
Discrod: piper#6707
Solana - Network Performance Dashboard
Q95. Create a dashboard displaying Solana network performance over time.
How has the network performed over the past month compared to the rest of the year?
Has transaction per second and success rates of transactions gone up recently? Is
this because of less botting or fewer users, or new improvements from the Solana
engineers? What wallets and programs have paid the most in fees for failed transactions?
*/
WITH success_tps AS (
SELECT
block_timestamp::date as date,
COUNT(tx_id)/86400 AS solana_tps,
'Successfull TX' AS type
FROM
solana.core.fact_transactions
WHERE
block_timestamp BETWEEN '2022-01-01' AND '2022-07-10'
AND
succeeded = 'True'
GROUP BY date
ORDER BY date ASC),
failed_tps AS (
SELECT
block_timestamp::date as date,
COUNT(tx_id)/86400 AS solana_tps,
'Failed TX' AS type
FROM
solana.core.fact_transactions
WHERE
Run a query to Download Data