TOTAL_TRANSACTIONS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | TOTAL_OPERATIONS | |
|---|---|---|---|---|
1 | 1719976234 | 673519836 | 1046456398 | 3782086579 |
permaryscientific-red
Updated 7 days ago
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
count(*) as total_transactions,
sum(case when successful then 1 else 0 end) as successful_transactions,
sum(case when not successful then 1 else 0 end) as failed_transactions,
sum(operation_count) as total_operations
from stellar.core.fact_transactions
where closed_at >= date_trunc('month', current_date) - interval '12 months'
Last run: 7 days ago
1
46B
47s