Re: [PERFORM] query runs for more than 24 hours!

2017-08-25 Thread vinny
On 2017-08-22 16:23, Mariel Cherkassky wrote: SELECT a.inst_prod_id, product_id, nap_area2, nap_phone_num, nap_product_id,

Re: [PERFORM] query runs for more than 24 hours!

2017-08-22 Thread Tomas Vondra
On 08/22/2017 04:23 PM, Mariel Cherkassky wrote: Hi, I have a query that I run in my postgresql 9.6 database and it runs for more than 24 hours and doesnt finish. My select consist from few joins : I'm sorry, but the query and plans are completely broken (wrapped in funny ways, missing im