Query is taking too long i intermittent

of the running process and sometime after 2 - 3 weeks of the running process. We add a new partition to the table every Sunday and write new data in the new partition. -- regards Mayank Kandari

Re: Query is taking too long i intermittent

Thanks for the tip! I will update my process and monitor it. On Mon, Jun 6, 2022 at 7:41 PM Tom Lane wrote: > Justin Pryzby writes: > > On Mon, Jun 06, 2022 at 03:28:43PM +0530, Mayank Kandari wrote: > >> SELECT event_id FROM event WHERE (event_sec > time.seconds