# FLUSH EXTRACTOR POOLS

Extractor pools are used in pipeline architecture by caching extractors (i.e., data consumers) per node to increase the data consumption speed.

Used to flush the extractor pools on a current node or all nodes

## Syntax

```sql
FLUSH EXTRACTOR POOLS;
```

```sql
FLUSH NODE EXTRACTOR POOLS;
```

## Remarks

* `flush extractor pools`: flushes extractor pools on each online node - aggregator/leaf.
* `flush node extractor pools`: flushes extractor pools on the current node only.

## Examples

```sql
FLUSH EXTRACTOR POOLS;

```

```output

Query OK, 10 rows affected (3.01 sec)
```

## Related Topics

* [Sync Variables Lists](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables/list-of-engine-variables/#sync-variables-lists.md)

***

Modified at: July 31, 2023

Source: [/db/v9.1/reference/sql-reference/cluster-management-commands/flush-extractor-pools/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/flush-extractor-pools/)

(An index of the documentation is available at /llms.txt)