Hu, any luck figuring this out?

I've noticed this as well - 100% CPU usage and occasional memory leak behavior. Removing the predicate/filters from the query resolved the issue. Very strange.