QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=262056.35..262056.47 rows=50 width=44) (actual time=190.836..190.859 rows=50 loops=1) Buffers: shared hit=165374 dirtied=1 -> Sort (cost=262056.35..262277.28 rows=88375 width=44) (actual time=190.835..190.848 rows=50 loops=1) Sort Key: inputdocum0_.created_at, inputdocum0_.reception_id, inputdocum0_.reception_order Sort Method: top-N heapsort Memory: 31kB Buffers: shared hit=165374 dirtied=1 -> Append (cost=0.29..259120.59 rows=88375 width=44) (actual time=5.260..190.514 rows=1078 loops=1) Buffers: shared hit=165374 dirtied=1 -> Index Scan using input_document_00_indexation_activity_id_indexation_domain_idx1 on input_document_00 inputdocum0__1 (cost=0.29..12844.44 rows=4386 width=44) (actual time=5.259..9.211 rows=56 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: 6931 Buffers: shared hit=7989 -> Index Scan using input_document_01_indexation_activity_id_indexation_domain_idx1 on input_document_01 inputdocum0__2 (cost=0.29..12873.65 rows=4352 width=44) (actual time=5.529..9.709 rows=53 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: 7025 Buffers: shared hit=8372 -> Index Scan using input_document_02_indexation_activity_id_indexation_domain_idx1 on input_document_02 inputdocum0__3 (cost=0.29..12761.21 rows=4380 width=44) (actual time=6.005..9.832 rows=59 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=8275 -> Index Scan using input_document_03_indexation_activity_id_indexation_domain_idx1 on input_document_03 inputdocum0__4 (cost=0.29..13019.24 rows=4467 width=44) (actual time=5.382..9.862 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: 7015 Buffers: shared hit=8289 -> Index Scan using input_document_04_indexation_activity_id_indexation_domain_idx1 on input_document_04 inputdocum0__5 (cost=0.29..12800.57 rows=4353 width=44) (actual time=3.896..9.561 rows=50 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: 7102 Buffers: shared hit=8182 -> Index Scan using input_document_05_indexation_activity_id_indexation_domain_idx1 on input_document_05 inputdocum0__6 (cost=0.29..13551.07 rows=4600 width=44) (actual time=5.455..9.603 rows=71 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=8234 -> Index Scan using input_document_06_indexation_activity_id_indexation_domain_idx1 on input_document_06 inputdocum0__7 (cost=0.29..12792.32 rows=4349 width=44) (actual time=5.303..10.089 rows=55 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: 7028 Buffers: shared hit=8382 -> Index Scan using input_document_07_indexation_activity_id_indexation_domain_idx1 on input_document_07 inputdocum0__8 (cost=0.29..13524.32 rows=4590 width=44) (actual time=4.964..9.803 rows=55 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: 7072 Buffers: shared hit=8556 -> Index Scan using input_document_08_indexation_activity_id_indexation_domain_idx1 on input_document_08 inputdocum0__9 (cost=0.29..13222.97 rows=4531 width=44) (actual time=6.374..10.024 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: 7203 Buffers: shared hit=8409 -> Index Scan using input_document_09_indexation_activity_id_indexation_domain_idx1 on input_document_09 inputdocum0__10 (cost=0.29..12945.35 rows=4399 width=44) (actual time=5.608..9.712 rows=43 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: 7042 Buffers: shared hit=8186 -> Index Scan using input_document_10_indexation_activity_id_indexation_domain_idx1 on input_document_10 inputdocum0__11 (cost=0.29..13146.21 rows=4451 width=44) (actual time=4.734..9.246 rows=51 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: 6997 Buffers: shared hit=8136 -> Index Scan using input_document_11_indexation_activity_id_indexation_domain_idx1 on input_document_11 inputdocum0__12 (cost=0.29..12324.47 rows=4178 width=44) (actual time=5.053..9.310 rows=57 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: 6989 Buffers: shared hit=8134 -> Index Scan using input_document_12_indexation_activity_id_indexation_domain_idx1 on input_document_12 inputdocum0__13 (cost=0.29..13506.89 rows=4569 width=44) (actual time=5.539..8.605 rows=57 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=8418 -> Index Scan using input_document_13_indexation_activity_id_indexation_domain_idx1 on input_document_13 inputdocum0__14 (cost=0.29..13398.08 rows=4537 width=44) (actual time=6.058..9.401 rows=64 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: 6979 Buffers: shared hit=8281 dirtied=1 -> Index Scan using input_document_14_indexation_activity_id_indexation_domain_idx1 on input_document_14 inputdocum0__15 (cost=0.29..12748.84 rows=4391 width=44) (actual time=6.587..8.968 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: 6958 Buffers: shared hit=8274 -> Index Scan using input_document_15_indexation_activity_id_indexation_domain_idx1 on input_document_15 inputdocum0__16 (cost=0.29..12835.44 rows=4434 width=44) (actual time=5.711..9.774 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: 6957 Buffers: shared hit=8236 -> Index Scan using input_document_16_indexation_activity_id_indexation_domain_idx1 on input_document_16 inputdocum0__17 (cost=0.29..12660.13 rows=4373 width=44) (actual time=7.794..11.250 rows=45 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=8279 -> Index Scan using input_document_17_indexation_activity_id_indexation_domain_idx1 on input_document_17 inputdocum0__18 (cost=0.29..13197.34 rows=4540 width=44) (actual time=5.942..8.533 rows=51 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: 7086 Buffers: shared hit=8439 -> Index Scan using input_document_18_indexation_activity_id_indexation_domain_idx1 on input_document_18 inputdocum0__19 (cost=0.29..11642.48 rows=4029 width=44) (actual time=6.790..9.283 rows=44 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=8138 -> Index Scan using input_document_19_indexation_activity_id_indexation_domain_idx1 on input_document_19 inputdocum0__20 (cost=0.29..12883.71 rows=4466 width=44) (actual time=5.687..8.579 rows=44 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: 7064 Buffers: shared hit=8165 Planning Time: 6.280 ms Execution Time: 191.048 ms (110 rows)