diff options
| author | user <user@node5.net> | 2024-03-26 22:10:32 +0100 |
|---|---|---|
| committer | user <user@node5.net> | 2024-03-26 22:10:32 +0100 |
| commit | 34da62f80e1acfe924c4e7e30bb0f752e1d4de94 (patch) | |
| tree | cc0847da12885aaf032fbb08ce97bfc146bdfe3d | |
| parent | c258e5f89f01d2d1f1e2eab0e4b62dca0bca3fc6 (diff) | |
Revert "chart show 1 day to load faster"
This reverts commit 57ba2cc237203e85756cecd92202d4785b234850.
| -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 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 ; |
