What are dApps?

dApps are decentralized apps. They are like normal apps and offer similar functions, but the key difference is that they are run on a peer-to-peer network, such as a blockchain, using smart contracts.

As dApps are decentralized, they can’t be controlled by a single person or entity.

Source: decrypt.co

Calculating the gas usage for dApps.

To find the dApp names and their contracts on the Avalanche blockchain, we use data from [avalanche.core.dim_labels].
We use data from [avalanche.core.fact transactions] to find the gas used in transactions. when a user interacts with a dApp in a transaction, the TO_ADDRESS field of the transaction will equal one of the dApp's contract addresses.

The following SQL code shows the gas usage for dApps in the user-selected timespan:

WITH GET_INPUT_TIMESPAN AS (
  SELECT CURRENT_DATE - IFF(TRY_CAST( '{{Timespan_of_results}}' as int) IS NULL, 180, TRY_CAST( '{{Timespan_of_results}}' as int)) AS TIMESPAN
),

DAPPS AS (
SELECT ADDRESS, PROJECT_NAME AS "dApp name"
FROM avalanche.core.dim_labels 
WHERE LABEL_TYPE NOT IN ('chadmin', 'cex', 'token')
 ),

TRANSACTIONS AS (
SELECT TRS.BLOCK_TIMESTAMP, TRS.TX_HASH, FROM_ADDRESS, ADDRESS, "dApp name" ,TX_FEE
 FROM avalanche.core.fact_transactions TRS  JOIN DAPPS ON (TO_ADDRESS = ADDRESS)
 WHERE TRS.BLOCK_TIMESTAMP > (SELECT * FROM GET_INPUT_TIMESPAN) AND TRS.STATUS = 'SUCCESS'
)
SELECT COUNT(DISTINCT(FROM_ADDRESS)) AS "The number of users who used dApps",
COUNT(DISTINCT("dApp name")) "The number of dApps used by users",
COUNT(DISTINCT(TX_HASH)) AS "dApps usage",
SUM(TX_FEE) AS "Gas usage of dApps",
"Gas usage of dApps" / "The number of dApps used by users" AS "Average gas usage per dApp (in AVAX)",
"Gas usage of dApps" / (SELECT DATEDIFF(day, (SELECT * FROM GET_INPUT_TIMESPAN), CURRENT_DATE)) AS "Average gas usage of dApps per day",
"The number of users who used dApps" / (SELECT DATEDIFF(day, (SELECT * FROM GET_INPUT_TIMESPAN), CURRENT_DATE)) AS "Average number of daily users who used dApps "
FROM TRANSACTIONS

EVM - 17. Avalanche Gas Fees