Please follow the below template, it will help us to help you!
*If you are Experiencing issues with a Pi-hole install that has non-standard elements
Using standard elements all the way.
Expected Behaviour:
Query-ing the log for all queries (all entries) and then search for a certain query - for example search for the phrase "itv.lan." (including the dot).
Versions:
Pi-hole v5.14.2 FTL v5.19.2 Web Interface v5.17
Ubuntu 22.04.1 LTS
Actual Behaviour:
After selecting show all queries with show all entries the session becomes unresponsive. In addition, the browsers (i.e. FF) returns the stop-bar with a message stating that the page is slowing down FF.
I also tried Chrome and Edge - both with similar results.
In all cases no results are presented unless the stop-button is clicked. The search-bar is still not responsive.
Your debug log suggests you are running two Pi-hole's?
If that's the case and your network would be aware of both of them, make sure you are addressing them by distinctive names, so the UI won't get confused by starting to talk to one and then continue with the respective other.
Also, which client did you use to request to show all queries?
Perhaps your 192.168.139.162?
*** [ DIAGNOSING ]: contents of /var/log/pihole
-rw-r--r-- 1 pihole pihole 17K Dec 1 12:00 /var/log/pihole/FTL.log
-----head of FTL.log------
[2022-12-01 00:33:20.759 40525M] Rate-limiting 192.168.139.162 for at least 5 seconds
That may also hint at an excessive count of queries, which could also slow down processing.
Let's check your most recent 24 hours.
Run on your Pi-hole host, what's the output of:
There is only one pi-hole.
The client used to show all qeries is called pandora and had IP-adres 192.168.139.41 at the time of the request.
The client with IP 192.168.139.162 is a snmp type of monitoring system.
It runs device discoveries from time-to-time and may show lots of DNS-requests.
Below the stats for the last 24hrs.
Doesn't look like alarming values... or?