All Chains Latency - Top-level Categories

winnie-fsAll Chains Latency - Top-level Categories

Updated 2024-01-17

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

	CHAIN	TABLE_TYPE	MINS_BEHIND	HRS_BEHIND
1	arbitrum	event_level	14.166667	0.236111116667
2	arbitrum	top_level	14.166667	0.236111116667
3	aurora	event_level	51.083333	0.851388883333
4	aurora	top_level	50.9666665	0.849444441667
5	avalanche	event_level	38.683333	0.644722216667
6	avalanche	top_level	38.683333	0.644722216667
7	axelar	event_level	45.9	0.765
8	axelar	top_level	45.8583335	0.764305558333
9	base	event_level	63.916667	1.065277783333
10	base	top_level	63.916667	1.065277783333
11	bitcoin	event_level	36.1	0.601666666667
12	bitcoin	top_level	36.1	0.601666666667
13	bsc	event_level	34.316667	0.57194445
14	bsc	top_level	34.316667	0.57194445
15	cosmos	event_level	187.466667	3.12444445
16	cosmos	top_level	172.316667	2.87194445
17	ethereum	event_level	15.683333	0.261388883333
18	ethereum	top_level	15.683333	0.261388883333
19	flow	event_level	27.016667	0.450277783333
20	flow	top_level	27	0.45

2KB

226s