Query editor
WITHprogram_compute AS (SELECTSPLIT(log, ' ') [2] AS program_id,TRY_CAST(SPLIT(log, ' ') [4] AS BIGINT) AS computed_units_spent,TRY_CAST(SPLIT(log, ' ') [6] AS BIGINT) AS computed_units_allocated,block_date,block_slot,block_time,id,feeFROMsolana.transactions AS tLEFT JOIN UNNEST (log_messages) AS l (log) ON TRUEWHERElog LIKE 'Program % consumed % of % compute units'AND t.block_time >= CURRENT_TIMESTAMP - INTERVAL '2' hour),block_compute AS (SELECTblock_date,block_slot,COUNT(*) AS num_ixs,SUM(computed_units_spent) AS computed_units_spent,SUM(computed_units_allocated) AS computed_units_allocated,SUM(fee) AS feeFROMprogram_compute AS pcGROUP BYblock_date,block_slot),totals as (SELECTpc.block_date,pc.block_slot,pc.program_id,CASEWHEN pi.is_anchor IS NULL THEN falseELSE pi.is_anchorEND as is_anchor,CASEWHEN pi.has_idl IS NULL THEN falseELSE pi.has_idlEND as has_idl,bc.fee,bc.num_ixs,bc.computed_units_spent,SUM(pc.computed_units_spent) compute,COUNT(*) AS ctFROMprogram_compute AS pcLEFT JOIN dune.solana_team.dataset_programinfo AS pi ON pi.program_id = pc.program_idLEFT JOIN block_compute AS bc ON pc.block_slot = bc.block_slotGROUP BYpc.block_date,pc.block_slot,pc.program_id,pi.is_anchor,pi.has_idl,