Redshift query explainer

Explain and understand query for Redshift.