Greenplum DBA Scripts
- Greenplum: Script to find running queries or statements which are Waiting in Resource Queues
- Greenplum: Script to find information for Long running Queries with occupied resource
- Greenplum: Script to check the size of Database, Schema and Table (Using gp_toolkit schema)
- Greenplum: Script to check Tablespace and Filespace information
- Greenplum: Script to check the full disk space of DCA
- Greenplum: Script to find a list of DISTRIBUTED RANDOMLY Table
- Greenplum: Script to find list of Append Only or Append Optimized Tables
- Greenplum: Script to find the usage of Work spill file per Running Query
- Greenplum: How to find Skewness of table (Skew of data)?
- Greenplum: Script to find Work Spill Files usage for all Segments
- Greenplum: When the last VACUUM or ANALYZE executed on Tables?
- Greenplum: Script to find Role information with associated Resource Queue
- Greenplum: Script to find configuration information of Resource Queues
- Greenplum: Script to find the size and usage statistics of Indexes
- Greenplum: Script to find the size of Column Data
- Greenplum: Script to find list of Roles with Member information
- Greenplum: Script to find all Distribution Keys of Database tables
