WAXTransactions

Column Descriptions

for wax.transactions

17 rows

Sample Queries

Average Transaction CPU Usage

Calculates the average CPU usage per transaction

SELECT
  AVG(cpu_usage_micro_seconds) AS average_cpu_usage
FROM
  wax.transactions;

Find Transactions with High Net Usage

Identifies transactions with a net usage greater than a specific threshold

SELECT
  hash,
  net_usage
FROM
  wax.transactions
WHERE
  net_usage > 1000
ORDER BY
  net_usage DESC;

Failed Transaction Count per Day

Calculates the number of failed transactions for each day

SELECT
  block_date,
  COUNT(*) AS failed_transactions
FROM
  wax.transactions
WHERE
  success = FALSE
GROUP BY
  block_date
ORDER BY
  block_date;