4 ms·
Wouldn't it have been better to do an EXPLAIN ANALYZE for the timing measurements instead of having the results returned locally?
by Whitespace 14y ago
Wouldn't it have been better to do an EXPLAIN ANALYZE for the timing measurements instead of having the results returned locally?
- rarestblog 14y agoHonestly I don't know. Do you think it would be better? Could you explain why?
- kapilvt 14y agobecause 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.
- rarestblog 14y agoAhhh, 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 http://docs.aws.amazon.com/redshift/latest/dg/r_EXPLAIN.html
- fusiongyro 14y agoIt would certainly be interesting to see what Redshift returns when you do that.