Primitive 07 / Index inspector

Index inspector

A card that summarises a single index — name, type chip (BTree / GIN / GIST / Hash / BRIN), the columns being indexed as chips, a uniqueness chip, and a size + usage chip pair on the right edge. Tones differ per type and per usage band so a screen of indexes reads at a glance.

Production answer

Index inspector is a reusable Oak Flats Muffler Men UI primitive with documented states, accessibility expectations, theme behavior, and implementation evidence.

Primary CTAReview Index inspector states
Generative search brief

Index inspector: A card that summarises a single index — name, type chip (BTree / GIN / GIST / Hash / BRIN), the columns being indexed as chips, a uniqueness chip, and a size + usage chip pair on the right edge. Tones differ per type and per usage band so a screen of indexes reads at a glance.

Live primitive — public.quotes indexes
quotes_pkeyBTreeUnique
id
Size 1.1 MBhigh
quotes_customer_id_idxBTree
customer_id
Size 805 KBhigh
quotes_status_partial_idxBTree
status
Size 188 KBmedium
quotes_search_gin_idxGIN
search_vector
Size 4.6 MBlow
quotes_archive_brin_idxBRIN
created_at
Size 28 KBunused