ibold-devGetting Started
    Updated 2025-06-28
    -- -- First, get the TX_IDs from fact_events for the specific program
    -- WITH program_transactions AS (
    -- SELECT DISTINCT TX_ID
    -- FROM eclipse.core.fact_events
    -- WHERE PROGRAM_ID = 'H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg'
    -- )

    -- Then get all transaction details for those TX_IDs
    SELECT
    t.BLOCK_TIMESTAMP,
    -- t.BLOCK_ID,
    -- t.TX_ID,
    -- t.INDEX,
    -- t.RECENT_BLOCK_HASH,
    -- t.SIGNERS,
    -- t.FEE,
    -- t.SUCCEEDED,
    -- t.ACCOUNT_KEYS,
    -- t.PRE_BALANCES,
    -- t.POST_BALANCES,
    -- t.PRE_TOKEN_BALANCES,
    -- t.POST_TOKEN_BALANCES,
    -- t.INSTRUCTIONS,
    -- t.INNER_INSTRUCTIONS,
    t.LOG_MESSAGES,
    -- t.ADDRESS_TABLE_LOOKUPS,
    -- t.UNITS_CONSUMED,
    -- t.UNITS_LIMIT,
    -- t.TX_SIZE,
    -- t.VERSION,
    -- t.FACT_TRANSACTIONS_ID,
    -- t.INSERTED_TIMESTAMP,
    -- t.MODIFIED_TIMESTAMP
    FROM eclipse.core.fact_transactions t
    INNER JOIN program_transactions pt ON t.TX_ID = pt.TX_ID
    ORDER BY t.BLOCK_TIMESTAMP DESC
    Last run: 13 days ago
    BLOCK_TIMESTAMP
    LOG_MESSAGES
    1
    2025-06-28 16:23:37.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: CreatePlayer", "Program 11111111111111111111111111111111 invoke [2]", "Program 11111111111111111111111111111111 success", "Program data: /glKUVwFvdwEZcjYW9LO4wi/p6kYvjTRVteRRXIH5wiUTO366VfPCg==", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 10314 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    2
    2025-06-28 13:46:08.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: ClaimDailyLives", "Program data: jjTCixTohYPB3nkjTit6FQHqN+c+AGMEqmlPzUFtHZ9WANg8dMur5gog8l9oAAAAAB0AAAAAAAAA", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 7295 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    3
    2025-06-28 09:53:07.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: ClaimDailyLives", "Program data: jjTCixTohYM0Usm2N6hdVttJrz6pkWUVAlSjE6eNTeZsuJBmTD7GswqDu19oAAAAAAoAAAAAAAAA", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 7295 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    4
    2025-06-28 09:50:12.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: UpdatePlayer", "Program data: WGxN9u5FWzpwkfYCrYUW1zBzglA+HOfF5KjlPH7dfE0R9ZG1xW6cIAAAAAAAAAAAam8AAAAAAAAAAAAAAAAAAAAKAAAAAAAAAJMHAAAAAAAAAAAAAAAAAAAA1LpfaAAAAAA=", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 11390 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    5
    2025-06-28 09:38:11.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: ClaimDailyLives", "Program data: jjTCixTohYNwkfYCrYUW1zBzglA+HOfF5KjlPH7dfE0R9ZG1xW6cIAoDuF9oAAAAAAoAAAAAAAAA", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 11795 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    6
    2025-06-28 07:29:02.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: UpdatePlayer", "Program data: WGxN9u5FWzpsfInTL/hYx2J2WuLjSARUbqeMO7VTd+84qzviYQ+roQAAAAAAAAAAQXoAAAAAAAAAAAAAAAAAAAADAAAAAAAAAIIAAAAAAAAAAAAAAAAAAAAAvplfaAAAAAA=", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 6890 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    7
    2025-06-28 07:25:54.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: UpdatePlayer", "Program data: WGxN9u5FWzpsfInTL/hYx2J2WuLjSARUbqeMO7VTd+84qzviYQ+roQMAAAAAAAAAv3kAAAAAAAAAAAAAAAAAAAAHAAAAAAAAAAoEAAAAAAAAAAAAAAAAAAAAAplfaAAAAAA=", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 6890 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    8
    2025-06-28 07:17:06.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: ClaimDailyLives", "Program data: jjTCixTohYNsfInTL/hYx2J2WuLjSARUbqeMO7VTd+84qzviYQ+roQryll9oAAAAAAoAAAAAAAAA", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 7295 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    9
    2025-06-28 06:33:11.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: UpdatePlayer", "Program data: WGxN9u5FWzrjCIHIBi9DEVCKWKf66NPcXZQfLSW1+BTEaQgIQ+5S+TMAAAAAAAAAwS4BAAAAAAAAAAAAAAAAAAAEAAAAAAAAABABAAAAAAAAAAAAAAAAAAAAp4xfaAAAAAA=", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 6890 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    10
    2025-06-28 04:56:55.000
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg invoke [1]", "Program log: Instruction: ClaimDailyLives", "Program data: jjTCixTohYPjCIHIBi9DEVCKWKf66NPcXZQfLSW1+BTEaQgIQ+5S+QoXdl9oAAAAADcAAAAAAAAA", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg consumed 7295 of 599850 compute units", "Program H7t1tMD62Vn3MV5G4yZ8Gz6J7GkATqY7prtGqGzPD2hg success" ]
    10
    5KB
    176s