starred/AdGuardHome

Fork 0

mirror of https://github.com/AdguardTeam/AdGuardHome.git synced 2026-03-04 00:01:12 -05:00

Query log filtering very slow on underpowered devices such as routers #4167

New issue

Open

opened 2026-03-04 04:49:28 -05:00 by deekerman · 7 comments

deekerman commented

2026-03-04 04:49:28 -05:00

Owner

Originally created by @timkgh on GitHub (Jan 16, 2023).

Prerequisites

I have checked the Wiki and Discussions and found no answer
I have searched other issues and found no duplicates
I want to report a bug and not ask a question

Operating system type

Linux, Other (please mention the version in the description)

CPU architecture

64-bit MIPS

Installation

GitHub releases or script from README

Setup

On a router, DHCP is handled by the router

AdGuard Home version

v0.107.21

Description

Filtering the query log on an EdgeRouter ER-12 is very slow and causes very high CPU use. This means I can't really keep more than 7 days of logs and have a usable UI.

Originally created by @timkgh on GitHub (Jan 16, 2023). ### Prerequisites - [X] I have checked the [Wiki](https://github.com/AdguardTeam/AdGuardHome/wiki) and [Discussions](https://github.com/AdguardTeam/AdGuardHome/discussions) and found no answer - [X] I have searched other issues and found no duplicates - [X] I want to report a bug and not ask a question ### Operating system type Linux, Other (please mention the version in the description) ### CPU architecture 64-bit MIPS ### Installation GitHub releases or script from README ### Setup On a router, DHCP is handled by the router ### AdGuard Home version v0.107.21 ### Description Filtering the query log on an EdgeRouter ER-12 is very slow and causes very high CPU use. This means I can't really keep more than 7 days of logs and have a usable UI.

deekerman added the

waiting for data

label

2026-03-04 04:49:28 -05:00

deekerman commented

2026-03-04 04:49:32 -05:00

Author

Owner

@ghost commented on GitHub (Mar 27, 2024):

Hi there, are you still experiencing this?

@ghost commented on GitHub (Mar 27, 2024): Hi there, are you still experiencing this?

deekerman commented

2026-03-04 04:49:33 -05:00

Author

Owner

@timkgh commented on GitHub (Apr 2, 2024):

Hi there, are you still experiencing this?

Yes, nothing changed, still slow. Can you please reopen?

@timkgh commented on GitHub (Apr 2, 2024): > Hi there, are you still experiencing this? Yes, nothing changed, still slow. Can you please reopen?

deekerman commented

2026-03-04 04:49:33 -05:00

Author

Owner

@overwatch3560 commented on GitHub (Apr 2, 2024):

What do you mean with very slow?

@overwatch3560 commented on GitHub (Apr 2, 2024): What do you mean with very slow?

deekerman commented

2026-03-04 04:49:33 -05:00

Author

Owner

@timkgh commented on GitHub (Apr 2, 2024):

What do you mean with very slow?

It takes minutes to get any results when I click on the Dashboard > Blocked malware/phishing
E.g. this URL: https://192.168.1.1/#logs?response_status=blocked_safebrowsing

@timkgh commented on GitHub (Apr 2, 2024): > What do you mean with very slow? It takes minutes to get any results when I click on the Dashboard > Blocked malware/phishing E.g. this URL: https://192.168.1.1/#logs?response_status=blocked_safebrowsing

deekerman commented

2026-03-04 04:49:33 -05:00

Author

Owner

@ainar-g commented on GitHub (Apr 3, 2024):

This is likely just an inevitable consequence of having to filter through a lot of data fetched from the disk. See #2290.

You can enable verbose logging to see the progress of the fetching and filtering. It is likely that it's just inherently slow on that hardware, and in that case the recommendation would be to limit the size of the querylog or, if RAM allows, keep it in memory.

@ainar-g commented on GitHub (Apr 3, 2024): This is likely just an inevitable consequence of having to filter through a lot of data fetched from the disk. See #2290. You can [enable verbose logging](https://adguard-dns.io/kb/adguard-home/faq/#verboselog) to see the progress of the fetching and filtering. It is likely that it's just inherently slow on that hardware, and in that case the recommendation would be to limit the size of the querylog or, if RAM allows, keep it in memory.

deekerman commented

2026-03-04 04:49:33 -05:00

Author

Owner

@Cebeerre commented on GitHub (Apr 3, 2024):

What do you mean with very slow?

It takes minutes to get any results when I click on the Dashboard > Blocked malware/phishing E.g. this URL: https://192.168.1.1/#logs?response_status=blocked_safebrowsing

Assuming you're using OpenWRT on this Uniquiti router, are you using the squash image so all the "/data" AGH directory is sitting on the ramdisk ?

@Cebeerre commented on GitHub (Apr 3, 2024): > > What do you mean with very slow? > > It takes minutes to get any results when I click on the Dashboard > Blocked malware/phishing E.g. this URL: https://192.168.1.1/#logs?response_status=blocked_safebrowsing Assuming you're using OpenWRT on this Uniquiti router, are you using the squash image so all the "/data" AGH directory is sitting on the ramdisk ?

deekerman commented

2026-03-04 04:49:33 -05:00

Author

Owner

@timkgh commented on GitHub (Apr 3, 2024):

I'm using EdgeOS, not OpenWRT, but all the AGH logs are in /tmp (tmpfs) mainly to no wear the flash. Keeping only 14 days of logs (7 days rotation), ~125MB and it's still very slow.

@timkgh commented on GitHub (Apr 3, 2024): I'm using EdgeOS, not OpenWRT, but all the AGH logs are in /tmp (tmpfs) mainly to no wear the flash. Keeping only 14 days of logs (7 days rotation), ~125MB and it's still very slow.

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/AdGuardHome#4167

No description provided.

Rows
Columns