-- forked from bsc Latency - Live @ https://flipsidecrypto.xyz/edit/queries/b8f63300-e92f-456e-8110-7cd834736467

with

bsc as (

select

datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,

'bsc' as chain,

'fact_blocks' as table_name

from

bsc.core.fact_blocks

union

select

datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,

'bsc' as chain,

'fact_transactions' as table_name

from

bsc.core.fact_transactions

union

select

datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,

'bsc' as chain,

'fact_event_logs' as table_name

from

bsc.core.fact_event_logs

union

select

datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,

'bsc' as chain,

'fact_traces' as table_name

from

bsc.core.fact_traces

)

table_name,