How to check database activity?
Post date: Oct 27, 2012 11:10:59 PM
Checking for Active Sessions (Workload)
Checking for Locks (Contention)
Checking Query Status and System Utilization
For details see https://sites.google.com/a/greenplumdba.com/gpdb/checking-database-activity-in-greenplum