Long-running Query from relatively simple search

[Jason Stephenson]

Evergreen 3.5.3
PostgreSQL: 10.19
O/S: Uubntu 18.04

I canceled a search query that had run for over 14 hours this morning. After digging through the logs, I was able to find the initial search request in the gateway and Apache logs, along with the final SQL that was canceled.

From the gateway log:

tpac: site=SOUTHBORO, depth=3, user_query="winter" AND "sports", query=sort(poprel) "winter" AND "sports" search_format(book) site(SOUTHBORO) depth(3)

The corresponding websockets entry from the Apache logs:

localhost:443 127.0.0.1 - - [08/Feb/2022:18:52:36 -0500] "GET /eg/opac/results?bool=and&qtype=keyword&contains=contains&query=%22winter%22+AND+%22sports%22&bool=and&qtype=title&contains=contains&query=&bool=and&qtype=author&contains=contains&query=&_adv=1&detail_record_view=0&fi%3Asearch_format=book&locg=105&pubdate=is&date1=&date2=&sort=poprel HTTP/1.0" 200 135595 "https://bark.cwmars.org/eg/opac/advanced" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.99 Safari/537.36"

Since the SQL is approximately 14k, I'll attach rather than paste it into the bug description.

[Jason Stephenson (jstephenson)]

I'm adding the output of EXPLAIN on the SQL in the same datbase where it ran for 14+ hours.