All Chains Latency - Top-level Categories

flipsidecryptoAll Chains Latency - Top-level Categories

Updated 2024-10-30

-- 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: 7 days ago

	CHAIN	TABLE_TYPE	MINS_BEHIND	HRS_BEHIND
1	arbitrum	event_level	60.7	1.011666666667
2	arbitrum	top_level	60.7	1.011666666667
3	aurora	event_level	29.95	0.499166666667
4	aurora	top_level	29.833333	0.497222216667
5	avalanche	event_level	54.783333	0.91305555
6	avalanche	top_level	54.783333	0.91305555
7	axelar	event_level	47.808333	0.79680555
8	axelar	top_level	47.758333	0.795972216667
9	base	event_level	50.683333	0.844722216667
10	base	top_level	50.683333	0.844722216667
11	bitcoin	event_level	25.866667	0.431111116667
12	bitcoin	top_level	25.866667	0.431111116667
13	bsc	event_level	49.266667	0.821111116667
14	bsc	top_level	49.266667	0.821111116667
15	cosmos	event_level	144.183333	2.40305555
16	cosmos	top_level	129.1416665	2.152361108333
17	ethereum	event_level	65.25	1.0875
18	ethereum	top_level	65.25	1.0875
19	flow	event_level	41.183333	0.686388883333
20	flow	top_level	41.183333	0.686388883333

2KB

398s