CronCats / croncat-indexer

Listen to the chain, get stats about croncat!
0 stars 0 forks source link

[FEATURE]: Historical recollection/gap fixes. #3

Closed SeedyROM closed 2 years ago

SeedyROM commented 2 years ago

Requirements

Example gap finder query:

select time, height + 1 as gap_start,
       next_nr - 1 as gap_end
from (
  select time, height,
         lead(height) over (order by height) as next_nr
  from block
) nr
where height + 1 <> next_nr;
2022-10-15 22:19:21.556055,339186,339192
2022-10-15 22:22:03.791004,339213,339221