EOSDb Ops

Column Descriptions

for eos.db_ops

20 rows

Name	Type	Description
block_date	DATE
block_number	NUMBER
new_payer	TEXT
operation_code	NUMBER
tx_success	BOOLEAN
tx_hash	TEXT
table_name	TEXT
old_data_json	VARIANT
scope	TEXT
operation	TEXT
new_data_json	VARIANT
old_payer	TEXT
primary_key	TEXT
new_data	TEXT
index	NUMBER
code	TEXT
action_index	NUMBER
block_time	TIMESTAMP_NTZ
old_data	TEXT
block_hash	TEXT

Sample Queries

Most Frequent Table Modifications

Identifies the tables that are modified most frequently

SELECT
  code,
  scope,
  table_name,
  COUNT(*) AS modification_count
FROM
  eos.db_ops
GROUP BY
  code,
  scope,
  table_name
ORDER BY
  modification_count DESC
LIMIT
  10;

Find All Operations on a Specific Table

Retrieves all database operations performed on a specific table

SELECT
  *
FROM
  eos.db_ops
WHERE
  code = 'eosio.token'
  AND table_name = 'accounts';

Data Changes for a Specific Primary Key

Tracks the changes in data for a specific primary key over time

SELECT
  block_time,
  operation,
  old_data_json,
  new_data_json
FROM
  eos.db_ops
WHERE
  code = 'eosio.token'
  AND table_name = 'accounts'
  AND primary_key = 'someaccount'
ORDER BY
  block_time;