Query cancellation freezes on local lazy queries

The reason is a query cancellation that acquires an iterator's lock to check the availability of a next row and thus update a state of the cursor to prevent unnecessary request cancelation. But the lock is already held by a query thread to fetch a next page, so the cancellation is forced to wait till the page will be completely prefetched.