# Loading query log takes several seconds since core 6.3

**URL:** <https://discourse.pi-hole.net/t/loading-query-log-takes-several-seconds-since-core-6-3/83695>\
**Category:** Help\
**Created:** [November 28, 2025, 11:25pm UTC](https://discourse.pi-hole.net/t/loading-query-log-takes-several-seconds-since-core-6-3/83695 "2025-11-28T23:25:47Z")\
**Posts on this page:** 1\
**Showing post:** 14

<div class="post-metadata">

**Author:** ![bcutter](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/bcutter/32/5769_2.png) [@bcutter](https://discourse.pi-hole.net/u/bcutter)\
**Post date:** [December 14, 2025, 6:28pm UTC](https://discourse.pi-hole.net/t/loading-query-log-takes-several-seconds-since-core-6-3/83695/14 "2025-12-14T18:28:42Z")

</div>

6 seconds loading time at minimum. No matter if accessed via http oder https.

```auto
sudo service pihole-FTL stop
sudo cp /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL_BU.db
sudo sqlite3 /etc/pihole/pihole-FTL_BU.db "PRAGMA integrity_check;"
-> ok
sudo service pihole-FTL start
sudo pihole status
[✓] FTL is listening on port 53
  [✓] UDP (IPv4)
  [✓] TCP (IPv4)
  [✓] UDP (IPv6)
  [✓] TCP (IPv6)

[✓] Pi-hole blocking is enabled

```

Ah I see `pihole -d` is also performing an integrity check so this was not necessary in addition.

```auto
*** [DIAGNOSING]: Pi-hole FTL Query Database
-rw-r----- 1 pihole pihole 3,7G 14. Dez 18:53 /etc/pihole/pihole-FTL.db
[i] Checking integrity of /etc/pihole/pihole-FTL.db ... (this can take several minutes)
\ 01:03

```

So here’s the redacted pihole debug:

~~First upload (potentially failed- `/usr/local/bin/pihole: Zeile 38: /etc/pihole/versions: Keine Berechtigung` - as `pihole` almost everywhere needs a `sudo` since v6): [https://tricorder.pi-hole.net/fCJVoQFK/](https://tricorder.pi-hole.net/fCJVoQFK/) .~~

Second upload without any errors:  
Upload successful, your token is: [https://tricorder.pi-hole.net/t7MzLlg0/](https://tricorder.pi-hole.net/t7MzLlg0/)

---

_[View the full topic](https://discourse.pi-hole.net/t/loading-query-log-takes-several-seconds-since-core-6-3/83695)._