rain_syndicaAverage Fees, Tx Size and Compute Units for Inscriptions
    Updated 2024-01-12
    with

    all_txs as (

    select distinct

    block_timestamp
    , signers[0] as creator
    , tx_id
    , fee
    , tx_size
    , units_consumed

    from solana.core.fact_events
    inner join solana.core.fact_transactions
    using(block_timestamp, tx_id, succeeded)
    inner join lateral flatten (input => log_messages) f_logs
    where succeeded
    and program_id in (
    'Leg1xVbrpq5gY6mprak3Ud4q4mBwcJi5C9ZruYjWv7n' -- libreplex_legacy
    , '8bvPnYE5Pvz2Z9dE6RAqWr1rzLknTndZ9hwvRE6kPDXP' -- libreplex_fair_launch
    )
    and log_messages[f_logs.index -1] like 'Program inscokhJarcjaEs59QbQ7hYjrKz25LEPRfCbP8EmdUp invoke [%]' -- libreplex_inscriptions
    and f_logs.value rlike '^Program log: Instruction: CreateInscription(V[0-9])?'
    and block_timestamp > '2023-11-13'
    and block_timestamp < '2024-01-01'
    )

    select
    avg(fee) as avg_fee,
    avg(tx_size) as avg_tx_size,
    avg(units_consumed) as avg_units_consumed
    from all_txs


    QueryRunArchived: QueryRun has been archived