> Would you be able to confirm if you are still able to see the segmentation fault errors?
Yes, I confirm this. The last one per our logs happened today at 2021-04-13 08:11:32.469 UTC. The segmentation errors are not extremely common (due to low traffic on staging environment), but happen every day, once or twice. This may become a deal breaker should be plan to move our production DB to Google Cloud though.
> does the query involve a LEFT JOIN?
The query definition itself has two JOINs, although not LEFT JOINs. However, one of the joined relations is a view that is defined to have LEFT JOINs in it.
Noted on the SO question. I am not sure what to take from it though...
Noted on the issue tracker too. I'll gather up the info I have so far and will publish there. Thank you!