QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=261429.93..262013.30 rows=5000 width=44) (actual time=73.216..73.989 rows=1232 loops=1) Buffers: shared hit=166387 dirtied=7 -> Gather Merge (cost=261429.93..270022.79 rows=73648 width=44) (actual time=73.215..73.811 rows=1232 loops=1) Workers Planned: 2 Workers Launched: 2 Buffers: shared hit=166387 dirtied=7 -> Sort (cost=260429.90..260521.96 rows=36824 width=44) (actual time=67.477..67.513 rows=411 loops=3) Sort Key: inputdocum0_.created_at, inputdocum0_.reception_id, inputdocum0_.reception_order Sort Method: quicksort Memory: 55kB Buffers: shared hit=166387 dirtied=7 Worker 0: Sort Method: quicksort Memory: 60kB Worker 1: Sort Method: quicksort Memory: 55kB -> Parallel Append (cost=0.29..257983.37 rows=36824 width=44) (actual time=6.110..67.258 rows=411 loops=3) Buffers: shared hit=166337 dirtied=7 -> Parallel Index Scan using input_document_05_indexation_activity_id_indexation_domain_idx1 on input_document_05 inputdocum0__6 (cost=0.29..13505.31 rows=2706 width=44) (actual time=4.474..8.040 rows=75 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 6984 Buffers: shared hit=8282 -> Parallel Index Scan using input_document_07_indexation_activity_id_indexation_domain_idx1 on input_document_07 inputdocum0__8 (cost=0.29..13478.67 rows=2700 width=44) (actual time=5.316..11.536 rows=61 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7071 Buffers: shared hit=8609 dirtied=1 -> Parallel Index Scan using input_document_12_indexation_activity_id_indexation_domain_idx1 on input_document_12 inputdocum0__13 (cost=0.29..13461.40 rows=2688 width=44) (actual time=5.428..8.240 rows=61 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7026 Buffers: shared hit=8476 -> Parallel Index Scan using input_document_13_indexation_activity_id_indexation_domain_idx1 on input_document_13 inputdocum0__14 (cost=0.29..13352.92 rows=2669 width=44) (actual time=6.148..10.358 rows=72 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 6976 Buffers: shared hit=8321 -> Parallel Index Scan using input_document_08_indexation_activity_id_indexation_domain_idx1 on input_document_08 inputdocum0__9 (cost=0.29..13177.96 rows=2665 width=44) (actual time=5.123..8.169 rows=66 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7205 Buffers: shared hit=8460 -> Parallel Index Scan using input_document_17_indexation_activity_id_indexation_domain_idx1 on input_document_17 inputdocum0__18 (cost=0.29..13152.15 rows=2671 width=44) (actual time=7.992..10.967 rows=63 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7084 Buffers: shared hit=8503 -> Parallel Index Scan using input_document_10_indexation_activity_id_indexation_domain_idx1 on input_document_10 inputdocum0__11 (cost=0.29..13101.85 rows=2618 width=44) (actual time=4.224..8.156 rows=63 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 6995 Buffers: shared hit=8173 -> Parallel Index Scan using input_document_03_indexation_activity_id_indexation_domain_idx1 on input_document_03 inputdocum0__4 (cost=0.29..12974.79 rows=2628 width=44) (actual time=4.992..8.954 rows=61 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7014 Buffers: shared hit=8336 -> Parallel Index Scan using input_document_09_indexation_activity_id_indexation_domain_idx1 on input_document_09 inputdocum0__10 (cost=0.29..12901.62 rows=2588 width=44) (actual time=6.168..10.321 rows=61 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7037 Buffers: shared hit=8228 -> Parallel Index Scan using input_document_19_indexation_activity_id_indexation_domain_idx1 on input_document_19 inputdocum0__20 (cost=0.29..12839.26 rows=2627 width=44) (actual time=6.840..9.910 rows=54 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7062 Buffers: shared hit=8208 -> Parallel Index Scan using input_document_01_indexation_activity_id_indexation_domain_idx1 on input_document_01 inputdocum0__2 (cost=0.29..12830.23 rows=2560 width=44) (actual time=6.010..11.036 rows=61 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7027 Buffers: shared hit=8439 dirtied=1 -> Parallel Index Scan using input_document_00_indexation_activity_id_indexation_domain_idx1 on input_document_00 inputdocum0__1 (cost=0.29..12800.79 rows=2580 width=44) (actual time=5.043..9.051 rows=49 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 6927 Buffers: shared hit=8011 -> Parallel Index Scan using input_document_15_indexation_activity_id_indexation_domain_idx1 on input_document_15 inputdocum0__16 (cost=0.29..12791.22 rows=2608 width=44) (actual time=3.162..5.227 rows=36 loops=2) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 3478 Buffers: shared hit=8305 -> Parallel Index Scan using input_document_04_indexation_activity_id_indexation_domain_idx1 on input_document_04 inputdocum0__5 (cost=0.29..12757.31 rows=2561 width=44) (actual time=1.986..5.141 rows=30 loops=2) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 3550 Buffers: shared hit=8211 dirtied=1 -> Parallel Index Scan using input_document_06_indexation_activity_id_indexation_domain_idx1 on input_document_06 inputdocum0__7 (cost=0.29..12749.00 rows=2558 width=44) (actual time=5.223..10.879 rows=60 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7031 Buffers: shared hit=8431 dirtied=1 -> Parallel Index Scan using input_document_02_indexation_activity_id_indexation_domain_idx1 on input_document_02 inputdocum0__3 (cost=0.29..12717.71 rows=2576 width=44) (actual time=6.613..11.165 rows=61 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7053 Buffers: shared hit=8304 dirtied=1 -> Parallel Index Scan using input_document_14_indexation_activity_id_indexation_domain_idx1 on input_document_14 inputdocum0__15 (cost=0.29..12705.16 rows=2583 width=44) (actual time=7.499..10.569 rows=54 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 6956 Buffers: shared hit=8306 -> Parallel Index Scan using input_document_16_indexation_activity_id_indexation_domain_idx1 on input_document_16 inputdocum0__17 (cost=0.29..12616.55 rows=2572 width=44) (actual time=6.924..10.732 rows=54 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 6985 Buffers: shared hit=8340 -> Parallel Index Scan using input_document_11_indexation_activity_id_indexation_domain_idx1 on input_document_11 inputdocum0__12 (cost=0.29..12282.94 rows=2458 width=44) (actual time=5.599..10.892 rows=63 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 6983 Buffers: shared hit=8172 dirtied=1 -> Parallel Index Scan using input_document_18_indexation_activity_id_indexation_domain_idx1 on input_document_18 inputdocum0__19 (cost=0.29..11602.43 rows=2370 width=44) (actual time=8.538..11.839 rows=61 loops=1) Index Cond: (indexation_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) Filter: ((locked_at IS NULL) AND (locked_by_app IS NULL) AND (locked_by_user IS NULL) AND (lock_time_out IS NULL) AND active_content AND (archiving_state <> 'DESTROYED'::text) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text)) Rows Removed by Filter: 7024 Buffers: shared hit=8222 dirtied=1 Planning Time: 5.769 ms Execution Time: 74.293 ms (116 rows)