DAY | Daily Average Block Utilization (%) | |
|---|---|---|
1 | 2024-06-07 00:00:00.000 | 2.0814540006 |
2 | 2024-06-08 00:00:00.000 | 17.1996360182 |
3 | 2024-06-09 00:00:00.000 | 18.4021005427 |
4 | 2024-06-10 00:00:00.000 | 4.7596131237 |
5 | 2024-06-11 00:00:00.000 | 5.5348405042 |
6 | 2024-06-12 00:00:00.000 | 7.132710685 |
7 | 2024-06-13 00:00:00.000 | 8.1041797418 |
8 | 2024-06-14 00:00:00.000 | 11.1987978473 |
9 | 2024-06-15 00:00:00.000 | 6.5175927279 |
10 | 2024-06-16 00:00:00.000 | 9.2909395175 |
11 | 2024-06-17 00:00:00.000 | 12.9261459113 |
12 | 2024-06-18 00:00:00.000 | 11.7492262082 |
13 | 2024-06-19 00:00:00.000 | 16.9115008566 |
14 | 2024-06-20 00:00:00.000 | 25.2878116119 |
15 | 2024-06-21 00:00:00.000 | 35.1651497793 |
16 | 2024-06-22 00:00:00.000 | 27.0303618534 |
17 | 2024-06-23 00:00:00.000 | 25.9343195924 |
18 | 2024-06-24 00:00:00.000 | 30.7277598387 |
19 | 2024-06-25 00:00:00.000 | 25.5480492306 |
20 | 2024-06-26 00:00:00.000 | 24.4084522262 |
Mrftieager-gray
Updated 2025-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
WITH daily_block_data AS
(
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
AVG(GAS_USED / NULLIF(GAS_LIMIT, 0)) * 100 AS daily_avg_block_utilization
FROM berachain.testnet.fact_blocks
GROUP BY 1
)
SELECT
day,
daily_avg_block_utilization AS "Daily Average Block Utilization (%)"
FROM daily_block_data
ORDER BY 1
Last run: about 2 months agoAuto-refreshes every 12 hours
...
246
10KB
6s