X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;ds=sidebyside;f=i_s%2Fpl_by_user.go;h=ae5b4aa4cd90469546a53bcbf48706fe966338b8;hb=724089cf7925d3e7f54f4b9cf7be341d6fdbe8bf;hp=9ad2c8d60311424bc5cf882ce989bd35b9721e36;hpb=52d3c00ce729f908f342e10f48818b112dec0130;p=pstop.git diff --git a/i_s/pl_by_user.go b/i_s/pl_by_user.go index 9ad2c8d..ae5b4aa 100644 --- a/i_s/pl_by_user.go +++ b/i_s/pl_by_user.go @@ -42,7 +42,7 @@ xxxxxxxxxxxxxx|hh:mm:ss 100.0%|9999 9999|9999 999|100.0% 100.0% 100.0% 100.0% 1 */ func (r *pl_by_user_row) headings() string { - return fmt.Sprintf("%-14s|%10s %6s|%5s %4s|%4s %3s|%6s %6s %6s %6s %6s|", + return fmt.Sprintf("%-14s|%10s %6s|%4s %4s|%5s %3s|%6s %6s %6s %6s %6s|", "username", "Run Time", "%", "Conn", "Actv", "Hosts", "DBs", "Select", "Insert", "Update", "Delete", "Other") } @@ -56,7 +56,7 @@ func (r *pl_by_user_row) row_content(totals pl_by_user_row) string { } else { u = r.username } - return fmt.Sprintf("%-14s|%10s %6s|%5s %4s|%4s %3s|%6s %6s %6s %6s %6s|", + return fmt.Sprintf("%-14s|%10s %6s|%4s %4s|%5s %3s|%6s %6s %6s %6s %6s|", u, lib.FormatTime(r.runtime), lib.FormatPct(lib.MyDivide(r.runtime, totals.runtime)), @@ -80,8 +80,8 @@ func (t pl_by_user_rows) totals() pl_by_user_row { totals.runtime += t[i].runtime totals.connections += t[i].connections totals.active += t[i].active - // totals.hosts += t[i].hosts This needs to be done differently to get the total number of distinct hosts - // totals.dbs += t[i].dbs This needs to be done differently to get the total number of distinct dbs + // totals.hosts += t[i].hosts This needs to be done differently to get the total number of distinct hosts + // totals.dbs += t[i].dbs This needs to be done differently to get the total number of distinct dbs totals.selects += t[i].selects totals.inserts += t[i].inserts totals.updates += t[i].updates @@ -118,7 +118,8 @@ func (t ByRunTime) Len() int { return len(t) } func (t ByRunTime) Swap(i, j int) { t[i], t[j] = t[j], t[i] } func (t ByRunTime) Less(i, j int) bool { return (t[i].runtime > t[j].runtime) || - ((t[i].runtime == t[j].runtime) && (t[i].connections > t[j].connections)) + ((t[i].runtime == t[j].runtime) && (t[i].connections > t[j].connections)) || + ((t[i].runtime == t[j].runtime) && (t[i].connections == t[j].connections) && (t[i].username < t[j].username)) } func (t pl_by_user_rows) Sort() {