permaryDaily ledgers
Updated 2025-03-13Copy Reference Fork
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;
QueryRunArchived: QueryRun has been archived