adm_ai_rag_job_queue_v

RAG job queue with collection and document information, retry counts and processing times, for monitoring job progress and troubleshooting failures. AI Pack.

Overview

Group: Administrative reporting

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

Use Cases

Watch the indexing queue
Troubleshoot failed jobs and their error messages

Columns

The view contains 19 columns providing comprehensive information:

Column Name	Description
`indexing_queue_id`	Primary key of the indexing queue entry.
`rag_collection_file_id`	Foreign key to the RAG collection file.
`job_type`	Type of job: EMBEDDING or REMOVE.
`status`	Status of the job: PENDING, IN_PROGRESS, COMPLETED, or FAILED.
`error_message`	Error message if the job failed.
`retry_count`	Number of retry attempts.
`created_date`	Timestamp when the job was created.
`created_by`	User who created the job.
`updated_date`	Timestamp when the job was last updated.
`updated_by`	User who last updated the job.
`rag_collection_id`	Foreign key to the RAG collection.
`collection_name`	Name of the RAG collection.
`version_id`	Foreign key to the document version.
`document_name`	Name of the document.
`file_mime_type`	MIME type of the document.
`file_size`	Size of the file in bytes.
`version_number`	Version number of the document.
`minutes_since_created`	Minutes elapsed since the job was created.
`processing_duration_minutes`	Minutes taken to process the job (only for completed/failed jobs).

Description: Comprehensive view of the RAG job queue with collection and document information for monitoring job progress and troubleshooting failures.

Key Features

One row per queue job
Status, error message and retry count
Minutes since creation and processing duration