HOUR | TOTAL_TRANSACTIONS | SUCCESSFUL | FAILED | SUCCESS_RATE_PERCENTAGE | |
|---|---|---|---|---|---|
1 | 2025-02-19 00:00:00.000 | 310 | 304 | 6 | 98.06 |
2 | 2025-02-19 01:00:00.000 | 122323 | 122319 | 4 | 100 |
3 | 2025-02-19 02:00:00.000 | 74288 | 74283 | 5 | 99.99 |
4 | 2025-02-19 03:00:00.000 | 1489 | 1483 | 6 | 99.6 |
5 | 2025-02-19 04:00:00.000 | 71385 | 71379 | 6 | 99.99 |
6 | 2025-02-19 05:00:00.000 | 117384 | 117377 | 7 | 99.99 |
7 | 2025-02-19 06:00:00.000 | 3942 | 3936 | 6 | 99.85 |
8 | 2025-02-19 07:00:00.000 | 4050 | 4034 | 16 | 99.6 |
9 | 2025-02-19 08:00:00.000 | 3797 | 3796 | 1 | 99.97 |
10 | 2025-02-19 09:00:00.000 | 3028 | 2999 | 29 | 99.04 |
11 | 2025-02-19 10:00:00.000 | 4023 | 3974 | 49 | 98.78 |
12 | 2025-02-19 11:00:00.000 | 3353 | 3300 | 53 | 98.42 |
13 | 2025-02-19 12:00:00.000 | 4488 | 4358 | 130 | 97.1 |
14 | 2025-02-19 13:00:00.000 | 12489 | 12365 | 124 | 99.01 |
15 | 2025-02-19 14:00:00.000 | 23759 | 23530 | 229 | 99.04 |
16 | 2025-02-19 15:00:00.000 | 72498 | 66512 | 5986 | 91.74 |
17 | 2025-02-19 16:00:00.000 | 65929 | 58491 | 7438 | 88.72 |
18 | 2025-02-19 17:00:00.000 | 90297 | 89031 | 1266 | 98.6 |
19 | 2025-02-19 18:00:00.000 | 108641 | 106746 | 1895 | 98.26 |
20 | 2025-02-19 19:00:00.000 | 82510 | 81214 | 1296 | 98.43 |
Kruys-Collinsstandard-rose
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('hour', block_timestamp) AS hour,
COUNT(*) AS total_transactions,
COUNT(CASE WHEN tx_succeeded = TRUE THEN 1 END) AS successful,
COUNT(CASE WHEN tx_succeeded = FALSE THEN 1 END) AS failed,
ROUND(
COUNT(CASE WHEN tx_succeeded = TRUE THEN 1 END)::FLOAT /
NULLIF(COUNT(*), 0) * 100, 2
) AS success_rate_percentage
FROM monad.testnet.fact_transactions
WHERE block_timestamp >= '2025-02-19'
GROUP BY hour
ORDER BY hour;
Last run: 23 days ago
46
2KB
2s