piperSolana - Network Performance Dashboard: Failed/Success Tx
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 part1 AS (
SELECT
block_timestamp::date AS date,
succeeded,
COUNT(tx_id) AS number_of_transactions
FROM
solana.core.fact_events
WHERE
block_timestamp BETWEEN '2022-01-01' AND '2022-04-30'
GROUP BY date, succeeded),
part2 AS (
SELECT
block_timestamp::date AS date,
succeeded,
COUNT(tx_id) AS number_of_transactions
FROM
solana.core.fact_events
WHERE
block_timestamp BETWEEN '2022-04-29' AND '2022-05-01'
GROUP BY date, succeeded),
Run a query to Download Data