Greenplum database ASH (active session history) Report

posted Oct 19, 2014, 10:46 AM by Sachchida Ojha
This report displays the information related to active sessions such as
  1.  No of Active Sessions
  2.  No of Waiting Sessions
  3. Resources (CPU, MEMORY, DISK READ, DISK WRITE, NETWORK READ, NETWORK WRITE, LOAD ON DCA) consumed by active sessions
  4. Most used resource queue 
  5. SWAP used
  6. Query Submit time, Start time and Query Text
  7. Which database user is running most of the queries  and what resource queue is being used by those queries
  8.  Locks
  9.  Idle Sessions
  10. Long running queries
Note: As of today, I have not found this report on Pivotal documents so I thought of creating one for my internal use only.