Bug 16625

Summary: add time_added column to zebraqueue
Product: Koha Reporter: Barton Chittenden <barton>
Component: SearchingAssignee: Galen Charlton <gmcharlt>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Barton Chittenden 2016-05-31 18:41:35 UTC
I've run into zebra daemon performance issues. I would like to be able to run queries that look something like this:

-- Find finished rows in zebraqueue that took more than 10 minutes to process.
select
    time_added,
    time,
    time - time_added as difference
from
    zebraqueue
where
    done = 1
    and time - time_added > 600
order by time_added

... but there's no time_added column in zebraqueue.
Comment 1 Katrin Fischer 2023-09-09 20:38:00 UTC
Is there still an interest in this?