MONTH | AVG(TPS) | |
|---|---|---|
1 | 2024-09-01 00:00:00.000 | 0.513323733333 |
2 | 2021-12-01 00:00:00.000 | 0.027358483871 |
3 | 2024-05-01 00:00:00.000 | 0.503565193548 |
4 | 2024-11-01 00:00:00.000 | 0.5300498 |
5 | 2021-11-01 00:00:00.000 | 0.0763488 |
6 | 2024-08-01 00:00:00.000 | 0.514457548387 |
7 | 2023-08-01 00:00:00.000 | 0.004564387097 |
8 | 2022-09-01 00:00:00.000 | 0.012738866667 |
9 | 2023-11-01 00:00:00.000 | 0.0044926 |
10 | 2022-01-01 00:00:00.000 | 0.013553193548 |
11 | 2022-02-01 00:00:00.000 | 0.025613071429 |
12 | 2024-07-01 00:00:00.000 | 0.518511064516 |
13 | 2024-10-01 00:00:00.000 | 0.512591193548 |
14 | 2023-04-01 00:00:00.000 | 0.005350733333 |
15 | 2022-04-01 00:00:00.000 | 0.040988833333 |
16 | 2023-02-01 00:00:00.000 | 0.007614071429 |
17 | 2022-07-01 00:00:00.000 | 0.017634677419 |
18 | 2023-12-01 00:00:00.000 | 0.004690548387 |
19 | 2025-01-01 00:00:00.000 | 0.530800870968 |
20 | 2024-04-01 00:00:00.000 | 0.241733466667 |
elsinatps
Updated 2025-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with daily as (
SELECT
date_trunc('day', block_timestamp) as date,
24 * 60 * 60 AS seconds_per_day,
count(DISTINCT tx_hash) / seconds_per_day as TPS
from
boba.core.fact_transactions
group by
date
order by
date asc
)
select
date_trunc('month', date) as month,
avg(tps)
from daily
group by 1
Last run: 18 days ago
42
2KB
2s