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"
] |
ibold-devGetting Started
Updated 2025-06-28Copy Reference Fork
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
›
⌄
-- -- 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
10
5KB
176s