keean82Getting Started
Updated 2024-08-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH failed_txs AS (
SELECT
signers[1] as mint,
tx_id as tx,
block_timestamp as timestamp
FROM solana.core.fact_events
WHERE
date_trunc('day', block_timestamp) = '2024-08-22 00:00:00'
AND succeeded = false
AND ARRAY_CONTAINS('TSLvdd1pWpHVjahSpsvCXUbgwsL3JAcvokwaKt1eokM'::VARIANT, instruction:accounts)
),
kkk AS (
SELECT
mint,
COUNT(tx) as failed_txs_count
FROM
failed_txs
GROUP BY
mint
ORDER BY
failed_txs_count DESC
QueryRunArchived: QueryRun has been archived