"connections" / "conns" command output not sorted

[kmoppel]

Rollup by total, per user, host, db, app name - to quickly show who's not using pooling

• "histo" subcmd

[kmoppel]

main functionalkity added:

=== Connection Statistics ===
Total connection attempts: 33703
Total authenticated: 33702
Total authenticated with SSL: 0
Connection failures: 0
Success rate: 100.0%
SSL usage: 0.0%

Connections by host:
  192.168.8.1: 29687 (88.1%)
  local: 4016 (11.9%)

Connections by database:
  shop: 32996 (97.9%)
  postgres: 706 (2.1%)

Connections by user:
  postgres: 31094 (92.3%)
  monitor: 2608 (7.7%)

Connections by application:
  shop: 29686 (88.1%)
  monitor: 1402 (4.2%)
  (none): 2611 (7.7%)
  pg_activity: 2 (0.0%)
  psql: 1 (0.0%)

Top 3 busiest connection attempt buckets (10m0s interval):
  2025-08-25 19:40:00: 710
  2025-08-25 21:40:00: 709
  2025-08-25 23:00:00: 661

[yansheng836]

When I was trying to use this tool, I found that the Connections option was not sorted.
like

Connections by database:
  postgres: 33580 (64.9%)
  dial: 1932 (3.7%)
  dssfile: 6568 (12.7%)

However, I noticed that the output here is sorted. I downloaded the latest code and ran it on Windows.
I have no idea what's going on?
@kmoppel

[kmoppel]

Yes, seems still valid for the new Rust version as well - should be improved :)

[kmoppel]

./target/release/pgweasel conns testdata/connections.log 
Total connection attempts: 100
Total authenticated connections: 99
Total authenticated SSL connections: 92
Total connection failures: 1
Connections by host:
      96  127.0.0.1
       4  [local]

Connections by database:
       7  postgres
      92  bench
Connections by user:
      93  monitor
       3  krl
       3  sitt
Connections by application name:
      92  unknown
       7  psql

Connections by time bucket:
      18  2025-08-27 17:50:00 +03:00
      26  2025-08-27 17:30:00 +03:00
      20  2025-08-27 17:40:00 +03:00
      15  2025-08-27 17:10:00 +03:00
      21  2025-08-27 17:20:00 +03:00

[gintsgints]

@kmoppel can you point out, what should be sorted in output? Connections by ammount?

[kmoppel]

@gintsgints yes, exactly :) For timebuckets as well. And time buckets should be only top 10 or some other limit as well

[gintsgints]

Fixed in MR #26 . @kmoppel Please review.