Indexing Status

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

SQL

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

ensdb-sdk (TypeScript)

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

const indexingMetadataContext = await ensDbReader.getIndexingMetadataContext();
if (indexingMetadataContext.statusCode === IndexingMetadataContextStatusCodes.Initialized) {
  const indexingStatusSnapshot = indexingMetadataContext.indexingStatus;
  // Do something with the indexing status snapshot
}