Hacker News new | ask | show | jobs
by Whitespace 4868 days ago
Wouldn't it have been better to do an EXPLAIN ANALYZE for the timing measurements instead of having the results returned locally?
2 comments
fusiongyro 4868 days ago
It would certainly be interesting to see what Redshift returns when you do that.
link
rarestblog 4868 days ago
Honestly I don't know. Do you think it would be better? Could you explain why?
link
kapilvt 4868 days ago
because it shows the estimated cost (plan) of the queries independent of the magically subtracted network roundtrip time. it also serves to show if the redshift even supports it.it.
link
rarestblog 4868 days ago
Ahhh, you meant on the RedShift side. I did not think of it. It would have definitely been better. Good point!

It seems that it actually supports it http://docs.aws.amazon.com/redshift/latest/dg/r_EXPLAIN.html

link