mo115Avalanche Performance
    Updated 2024-08-19
    with A as(select date_trunc('day',BLOCK_TIMESTAMP) as date , (count(TX_HASH))/1440 as tx_per_sec ,
    status
    from avalanche.core.fact_transactions
    where date > CURRENT_DATE - 60
    and STATUS='SUCCESS'
    group by 1,3),
    B as(select date_trunc('day',BLOCK_TIMESTAMP) as date , (count(TX_HASH))/1440 as tx_per_sec ,
    status
    from avalanche.core.fact_transactions
    where date > CURRENT_DATE - 60
    and STATUS='FAIL'
    group by 1,3)
    select a.date, a.tx_per_sec as successful_tx_per_min , b.tx_per_sec*-1 as failed_tx_per_min,
    (successful_tx_per_min)/(successful_tx_per_min-failed_tx_per_min) as success_rate
    from A a inner join b B on a.date=b.date

    QueryRunArchived: QueryRun has been archived