summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authoruser <user@node5.net>2024-03-26 22:10:32 +0100
committeruser <user@node5.net>2024-03-26 22:10:32 +0100
commit34da62f80e1acfe924c4e7e30bb0f752e1d4de94 (patch)
treecc0847da12885aaf032fbb08ce97bfc146bdfe3d /src
parentc258e5f89f01d2d1f1e2eab0e4b62dca0bca3fc6 (diff)
Revert "chart show 1 day to load faster"
This reverts commit 57ba2cc237203e85756cecd92202d4785b234850.
Diffstat (limited to 'src')
-rw-r--r--src/db_handler.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/db_handler.py b/src/db_handler.py
index e900e4c..4d834e8 100644
--- a/src/db_handler.py
+++ b/src/db_handler.py
@@ -63,7 +63,7 @@ def get_histogram_detailed() -> str:
SELECT count(la.id) as total_count, date_trunc('hour', la.timestamp) as date, cn.ip
FROM login_attempt la
JOIN connection cn on cn.id = la.connection
-WHERE la.timestamp BETWEEN (select max(timestamp) from login_attempt) - interval '1 days' AND (select max(timestamp) from login_attempt)
+WHERE la.timestamp BETWEEN (select max(timestamp) from login_attempt) - interval '2 days' AND (select max(timestamp) from login_attempt)
GROUP BY date_trunc('hour', la.timestamp), cn.ip
ORDER BY COUNT(la.id) DESC
;