Query editor
withprogram_compute as (SELECTsplit(log, ' ')[2] as program_id, cast(split(log,' ')[4] as bigint) as computed_units_spent, cast(split(log,' ')[6] as bigint) as computed_units_allocated, block_slot, block_time, id, feeFROM solana.transactions tLEFT JOIN unnest(log_messages) as l(log) ON TrueWHERE log LIKE 'Program % consumed % of % compute units'-- AND id = 'u2V4YynJsktLbcj8rSo7Aih66HU59h4eEAY9LJmMjti3jaZBcMCVSJkYdkSxhekN8Dn5qKmeX979FXzvdMmpkgE'-- and block_slot = 229394527AND t.block_time >= now() - interval '{{hours}}' hour), block_cu as (selectr.blockslot as slot, reduce(transform(transactions, x->x.meta.computeunitsconsumed), 0,(s, x) -> s + x,s -> s) as total_block_cuFROM solana.raw_0003 rJOIN solana.blocks b ON b.slot = r.blockslot-- LEFT JOIN unnest(transaction.signatures) as tx(id) ON trueWHERE time > now() - interval '{{hours}}' hour), avg_block as (SELECTprogram_id, avg(total_cu) as average_compute_per_block, avg(cast(total_cu as double)/cast(total_block_cu as double)) as average_percent_compute_per_blockFROM (SELECTprogram_id, block_slot, bc.total_block_cu, sum(computed_units_spent) as total_cuFROM program_compute pcLEFT JOIN block_cu bc ON pc.block_slot = bc.slotgroup by 1,2,3)group by 1)SELECTget_href(get_chain_explorer('solana') || '/account/' || pc.program_id, COALESCE('✔️ ' || p.namespace, pc.program_id)) as program_id, avg(computed_units_spent) as average_compute_per_invoke, b.average_compute_per_block, b.average_percent_compute_per_block, sum(computed_units_spent) as total_compute-- , avg(fee/1e9) as avg_fee_sol-- , sum(fee/1e9) as fees_sol-- , avg(fee)/avg(computed_units_spent) as fee_per_cu, count(*) as times_invoked, arbitrary(get_href('https://solscan.io/tx/' || pc.id, 'tx link')) as example_txFROM program_compute pc