@Ajay Pandey​  Yes initially it was running in 4 workers ..now after scaling upto 8 workers also from past 6 hours i dont see any movement and it was telling filtering as per screen shot. Not sure to tune nothing is there in the query other than insert and coalesce function for few variables. Need quick help from tuning it and as well debugging the issue for optimization parameters