-- forked from ethereum Latency - Live @ https://flipsidecrypto.xyz/edit/queries/665e44a5-aed3-4207-a1a5-d1d16429107c

-- forked from ethereum Latency - Live @ https://flipsidecrypto.xyz/edit/queries/9f739c4b-00cf-4550-9461-c7926d8885f6

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

with

solana as (

select

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

'solana' as chain,

'fact_blocks' as table_name

from

solana.core.fact_blocks

union

select

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

'solana' as chain,

'fact_transactions' as table_name

from

solana.core.fact_transactions

union

select

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

'solana' as chain,

'fact_events' as table_name

from

solana.core.fact_events

)

table_name,

mins_behind

from solana

order by table_name