2021-08-16 15:04:24 UTC:xx.xx.xx.xx(48082):fs00001034_mod_source_record_manager@folio:[28910]:LOG:  duration: 3854.769 ms  statement: SELECT
	  CASE
	    WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb
	    ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId',
	                                                                          'total', job_execution_progress.jsonb -> 'total',
	                                                                          'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int))
	  END as jsonb, (SELECT COUNT(id) FROM fs00001034_mod_source_record_manager.job_executions WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))) ) AS total_rows
	FROM fs00001034_mod_source_record_manager.job_executions
	LEFT JOIN fs00001034_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid
	WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))) 
	ORDER BY left(lower(f_unaccent(job_executions.jsonb->>'completedDate')),600) DESC, lower(f_unaccent(job_executions.jsonb->>'completedDate')) DESC
	LIMIT 25 OFFSET 0;
	
	
	2021-08-16 15:04:28 UTC:xx.xx.xx.xx(48082):fs00001034_mod_source_record_manager@folio:[28910]:LOG:  duration: 3742.868 ms  statement: EXPLAIN ANALYZE SELECT
	  CASE
	    WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb
	    ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId',
	                                                                          'total', job_execution_progress.jsonb -> 'total',
	                                                                          'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int))
	  END as jsonb, (SELECT COUNT(id) FROM fs00001034_mod_source_record_manager.job_executions WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))) ) AS total_rows
	FROM fs00001034_mod_source_record_manager.job_executions
	LEFT JOIN fs00001034_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid
	WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))) 
	ORDER BY left(lower(f_unaccent(job_executions.jsonb->>'completedDate')),600) DESC, lower(f_unaccent(job_executions.jsonb->>'completedDate')) DESC
	LIMIT 25 OFFSET 0;