Defining Database Performance 1172 Understanding the Performance Factors 1172 System Resources 1173 Workload 1173 Throughput 1173 Contention 1173 Optimization 1173 Determining Acceptable Performance 1174 Common Causes of Performance Issues 1176 Identifying Hardware and Segment Failures 1176 Managing Workload 1177 Avoiding Contention 1177 Maintaining Database Statistics 1177 Identifying Statistics Problems 1224 Checking System State 1224 Checking Database Activity 1224 Checking for Active Sessions (Workload) 1224 Checking for Locks (Contention) 1225 VMware Greenplum 6 Documentation VMware by Broadcom

Performance Factors 994 VMware Greenplum v6.18 Documentation VMware, Inc. 57 System Resources 995 Workload 995 Throughput 995 Contention 995 Optimization 995 Determining Acceptable Performance 996 Baseline Common Causes of Performance Issues 0 Identifying Hardware and Segment Failures 998 Managing Workload 999 Avoiding Contention 999 Maintaining Database Statistics 999 Identifying Statistics Problems Activity 1043 VMware Greenplum v6.18 Documentation VMware, Inc. 60 Checking for Active Sessions (Workload) 1043 Checking for Locks (Contention) 1043 Checking Query Status and System Utilization 1044

Performance Factors 1003 VMware Greenplum v6.19 Documentation VMware, Inc. 58 System Resources 1004 Workload 1004 Throughput 1004 Contention 1004 Optimization 1004 Determining Acceptable Performance 1005 Common Causes of Performance Issues 0 Identifying Hardware and Segment Failures 1007 Managing Workload 1008 Avoiding Contention 1008 Maintaining Database Statistics 1008 Identifying Statistics Problems Activity 1052 VMware Greenplum v6.19 Documentation VMware, Inc. 61 Checking for Active Sessions (Workload) 1052 Checking for Locks (Contention) 1052 Checking Query Status and System Utilization 1053

Defining Database Performance 1140 Understanding the Performance Factors 1140 System Resources 1141 Workload 1141 Throughput 1141 Contention 1141 Optimization 1141 Determining Acceptable Performance 1142 Common Causes of Performance Issues 1144 Identifying Hardware and Segment Failures 1144 Managing Workload 1145 Avoiding Contention 1145 Maintaining Database Statistics 1145 Identifying Statistics Problems 1192 Checking System State 1192 Checking Database Activity 1192 Checking for Active Sessions (Workload) 1192 Checking for Locks (Contention) 1193 Checking Query Status and System Utilization 1193

Defining Database Performance 1157 Understanding the Performance Factors 1157 System Resources 1158 Workload 1158 Throughput 1158 Contention 1158 Optimization 1158 Determining Acceptable Performance 1159 Common Causes of Performance Issues 1161 Identifying Hardware and Segment Failures 1161 Managing Workload 1162 Avoiding Contention 1162 Maintaining Database Statistics 1162 Identifying Statistics Problems 1207 Checking System State 1207 Checking Database Activity 1207 Checking for Active Sessions (Workload) 1207 Checking for Locks (Contention) 1208 Checking Query Status and System Utilization 1208

Performance Factors 926 VMware Greenplum v6.17 Documentation VMware, Inc. 53 System Resources 927 Workload 927 Throughput 927 Contention 927 Optimization 927 Determining Acceptable Performance 928 Baseline Common Causes of Performance Issues 0 Identifying Hardware and Segment Failures 932 Managing Workload 933 Avoiding Contention 933 Maintaining Database Statistics 934 Identifying Statistics Problems Activity 978 VMware Greenplum v6.17 Documentation VMware, Inc. 56 Checking for Active Sessions (Workload) 978 Checking for Locks (Contention) 978 Checking Query Status and System Utilization 979 Troubleshooting

Defining Database Performance 978 Understanding the Performance Factors 978 System Resources 979 Workload 979 Throughput 979 Contention 979 Optimization 979 Determining Acceptable Performance 979 Baseline Common Causes of Performance Issues 982 Identifying Hardware and Segment Failures 982 Managing Workload 982 Avoiding Contention 983 Maintaining Database Statistics 983 Identifying Statistics Problems 1021 Checking System State 1021 Checking Database Activity 1021 Checking for Active Sessions (Workload) 1021 Checking for Locks (Contention) 1021 Checking Query Status and System Utilization 1022

Defining Database Performance 1121 Understanding the Performance Factors 1121 System Resources 1122 Workload 1122 Throughput 1122 Contention 1122 Optimization 1122 Determining Acceptable Performance 1122 Hardware and Segment Failures 1125 VMware Tanzu Greenplum 6 Documentation VMware, Inc 51 Managing Workload 1126 Avoiding Contention 1126 Maintaining Database Statistics 1126 Identifying Statistics Problems 1168 Checking System State 1169 Checking Database Activity 1169 Checking for Active Sessions (Workload) 1169 Checking for Locks (Contention) 1169 Checking Query Status and System Utilization 1170

Defining Database Performance 1116 Understanding the Performance Factors 1116 System Resources 1117 Workload 1117 Throughput 1117 Contention 1117 Optimization 1117 Determining Acceptable Performance 1117 Common Causes of Performance Issues 1120 Identifying Hardware and Segment Failures 1120 Managing Workload 1121 Avoiding Contention 1121 Maintaining Database Statistics 1121 Identifying Statistics Problems 1163 Checking System State 1164 Checking Database Activity 1164 Checking for Active Sessions (Workload) 1164 Checking for Locks (Contention) 1164 Checking Query Status and System Utilization 1165

Defining Database Performance 994 Understanding the Performance Factors 994 System Resources 995 Workload 995 Throughput 995 Contention 995 Optimization 995 Determining Acceptable Performance 995 Baseline Common Causes of Performance Issues 998 Identifying Hardware and Segment Failures 998 Managing Workload 999 Avoiding Contention 999 Maintaining Database Statistics 999 Identifying Statistics Problems 1042 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 51 Checking for Active Sessions (Workload) 1042 Checking for Locks (Contention) 1042 Checking Query Status and System Utilization 1043