cryptodatadiveGas Usage During Deployments
    Updated 2025-04-10
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DAY,
    COUNT(*) AS DEPLOYMENT_TX_COUNT,
    SUM(GAS_USED) AS TOTAL_GAS_USED,
    AVG(GAS_USED) AS AVG_GAS_USED
    FROM
    mezo.testnet.FACT_TRANSACTIONS
    WHERE
    TO_ADDRESS IS NULL
    GROUP BY
    DAY
    ORDER BY
    DAY

    Last run: about 2 months ago
    DAY
    DEPLOYMENT_TX_COUNT
    TOTAL_GAS_USED
    AVG_GAS_USED
    1
    2025-03-28 00:00:00.000226
    2
    2025-03-29 00:00:00.000360179414472498373.533333
    3
    2025-03-30 00:00:00.0001436537139286374313.091289
    4
    2025-03-31 00:00:00.000767467384021609366.389831
    5
    2025-04-01 00:00:00.000915672207774734653.304918
    6
    2025-04-02 00:00:00.000973865553809889572.260021
    7
    2025-04-03 00:00:00.000300283256949944189.83
    8
    2025-04-04 00:00:00.00038685767121804650.315789
    9
    2025-04-06 00:00:00.00011235226658314523.732143
    10
    2025-04-07 00:00:00.000393116347560296049.770992
    11
    2025-04-08 00:00:00.000212121061623571045.391509
    12
    2025-04-09 00:00:00.00017292544450538049.127907
    13
    2025-04-10 00:00:00.0001121142921081020465.25
    13
    706B
    2s