AVG_LEDGER_TIME_SECONDS | TOTAL_OPERATIONS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | SUCCESS_RATE_PERCENTAGE | TOTAL_ACCOUNTS | |
|---|---|---|---|---|---|---|
1 | 5.838765 | 4182299 | 1750414 | 2113248 | 45.3 | 4394925 |
permaryrotten-lavender
Updated 2025-02-19
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
›
⌄
⌄
WITH ledger_times AS (
SELECT
DATEDIFF('second', LAG(closed_at) OVER (ORDER BY sequence), closed_at) as time_diff,
sequence,
closed_at,
operation_count,
successful_transaction_count,
failed_transaction_count
FROM stellar.core.fact_ledgers
WHERE closed_at >= DATEADD(hour, -24, CURRENT_TIMESTAMP())
),
account_count AS (
SELECT COUNT(*) as total_accounts
FROM stellar.core.fact_accounts
WHERE block_timestamp >= DATEADD(hour, -24, CURRENT_TIMESTAMP())
)
SELECT
AVG(time_diff) as avg_ledger_time_seconds,
SUM(operation_count) as total_operations,
SUM(successful_transaction_count) as successful_transactions,
SUM(failed_transaction_count) as failed_transactions,
ROUND(SUM(successful_transaction_count) * 100.0 / NULLIF(SUM(successful_transaction_count + failed_transaction_count), 0), 2) as success_rate_percentage,
(SELECT total_accounts FROM account_count) as total_accounts
FROM ledger_times;
SELECT COUNT(DISTINCT account) AS unique_accounts
FROM stellar.core.fact_ledgers
WHERE closed_at >= '2025-01-01'
AND closed_at < '2025-03-01';
Last run: 27 days ago
1
49B
2s