Re: Slow GroupAggregate and Sort

2024-01-07 Thread Darwin Correa
Hello, my answers in blue again El Wed, 03 Jan 2024 21:43:15 -0500, Jeff Janes escribió On Mon, Jan 1, 2024 at 9:57 AM Darwin Correa <mailto:dcorrea@jedai.group> wrote: Hello, Happy New Year! I add my responses in blue. El Thu, 28 Dec 2023 13:06:18 -0500

Re: Slow GroupAggregate and Sort

2024-01-01 Thread Darwin Correa
Hello, Happy New Year! I add my responses in blue. El Thu, 28 Dec 2023 13:06:18 -0500, Jeff Janes escribió On Thu, Dec 28, 2023 at 12:03 PM Darwin Correa <mailto:dcorrea@jedai.group> wrote: when run the query (query.sql)  as you can see in explain (plan4_v3.txt)

Slow GroupAggregate and Sort

2023-12-28 Thread Darwin Correa
Hello great day, we have a strange case with slow query and would like some help. I've already read the article https://wiki.postgresql.org/wiki/Slow_Query_Questions Explain: https://paste.depesz.com/s/PLP Explain2: https://explain-postgresql.com/archive/explain/8e4b573c5f7bcf3a0d30675