Comment on Amazon RedShift vs. local PostgreSQLComments−Whitespace13yWouldn't it have been better to do an EXPLAIN ANALYZE for the timing measurements instead of having the results returned locally?−fusiongyro13yIt would certainly be interesting to see what Redshift returns when you do that.−rarestblogOP13yHonestly I don't know. Do you think it would be better? Could you explain why?−kapilvt13ybecause 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.−rarestblogOP13yAhhh, 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
Comments
Wouldn't it have been better to do an EXPLAIN ANALYZE for the timing measurements instead of having the results returned locally?
It would certainly be interesting to see what Redshift returns when you do that.
Honestly I don't know. Do you think it would be better? Could you explain why?
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.
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