I did a quite test vs postgres of that query.
This instance has 40 zones and about 2.25k records.
Explain analyze reports:
QUERY PLAN
Limit (cost=105.26..105.27 rows=1 width=72) (actual time=0.542..0.542 rows=1
loops=1)
-> Sort (cost=105.26..105.46 rows=78 width=72) (actual time=0.541..0.5
Hello,
This is an update in our attempts to debug the performance issues on our
nameservers. We have found the main source of the timeouts: it was
caused by a somewhat larger zone (12699 records, 4236 unique names). The
zone was secured using DNSSEC.
Let's Encrypt certificates are automatically r
