licieSolana TPS
    Updated 2025-01-17
    WITH hourly_data AS (
    SELECT
    DATE_TRUNC('HOUR', block_timestamp) AS hour,
    COUNT(*) AS transaction_count,
    MIN(block_timestamp) AS start_time,
    MAX(block_timestamp) AS end_time
    FROM solana.core.fact_transactions
    WHERE block_timestamp >= CURRENT_DATE - INTERVAL '1 DAY'
    GROUP BY 1
    )
    SELECT
    hour,
    transaction_count,
    DATEDIFF('SECOND', start_time, end_time) AS time_duration_seconds,
    transaction_count / NULLIF(DATEDIFF('SECOND', start_time, end_time), 0) AS tps
    FROM hourly_data
    ORDER BY hour;

    Last run: about 1 month ago
    HOUR
    TRANSACTION_COUNT
    TIME_DURATION_SECONDS
    TPS
    1
    2025-01-16 00:00:00.000455893935991266.723812
    2
    2025-01-16 01:00:00.000460107135991278.430397
    3
    2025-01-16 02:00:00.000469681635991305.03362
    4
    2025-01-16 03:00:00.000446199535991239.787441
    5
    2025-01-16 04:00:00.000419218635991164.819672
    6
    2025-01-16 05:00:00.000397299235991103.915532
    7
    2025-01-16 06:00:00.000429910335991194.527091
    8
    2025-01-16 07:00:00.000439292135991220.594887
    9
    2025-01-16 08:00:00.000437796735991216.439844
    10
    2025-01-16 09:00:00.000445207335991237.030564
    11
    2025-01-16 10:00:00.000438267735991217.748541
    12
    2025-01-16 11:00:00.000451193635991253.663795
    13
    2025-01-16 12:00:00.000437421035991215.395943
    14
    2025-01-16 13:00:00.000412666835991146.615171
    15
    2025-01-16 14:00:00.000429468335991193.298972
    16
    2025-01-16 15:00:00.000423354035991176.310086
    17
    2025-01-16 16:00:00.000434317035991206.771325
    18
    2025-01-16 17:00:00.000445889535991238.926091
    19
    2025-01-16 18:00:00.000463219135991287.077244
    20
    2025-01-16 19:00:00.000443713535991232.879967
    34
    2KB
    5s