adm_ai_rag_collection_status_v

RAG collection overview with file counts, chunk statistics, extraction mismatches and job queue counts, for monitoring collection health and indexing progress. AI Pack.

Access scope — Administrative reporting

Applies NO ADM user-access filter. Every matching row in the instance is returned, whoever is querying, and establishing an ADM context does not narrow it. Treat it as an administrative interface: anything built on it carries the whole authorization decision itself.

Overview

Group: Administrative reporting

Category: RAG collections - Monitoring of RAG collections: files, chunks, queue and search log

Use Cases

• Monitor the indexing progress of a RAG collection
• Find collections with failed, empty or unindexed files
• List collections for the RAG collection manager

Columns

The view contains 11 columns providing comprehensive information:

Column Name	Description
rag_collection_id	Primary key of the RAG collection.
active_file_count	Number of active files in the collection.
inactive_file_count	Number of inactive files kept for historical purposes.
total_chunk_count	Total number of chunks from active files.
embedded_chunk_count	Number of chunks that have been embedded in the vector database.
pending_chunk_count	Number of chunks waiting to be embedded.
failed_file_count	Number of active files in status ERROR: a FAILED queue job, or text extraction or chunking that used up its attempt budget. Retry failed resets them.
empty_file_count	Number of active files whose text is empty, so they have no chunks. They do not block READY.
extraction_mismatch_count	Number of active files whose text comes from another reader than the collection asks for (see extraction_mismatch in adm_ai_rag_collection_files_v). Informational: it does not change collection_status.
unindexed_file_count	Number of active files without chunks that neither failed nor have empty text: they wait for text extraction or chunking.
searchable_file_count	Number of active files that have at least one chunk and whose chunks are all embedded.

Description: Overview of RAG collection status including file counts, chunk statistics, and job queue status for monitoring collection health and indexing progress.

Key Features

• Active and inactive file counts
• Chunk counts: total, embedded, pending
• Pending, in progress and failed queue jobs
• A status derived from the file statuses

Related Views

Other views in the RAG collections category:

• adm_ai_rag_collection_files_v
• adm_ai_rag_chunks_v
• adm_ai_rag_job_queue_v
• adm_ai_rag_debug_log_v