magMonad Transaction Success Rate
    Updated 2025-02-26
    SELECT
    CASE
    WHEN TX_SUCCEEDED THEN 'successful transactions'
    ELSE 'failed transactions'
    END AS transaction_status,
    COUNT(TX_HASH) AS transaction_count,
    COUNT(TX_HASH) * 100.0 / SUM(COUNT(TX_HASH)) OVER () AS transaction_percentage
    FROM
    monad.testnet.fact_transactions
    GROUP BY
    transaction_status;
    QueryRunArchived: QueryRun has been archived