CHAIN | TABLE_TYPE | MINS_BEHIND | HRS_BEHIND | |
---|---|---|---|---|
1 | arbitrum | event_level | 40.366667 | 0.672777783333 |
2 | arbitrum | top_level | 40.366667 | 0.672777783333 |
3 | aurora | event_level | 36.816667 | 0.613611116667 |
4 | aurora | top_level | 36.816667 | 0.613611116667 |
5 | avalanche | event_level | 34.8 | 0.58 |
6 | avalanche | top_level | 34.8 | 0.58 |
7 | axelar | event_level | 42.75 | 0.7125 |
8 | axelar | top_level | 42.7 | 0.711666666667 |
9 | base | event_level | 30.4 | 0.506666666667 |
10 | base | top_level | 30.4 | 0.506666666667 |
11 | bitcoin | event_level | 43 | 0.716666666667 |
12 | bitcoin | top_level | 43 | 0.716666666667 |
13 | bsc | event_level | 29.45 | 0.490833333333 |
14 | bsc | top_level | 29.45 | 0.490833333333 |
15 | cosmos | event_level | 604.116667 | 10.068611116667 |
16 | cosmos | top_level | 589.2083335 | 9.820138891667 |
17 | ethereum | event_level | 45.433333 | 0.757222216667 |
18 | ethereum | top_level | 45.433333 | 0.757222216667 |
19 | flow | event_level | 37.8 | 0.63 |
20 | flow | top_level | 29.65 | 0.494166666667 |
flipsidecryptoAll Chains Latency - Top-level Categories
Updated 2024-10-30Copy Reference Fork
999
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
33
34
35
36
›
⌄
-- forked from forgash / All Chains Delay - Cats @ https://flipsidecrypto.xyz/forgash/q/all-chains-delay-DkdsNk
-- forked from All Chains Delay @ https://flipsidecrypto.xyz/edit/queries/ba5b9498-40ec-4d44-9465-5f65b06b363d
with
arbitrum as (
select
datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
'arbitrum' as chain,
'fact_blocks' as table_name
from
arbitrum.core.fact_blocks
union
select
datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
'arbitrum' as chain,
'fact_transactions' as table_name
from
arbitrum.core.fact_transactions
union
select
datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
'arbitrum' as chain,
'fact_event_logs' as table_name
from
arbitrum.core.fact_event_logs
union
select
datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
'arbitrum' as chain,
'fact_traces' as table_name
from
arbitrum.core.fact_traces
),
aurora as (
select
datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
'aurora' as chain,
Last run: 9 days ago
34
1KB
365s