Loading query log takes several seconds since core 6.3

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 time“ is set as default, explaining why the page load takes so much time. This behavior has definitely changed. How to set the default filter to e. g. „Today“?

Before the latest release, the initial value was set to 2020-01-01, as you can see on this Github issue, but this is only applied when you select the "Query on-disk data" checkbox.

With out the checkbox, only data from the last 24h is loaded.

1 Like

Indeed only the last 24 hours are loaded, giving 6.300 pages currently. The visual filter section was a „false trap“.

So the remaining question is: why does loading take so much more time compared to the initial display until the last release?

Not sure why in your case you feel this is slower.

The latest version was released with a lot of small improvements and most users are seeing the opposite effect.

If you think there is something wrong, we will need a debug log.

I don’t think, I can guarantee. Previous version made query log load within a blink of an eye (<= a second), now it takes 6 to 7 seconds. Period.

So I fear I will need to walk the debug log path which will take a while.

It’s as simple as running sudo pihole -d and selecting Y when given the upload option.

Technically yes. But unless you have changed the debug process in the last two years I will have to manually check for privacy related information first. Was way too chatty for my taste back in July 2023. So I will follow up once finished.

Just for reference: query log with 6500 pages x 10 entries on a Pi 2 loaded in appr. one second.