> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# vectorizer_queue_pending

> Retrieve the number of pending items for a specific vectorizer

Retrieve the number of items in a vectorizer queue when you need to focus on a particular vectorizer or troubleshoot issues.

* Retrieve the number of pending items for a specific vectorizer
* Allow for more granular monitoring of individual vectorizer queues

## Samples

### Using vectorizer name

```sql theme={"dark"}
SELECT ai.vectorizer_queue_pending('public_blog_embeddings');
```

### Using vectorizer ID

```sql theme={"dark"}
SELECT ai.vectorizer_queue_pending(1);
```

### Get exact count

A queue with a very large number of items may be slow to count. The optional `exact_count` parameter is defaulted to false. When false, the count is limited. An exact count is returned if the queue has 10,000 or fewer items, and returns 9223372036854775807 (the max bigint value) if there are greater than 10,000 items.

To get an exact count, regardless of queue size:

```sql theme={"dark"}
-- Using name (recommended)
SELECT ai.vectorizer_queue_pending('public_blog_embeddings', exact_count=>true);

-- Using ID
SELECT ai.vectorizer_queue_pending(1, exact_count=>true);
```

## Arguments

`ai.vectorizer_queue_pending` can be called in two ways:

### With vectorizer name (recommended)

| Name         | Type | Default | Required | Description                                             |
| ------------ | ---- | ------- | -------- | ------------------------------------------------------- |
| name         | text | -       | ✔        | The name of the vectorizer you want to check            |
| exact\_count | bool | false   | ✖        | If true, return exact count. If false, capped at 10,000 |

### With vectorizer ID

| Name           | Type | Default | Required | Description                                             |
| -------------- | ---- | ------- | -------- | ------------------------------------------------------- |
| vectorizer\_id | int  | -       | ✔        | The identifier of the vectorizer you want to check      |
| exact\_count   | bool | false   | ✖        | If true, return exact count. If false, capped at 10,000 |

## Returns

The number of items in the queue for the specified vectorizer.