tx Sucess rate % | |
|---|---|
1 | 93.4158 |
Mrfti2024-07-24 06:13 PM copy
Updated 2025-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with alltx AS
(
SELECT
count (DISTINCT tx_hash) as "Total Transaction"
from berachain.testnet.fact_transactions
)
, succeededtx AS
(
SELECT
count (DISTINCT tx_hash) as "Total Suceeded Transaction"
from berachain.testnet.fact_transactions
where TX_SUCCEEDED = 'TRUE'
)
SELECT
"Total Suceeded Transaction"/"Total Transaction"*100 as "tx Sucess rate %"
from alltx join succeededtx
Last run: 3 months ago
1
11B
368s