Memory leak or very high usage

I'm pulling a SELECT of 3 short text columns and expecting 101K rows.

Heidi crashed a couple times but I observe a VERY HIGH memory usage

So far I only had a couple screenshots and the original query if it helps. Let me know what other debug info could I grab.

A short result set:

The original query: SELECT CONCAT(iu.first_name, ' ',iu.last_name) AS user_full_name, iu.email, ia.name AS account_name FROM iaa_users iu JOIN iaa_accounts ia WHERE iu.email != 'anonymous@default.com'

OS: Win 11 x64

Sorry, I had an error in the SQL. It is my fault. I've missed the joining column and then that created an exponential number of rows: about ten and a half million.

My bad.

I'm leaving this message so you're aware. I'll try otherwise please remove the thread Anse.

Glad you fixed it, and lucky me it's not a bug :).

It's probably helpful for others so I'll keep this thread open.