datavortexfunction calls
Updated 2024-12-06
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 deployed_contracts AS (
SELECT
signer_id AS "deployers",
COUNT(DISTINCT tx_hash) AS "total_contracts_deployed"
FROM
near.core.fact_actions_events
WHERE
action_name = 'DeployContract'
AND receipt_succeeded = TRUE
GROUP BY
signer_id
ORDER BY
"total_contracts_deployed" DESC
LIMIT 10
),
method_counts AS (
SELECT
d."deployers",
d."total_contracts_deployed",
a.method_name,
COUNT(DISTINCT a.tx_hash) AS "method_call_count",
ROW_NUMBER() OVER (PARTITION BY d."deployers" ORDER BY COUNT(DISTINCT a.tx_hash) DESC) AS rn
FROM
deployed_contracts d
JOIN
near.core.fact_actions_events_function_call a
ON d."deployers" = a.signer_id
GROUP BY
d."deployers", d."total_contracts_deployed", a.method_name
)
SELECT
"deployers",
"total_contracts_deployed",
method_name,
QueryRunArchived: QueryRun has been archived