Re: Slow GroupAggregate and Sort

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 wrote: Hello, Happy New Year! I add my responses in blue. El Thu, 28 Dec 2023 13:06:18 -0500, Jeff Ja

Re: Slow GroupAggregate and Sort

On Mon, Jan 1, 2024 at 9:57 AM Darwin Correa wrote: > Hello, Happy New Year! I add my responses in blue. > > > > El Thu, 28 Dec 2023 13:06:18 -0500, *Jeff Janes > >* escribió > > I thought the point of sharding was to bring more CPU and RAM to bear than > can feasibly be obtained in one

Re: Slow GroupAggregate and Sort

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 wrote: when run the query (query.sql)  as you can see in explain (plan4_v3.txt) citus t

Re: Slow GroupAggregate and Sort

On Thu, Dec 28, 2023 at 12:03 PM Darwin Correa wrote: > > when run the query (query.sql) as you can see in explain (plan4_v3.txt) > citus take about 18s to run all fragments > Where is plan4_v3.txt? Is that hidden in some non-obvious way in one of your links? > but each fragment take at most

Slow GroupAggregate and Sort

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