Redshift Query Plan Execution

QUERY PLAN EXECUTION joins the Query Explain Plan with the actual query execution data to give you a deep understanding of your query performance. This powerful tool combines the Query Explain Plan with actual query execution data, giving you a complete picture of how your queries are running. With Query Plan Execution, you'll be able to identify any bottlenecks or inefficiencies in your query plan and make informed decisions on how to optimize your query performance.

Before... The query plan has limited use to optimize the query because the actual performance of each line in the query plan is unknown.

Now... The actual performance (in query run time, rows returned, and bytes scanned) of each line in the query plan is known, highlighting areas of optimization opportunity.

Turn the Explain Plan...

Into an Actionable Dataset to optimize the query...

• "Segment Execution Time" indicates the longest running lines of the SQL Code.
• Exec_rows and Exec_mb provide further insights to the performance of each line.
• Included (not shown) are the Redshift System Alerts (when applicable) for each line of the query plan.