pinax-network / subgraph-antelope-transactions

Subgraph Antelope Transactions
https://thegraph.com/explorer/subgraphs/4bAe7NA8b6J14ZfZr3TXfzzjjSoGECTFuqv7CwnK1zzg?view=Query&chain=arbitrum-one
MIT License
0 stars 0 forks source link
subgraph

Subgraph: Antelope Transactions

Transactions, Decoded Actions & Database Operations

WAX, EOS, Ultra, Telos... sf.antelope.type.v1.Block

Chains

Chain Subgraph ID
WAX 4bAe7NA8b6J14ZfZr3TXfzzjjSoGECTFuqv7CwnK1zzg
EOS 2RNdhL5p62dGN5UqKtsSEhYZiTJbFcuuhzk9qRJj8QeU

GraphQL

{
  actions(
    where: {isNotify: false, account: "eosio.token"}
    orderBy: block__number
    orderDirection: desc
  ) {
    block{
      number
      time
    }
    transaction {
      id
    }
    account
    name
    jsonData
    dbOps {
      code
      tableName
      primaryKey
      newDataJson
    }
  }
}

Substreams Modules

graph TD;
  graph_out[map: graph_out];
  sf.antelope.type.v1.Block[source: sf.antelope.type.v1.Block] --> graph_out;

Operator Instructions

To improve Graph Node syncing performance, operators can drop the following Postgres indexes which reference *_data fields:

DROP INDEX IF EXISTS sgd1.attr_0_3_action_json_data;
DROP INDEX IF EXISTS sgd1.attr_0_4_action_raw_data;
DROP INDEX IF EXISTS sgd1.attr_1_8_db_op_new_data_json;
DROP INDEX IF EXISTS sgd1.attr_1_9_db_op_new_data;
DROP INDEX IF EXISTS sgd1.attr_1_10_db_op_old_data_json;
DROP INDEX IF EXISTS sgd1.attr_1_11_db_op_old_data;

Note: For multiple Subgraphs, replace sgd1 with the appropriate Subgraph table name.

Example queries

Available query fields

These are the expressions that can be used in queries:

Queries can include && and || logical operands, as well as ( and ) parenthesis.