7d_v3_unique_pid_count_log_messages copy

Switchboard7d_v3_unique_pid_count_log_messages copy

Updated 2024-01-23

-- forked from 7d_v3_unique_pid_count_log_messages @ https://flipsidecrypto.xyz/edit/queries/411b5aca-829b-42d5-8572-db73a3055b1c

-- functionRoutineVerify, functionRequestVerify,

-- when they call an ixn in user program,

-- is it our program calling the ixn or the accounts?

-- functionVerify is called by our sbatt program

-- which then also calls the ixn in user program in the same txn

-- so does routineVerify and requestVerify only trigger initial execution call?

SELECT f.this AS log, f.this[9]

FROM solana.core.fact_transactions

INNER JOIN lateral flatten (input => log_messages) f

WHERE block_timestamp >= CURRENT_DATE - 30

AND succeeded

AND f.this[0] = 'Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]'

AND f.this[1] = 'Program log: Instruction: FunctionRequestVerify'

Last run: over 1 year ago

	LOG	F.THIS[9]
1	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
2	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
3	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
4	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
5	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
6	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
7	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
8	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
9	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
10	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
11	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
12	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
13	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
14	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
15	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
16	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
17	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
18	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
19	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]
20	["Program sbattyXrzedoNATfc4L31wC9Mhxsi1BmFhTiN8gDshx invoke [1]","Progr...	Program f1ipPG3C8GLN1pPxAkxrmo7dSWfDGF4Zw5BfNfs48fb invoke [1]

...

3219

4MB

174s