DATE | DAILY_LEDGERS_PRODUCED | AVG_BLOCK_TIME_MINUTES | |
|---|---|---|---|
1 | 2025-03-13 00:00:00.000 | 9892 | 0.097037944298 |
2 | 2025-03-12 00:00:00.000 | 14859 | 0.096912016825 |
3 | 2025-03-11 00:00:00.000 | 14749 | 0.097633678961 |
4 | 2025-03-10 00:00:00.000 | 14558 | 0.098915794889 |
5 | 2025-03-09 00:00:00.000 | 14798 | 0.097310385525 |
6 | 2025-03-08 00:00:00.000 | 14895 | 0.096678904062 |
7 | 2025-03-07 00:00:00.000 | 14746 | 0.097651285366 |
8 | 2025-03-06 00:00:00.000 | 14793 | 0.097343275671 |
9 | 2025-03-05 00:00:00.000 | 14825 | 0.097135405329 |
10 | 2025-03-04 00:00:00.000 | 14886 | 0.096732877805 |
11 | 2025-03-03 00:00:00.000 | 14836 | 0.097062259099 |
12 | 2025-03-02 00:00:00.000 | 14684 | 0.098063603242 |
13 | 2025-03-01 00:00:00.000 | 14885 | 0.0967404956 |
14 | 2025-02-28 00:00:00.000 | 14727 | 0.097780665377 |
15 | 2025-02-27 00:00:00.000 | 14883 | 0.09675237526 |
16 | 2025-02-26 00:00:00.000 | 14770 | 0.097500504536 |
17 | 2025-02-25 00:00:00.000 | 14571 | 0.098821820808 |
18 | 2025-02-24 00:00:00.000 | 14745 | 0.097659035063 |
19 | 2025-02-23 00:00:00.000 | 14886 | 0.096738474271 |
20 | 2025-02-22 00:00:00.000 | 14853 | 0.09694667515 |
permaryDaily ledgers
Updated 7 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with ledger_times as (
select
date(closed_at) as date,
closed_at,
lead(closed_at) over (order by closed_at) as next_ledger_time
from stellar.core.fact_ledgers
)
select
date,
count(*) as daily_ledgers_produced,
avg(datediff(second, closed_at, next_ledger_time) / 60) as avg_block_time_minutes
from ledger_times
where next_ledger_time is not null
group by date
order by date desc;
Last run: 7 days ago
...
438
21KB
6s