Greenplum
- Greenplum: Script to find Table Fragmentation and total wasted space
- Greenplum: gp_bloat_diag to get the list of pending VACUUM of Tables
- Greenplum: gp_stats_missing to get the list of pending ANALYZE of Tables
- Greenplum: How to Troubleshoot running Database Backup Process
- Greenplum: Script to find blocked and deadlock by other blocking queries
- Greenplum: Find long running sessions with lock information
- Greenplum: Script to find running queries or statements which are Waiting in Resource Queues
- Greenplum: How to Start and Stop Database?
- 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: How to reset the Priority of Running Statement or Transaction?
- Greenplum: Important Queries to Configure the Resource Queue (Workload Management)
- Greenplum: Important Parameters of Resource Queue (Workload Management)
- Greenplum: Alter Table Distribution Key or Policy
- 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
