diff options
| author | user <user@node5.net> | 2024-03-25 00:25:17 +0100 |
|---|---|---|
| committer | user <user@node5.net> | 2024-03-25 00:25:17 +0100 |
| commit | 3304f879939cc851650040c21b5ce8a93140c8c5 (patch) | |
| tree | 79b5648d6d1de50697ef966e01fc1997e0a2f24c /src/db_handler.py | |
| parent | 8b21517ff20e7b678a0b41b93bd1181a38763287 (diff) | |
chart switch to bar, tooltip only nonzero, sum
Diffstat (limited to 'src/db_handler.py')
| -rw-r--r-- | src/db_handler.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/db_handler.py b/src/db_handler.py index 7c40d51..7a436e6 100644 --- a/src/db_handler.py +++ b/src/db_handler.py @@ -65,7 +65,7 @@ FROM login_attempt la JOIN connection cn on cn.id = la.connection WHERE la.timestamp BETWEEN current_timestamp - interval '2 days' AND la.timestamp GROUP BY date_trunc('hour', la.timestamp), cn.ip -ORDER BY COUNT(la.id) +ORDER BY COUNT(la.id) DESC ; """) histogram = cur.fetchall() |