Errors in CDC and query

[p1xel007]

I'm getting this error when running query

exception": "Code: 241. DB::Exception: (total) memory limit exceeded: would use 37.62 GiB (attempt to allocate chunk of 9.15 MiB bytes), current RSS: 1.68 GiB, maximum: 37.61 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker: (avg_value_size_hint = 1024, avg_chars_size = 1219.2, limit = 5959): (while reading column datas): (while reading from part \/var\/lib\/clickhouse\/store\/492\/4922fd1f-cbfd-462f-b82d-ddf3ae4dc04e\/all_11_15_2\/ in table peerdb.platform_datas (4922fd1f-cbfd-462f-b82d-ddf3ae4dc04e) located on disk default of type local, from mark 4 with max_rows_to_read = 5959, offset = 0): While executing MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder). (MEMORY_LIMIT_EXCEEDED) (version 25.7.1.961 (official build))

Also getting this error with clickhouse CDC
Normalization Error: failed to normalize records: error while inserting into target clickhouse table platform_lists: code: 241, message: (total) memory limit exceeded: would use 37.62 GiB (attempt to allocate chunk of 6.00 MiB bytes), current RSS: 1.68 GiB, maximum: 37.61 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker: (while reading column _peerdb_data): (while reading from part /var/lib/clickhouse/store/c99/c995d871-b837-4a75-8004-ecca0649a095/all_16983_17568_6/ in table peerdb._peerdb_raw_selfhosted_clickhouse_mirror (c995d871-b837-4a75-8004-ecca0649a095) located on disk default of type local, from mark 39 with max_rows_to_read = 43, offset = 0): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread)

Any help?