forgashAvax Delay
    Updated 2023-04-20
    with
    avax as (
    select
    datediff('second', max(block_timestamp), current_timestamp) / 60 as min_delay,
    'avalanche' as chain,
    'fact_blocks' as table_name
    from
    avalanche.core.fact_blocks
    union
    select
    datediff('second', max(block_timestamp), current_timestamp) / 60 as min_delay,
    'avalanche' as chain,
    'fact_transactions' as table_name
    from
    avalanche.core.fact_transactions
    union
    select
    datediff('second', max(block_timestamp), current_timestamp) / 60 as min_delay,
    'avalanche' as chain,
    'fact_event_logs' as table_name
    from
    avalanche.core.fact_event_logs
    union
    select
    datediff('second', max(block_timestamp), current_timestamp) / 60 as min_delay,
    'avalanche' as chain,
    'fact_traces' as table_name
    from
    avalanche.core.fact_traces
    )
    select
    *
    from
    avax
    Run a query to Download Data