------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | timestamp | message | |---------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | 1627994958199 | 12:49:18.199 [vert.x-eventloop-thread-1] INFO LogUtil [53247548eqId] 127.0.0.1:44806 GET /metadata-provider/jobExecutions limit=100&query=%28%28status%20any%20%22COMMITTED%20ERROR%22%29%29%20sortby%20completedDate%2Fsort.descending HTTP_1_1 200 8356821 4707 tid=fs00001034 OK | | 1627994958199 | 12:49:18.199 [vert.x-eventloop-thread-1] WARN PostgresClient [53247548eqId] EXPLAIN ANALYZE SELECT | | 1627994958199 | CASE | | 1627994958199 | WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb | | 1627994958199 | ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId', | | 1627994958199 | 'total', job_execution_progress.jsonb -> 'total', | | 1627994958199 | 'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int)) | | 1627994958199 | 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 | | 1627994958199 | FROM fs00001034_mod_source_record_manager.job_executions | | 1627994958199 | LEFT JOIN fs00001034_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid | | 1627994958199 | 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'))) | | 1627994958199 | ORDER BY left(lower(f_unaccent(job_executions.jsonb->>'completedDate')),600) DESC, lower(f_unaccent(job_executions.jsonb->>'completedDate')) DESC | | 1627994958199 | LIMIT 100 OFFSET 0; | | 1627994958199 | Limit (cost=6737.69..6792.94 rows=100 width=104) (actual time=1986.687..2013.734 rows=100 loops=1) | | 1627994958199 | InitPlan 1 (returns $0) | | 1627994958199 | -> Aggregate (cost=2608.94..2608.95 rows=1 width=8) (actual time=646.005..646.007 rows=1 loops=1) | | 1627994958199 | -> Bitmap Heap Scan on job_executions job_executions_1 (cost=35.05..2602.82 rows=2446 width=16) (actual time=0.417..645.588 rows=2712 loops=1) | | 1627994958199 | Recheck Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627994958199 | Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE)) | | 1627994958199 | Heap Blocks: exact=35 | | 1627994958199 | -> Bitmap Index Scan on job_executions_status_idx_ft (cost=0.00..34.44 rows=2459 width=0) (actual time=0.232..0.233 rows=2712 loops=1) | | 1627994958199 | Index Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627994958199 | -> Result (cost=4128.74..5480.16 rows=2446 width=104) (actual time=1986.686..2013.714 rows=100 loops=1) | | 1627994958199 | -> Sort (cost=4128.74..4134.86 rows=2446 width=289) (actual time=1986.605..1986.623 rows=100 loops=1) | | 1627994958199 | Sort Key: ("left"(lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text))), 600)) DESC, (lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text)))) DESC | | 1627994958199 | Sort Method: top-N heapsort Memory: 128kB | | 1627994958199 | -> Hash Right Join (cost=2633.40..4035.26 rows=2446 width=289) (actual time=1325.612..1978.169 rows=2712 loops=1) | | 1627994958199 | Hash Cond: (((job_execution_progress.jsonb ->> 'jobExecutionId'::text))::uuid = job_executions.id) | | 1627994958199 | -> Seq Scan on job_execution_progress (cost=0.00..140.13 rows=2713 width=199) (actual time=0.005..0.754 rows=2713 loops=1) | | 1627994958199 | -> Hash (cost=2602.82..2602.82 rows=2446 width=34) (actual time=679.355..679.356 rows=2712 loops=1) | | 1627994958199 | Buckets: 4096 Batches: 1 Memory Usage: 207kB | | 1627994958199 | -> Bitmap Heap Scan on job_executions (cost=35.05..2602.82 rows=2446 width=34) (actual time=0.370..678.401 rows=2712 loops=1) | | 1627994958199 | Recheck Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627994958199 | Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE)) | | 1627994958199 | Heap Blocks: exact=35 | | 1627994958199 | -> Bitmap Index Scan on job_executions_status_idx_ft (cost=0.00..34.44 rows=2459 width=0) (actual time=0.221..0.222 rows=2712 loops=1) | | 1627994958199 | Index Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627994958199 | Planning time: 1.423 ms | | 1627994958199 | Execution time: 2013.921 ms | | 1627994958202 | 12:49:18.202 [vert.x-eventloop-thread-1] INFO LogUtil [53247551eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627994958203 | 12:49:18.203 [vert.x-eventloop-thread-1] INFO LogUtil [53247552eqId] 127.0.0.1:44820 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627994965327 | 12:49:25.327 [vert.x-eventloop-thread-1] INFO LogUtil [53254676eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627994965327 | 12:49:25.327 [vert.x-eventloop-thread-1] INFO LogUtil [53254676eqId] 127.0.0.1:44868 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627994988124 | 12:49:48.124 [vert.x-eventloop-thread-1] INFO LogUtil [53277473eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627994988124 | 12:49:48.124 [vert.x-eventloop-thread-1] INFO LogUtil [53277473eqId] 127.0.0.1:44922 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627994995357 | 12:49:55.357 [vert.x-eventloop-thread-1] INFO LogUtil [53284706eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627994995357 | 12:49:55.357 [vert.x-eventloop-thread-1] INFO LogUtil [53284706eqId] 127.0.0.1:45064 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627994998578 | Aug 03, 2021 12:49:58 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema | | 1627994998578 | INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK | | 1627995002576 | 12:50:02.576 [vert.x-eventloop-thread-1] INFO LogUtil [53291925eqId] org.folio.rest.RestVerticle start invoking getMetadataProviderJobExecutions | | 1627995002606 | 12:50:02.606 [vert.x-eventloop-thread-1] INFO LogUtil [53291955eqId] 127.0.0.1:45076 GET /metadata-provider/jobExecutions query=(status%20any%20%22COMMITTED%20ERROR%22)%20sortBy%20completedDate/sort.descending&limit=25 HTTP_1_1 200 1134479 4029 tid=fs00001034 OK | | 1627995002606 | 12:50:02.606 [vert.x-eventloop-thread-1] WARN PostgresClient [53291955eqId] EXPLAIN ANALYZE SELECT | | 1627995002606 | CASE | | 1627995002606 | WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb | | 1627995002606 | ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId', | | 1627995002606 | 'total', job_execution_progress.jsonb -> 'total', | | 1627995002606 | 'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int)) | | 1627995002606 | 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 | | 1627995002606 | FROM fs00001034_mod_source_record_manager.job_executions | | 1627995002606 | LEFT JOIN fs00001034_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid | | 1627995002606 | 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'))) | | 1627995002606 | ORDER BY left(lower(f_unaccent(job_executions.jsonb->>'completedDate')),600) DESC, lower(f_unaccent(job_executions.jsonb->>'completedDate')) DESC | | 1627995002606 | LIMIT 25 OFFSET 0; | | 1627995002606 | Limit (cost=6713.23..6727.04 rows=25 width=104) (actual time=1959.365..1963.070 rows=25 loops=1) | | 1627995002606 | InitPlan 1 (returns $0) | | 1627995002606 | -> Aggregate (cost=2608.94..2608.95 rows=1 width=8) (actual time=646.364..646.365 rows=1 loops=1) | | 1627995002606 | -> Bitmap Heap Scan on job_executions job_executions_1 (cost=35.05..2602.82 rows=2446 width=16) (actual time=0.375..645.923 rows=2712 loops=1) | | 1627995002606 | Recheck Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995002606 | Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE)) | | 1627995002606 | Heap Blocks: exact=35 | | 1627995002606 | -> Bitmap Index Scan on job_executions_status_idx_ft (cost=0.00..34.44 rows=2459 width=0) (actual time=0.220..0.220 rows=2712 loops=1) | | 1627995002606 | Index Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995002606 | -> Result (cost=4104.28..5455.70 rows=2446 width=104) (actual time=1959.364..1963.063 rows=25 loops=1) | | 1627995002606 | -> Sort (cost=4104.28..4110.40 rows=2446 width=289) (actual time=1959.283..1959.287 rows=25 loops=1) | | 1627995002606 | Sort Key: ("left"(lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text))), 600)) DESC, (lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text)))) DESC | | 1627995002606 | Sort Method: top-N heapsort Memory: 51kB | | 1627995002606 | -> Hash Right Join (cost=2633.40..4035.26 rows=2446 width=289) (actual time=1304.023..1955.829 rows=2712 loops=1) | | 1627995002606 | Hash Cond: (((job_execution_progress.jsonb ->> 'jobExecutionId'::text))::uuid = job_executions.id) | | 1627995002606 | -> Seq Scan on job_execution_progress (cost=0.00..140.13 rows=2713 width=199) (actual time=0.005..0.735 rows=2713 loops=1) | | 1627995002606 | -> Hash (cost=2602.82..2602.82 rows=2446 width=34) (actual time=657.442..657.442 rows=2712 loops=1) | | 1627995002606 | Buckets: 4096 Batches: 1 Memory Usage: 207kB | | 1627995002606 | -> Bitmap Heap Scan on job_executions (cost=35.05..2602.82 rows=2446 width=34) (actual time=0.374..656.571 rows=2712 loops=1) | | 1627995002606 | Recheck Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995002606 | Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE)) | | 1627995002606 | Heap Blocks: exact=35 | | 1627995002606 | -> Bitmap Index Scan on job_executions_status_idx_ft (cost=0.00..34.44 rows=2459 width=0) (actual time=0.220..0.220 rows=2712 loops=1) | | 1627995002606 | Index Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995002606 | Planning time: 1.369 ms | | 1627995002606 | Execution time: 1963.229 ms | | 1627995018164 | 12:50:18.163 [vert.x-eventloop-thread-1] INFO LogUtil [53307512eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995018164 | 12:50:18.164 [vert.x-eventloop-thread-1] INFO LogUtil [53307513eqId] 127.0.0.1:45112 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995025401 | 12:50:25.401 [vert.x-eventloop-thread-1] INFO LogUtil [53314750eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995025401 | 12:50:25.401 [vert.x-eventloop-thread-1] INFO LogUtil [53314750eqId] 127.0.0.1:45132 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995048185 | 12:50:48.185 [vert.x-eventloop-thread-1] INFO LogUtil [53337534eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995048185 | 12:50:48.185 [vert.x-eventloop-thread-1] INFO LogUtil [53337534eqId] 127.0.0.1:45172 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995055390 | 12:50:55.390 [vert.x-eventloop-thread-1] INFO LogUtil [53344739eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995055390 | 12:50:55.390 [vert.x-eventloop-thread-1] INFO LogUtil [53344739eqId] 127.0.0.1:45282 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995059744 | Aug 03, 2021 12:50:59 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema | | 1627995059744 | INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK | | 1627995063730 | 12:51:03.729 [vert.x-eventloop-thread-1] INFO LogUtil [53353078eqId] org.folio.rest.RestVerticle start invoking getMetadataProviderJobExecutions | | 1627995063768 | 12:51:03.768 [vert.x-eventloop-thread-1] INFO LogUtil [53353117eqId] 127.0.0.1:45302 GET /metadata-provider/jobExecutions query=(status%20any%20%22COMMITTED%20ERROR%22)%20sortBy%20completedDate/sort.descending&limit=25 HTTP_1_1 200 1134479 4025 tid=fs00001034 OK | | 1627995063769 | 12:51:03.768 [vert.x-eventloop-thread-1] WARN PostgresClient [53353117eqId] EXPLAIN ANALYZE SELECT | | 1627995063769 | CASE | | 1627995063769 | WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb | | 1627995063769 | ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId', | | 1627995063769 | 'total', job_execution_progress.jsonb -> 'total', | | 1627995063769 | 'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int)) | | 1627995063769 | 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 | | 1627995063769 | FROM fs00001034_mod_source_record_manager.job_executions | | 1627995063769 | LEFT JOIN fs00001034_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid | | 1627995063769 | 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'))) | | 1627995063769 | ORDER BY left(lower(f_unaccent(job_executions.jsonb->>'completedDate')),600) DESC, lower(f_unaccent(job_executions.jsonb->>'completedDate')) DESC | | 1627995063769 | LIMIT 25 OFFSET 0; | | 1627995063769 | Limit (cost=6713.23..6727.04 rows=25 width=104) (actual time=1973.398..1977.070 rows=25 loops=1) | | 1627995063769 | InitPlan 1 (returns $0) | | 1627995063769 | -> Aggregate (cost=2608.94..2608.95 rows=1 width=8) (actual time=648.186..648.187 rows=1 loops=1) | | 1627995063769 | -> Bitmap Heap Scan on job_executions job_executions_1 (cost=35.05..2602.82 rows=2446 width=16) (actual time=0.390..647.752 rows=2712 loops=1) | | 1627995063769 | Recheck Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995063769 | Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE)) | | 1627995063769 | Heap Blocks: exact=35 | | 1627995063769 | -> Bitmap Index Scan on job_executions_status_idx_ft (cost=0.00..34.44 rows=2459 width=0) (actual time=0.223..0.223 rows=2712 loops=1) | | 1627995063769 | Index Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995063769 | -> Result (cost=4104.28..5455.70 rows=2446 width=104) (actual time=1973.397..1977.064 rows=25 loops=1) | | 1627995063769 | -> Sort (cost=4104.28..4110.40 rows=2446 width=289) (actual time=1973.314..1973.318 rows=25 loops=1) | | 1627995063769 | Sort Key: ("left"(lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text))), 600)) DESC, (lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text)))) DESC | | 1627995063769 | Sort Method: top-N heapsort Memory: 51kB | | 1627995063769 | -> Hash Right Join (cost=2633.40..4035.26 rows=2446 width=289) (actual time=1314.706..1969.791 rows=2712 loops=1) | | 1627995063769 | Hash Cond: (((job_execution_progress.jsonb ->> 'jobExecutionId'::text))::uuid = job_executions.id) | | 1627995063769 | -> Seq Scan on job_execution_progress (cost=0.00..140.13 rows=2713 width=199) (actual time=0.005..0.772 rows=2713 loops=1) | | 1627995063769 | -> Hash (cost=2602.82..2602.82 rows=2446 width=34) (actual time=666.297..666.298 rows=2712 loops=1) | | 1627995063769 | Buckets: 4096 Batches: 1 Memory Usage: 207kB | | 1627995063769 | -> Bitmap Heap Scan on job_executions (cost=35.05..2602.82 rows=2446 width=34) (actual time=0.414..665.422 rows=2712 loops=1) | | 1627995063769 | Recheck Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995063769 | Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE)) | | 1627995063769 | Heap Blocks: exact=35 | | 1627995063769 | -> Bitmap Index Scan on job_executions_status_idx_ft (cost=0.00..34.44 rows=2459 width=0) (actual time=0.254..0.254 rows=2712 loops=1) | | 1627995063769 | Index Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995063769 | Planning time: 1.390 ms | | 1627995063769 | Execution time: 1977.276 ms | | 1627995078198 | 12:51:18.198 [vert.x-eventloop-thread-1] INFO LogUtil [53367547eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995078198 | 12:51:18.198 [vert.x-eventloop-thread-1] INFO LogUtil [53367547eqId] 127.0.0.1:45332 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995085423 | 12:51:25.423 [vert.x-eventloop-thread-1] INFO LogUtil [53374772eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995085423 | 12:51:25.423 [vert.x-eventloop-thread-1] INFO LogUtil [53374772eqId] 127.0.0.1:45354 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995108230 | 12:51:48.230 [vert.x-eventloop-thread-1] INFO LogUtil [53397579eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995108230 | 12:51:48.230 [vert.x-eventloop-thread-1] INFO LogUtil [53397579eqId] 127.0.0.1:45466 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995109390 | Aug 03, 2021 12:51:49 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema | | 1627995109390 | INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK | | 1627995113823 | 12:51:53.823 [vert.x-eventloop-thread-1] INFO LogUtil [53403172eqId] org.folio.rest.RestVerticle start invoking getMetadataProviderJobExecutions | | 1627995114296 | 12:51:54.296 [vert.x-eventloop-thread-1] INFO LogUtil [53403645eqId] 127.0.0.1:45484 GET /metadata-provider/jobExecutions limit=100&query=%28%28status%20any%20%22COMMITTED%20ERROR%22%29%29%20sortby%20completedDate%2Fsort.descending HTTP_1_1 200 8356821 4906 tid=fs00001034 OK | | 1627995114297 | 12:51:54.296 [vert.x-eventloop-thread-1] WARN PostgresClient [53403645eqId] EXPLAIN ANALYZE SELECT | | 1627995114297 | CASE | | 1627995114297 | WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb | | 1627995114297 | ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId', | | 1627995114297 | 'total', job_execution_progress.jsonb -> 'total', | | 1627995114297 | 'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int)) | | 1627995114297 | 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 | | 1627995114297 | FROM fs00001034_mod_source_record_manager.job_executions | | 1627995114297 | LEFT JOIN fs00001034_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid | | 1627995114297 | 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'))) | | 1627995114297 | ORDER BY left(lower(f_unaccent(job_executions.jsonb->>'completedDate')),600) DESC, lower(f_unaccent(job_executions.jsonb->>'completedDate')) DESC | | 1627995114297 | LIMIT 100 OFFSET 0; | | 1627995114297 | Limit (cost=6737.69..6792.94 rows=100 width=104) (actual time=2210.315..2236.839 rows=100 loops=1) | | 1627995114297 | InitPlan 1 (returns $0) | | 1627995114297 | -> Aggregate (cost=2608.94..2608.95 rows=1 width=8) (actual time=827.688..827.689 rows=1 loops=1) | | 1627995114297 | -> Bitmap Heap Scan on job_executions job_executions_1 (cost=35.05..2602.82 rows=2446 width=16) (actual time=0.664..826.992 rows=2712 loops=1) | | 1627995114297 | Recheck Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995114297 | Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE)) | | 1627995114297 | Heap Blocks: exact=35 | | 1627995114297 | -> Bitmap Index Scan on job_executions_status_idx_ft (cost=0.00..34.44 rows=2459 width=0) (actual time=0.438..0.439 rows=2712 loops=1) | | 1627995114297 | Index Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995114297 | -> Result (cost=4128.74..5480.16 rows=2446 width=104) (actual time=2210.314..2236.820 rows=100 loops=1) | | 1627995114297 | -> Sort (cost=4128.74..4134.86 rows=2446 width=289) (actual time=2210.235..2210.250 rows=100 loops=1) | | 1627995114297 | Sort Key: ("left"(lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text))), 600)) DESC, (lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text)))) DESC | | 1627995114297 | Sort Method: top-N heapsort Memory: 128kB | | 1627995114297 | -> Hash Right Join (cost=2633.40..4035.26 rows=2446 width=289) (actual time=1525.559..2201.156 rows=2712 loops=1) | | 1627995114297 | Hash Cond: (((job_execution_progress.jsonb ->> 'jobExecutionId'::text))::uuid = job_executions.id) | | 1627995114297 | -> Seq Scan on job_execution_progress (cost=0.00..140.13 rows=2713 width=199) (actual time=0.006..0.870 rows=2713 loops=1) | | 1627995114297 | -> Hash (cost=2602.82..2602.82 rows=2446 width=34) (actual time=697.656..697.657 rows=2712 loops=1) | | 1627995114297 | Buckets: 4096 Batches: 1 Memory Usage: 207kB | | 1627995114297 | -> Bitmap Heap Scan on job_executions (cost=35.05..2602.82 rows=2446 width=34) (actual time=0.372..696.740 rows=2712 loops=1) | | 1627995114297 | Recheck Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995114297 | Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE)) | | 1627995114297 | Heap Blocks: exact=35 | | 1627995114297 | -> Bitmap Index Scan on job_executions_status_idx_ft (cost=0.00..34.44 rows=2459 width=0) (actual time=0.223..0.223 rows=2712 loops=1) | | 1627995114297 | Index Cond: (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery) | | 1627995114297 | Planning time: 1.367 ms | | 1627995114297 | Execution time: 2237.003 ms | | 1627995115454 | 12:51:55.454 [vert.x-eventloop-thread-1] INFO LogUtil [53404803eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995115455 | 12:51:55.455 [vert.x-eventloop-thread-1] INFO LogUtil [53404804eqId] 127.0.0.1:45616 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995120432 | Aug 03, 2021 12:52:00 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema | | 1627995120432 | INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK | | 1627995120441 | 12:52:00.441 [vert.x-eventloop-thread-1] INFO LogUtil [53409790eqId] org.folio.rest.RestVerticle start invoking getMetadataProviderJobExecutions | | 1627995120442 | 12:52:00.442 [vert.x-eventloop-thread-1] INFO LogUtil [53409791eqId] 127.0.0.1:45682 GET /metadata-provider/jobExecutions query=(status=%22%22%20NOT%20status=DISCARDED)%20AND%20(uiStatus==(%22PREPARING_FOR_PREVIEW%22%20OR%20%22READY_FOR_PREVIEW%22%20OR%20%22RUNNING%22))&limit=50 HTTP_1_1 200 14059 9 tid=fs00001034 OK | | 1627995130578 | 12:52:10.577 [vert.x-eventloop-thread-1] INFO LogUtil [53419926eqId] org.folio.rest.RestVerticle start invoking getMetadataProviderJobExecutions | | 1627995130578 | 12:52:10.578 [vert.x-eventloop-thread-1] INFO LogUtil [53419927eqId] 127.0.0.1:45748 GET /metadata-provider/jobExecutions query=(status=%22%22%20NOT%20status=DISCARDED)%20AND%20(uiStatus==(%22PREPARING_FOR_PREVIEW%22%20OR%20%22READY_FOR_PREVIEW%22%20OR%20%22RUNNING%22))&limit=50 HTTP_1_1 200 14059 1 tid=fs00001034 OK | | 1627995138260 | 12:52:18.260 [vert.x-eventloop-thread-1] INFO LogUtil [53427609eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995138260 | 12:52:18.260 [vert.x-eventloop-thread-1] INFO LogUtil [53427609eqId] 127.0.0.1:45786 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995145447 | 12:52:25.447 [vert.x-eventloop-thread-1] INFO LogUtil [53434796eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | | 1627995145447 | 12:52:25.447 [vert.x-eventloop-thread-1] INFO LogUtil [53434796eqId] 127.0.0.1:45854 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK | | 1627995168268 | 12:52:48.268 [vert.x-eventloop-thread-1] INFO LogUtil [53457617eqId] org.folio.rest.RestVerticle start invoking getAdminHealth | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------