No Data to Display
flyingfishLooking for a Eclipse program id instruction names
Updated 2 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Looking for a Solana program id instruction names @ https://flipsidecrypto.xyz/studio/queries/cc1b5553-2408-4daf-b281-af6115f6812c
with
logs as (
select
block_timestamp
, tx_id
, program_id
, index
, substr(livequery.utils.udf_base58_to_hex(instruction:data), 3, 16) as fun_hex
, instruction
, inner_instruction
, log_messages
from eclipse.core.fact_transactions
join eclipse.core.fact_events using(block_timestamp, tx_id)
where 1 = 1
and block_timestamp > current_date - {{lookback_days}}
and program_id = '{{program_address}}'
and succeeded
--limit 20
-- and tx_id = '4ocENbUDh8EezVxbDVmrEguS1YfyvM3EKvqWHBaD7mnrG5rsLmcbdMKvkwm9XKEaTMTyUv2G6VzYM11xheoc1McL'
-- and block_id = 25196010
)
, flattened_logs as (
select
logs.*
, f.index as log_index
, f.value as log_msg
, CASE
WHEN LOG_MSG LIKE '% invoke [%' THEN log_msg
ELSE NULL
END AS program_invocation
from logs
, lateral flatten (input => log_messages) f
)
Last run: 2 days ago
0
2B
15s