TD Explain_Plan

explain select * from movies.movies;

explain select * from movies.movies;

 *** Help information returned. 12 rows.
 *** Total elapsed time was 1 second.

Explanation
---------------------------------------------------------------------------
  1) First, we lock movies.movies for read on a reserved RowHash to
     prevent global deadlock.
  2) Next, we lock movies.movies for read.
  3) We do an all-AMPs RETRIEVE step from movies.movies by way of an
     all-rows scan with no residual conditions into Spool 1
     (group_amps), which is built locally on the AMPs.  The size of
     Spool 1 is estimated with low confidence to be 1,730 rows (
     425,580 bytes).  The estimated time for this step is 0.04 seconds.
  4) Finally, we send out an END TRANSACTION step to all AMPs involved
     in processing the request.
  -> The contents of Spool 1 are sent back to the user as the result of
     statement 1.  The total estimated time is 0.04 seconds.