@@ -17,12 +17,12 @@ Error (total time): {{ NumFormat (index (index (index .results .hosts.master) "d
17
17
18
18
{ {if gt (len (index (index (index .results .hosts.master)" data" )" queries" )) .LISTLIMIT} }The list is limited to{ {.LISTLIMIT} } items.{ { end} }
19
19
20
- | \# | Query | Calls |▼ ;  ; Total  ; time | Rows | shared_blks_hit | shared_blks_read | shared_blks_dirtied | shared_blks_written | blk_read_time | blk_write_time | kcache_reads | kcache_writes | kcache_user_time_ms | kcache_system_time |
20
+ | \#< br />(query id) | Query | Calls |▼ ;  ; Total  ; time | Rows | shared_blks_hit | shared_blks_read | shared_blks_dirtied | shared_blks_written | blk_read_time | blk_write_time | kcache_reads | kcache_writes | kcache_user_time_ms | kcache_system_time |
21
21
|----|----------|-------|------------|------|-----------------|------------------|---------------------|---------------------|---------------|----------------|--------------|---------------|---------------------|--------------------|
22
22
{ { range$i ,$key := (index (index (index (index .results .hosts.master)" data" )" queries" )" _keys" )} }
23
23
{ {-if lt $i $.LISTLIMIT -} }
24
24
{ {-$value := (index (index (index (index $.results $.hosts.master)" data" )" queries" )$key ) -} }
25
- |{ {-$key } } |
25
+ |{ {-$key } }< br />( { { $ value .queryid } })|
26
26
{ {- EscapeQuery (WordWrap (LimitStr$value .query 1000) 30)} }<br />[Full query]({ {$value .link} }) |
27
27
{ {- RawIntFormat$value .diff_calls} }<br />{ { NumFormat$value .per_sec_calls 2} }/sec<br />{ { NumFormat$value .per_call_calls 2} }/call<br />{ { NumFormat$value .ratio_calls 2} }% |
28
28
{ {- RawFloatFormat$value .diff_total_time 2} }  ; ms<br />{ { MsFormat$value .per_sec_total_time} }/sec<br />{ { MsFormat$value .per_call_total_time} }/call<br />{ { NumFormat$value .ratio_total_time 2} }% |
@@ -56,12 +56,12 @@ Period age: {{ (index (index (index $.results $host) "data") "period_age") }}
56
56
57
57
{ {if gt (len (index (index (index $.results$host )" data" )" queries" )) 50} }Top 50 rows{ { end} }
58
58
59
- | \# | Query | Calls |▼ ;  ; Total  ; time | Rows | shared_blks_hit | shared_blks_read | shared_blks_dirtied | shared_blks_written | blk_read_time | blk_write_time | kcache_reads | kcache_writes | kcache_user_time_ms | kcache_system_time |
59
+ | \#< br />(query id) | Query | Calls |▼ ;  ; Total  ; time | Rows | shared_blks_hit | shared_blks_read | shared_blks_dirtied | shared_blks_written | blk_read_time | blk_write_time | kcache_reads | kcache_writes | kcache_user_time_ms | kcache_system_time |
60
60
|----|----------|-------|------------|------|-----------------|------------------|---------------------|---------------------|---------------|----------------|--------------|---------------|---------------------|--------------------|
61
61
{ { range$i ,$key := (index (index (index (index $.results$host )" data" )" queries" )" _keys" )} }
62
62
{ {-if lt $i $.LISTLIMIT -} }
63
63
{ {-$value := (index (index (index (index $.results$host )" data" )" queries" )$key ) -} }
64
- |{ {-$key } } |
64
+ |{ {-$key } }< br />( { { $ value .queryid } }) |
65
65
{ {- EscapeQuery (WordWrap (LimitStr$value .query 1000) 30)} }<br />[Full query]({ {$value .link} }) |
66
66
{ {- RawIntFormat$value .diff_calls} }<br />{ { NumFormat$value .per_sec_calls 2} }/sec<br />{ { NumFormat$value .per_call_calls 2} }/call<br />{ { NumFormat$value .ratio_calls 2} }% |
67
67
{ {- RawFloatFormat$value .diff_total_time 2} }  ; ms<br />{ { MsFormat$value .per_sec_total_time} }/sec<br />{ { MsFormat$value .per_call_total_time} }/call<br />{ { NumFormat$value .ratio_total_time 2} }% |