Expected Behaviour: Loading query log page takes a few hundred ms as before the upgrade. Pi OS 12 Pi 5 Bare metal install Actual Behaviour: Page load takes 6 to 7 seconds since the latest update Pi-hole FTL v6.4, Web v6.4 and Core v6.3 Released! . When checking the filter above I notice the „all…

[image] Bucking_Horn: to avoid having to compute that field on every API request We actually have an improvement for this (and a few other related things) still awaiting review. It is exactly doing this (eliminating COUNT(*) and MIN(timestamp) at all) this, see …

This is black box testing. Might be helpful, but without a dev/expert finally taking the investigation lead (they got the debug logs… in case they did not get removed already meanwhile, not sure bout the retention policy) we won’t make any noteworthy progress here.

The silence in this topic is interesting. Hopefully @jfb and/or @rdwebdesign will finally end it :slight_smile: What are we waiting for? In case this topic gets auto closed, I can guarantee you the day after there will be a new one :wink:

[image] bcutter: What are we waiting for? In case this topic gets auto closed, I can guarantee you the day after there will be a new one :wink: That's fine, we can move those posts to this topic thread and adjust the bump dates.

Great solution oriented proposal. This helps build trust, more of this spirit :+1: :smiley: (when you finally get an expert response and you realize it’s not that helpful as you were hoping for (a long time) and you see it even is THE number one expert - priceless. Happy new year everybody …

Please follow up on this. Thank you. @emorgoch anything new from your side?

I see you guys are comparing the hardware Pi-Hole is running on but there is no information about the STORAGE part of the setups ?! microSDXC card model ? Please be exact as possible! For how long have you been using it ? Maybe it just crossed a certain level of age/being worn at the same moment…

Nice idea, but Pi-hole system is running on a super fast internal M.2 NVMe for a few months only the issue got 100 % introduced with the Pi-hole software update - so no reason to blame the hardware (but I understand you thought in that direction).

Well… at least we now know that it should not be a problem then! :grimacing: However please do keep in mind that even the best SSD out there can have issues from time to time because of some unforseen firmware bug for example…

Yeah, now that we ticked the IT basics for beginners (very interesting for IT technicians working in IT for 20 years :slight_smile: ) we can finally stop talking about hardware and focusing on the root cause for this bug: the software update introducing this. The silence of the Pi-Hole team is impre…

I can't reproduce your observation in my Pi-hole: I don't see loading times of 5 seconds for my Query Log, but I can see the query table being rendered empty very briefly before it gets populated (but then my query database is under 100M in size). Nevertheless, I compared my current Pi-hole agains…

Loading query log takes several seconds since core 6.3

Help

bcutter February 16, 2026, 12:27pm 51

Looking forward to see that in an upcoming stable release.

Especially as I discovered this, one central question is if this resource usage is related to this issue: