It's possible that the query is not being allocated enough memory to fully utilize the available RAM. Greenplum might be configured to limit memory usage for individual queries, leading to low RAM utilization despite the overall system having sufficient memory.