Check Vector Index State

This example reads AkasicDB vector index state immediately after index creation, after fence_vector_index, and after additional writes.

DROP TABLE IF EXISTS akasicdb_example_index_events;

CREATE TABLE akasicdb_example_index_events (
  id integer PRIMARY KEY,
  event_name text NOT NULL,
  embedding vector(4) NOT NULL
);

INSERT INTO akasicdb_example_index_events (id, event_name, embedding) VALUES
  (1, 'search opened', ARRAY[0.10,0.20,0.30,0.00]::real[]::vector),
  (2, 'search refined', ARRAY[0.11,0.21,0.29,0.01]::real[]::vector),
  (3, 'result clicked', ARRAY[0.12,0.22,0.28,0.02]::real[]::vector),
  (4, 'filter applied', ARRAY[0.13,0.23,0.27,0.03]::real[]::vector),
  (5, 'item saved', ARRAY[0.30,0.10,0.20,0.04]::real[]::vector),
  (6, 'item shared', ARRAY[0.31,0.11,0.19,0.05]::real[]::vector),
  (7, 'cart updated', ARRAY[0.40,0.30,0.10,0.06]::real[]::vector),
  (8, 'checkout started', ARRAY[0.41,0.31,0.09,0.07]::real[]::vector),
  (9, 'recommendation shown', ARRAY[0.14,0.24,0.26,0.03]::real[]::vector),
  (10, 'recommendation dismissed', ARRAY[0.15,0.25,0.25,0.04]::real[]::vector),
  (11, 'profile viewed', ARRAY[0.50,0.20,0.20,0.08]::real[]::vector),
  (12, 'profile edited', ARRAY[0.51,0.21,0.19,0.09]::real[]::vector);

CREATE INDEX akasicdb_index_events_embedding_idx
ON akasicdb_example_index_events
USING vectoron (embedding vector_l2_ops)
WITH (options = $$
[indexing.hnsw]
$$);

SELECT idx_status, idx_indexing, idx_tuples, idx_write
FROM vectoron_index_stat
WHERE indexname = 'akasicdb_index_events_embedding_idx';

SELECT fence_vector_index('akasicdb_index_events_embedding_idx'::regclass);

SELECT idx_status, idx_indexing, idx_tuples, idx_write
FROM vectoron_index_stat
WHERE indexname = 'akasicdb_index_events_embedding_idx';

INSERT INTO akasicdb_example_index_events (id, event_name, embedding) VALUES
  (13, 'search exported', ARRAY[0.16,0.26,0.24,0.05]::real[]::vector),
  (14, 'saved search opened', ARRAY[0.17,0.27,0.23,0.06]::real[]::vector),
  (15, 'alert created', ARRAY[0.52,0.22,0.18,0.10]::real[]::vector),
  (16, 'alert delivered', ARRAY[0.53,0.23,0.17,0.11]::real[]::vector);

SELECT idx_status, idx_indexing, idx_tuples, idx_write
FROM vectoron_index_stat
WHERE indexname = 'akasicdb_index_events_embedding_idx';

Returned Fields

Field	Meaning
idx_status	Confirms that a stat row exists for the index
idx_indexing	Shows whether index work is still running
idx_tuples	Tracks indexed tuple count for the example table
idx_write	Shows write-segment activity after additional inserts