PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> If we execute the following query it will not return and more than one
> postgres.exe have high load.
This is not a bug, or at least you've presented no evidence why
it should be considered one. Actually, you've presented no evidence
period, because an unintelligible query given in isolation isn't
something anyone can comment on. Please review
https://wiki.postgresql.org/wiki/Slow_Query_Questions
regards, tom lane