rackhaelPolygon Vs Osmosis Vs Flow Block Performance Time
Updated 2022-07-29
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
›
⌄
WITH Table1_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)),
Table2_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 table1_Polygon),
Table1_flow AS (SELECT block_height,
min_time,
previous_time,
datediff('second',previous_time,min_time) AS time_difference
FROM (SELECT block_height, min(block_timestamp) AS min_time,
lag(min_time,1) ignore nulls over (ORDER BY block_height ASC) AS previous_time
FROM flow.core.fact_blocks
GROUP BY 1)),
Table2_flow 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 table1_flow),
Table1_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
FROM arbitrum.core.fact_blocks
GROUP BY 1)),
Run a query to Download Data