rackhaelLAYER 2s: Block Performance Time
Updated 2024-03-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Polygon Vs Osmosis Vs Flow Block Performance Time @ https://flipsidecrypto.xyz/edit/queries/02685ef9-f44c-4530-ac29-3ad120f9943e
WITH T1_Polygon AS (SELECT block_number,
min_time,
previous_time,
datediff('second',previous_time,min_time) AS time_difference
FROM (SELECT block_number, min(block_timestamp) AS min_time,
lag(min_time,1) ignore nulls over (ORDER BY block_number ASC) AS previous_time
FROM polygon.core.fact_transactions
GROUP BY 1)),
T2_Polygon AS (SELECT avg(time_difference) AS avg_time_between_blocks,
max(time_difference) AS max_time_between_blocks,
min(time_difference) AS min_time_between_blocks
FROM t1_Polygon),
T1_Optimism AS (SELECT block_number,
min_time,
previous_time,
datediff('second',previous_time,min_time) AS time_difference
FROM (SELECT block_number, min(block_timestamp) AS min_time,
lag(min_time,1) ignore nulls over (ORDER BY block_number ASC) AS previous_time
FROM optimism.core.fact_blocks
GROUP BY 1)),
T2_Optimism AS (SELECT avg(time_difference) AS avg_time_between_blocks,
max(time_difference) AS max_time_between_blocks,
min(time_difference) AS min_time_between_blocks
FROM t1_Optimism),
T1_Arbitrum AS (SELECT block_number,
min_time,
previous_time,
datediff('second',previous_time,min_time) AS time_difference
FROM (SELECT block_number, min(block_timestamp) AS min_time,
lag(min_time,1) ignore nulls over (ORDER BY block_number ASC) AS previous_time
QueryRunArchived: QueryRun has been archived