Greenplum database ASH (active session history) Report

Post date: Oct 19, 2014 5:46:32 PM

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.