SalehNetwork Performance Dashboard-daily
Updated 2022-07-09Copy Reference Fork
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
›
⌄
with lst_last_month as (
select
date_trunc(day,block_timestamp)::date as date
,count(tx_id) as tx_count
,count(DISTINCT signers[0]) as wallets
,tx_count/86400 as TPS
from solana.core.fact_transactions
where block_timestamp::date>=CURRENT_DATE-30
and SUCCEEDED=true
group by 1
order by 1
)
, lst_before_month as (
select
date_trunc(day,block_timestamp)::date as date
,count(tx_id) as tx_count
,count(DISTINCT signers[0]) as wallets
,tx_count/86400 as TPS
from solana.core.fact_transactions
where block_timestamp::date>='2022-04-01' and block_timestamp::date<CURRENT_DATE-30
and SUCCEEDED=true
group by 1
order by 1
)
select 'During_the_year' as type,* from lst_before_month
union all
select 'Last_month' as type,* from lst_last_month
Run a query to Download Data