'Why query takes indefinite amount of time to execute in certain date range?

I have a query that I'm trying to execute and when I take certain range, for example, 7th week of 2022, it never executes, but when I'm running query for the same week in previous year it executes well. What could be the reason of such behaviour?

It seems that it goes like that in all date ranges of February 2022.

sqlpostgresqlgreenplum


Solution 1:[1]

May be previous year has less data so the related partition returned the result quickly.

Solution 2:[2]

check on the segment host, is the segment process busy, maybe try pstack the query process and see what its doing

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Anilkumar Nandala
Solution 2 Ivan Novick

Related Questions