Memory limit has been exceeded during query execution

Written by

Updated at January 18, 2024

ERR.DS_API.DB.MEMORY_LIMIT_EXCEEDED

There is not enough memory in the data source to run the query.

The error occurs when the database does not have enough memory to run a query from DataLens.

To correct the error, optimize the source table or reduce the amount of data in the query using chart filters.

To optimize tables, contact your database administrator.

If you are going to perform optimization yourself, try enhancing your database with indexes and sorts.

Tip

If ClickHouse® is your data source, find queries from DataLens in system.query_log.

If PostgreSQL MDB is your data source, review the performance analysis.

ClickHouse® is a registered trademark of ClickHouse, Inc.