BLOCKS | AVG_BLOCK_TIME | |
|---|---|---|
1 | 270255067 | 0.522387 |
zackmendelSolana Average block times copy
Updated 2025-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from Solana Average block times @ https://flipsidecrypto.xyz/studio/queries/7a65606a-3ead-4266-9996-c37a0c567cbd
WITH solana_base AS (
SELECT
block_id,
block_timestamp AS current_times,
LAG(block_timestamp) OVER (ORDER BY block_id) AS previous_timestamp,
DATEDIFF('second', previous_timestamp, current_times) AS block_time
FROM solana.core.fact_blocks
-- WHERE block_timestamp::date >= CURRENT_DATE - 30 AND block_timestamp::date != CURRENT_DATE
WHERE block_timestamp::date >= '2020-10-10' AND block_timestamp::date != CURRENT_DATE
-- limit 10
)
SELECT
COUNT(DISTINCT s.block_id) AS blocks,
AVG(s.block_time) AS avg_block_time
FROM solana_base s
Last run: 3 months ago
1
22B
77s