flyingfishStress Test 1
    Updated 2025-02-24
    with stress_timestamps as (

    select *

    from (

    values
    (1, 'Test #1', '2025-01-24 15:40', '2025-01-24 17:30')
    , (2, 'Test #2', '2025-01-28 15:20', '2025-01-28 15:50')
    , (3, 'Test #3', '2025-01-29 14:30', '2025-01-29 15:00')
    , (4, 'Test #4', '2025-02-07 16:00', '2025-02-07 17:00')
    , (5, 'Test #5', '2025-02-13 09:50', '2025-02-14 05:00') --
    , (6, 'Test #6', '2025-02-14 13:50', '2025-02-14 16:00') --
    , (7, 'Test #7', '2025-02-15 15:00', '2025-02-17 03:00')
    , (8, 'Test #8', '2025-02-19 01:35', '2025-02-19 05:55')
    , (9, 'Last 2 hours', current_timestamp - interval '2 hours', current_timestamp)
    ) t( stress_index, stress_label, start_timestamp, end_timestamp)

    )

    , stress_times as (

    select
    start_timestamp
    , end_timestamp

    from stress_timestamps
    where stress_label = '{{test_label}}'
    )

    , txs as (

    select
    *
    , gas_used * 50 / 1e9 as mon_burned
    , gas_used * (gas_price - 50) / 1e9 as tx_savings
    Last run: 20 days ago
    HOUR_
    SIGNERS
    BLOCKS
    SIMPLE_TRANSFER
    NOT_A_SIMPLE_TRANSFER
    TXS
    TPS
    GUD
    NOT_SO_GUD
    FAIL_RATE
    TX_PER_ORIGIN
    MEDIAN(GAS_PRICE)
    AVG(GAS_PRICE)
    MEDIAN(TX_FEE)
    AVG(TX_FEE)
    SUM(MON_BURNED)
    SUM(TX_SAVINGS)
    GAS_LIMIT_
    GAS_USED_
    GAS_USED_ / GAS_LIMIT_
    SAMPLE_GUD_TX
    SAMPLE_BAD_TX
    START_TSP
    END_TSP
    1
    2025-01-24 15:54:00.000231541151001001151001918.311510000498.2683985050.0000000010.00172130.001721734589198.1422252.099999995e-91150210000039634330240.3445830x00010d7a2d2b8f2d99720ae45d5d238596d004e44dfd48bba9038d7fd734d0792025-01-24 15:40:00.0002025-01-24 17:30:00.000
    2
    2025-01-24 15:57:00.0001243261600100616001026.76160000496.7741945050.0000000020.00172130.001720302409105.9548812.099999995e-9615210000021194125680.3445020x00003b0d44ff5775385993f0c164a18975641150b41f35e9f72be9dd9051adf12025-01-24 15:40:00.0002025-01-24 17:30:00.000
    3
    2025-01-24 15:44:00.000518019190.319003.852.554.0631578950.09109038750.10684787491.9305910.099519522889051180386118020.4335910x20f643e56b815c51313786776db80e46e27d85ac7e24ec280f623044394874cc2025-01-24 15:40:00.0002025-01-24 17:30:00.000
    4
    2025-01-24 16:58:00.0003215115251201525122541.915251200475.11526550500.00172130.001721252535262.47263501525120000052502333320.3442510x000034ead7268a0385c57b7f470ad14eb3009ef6676950298f822c96c2d2f6472025-01-24 15:40:00.0002025-01-24 17:30:00.000
    5
    2025-01-24 16:32:00.0003435717094511709462849.117094600498.3848450500.00172130.001722813439294.4643145.370649364e-121709991329158901613220.3444560x000001bb57698954b6efb3dd6986132c7d4e952db0f72518e0b59ec2600086e72025-01-24 15:40:00.0002025-01-24 17:30:00.000
    6
    2025-01-24 15:59:00.00013225650002650011083.46500100492.4318185050.0000307690.00172130.001855688756120.6049760.00004200000613650072100024124316560.3711020x0001f74bc229644fa40f140b0a7bb5cc6a02e895a2e6e5d1112b388cbfb05b192025-01-24 15:40:00.0002025-01-24 17:30:00.000
    7
    2025-01-24 16:11:00.000321541601001001601002668.316010000498.7538945050.0000000010.00172130.001720833404275.464482.099999995e-91600210000055101085600.3443370x00003d854e54ce15b7de108424e4c5354ecaef498c7c0f8f5b9f0be62d13373c2025-01-24 15:40:00.0002025-01-24 17:30:00.000
    8
    2025-01-24 16:45:00.000342561680000168000280016800000491.2280750500.00172130.001721281629289.13233701680000000057835062720.3442560x0000012d03e123353a73d7fe6e3932a210442948d8c1d44eef64a7ed8e3edae52025-01-24 15:40:00.0002025-01-24 17:30:00.000
    9
    2025-01-24 16:06:00.00031553157500015750026251575000050050500.00172130.001721260419271.05820801575000000054219703200.3442520x000052fa173378fe989b020f83df5d6964bdaf6185e769bcd7a21f4c7c680c802025-01-24 15:40:00.0002025-01-24 17:30:00.000
    10
    2025-01-24 17:05:00.0003295315259731525982543.315259800463.8237085050.0000327660.00172130.001721282875262.6249110.0003563561526454200052532793560.3441490x000074bc1d01b78090548a6339b3e15b30461f4462dc6a82fff69790d530dcda2025-01-24 15:40:00.0002025-01-24 17:30:00.000
    11
    2025-01-24 16:25:00.00033055165000016500027501650000050050500.00172130.001721906447284.07234601650000000056822912760.3443810x00003f93015c81299c2d594069907012ba081c7ed8e3bea63accab7d2f29f0ee2025-01-24 15:40:00.0002025-01-24 17:30:00.000
    12
    2025-01-24 16:00:00.000291501440791011440792401.314407900495.1168385050.0000138820.00172130.001723232751248.2448030.00004200211439992100049656321920.3448370x000041bd490acb922d4660b24d8d8ad54da0d6d83fa35622a8caece68b8bad8f2025-01-24 15:40:00.0002025-01-24 17:30:00.000
    13
    2025-01-24 16:04:00.0002884814350001435002391.714350000498.26388950500.00172130.001721970319247.0660101435000000049420548160.3443940x00001bfcfb4191c402fed34a467c153c879c41e5b5986a6deb3a6720ba0a5a672025-01-24 15:40:00.0002025-01-24 17:30:00.000
    14
    2025-01-24 16:37:00.00031853158579100158579264315857900498.6761015050.0000000010.00172130.001720829451272.8468312.099999995e-91585000000054577482700.3443370x0000250a90a4337f27c7a85281ea80f247c1940c77f63291cb9978766b60127c2025-01-24 15:40:00.0002025-01-24 17:30:00.000
    15
    2025-01-24 17:17:00.00030050150000015000025001500000050050500.00172130.001721252532258.14950501500000000051637575960.3442510x0000a77b51a9d5b2b2eff2815e401e871b1ad793526eeda399d4a56d797ee15f2025-01-24 15:40:00.0002025-01-24 17:30:00.000
    16
    2025-01-24 17:04:00.0003415615877601587762646.315877600465.61876850500.00172130.001721252484273.25296501587760000054658716880.344250x00001fd1663068bf7f09b289592bd06eca03a80693ee129255feac4b5b7317792025-01-24 15:40:00.0002025-01-24 17:30:00.000
    17
    2025-01-24 16:27:00.000331551649991165000275016500000498.4894265050.0000121210.00172130.001721267539283.9667460.0001600661649998595256801796790.3442540x00007389f7877fe82eabcb42f1904a427a807c0dd86dcbf77be94d37ec44ea6b2025-01-24 15:40:00.0002025-01-24 17:30:00.000
    18
    2025-01-24 17:25:00.0002210000100016.710000050050500.00172130.00172124841.7209960100000000344249680.344250x00553fd96d40ba11b89c244eb0fdb1bdded8c53db7720411e23dceb973b041092025-01-24 15:40:00.0002025-01-24 17:30:00.000
    19
    2025-01-24 15:43:00.000515019190.319003.852.553.5157894740.120764910.10760069581.9424070.1020076705103577480388481110.3750630x07bbae1b05efb060c098821f300c0d827245b44033d7a86e4cf0ce225eeec54b2025-01-24 15:40:00.0002025-01-24 17:30:00.000
    20
    2025-01-24 16:21:00.0003135215550191555012591.715550100496.8083075050.0001157550.00172130.001721746999267.6931170.0004885021554947000053546578310.3443630x00002e646b48ac3b6e4dbc2a1d7e6de408c75bd12ca237ec75cba24772c379492025-01-24 15:40:00.0002025-01-24 17:30:00.000
    ...
    105
    30KB
    5s