Re: Never Ending query in PostgreSQL

On 3/1/22 16:01, Kumar, Mukesh wrote: > Hi Tomas , > > Thanks for replying , We have identified a Join condition which is > creating a problem for that query. > > Accept my apologies for pasting the plan twice. I am attaching the > query again in this mail > Queries without explain (or even bet

RE: Never Ending query in PostgreSQL

-Original Message- From: Tomas Vondra Sent: Tuesday, March 1, 2022 7:35 PM To: Jeff Janes ; Kumar, Mukesh Cc: pgsql-performa...@postgresql.org Subject: Re: Never Ending query in PostgreSQL On 2/27/22 18:20, Jeff Janes wrote: > > On Sun, Feb 27, 2022 at 7:09 AM Kumar, Mukesh > m

Re: Never Ending query in PostgreSQL

On 2/27/22 18:20, Jeff Janes wrote: > > On Sun, Feb 27, 2022 at 7:09 AM Kumar, Mukesh > wrote: > > Hi Team,  > > Can you please help in tunning the attached query as , i am trying > to run this query and it runs for several hours and it did not give

Re: Never Ending query in PostgreSQL

On 2/27/22 12:20, Jeff Janes wrote: Several hours is not all that long. Well, the pyramids in the Valley of the Kings last for around 4500 years. Dinosaurs have ruled the Earth for approximately 120 million years. Solar system is 5 billion years old. Cosmos is around 13 billion years old. Co

Re: Never Ending query in PostgreSQL

On 2/26/22 23:40, Kumar, Mukesh wrote: Hi Team, Can you please help in tunning the attached query as , i am trying to run this query and it runs for several hours and it did not give any output. I am not able to generate the explain analyze plan as well and it keeps on running for several h

Re: Never Ending query in PostgreSQL

On Sun, Feb 27, 2022 at 7:09 AM Kumar, Mukesh wrote: > Hi Team, > > Can you please help in tunning the attached query as , i am trying to run > this query and it runs for several hours and it did not give any output. > Several hours is not all that long. Without an EXPLAIN ANALYZE, we could eas

Re: Never Ending query in PostgreSQL

Hi, On Sun, Feb 27, 2022 at 04:40:16AM +, Kumar, Mukesh wrote: > > Can you please help in tunning the attached query as , i am trying to run > this query and it runs for several hours and it did not give any output. > > I am not able to generate the explain analyze plan as well and it keeps on

Never Ending query in PostgreSQL

Hi Team, Can you please help in tunning the attached query as , i am trying to run this query and it runs for several hours and it did not give any output. I am not able to generate the explain analyze plan as well and it keeps on running for several hours and did not give output. I have attac