DAY | FUNCTION_CALLED | CALLS_COUNT | TOTAL_GAS_USED | TOTAL_TX_FEE | |
|---|---|---|---|---|---|
1 | 2023-07-03 00:00:00.000 | enqueue(address,uint256,bytes) | 2 | 173182 | 0.005797115749 |
2 | 2023-07-04 00:00:00.000 | enqueue(address,uint256,bytes) | 2 | 176116 | 0.002966342613 |
3 | 2023-07-04 00:00:00.000 | appendSequencerBatch() | 87 | 9334237 | 0.1827811762 |
4 | 2023-07-05 00:00:00.000 | appendSequencerBatch() | 5 | 941744 | 0.04834892129 |
5 | 2023-07-06 00:00:00.000 | appendSequencerBatch() | 72 | 7609851 | 0.2774106076 |
6 | 2023-07-07 00:00:00.000 | appendSequencerBatch() | 91 | 9601251 | 0.3142117594 |
7 | 2023-07-08 00:00:00.000 | appendSequencerBatch() | 94 | 9833608 | 0.1918822301 |
8 | 2023-07-09 00:00:00.000 | appendSequencerBatch() | 91 | 9525183 | 0.1688126423 |
9 | 2023-07-10 00:00:00.000 | appendSequencerBatch() | 92 | 9690897 | 0.2080632011 |
10 | 2023-07-11 00:00:00.000 | appendSequencerBatch() | 93 | 10066881 | 0.2191077176 |
11 | 2023-07-12 00:00:00.000 | appendSequencerBatch() | 92 | 9993242 | 0.2705637762 |
12 | 2023-07-13 00:00:00.000 | appendSequencerBatch() | 92 | 9985435 | 0.3101367066 |
13 | 2023-07-14 00:00:00.000 | appendSequencerBatch() | 91 | 9899843 | 0.2348406436 |
14 | 2023-07-15 00:00:00.000 | appendSequencerBatch() | 93 | 9950180 | 0.139208044 |
15 | 2023-07-16 00:00:00.000 | appendSequencerBatch() | 92 | 9776495 | 0.1556345461 |
16 | 2023-07-17 00:00:00.000 | appendSequencerBatch() | 97 | 15363499 | 0.3529412892 |
17 | 2023-07-18 00:00:00.000 | appendSequencerBatch() | 92 | 17862480 | 0.5530869586 |
18 | 2023-07-19 00:00:00.000 | appendSequencerBatch() | 94 | 15667337 | 0.3989687106 |
19 | 2023-07-20 00:00:00.000 | appendSequencerBatch() | 97 | 18256004 | 0.4869019324 |
20 | 2023-07-21 00:00:00.000 | appendSequencerBatch() | 95 | 20841498 | 0.5922374929 |
10Blockchain2) Aller plus loin (analyse des fonctions appelées)
Updated 2025-02-24
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
›
⌄
WITH ctc_calls AS (
SELECT
block_timestamp,
SUBSTRING(input_data, 1, 10) AS fourbyte_signature,
tx_hash,
gas_used,
tx_fee
FROM ethereum.core.fact_transactions
WHERE to_address IN (
'0x291dc3819b863e19b0a9b9809f8025d2eb4aae93', -- CTC
'0x89E9D387555AF0cDE22cb98833Bae40d640AD7fa' -- SCC
)
)
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
CASE
WHEN fourbyte_signature = '0xd0f89344' THEN 'appendSequencerBatch()'
WHEN fourbyte_signature = '0x6fee07e0' THEN 'enqueue(address,uint256,bytes)'
ELSE 'other'
END AS function_called,
COUNT(DISTINCT tx_hash) AS calls_count,
SUM(gas_used) AS total_gas_used,
SUM(tx_fee) AS total_tx_fee
FROM ctc_calls
GROUP BY 1,2
ORDER BY day;
Last run: about 2 months ago
...
258
20KB
58s