Function Call Analysis

m3jiFunction Call Analysis

Updated 2025-05-08

SELECT

origin_function_signature,

COUNT(*) AS call_count,

COUNT(DISTINCT from_address) AS unique_callers,

AVG(gas_used) AS avg_gas,

AVG(tx_fee_precise) AS avg_fee,

(SUM(CASE WHEN tx_succeeded = false THEN 1 ELSE 0 END) / NULLIF(COUNT(*), 0)) * 100 AS failure_rate_percent

FROM scroll.core.fact_transactions

WHERE

origin_function_signature IS NOT NULL

AND block_timestamp >= DATEADD(day, -90, CURRENT_DATE())

GROUP BY origin_function_signature

ORDER BY call_count DESC

LIMIT 50;

Last run: about 2 months ago

	ORIGIN_FUNCTION_SIGNATURE	CALL_COUNT	UNIQUE_CALLERS	AVG_GAS	AVG_FEE	FAILURE_RATE_PERCENT
1	0x	417041	142606	26219.367789	0.000005671494821	0.0022
2	0x39455d3a	405951	1	40828.611921	0.000002393903637	0
3	0x095ea7b3	195712	77582	47715.055546	0.000004847938877	0.0864
4	0xa15112f9	168497	19541	137589.342653	0.000008625509372	1.2778
5	0xa00597a0	157912	5	151372.932165	0.000007495724421	2.566
6	0x3161b7f6	153860	1	37988.152242	0.000003370124684	0
7	0xb143044b	104732	1	69916.873534	0.000005363907177	0
8	0x00000000	86237	308	247289.818744	0.00002020759814	15.2371
9	0xc9807539	82169	25	146646.928671	0.00001159755411	1.3691
10	0xf923cc28	81359	2	231816.232255	0.00001187744184	5.5802
11	0xa9059cbb	80521	39461	48070.367556	0.00001661179268	2.3807
12	0x49a1a4fb	53518	1	226213.156396	0.00001228047826	0
13	0xcfc32570	53508	1	100548.976658	0.000007054604212	0
14	0x0894edf1	53212	1	76743.348493	0.000005192666222	0
15	0xc7c7f5b3	44436	26517	198467.917207	0.00001080143171	0.6099
16	0xa66f42c0	35645	1166	40570.91839	0.000002871082093	2.696
17	0x051d22a4	33620	1	244620.844497	0.00001475291768	0
18	0xb61d27f6	32777	8	153969.129786	0.000009390716055	31.1072
19	0x37523745	31727	4	217437.543732	0.00004159492528	0.2522
20	0x796c8ce6	27158	1	100612.243133	0.000008012901488	86.3208

3KB

flipside