TIMEFRAME | SUCCESS_RATE_PERCENTAGE | |
|---|---|---|
1 | A. Last 365 days | 89.38 |
2 | B. Last 180 days | 91.71 |
3 | C. Last 90 days | 92.73 |
4 | D. Last 30 days | 92.58 |
5 | E. Last 7 days | 92.66 |
6 | F. Last day | 91.62 |
HessishKPI - suc t
Updated 2025-05-15
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
›
⌄
WITH times AS (
SELECT
'F. Last day' AS timeframe,
COALESCE(
100.0 * SUM(CASE WHEN TX_SUCCEEDED = 'TRUE' THEN 1 ELSE 0 END) / NULLIF(COUNT(DISTINCT TX_HASH), 0),
0
) AS success_rate
FROM ton.core.fact_transactions
WHERE block_timestamp::date >= CURRENT_DATE - 1
UNION
SELECT
'E. Last 7 days' AS timeframe,
COALESCE(
100.0 * SUM(CASE WHEN TX_SUCCEEDED = 'TRUE' THEN 1 ELSE 0 END) / NULLIF(COUNT(DISTINCT TX_HASH), 0),
0
) AS success_rate
FROM ton.core.fact_transactions
WHERE block_timestamp::date >= CURRENT_DATE - 7
UNION
SELECT
'D. Last 30 days' AS timeframe,
COALESCE(
100.0 * SUM(CASE WHEN TX_SUCCEEDED = 'TRUE' THEN 1 ELSE 0 END) / NULLIF(COUNT(DISTINCT TX_HASH), 0),
0
) AS success_rate
FROM ton.core.fact_transactions
WHERE block_timestamp::date >= CURRENT_DATE - 30
UNION
Last run: 25 days ago
6
154B
265s