Key things to look in Greenplum SQL Query Plans

To find the node or operator that is consuming the most resource and taking the most time

Two ways to get a plan

Explain select … from … where …;

Explain analyze select … from … where …;