| # | Query Abstract | ID | Load | Count | Latency | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| TOTAL |
|
{{ profileTotal.Load | humanize : 'number' }} (100%) | {{profileTotal.QPS | humanize : 'number'}} QPS |
|
{{ profileTotal.Stats.Cnt | humanize : 'number'}} (100%) |
|
{{ profileTotal.Stats.Avg | humanize }} avg |
|
||
| {{ $index + 1 }} | {{ (row.Abstract | limitTo : 22) + (row.Abstract.length > 22 ? '...' : '') }} | {{ row.Id }} |
|
{{ row.Load | humanize : 'number' }} ({{ row.Percentage | humanize : 'percent' }}) | {{row.QPS | humanize : 'number'}} QPS |
|
{{row.Stats.Cnt | humanize : 'number'}} ({{ (row.Stats.Cnt / profileTotal.Stats.Cnt * 100).toFixed(2) }}%) |
|
{{ row.Stats.Avg | humanize }} avg |
|
| No data for selected time-range. | ||||||||||
| Id | SelectType | Table | Partitions | CreateTable | Type | PossibleKeys | Key | KeyLen | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {{ row.Id }} | {{ row.SelectType }} | {{ row.Table }} | {{ row.Partitions }} | {{ row.CreateTable }} | {{ row.Type }} | {{ row.PossibleKeys.replace(',', ', ') }} | {{ row.Key }} | {{ row.KeyLen }} | {{ row.Ref }} | {{ row.Rows }} | {{ row.Extra }} |
| Name | Value | ||
|---|---|---|---|
| {{ name }} | {{ value | humanize : 'size' }} | {{ value | humanize : 'number' }} | {{ value === null ? '-' : value}} |
| No data. | |||
| KeyName | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| {{ row.KeyName }} | {{ row.IndexType }} | {{ row.NonUnique === false ? 'Yes' : 'No' }} | {{ row.Packed ? 'Yes' : 'No' }} | {{ row.ColumnName }} | {{ row.Cardinality }} | {{ row.Collation }} | {{ row.Null ? 'Yes' : 'No' }} | {{ row.Comment }} |
| No data. | ||||||||