permaryrotten-lavender
    Updated 2025-02-19
    WITH ledger_times AS (
    SELECT
    DATEDIFF('second', LAG(closed_at) OVER (ORDER BY sequence), closed_at) as time_diff,
    sequence,
    closed_at,
    operation_count,
    successful_transaction_count,
    failed_transaction_count
    FROM stellar.core.fact_ledgers
    WHERE closed_at >= DATEADD(hour, -24, CURRENT_TIMESTAMP())
    ),
    account_count AS (
    SELECT COUNT(*) as total_accounts
    FROM stellar.core.fact_accounts
    WHERE block_timestamp >= DATEADD(hour, -24, CURRENT_TIMESTAMP())
    )
    SELECT
    AVG(time_diff) as avg_ledger_time_seconds,
    SUM(operation_count) as total_operations,
    SUM(successful_transaction_count) as successful_transactions,
    SUM(failed_transaction_count) as failed_transactions,
    ROUND(SUM(successful_transaction_count) * 100.0 / NULLIF(SUM(successful_transaction_count + failed_transaction_count), 0), 2) as success_rate_percentage,
    (SELECT total_accounts FROM account_count) as total_accounts
    FROM ledger_times;

    SELECT COUNT(DISTINCT account) AS unique_accounts
    FROM stellar.core.fact_ledgers
    WHERE closed_at >= '2025-01-01'
    AND closed_at < '2025-03-01';



    Last run: 26 days ago
    AVG_LEDGER_TIME_SECONDS
    TOTAL_OPERATIONS
    SUCCESSFUL_TRANSACTIONS
    FAILED_TRANSACTIONS
    SUCCESS_RATE_PERCENTAGE
    TOTAL_ACCOUNTS
    1
    5.83876541822991750414211324845.34394925
    1
    49B
    2s