Indexing Status

unigraph plugin required

Performing SQL queries on the ENS Unigraph requires that you have the unigraph plugin activated in your ENSNode instance. Learn more

Read the indexing status snapshot for an ENSIndexer instance from the shared ensnode.metadata table. See Connect for setup.

SQL

What is an ENSIndexer Schema?

An ENSIndexer Schema is a database schema within an ENSDb instance, used to store indexed ENS data from a given ENSIndexer instance. We use ensindexer_0 as the ENSIndexer Schema Name in examples on this page, but your ENSIndexer instance may be configured to use a different schema name based on how you configured its `ENSINDEXER_SCHEMA_NAME` environment variable. Make sure to replace ensindexer_0 with the actual schema name used by your ENSIndexer instance when querying the ENSDb instance directly.

SQL

-- Indexing status snapshot for the `ensindexer_0` ENSIndexer Schema
SELECT value -> 'indexingStatus' as indexing_status_snapshot
FROM "ensnode"."metadata"
WHERE ens_indexer_schema_name = 'ensindexer_0'
AND key = 'indexing_metadata_context';

#

indexing_status_snapshot

1

{ "strategy": "omnichain", "snapshotTime": 1779795066, "omnichainSnapshot": { "chains": { "1": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 3327417, "timestamp": 1489165544 } }, "chainStatus": "chain-backfill", "backfillEndBlock": { "number": 25171597, "timestamp": 1779703391 }, "latestIndexedBlock": { "number": 21224717, "timestamp": 1732054691 } }, "10": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 110393959, "timestamp": 1696386695 } }, "chainStatus": "chain-backfill", "backfillEndBlock": { "number": 152052671, "timestamp": 1779704119 }, "latestIndexedBlock": { "number": 128226309, "timestamp": 1732051395 } }, "8453": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 17522624, "timestamp": 1721834595 } }, "chainStatus": "chain-backfill", "backfillEndBlock": { "number": 46457386, "timestamp": 1779704119 }, "latestIndexedBlock": { "number": 22632818, "timestamp": 1732054983 } }, "42161": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 349263357, "timestamp": 1750406457 } }, "chainStatus": "chain-queued" }, "59144": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 6682888, "timestamp": 1720768992 } }, "chainStatus": "chain-backfill", "backfillEndBlock": { "number": 30774477, "timestamp": 1779703911 }, "latestIndexedBlock": { "number": 12280006, "timestamp": 1732054967 } }, "534352": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 16604272, "timestamp": 1750406415 } }, "chainStatus": "chain-queued" } }, "omnichainStatus": "omnichain-backfill", "omnichainIndexingCursor": 1732054983 }, "slowestChainIndexingCursor": 1732054983 }

Output matches a SQL response snapshot; live output depends on your ENSNode instance.

ensdb-sdk (TypeScript)

Reading data from your ENSDb

See how to connect to ENSDb and get access to the ensDb query builder and ensIndexerSchema schema definition in the Connect section if you haven't already.

TypeScript

import { IndexingMetadataContextStatusCodes } from "@ensnode/ensdb-sdk";

const indexingMetadataContext = await ensDbReader.getIndexingMetadataContext();
if (indexingMetadataContext.statusCode === IndexingMetadataContextStatusCodes.Initialized) {
  const indexingStatusSnapshot = indexingMetadataContext.indexingStatus;
  console.log(indexingStatusSnapshot);
}

#	strategy	snapshotTime	omnichainSnapshot	slowestChainIndexingCursor
1	omnichain	1779795066	{ "chains": { "1": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 3327417, "timestamp": 1489165544 } }, "chainStatus": "chain-backfill", "backfillEndBlock": { "number": 25171597, "timestamp": 1779703391 }, "latestIndexedBlock": { "number": 21224717, "timestamp": 1732054691 } }, "10": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 110393959, "timestamp": 1696386695 } }, "chainStatus": "chain-backfill", "backfillEndBlock": { "number": 152052671, "timestamp": 1779704119 }, "latestIndexedBlock": { "number": 128226309, "timestamp": 1732051395 } }, "8453": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 17522624, "timestamp": 1721834595 } }, "chainStatus": "chain-backfill", "backfillEndBlock": { "number": 46457386, "timestamp": 1779704119 }, "latestIndexedBlock": { "number": 22632818, "timestamp": 1732054983 } }, "42161": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 349263357, "timestamp": 1750406457 } }, "chainStatus": "chain-queued" }, "59144": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 6682888, "timestamp": 1720768992 } }, "chainStatus": "chain-backfill", "backfillEndBlock": { "number": 30774477, "timestamp": 1779703911 }, "latestIndexedBlock": { "number": 12280006, "timestamp": 1732054967 } }, "534352": { "config": { "rangeType": "left-bounded", "startBlock": { "number": 16604272, "timestamp": 1750406415 } }, "chainStatus": "chain-queued" } }, "omnichainStatus": "omnichain-backfill", "omnichainIndexingCursor": 1732054983 }	1732054983

Output matches a SQL response snapshot; live output depends on your ENSNode instance.