Bug 16625 - add time_added column to zebraqueue
Summary: add time_added column to zebraqueue
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Searching (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-05-31 18:41 UTC by Barton Chittenden
Modified: 2023-09-09 20:38 UTC (History)
0 users

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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?