princefarzamThe performance of NEAR protocol since Sep 2021
Updated 2022-07-20
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
›
⌄
WITH TPM AS (
SELECT
DATE_TRUNC('DAY',block_timestamp)::DATE AS DAY,
COUNT(TXN_HASH) AS NUMBER_OF_TRANSACTIONS,
NUMBER_OF_TRANSACTIONS/1440 AS TRANSACTIONS_PER_MINUTE
FROM flipside_prod_db.mdao_near.transactions
WHERE substr(tx_receipt[0]:outcome:status,3,7)::string='Success'
GROUP BY DAY
ORDER BY DAY ASC
)
SELECT
(SELECT
COUNT(DISTINCT TXN_HASH) as Number_of_all_txns
FROM flipside_prod_db.mdao_near.transactions) AS Number_of_all_txns,
(SELECT
COUNT(substr(tx_receipt[0]:outcome:status,3,7)) as Number_of_success_txns
FROM flipside_prod_db.mdao_near.transactions
WHERE substr(tx_receipt[0]:outcome:status,3,7)::string='Success') AS Number_of_success_txns,
(SELECT
COUNT(substr(tx_receipt[0]:outcome:status,3,7)) as Number_of_fail_txns
FROM flipside_prod_db.mdao_near.transactions
WHERE substr(tx_receipt[0]:outcome:status,3,7)::string='Failure') AS Number_of_fail_txns,
(Number_of_success_txns/Number_of_all_txns)*100 AS Percentage_of_success_txns,
(Number_of_fail_txns/Number_of_all_txns)*100 AS Percentage_of_fail_txns,
AVG(NUMBER_OF_TRANSACTIONS) AS Average_Daily_txns,
AVG(TRANSACTIONS_PER_MINUTE) AS Average_TPM
FROM TPM
Run a query to Download Data