flipside

    Looking for a Solana program id instruction names copy
    AephiaLooking for a Solana program id instruction names copy
    Updated 2025-06-02
    -- forked from flyingfish / Looking for a Solana program id instruction names @ https://flipsidecrypto.xyz/flyingfish/q/hgkolSkRRkxN/looking-for-a-solana-program-id-instruction-names

    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 solana.core.fact_transactions
    join solana.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
    )

    , 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
    )

    , filtered_logs as (
    select
    Last run: about 2 months ago
    INSTRUCTION_NAME
    INSTRUCTION_HEX_IDENTIFIER
    LOG_REFERENCES
    FIRST_LOG_REFERENCE
    LAST_LOG_REFERENCE
    SAMPLE_TX
    SAMPLE_INSTRUCTION
    SAMPLE_INNER_INSTRUCTION
    SAMPLE_INSTRUCTION_DATA
    1
    		FleetStateHandler724dfc1b34a1029c10683712025-05-30 00:00:01.0002025-06-02 20:31:15.000
    49i72iBngP2SxeDuoQAuexFk7CXPxoMj9TCcMST8ntnP7VSc1Pdkks8ZuoqVLpStpBgHMK3W...
    {"accounts":["HSfN1SYdPK5Pn2AuXPXpwEJy1bSHtoAiuesWRNfXpZAa","ANNmNnekJwm...
    {"index":1,"instructions":[{"accounts":["PiLotBQoUBUvKxMrrQbuR3qDhqgwLJc...
    L7u68T6jgbD
    2
    		ScanForSurveyDataUnits5466ea017e88ba938767632025-05-30 00:00:01.0002025-06-02 20:31:15.000
    5w2Mz24Z3oV2WirCdrZv8W1wxmeYEDGA6RMWHVfJWN7xadaL2mBsURvnKEKf4VJns486UMfM...
    {"accounts":["Ah7TRRMddXKXyY4nmUzbGRkrhPEnAfGaLBHiufixocfy","GW28A2tCCd2...
    {"index":1,"instructions":[{"accounts":["DataJpxFgHhzwu4zYJeHCnAv21YqWta...
    5k2cQw4xSusLns
    3
    		DepositCargoToFleet37eb697b00fd40ed8200102025-05-30 00:00:01.0002025-06-02 20:31:15.000
    5utSSTkFGgyehV58rHxr2opbirgPGY4oiBBVTeHEbiHLiw1chs36MgWvjHPMNivMpePKB22P...
    {"accounts":["CS32UoPZg31mbRdBwEY1kGZkwYTtTDTGBXdn2cZEKree","q7xKEJeo1L5...
    {"index":1,"instructions":[{"accounts":["8a3LyvwudbiH4KLFRzkcBHvxJEDGdHK...
    3KXPPwjAhGvpVHR4VE6wqw6V5
    4
    		IdleToLoadingBaye32e044a97f829837606382025-05-30 00:00:01.0002025-06-02 20:31:15.000
    5bAvZQVtykahKC5hBg6vobNcq6KPuKpJPhqhhg5FvkJvAEzsbbQvgSaScUMgSuK4ou71Yqdp...
    {"accounts":["ESrRf8M6G5gV5xAEHmEeUPBffzXXxU4fb9Hq5iY4ZNC9","7e1gmus9ZU2...
    DmGyrG3whmTcN3
    5
    		LoadingBayToIdle0d50e23f18acbe577604562025-05-30 00:00:01.0002025-06-02 20:31:15.000
    EAJeG2uPdbHNCxCd91Mo3iUVM9kCyGPtesjtLd3pYTxebDQAgemYB9hQfURjpHLQHyZzGeMi...
    {"accounts":["6mXEAJpRYuV5v8v74mNHWAKpi4BifAPxcipjhJY3rQsA","Fvvyrddj4Ad...
    kPf6M86k1NDLT
    6
    		WithdrawCargoFromFleet05a380e96c511f386920462025-05-30 00:00:01.0002025-06-02 20:31:15.000
    2RNTPgDCmFr38aN2jYfWzTHqPqrdUa7TpWcnE2ke4QF4C3RF6WW6xfsL4hLYsedwKFefMyir...
    {"accounts":["WWATF78X4xswEsKojdjKXDbLVE5VVaYLZKGAqbTHJZ2","BVUUhbHXTwKA...
    {"index":1,"instructions":[{"accounts":["8kA7P2omYfSgUDcW5mzv6WMSD7GWDih...
    EZkzcRv7MFUwGxEBTmeMJpZV
    7
    		StartMiningAsteroidbad7501eaee2d3214481012025-05-30 00:00:01.0002025-06-02 20:31:15.000
    3CXXbMWfuJ9oHZLA7oxy24dT63MeF4sAuoTHey6VT6g225PAo9Ut8j51iqFPYLTZjXfZtZ9d...
    {"accounts":["6LVuNtS4BHc5bdXr6V5v1fFUyRnWwYPF4bDABoh3evrt","ARgWiVzPsdT...
    BVq9Pqs7PKDLcf
    8
    		StopMiningAsteroidb54d2da3671bd3514480942025-05-30 00:00:01.0002025-06-02 20:31:15.000
    3n3rHdaHE8znjC9XT6awQRFbFSKKL66i8BaYkCJ6QTaNcJz5e49VEARjhfsZEYN2XHYyLhD3...
    {"accounts":["HvTHeZdhCHW29UFPK1y3hBmHiPsw4dv4EyammcyesazY","8t8PXsPaGB7...
    {"index":2,"instructions":[{"accounts":["MineMBxARiRdMh7s1wdStSK4Ns3YfnL...
    BBnBq1LavCsxDm
    9
    		StartSubwarpc068c5281e279b303707412025-05-30 00:00:03.0002025-06-02 20:31:15.000
    58XPKtayM6GpM3Dn79drnfpHhCRgqXnoSYNTaR2BuDAorpPg2kWtGeCXQYVsLYs6qms679WD...
    {"accounts":["7edjdvKdivY18HpYkSic2mMcvwqeGw2ni19GYXhyi3nn","C215TTvVnz8...
    6titos9ok9Lz9CRYmwebaydLRC4j8uQTKFpK
    10
    		WarpToCoordinate573c329af16a4d172625812025-05-30 00:00:08.0002025-06-02 20:31:15.000
    2aRLHQCD9dH59Q3u5ftx8QmJR8Wk9gZLZAEZB5hGvo8TFYJUNbNs1VtQDm5cvzCnKZL61erW...
    {"accounts":["Gtv7wc7gqTfBFSZPqLUJFAgFvw8C8e1AKZUeJz6g1JSz","2dwYrGTjrpM...
    {"index":1,"instructions":[{"accounts":["3XN8kcyY9GYQ3A2tyFbrLnhnCrnhQft...
    3fw1WsBCPGPUkGNdqPhC34PcL95bLc1twwaE
    11
    		DepositCraftingIngredient202391d538ffd19c553742025-05-30 00:00:04.0002025-06-02 20:30:55.000
    2WAgR9MqL7xyuN8JYvAbSaBJThihB6WYBiEA7kc1tCnhoztmKDTCdKZDe8qvYN1g4QfEhWdq...
    {"accounts":["5LVVJEAYEQPMoKp45r7GfNcnNDro1oFDgnLo7XHha3Xp","EXuMxkzAvYd...
    {"index":3,"instructions":[{"accounts":["EXuMxkzAvYdEbr4WHavcj42W98qmqCc...
    SyEJX1grgkpRc4mu2qLbTSW5bCj
    12
    		BurnCraftingConsumables0de1cb5b36e87eaa516992025-05-30 00:00:09.0002025-06-02 20:31:15.000
    2QwAdQo77k71egEMfSic6p6ZJvZHhXxLcJQxXHDqCJCQL7fwc37GGnDCEcQNNbpSJ8hpHHo9...
    {"accounts":["9tzsPX6uSUxd1coA2yMYDrmVfQQGJZdZG1qDeghxeSqu","D94iYQzFDMF...
    {"index":1,"instructions":[{"accounts":["GhmdkRMpfV34wxWBB9oY2E2poe6PuHt...
    nEe4nMupV8Lr3
    13
    		StartCraftingProcess406c6d3e09808af6439492025-05-30 00:00:04.0002025-06-02 20:30:55.000
    2WAgR9MqL7xyuN8JYvAbSaBJThihB6WYBiEA7kc1tCnhoztmKDTCdKZDe8qvYN1g4QfEhWdq...
    {"accounts":["5LVVJEAYEQPMoKp45r7GfNcnNDro1oFDgnLo7XHha3Xp","EXuMxkzAvYd...
    {"index":5,"instructions":[{"accounts":["5LVVJEAYEQPMoKp45r7GfNcnNDro1oF...
    4cvmXpXXxuc6Mm
    14
    		CreateCraftingProcess361903475ad7636c409022025-05-30 00:00:04.0002025-06-02 20:30:55.000
    2WAgR9MqL7xyuN8JYvAbSaBJThihB6WYBiEA7kc1tCnhoztmKDTCdKZDe8qvYN1g4QfEhWdq...
    {"accounts":["8uMGZW8rhKH5oHecXW7Ef7JKQE9A7Mt84HUqXmQo3c2","5LVVJEAYEQPM...
    {"index":1,"instructions":[{"parsed":{"info":{"lamports":1482480,"newAcc...
    QprVW6FfkcvbctzGbvEPsaTxXASuV6i5JVF5J7kJ53ofgnnTH
    15
    		CloseCraftingProcessca15e19c0f046a5d407082025-05-30 00:00:09.0002025-06-02 20:31:15.000
    2QwAdQo77k71egEMfSic6p6ZJvZHhXxLcJQxXHDqCJCQL7fwc37GGnDCEcQNNbpSJ8hpHHo9...
    {"accounts":["23xrRTYdTmosbC8Z3oeG4C2522j2jqhqTCHR5V7fNexb","9tzsPX6uSUx...
    {"index":3,"instructions":[{"accounts":["9HGdTSYqyAQZB9NH5j1B15nTHksNLeV...
    CMWGixsXzbyPuZ
    16
    		ClaimCraftingOutputsd7473b1c9c5dbcff407062025-05-30 00:00:09.0002025-06-02 20:31:15.000
    2cFVTMN8HPDK1T3RTyJp6JeKqVEqbEXGhF9NAjUZNepxym8eYLC5SwyeaqL6QgexFhpCe2VM...
    {"accounts":["HwSUG1sUzvk3HTyYDQk4Fx9Lk7NBGjSYKVMgUxZozp6B","3HTcs4cWivx...
    {"index":2,"instructions":[{"accounts":["823r7SfPhk42tUUWWxCpVRvsoiath5Y...
    D6VeYaXcRgMV4K
    17
    		StopSubwarp963a030006cf772e305162025-05-30 00:00:11.0002025-06-02 20:31:02.000
    5219CAwtNbdUpttWSsqsktDNrVeEEDWsRzvEX6dxLkR1YLTutGBo5VviPo5wckbTaHHjYSnY...
    {"accounts":["YAJqXkPnL1RhudMERrUZ23ekVt891dL41GaYxcyZ5Bm","BdNQKJw17jaw...
    {"index":2,"instructions":[{"accounts":["PiLotBQoUBUvKxMrrQbuR3qDhqgwLJc...
    9SXAzN5nKdj2Vu
    18
    		CreateStarbaseUpgradeResourceProcess1d05cafdb707042c34172025-05-30 00:01:01.0002025-06-02 20:30:17.000
    4qGAV12gxCujXcj9JLiwudyMg6AcwYDVm82XfbtSktNEvHejv4LjQjwrwPSJ8s46J6xtcspo...
    {"accounts":["zombiksx6VKEChaCaPXMKREibqbQ7ywrfgM42P4mBVA","7zomNZp3Z1sj...
    {"index":1,"instructions":[{"parsed":{"info":{"lamports":1482480,"newAcc...
    DnLxYKguefhPNNohu8fUagyW9KjinrntnrbChaZxCHKSd6SBH
    19
    		SubmitStarbaseUpgradeResource35b6e6e839c9a77832662025-05-30 00:00:31.0002025-06-02 20:30:09.000
    4oV9tSeDuU7Zqz8xwrAAFqsdqjnzdbtzuHivDWomSBQQRUohq1qj3rCAU2taxbRebXt3JsQJ...
    {"accounts":["DP7B9otvi3k9fUYKfzGgcwdSb6Mhsgzc6aFEAFAvF1yP","4a1ZvTYdSxo...
    {"index":3,"instructions":[{"accounts":["8ZvvREoLpfqWMg8Do1aWTh8ohCMGr39...
    kQPhFisHT6qT91R7mBSuXvuEVKN
    20
    		CloseUpgradeProcessd6848a7b8811595232662025-05-30 00:00:31.0002025-06-02 20:30:09.000
    4oV9tSeDuU7Zqz8xwrAAFqsdqjnzdbtzuHivDWomSBQQRUohq1qj3rCAU2taxbRebXt3JsQJ...
    {"accounts":["DP7B9otvi3k9fUYKfzGgcwdSb6Mhsgzc6aFEAFAvF1yP","4a1ZvTYdSxo...
    {"index":4,"instructions":[{"accounts":["8ZvvREoLpfqWMg8Do1aWTh8ohCMGr39...
    D41v43RV7fRNYf
    57
    122KB
    1005s