Amazon Redshift Guía de usuario Pagina 196
- Pagina / 255
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
The Avg statistic shows the average execution time for the step across data slices, and the percentage
of the total query runtime that represents. The Max statistic shows the longest execution time for the
step on any of the data slices, and the skew. The skew is the difference between the average and
maximum execution times for the step.You might want to investigate a step if the maximum execution
time is consistently more than twice the average execution time over multiple runs of the query, and if
the step also takes a significant amount of time (for example, being one of the top three steps in
execution time in a large query).
Note
When possible, you should run a query twice to see what its execution details will typically be.
Compilation adds overhead to the first run of the query that is not present in subsequent runs.
To investigate high skew for a step, check the query plan for distribution steps to see what type of
distribution is being performed in the query, then review your data distribution strategy to see if should
be modified. For more information about Amazon Redshift data distribution, go to Choosing a Data
Distribution Style in the Amazon Redshift Database Developer Guide.
You can click any bar in the chart to compare the data estimated from the explain plan with the actual
performance of the query, as shown following.
If the query optimizer posted alerts for the query in the STL_ALERT_EVENT_LOG system table, then
the plan nodes associated with the alerts are flagged with an alert icon.
API Version 2012-12-01
190
Amazon Redshift Management Guide
Viewing Query Performance Data
- Amazon Redshift 1
- Table of Contents 3
- What Is Amazon Redshift? 7
- Cluster Management 8
- Cluster Access and Security 8
- Monitoring Clusters 9
- Databases 10
- Amazon Redshift Clusters 11
- About Clusters and Nodes 12
- Dense Storage Node Types 13
- Dense Compute Node Types 13
- Resizing a Cluster 14
- EC2-Classic Platform 15
- EC2-VPC Platform 15
- Maintenance Windows 16
- Default Disk Space Alarm 17
- Renaming Clusters 17
- Creating a Cluster 20
- Modifying a Cluster 26
- To modify a cluster 27
- Rebooting a Cluster 29
- Cloud (VPC) 38
- Creating a Cluster in a VPC 39
- Cluster Subnet Groups 43
- Amazon Redshift Parameter 62
- Result Set 63
- User Group Wildcard 68
- Query Group Wildcard 71
- Operating Systems 78
- Creating a Parameter Group 79
- Modifying a Parameter Group 80
- Deleting a Parameter Group 82
- SDK for Java 83
- Amazon Redshift Snapshots 88
- Manual Snapshots 89
- Sharing Snapshots 90
- Creating a Manual Snapshot 93
- Deleting a Manual Snapshot 94
- Copying an Automated Snapshot 94
- Sharing a Cluster Snapshot 97
- Snapshot Copy 99
- CLI and API 103
- Amazon Redshift Database 104
- Encryption 104
- Hardware Security Modules 105
- Creating an HSM Connection 106
- API Version 2012-12-01 107
- Deleting an HSM Connection 110
- Rotating Encryption Keys 111
- Redshift CLI and API 112
- Purchasing Amazon Redshift 113
- Reserved Nodes 113
- Amazon Redshift Console 114
- AWS SDK for Java 117
- Amazon Redshift CLI and API 120
- Controlling Access to Amazon 121
- Redshift Resources 121
- Management 122
- Example 3: Manage clusters 129
- Accessing Amazon Redshift 134
- Clusters and Databases 134
- Command Line 136
- Signing an HTTP Request 137
- Example Signature Calculation 138
- Installation Instructions 140
- Step 1: Before You Begin 141
- Step 2: Launch a Cluster 141
- Connecting to a Cluster 144
- Configure a JDBC Connection 146
- Configure an ODBC Connection 150
- Windows Operating Systems 152
- Important 154
- System Requirements 154
- Configuring the odbc.ini File 157
- Connect Using SSL 164
- Install SQL Workbench/J 168
- Redshift 179
- Set MTU on Mac OS X 183
- Monitoring Amazon Redshift 185
- Cluster Performance 185
- Amazon Redshift Metrics 186
- Redshift Console 189
- Cluster Metrics: Examples 191
- Terminating a Running Query 193
- Viewing Query Details 194
- Analyzing Query Execution 195
- Creating an Alarm 201
- CloudWatch Console 203
- Amazon Redshift Events 205
- Filtering Events 206
- Overview 208
- Messages 210
- Subscriptions 218
- Subscription 218
- Notification Subscription 219
- Database Audit Logging 221
- Connection Log 222
- User Log 222
- Enabling Logging 223
- Managing Log Files 224
- Prerequisites 233
- Step 1: Resize the Cluster 233
- Step 1:Take a Snapshot 235
- Limits in Amazon Redshift 243
- Naming Constraints 244
- Tagging Resources in Amazon 246
- Tagging Requirements 247
- To add tags to a resource 249
- Document History 251
Relacionado con productos y manuales para Software Amazon Redshift
Software Amazon AWS SDK Guía de usuario
(155 paginas)
(155 paginas)
Software Amazon Redshift Manual de usuario
(24 paginas)
(24 paginas)
Software Amazon Redshift Manual de usuario
(11 paginas)
(11 paginas)
Software Amazon AWS SDK Guía de usuario
(73 paginas)
(73 paginas)
Teejet FieldPilot Install Case IH 9150-9250-9330-9350 manuels
Manuels d'utilisation et guides de l'utilisateur pour Machines spéciales Teejet FieldPilot Install Case IH 9150-9250-9330-9350.
Nous fournissons des manuels en pdf 1 Teejet FieldPilot Install Case IH 9150-9250-9330-9350 à télécharger gratuitement par type de document : Manuel de l'utilisateur
Teejet FieldPilot Install Case IH 9150-9250-9330-9350 Manuel de l'utilisateur (24 pages)
marque: Teejet | Catégorie: Special machinery | Taille: 2.58 MB |
Table des matières
Plus de produits et de manuels pour Machines spéciales Teejet
| Modèles | Type de document |
|---|---|
| FieldPilot Install Case MX Magnum |
Manuel de l'utilisateur
TeeJet FieldPilot Install Case MX Magnum User Manual [fr] [de] ,
20 pages
|
| FieldPilot Install Case MX Magnum Series |
Manuel de l'utilisateur
TeeJet FieldPilot Install Case MX Magnum Series User Manual [en] [pl] [de] ,
18 pages
|
| FieldPilot Install Case MX Magnum w/Factory Valve |
Manuel de l'utilisateur
TeeJet FieldPilot Install Case MX Magnum w/Factory Valve User Manual,
12 pages
|
| FieldPilot Install Case SPX 3150-3185 |
Manuel de l'utilisateur
TeeJet FieldPilot Install Case SPX 3150-3185 User Manual [en] [de] ,
19 pages
|
| FieldPilot Install Case SPX 4260b |
Manuel de l'utilisateur
TeeJet FieldPilot Install Case SPX 4260b User Manual,
18 pages
|
| FieldPilot Install Case STX, NH TJ, NH T90X0 |
Manuel de l'utilisateur
TeeJet FieldPilot Install Case STX, NH TJ, NH T90X0 User Manual [de] [fr] [it] ,
24 pages
|
| FieldPilot Install CAT C-D-E 65-75-85-95E |
Manuel de l'utilisateur
TeeJet FieldPilot Install CAT C-D-E 65-75-85-95E User Manual [fr] [de] ,
24 pages
|
| FieldPilot Install Ford NH 8x70 |
Manuel de l'utilisateur
TeeJet FieldPilot Install Ford NH 8x70 User Manual [en] [de] ,
20 pages
|
| FieldPilot Install Ford Versatile 8x6-9x6 |
Manuel de l'utilisateur
TeeJet FieldPilot Install Ford Versatile 8x6-9x6 User Manual [es] [it] [de] [en] ,
20 pages
|
| FieldPilot Install Ford Versatile |
Manuel de l'utilisateur
TeeJet FieldPilot Install Ford Versatile User Manual [en] [de] [pl] [cs] ,
24 pages
|
| FieldPilot Install John Deere 4x40, 4X50 & 4X5 |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 4x40, 4X50 & 4X55 User Manual [es] [it] [de] [en] ,
22 pages
|
| FieldPilot Install John Deere 4700 |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 4700 User Manual [fr] [de] ,
22 pages
|
| FieldPilot Install John Deere 4710 & 4720 |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 4710 & 4720 User Manual,
19 pages
|
| FieldPilot Install John Deere 6x10-6x20 |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 6x10-6x20 User Manual,
22 pages
|
| FieldPilot Install John Deere 6500 & 6700 Hi-C |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 6500 & 6700 Hi-Cycle User Manual,
24 pages
|
| FieldPilot Install John Deere 7x20 Series |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 7x20 Series User Manual,
20 pages
|
| FieldPilot Install John Deere 8xxx |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 8xxx User Manual,
16 pages
|
| FieldPilot Install John Deere 8x00 |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 8x00 User Manual [es] [it] [de] [en] ,
22 pages
|
| FieldPilot Install John Deere 8x20 |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 8x20 User Manual [fr] [de] ,
20 pages
|
| FieldPilot Install John Deere 9x00-9x20 |
Manuel de l'utilisateur
TeeJet FieldPilot Install John Deere 9x00-9x20 User Manual [pl] [en] [de] ,
32 pages
|
© 2020, manymanuals.es. Todos los derechos reservados | 0.037 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales