QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=324.05..16073.82 rows=50 width=44) (actual time=1663688.290..1663696.151 rows=50 loops=1) Buffers: shared hit=114672881 read=5725197 dirtied=38564 written=24394 I/O Timings: shared/local read=1481378.069 write=313.574 -> Incremental Sort (cost=324.05..27838050.13 rows=88375 width=44) (actual time=1663688.289..1663696.144 rows=50 loops=1) Sort Key: inputdocum0_.created_at, inputdocum0_.reception_id, inputdocum0_.reception_order Presorted Key: inputdocum0_.created_at Full-sort Groups: 2 Sort Method: quicksort Average Memory: 27kB Peak Memory: 27kB Buffers: shared hit=114672881 read=5725197 dirtied=38564 written=24394 I/O Timings: shared/local read=1481378.069 write=313.574 -> Merge Append (cost=9.08..27834073.25 rows=88375 width=44) (actual time=1663655.490..1663696.068 rows=53 loops=1) Sort Key: inputdocum0_.created_at Buffers: shared hit=114672878 read=5725197 dirtied=38564 written=24394 I/O Timings: shared/local read=1481378.069 write=313.574 -> Index Scan using input_document_00_created_at_idx on input_document_00 inputdocum0__1 (cost=0.43..1393473.44 rows=4386 width=44) (actual time=71549.638..71550.023 rows=4 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6142526 Buffers: shared hit=5765368 read=249016 dirtied=1845 I/O Timings: shared/local read=63290.786 -> Index Scan using input_document_01_created_at_idx on input_document_01 inputdocum0__2 (cost=0.43..1393184.39 rows=4352 width=44) (actual time=78042.848..78045.976 rows=2 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6143127 Buffers: shared hit=5738497 read=284482 dirtied=1962 I/O Timings: shared/local read=69615.236 -> Index Scan using input_document_02_created_at_idx on input_document_02 inputdocum0__3 (cost=0.43..1392610.99 rows=4380 width=44) (actual time=81013.719..81015.228 rows=5 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6142365 Buffers: shared hit=5724544 read=289987 dirtied=1815 I/O Timings: shared/local read=72137.057 -> Index Scan using input_document_03_created_at_idx on input_document_03 inputdocum0__4 (cost=0.43..1393923.23 rows=4467 width=44) (actual time=199595.759..199598.812 rows=2 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6146675 Buffers: shared hit=5543097 read=475116 dirtied=1981 written=813 I/O Timings: shared/local read=189813.632 write=34.866 -> Index Scan using input_document_04_created_at_idx on input_document_04 inputdocum0__5 (cost=0.43..1397122.98 rows=4353 width=44) (actual time=82145.692..82146.951 rows=6 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6147554 Buffers: shared hit=5719152 read=304006 dirtied=1920 I/O Timings: shared/local read=73345.926 -> Index Scan using input_document_05_created_at_idx on input_document_05 inputdocum0__6 (cost=0.43..1388617.40 rows=4600 width=44) (actual time=82586.906..82587.807 rows=4 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6141686 Buffers: shared hit=5711928 read=301639 dirtied=1898 I/O Timings: shared/local read=74137.666 -> Index Scan using input_document_06_created_at_idx on input_document_06 inputdocum0__7 (cost=0.43..1390531.29 rows=4349 width=44) (actual time=63089.152..63090.770 rows=3 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6145079 Buffers: shared hit=5779774 read=241619 dirtied=1922 I/O Timings: shared/local read=54763.294 -> Index Scan using input_document_07_created_at_idx on input_document_07 inputdocum0__8 (cost=0.43..1390230.46 rows=4590 width=44) (actual time=81109.357..81110.828 rows=3 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6142853 Buffers: shared hit=5749729 read=277663 dirtied=1941 I/O Timings: shared/local read=72473.615 -> Index Scan using input_document_08_created_at_idx on input_document_08 inputdocum0__9 (cost=0.43..1391099.15 rows=4531 width=44) (actual time=74895.899..74897.421 rows=6 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6144254 Buffers: shared hit=5777691 read=241200 dirtied=1950 I/O Timings: shared/local read=65971.028 -> Index Scan using input_document_09_created_at_idx on input_document_09 inputdocum0__10 (cost=0.43..1392014.47 rows=4399 width=44) (actual time=69633.668..69655.958 rows=5 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6142825 Buffers: shared hit=5773052 read=242699 dirtied=1841 I/O Timings: shared/local read=60391.646 -> Index Scan using input_document_10_created_at_idx on input_document_10 inputdocum0__11 (cost=0.43..1390727.36 rows=4451 width=44) (actual time=79189.038..79189.118 rows=4 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6140756 Buffers: shared hit=5758549 read=255973 dirtied=1845 I/O Timings: shared/local read=70141.546 -> Index Scan using input_document_11_created_at_idx on input_document_11 inputdocum0__12 (cost=0.43..1392159.62 rows=4178 width=44) (actual time=81230.619..81231.149 rows=6 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6143392 Buffers: shared hit=5718755 read=294731 dirtied=1956 I/O Timings: shared/local read=72242.944 -> Index Scan using input_document_12_created_at_idx on input_document_12 inputdocum0__13 (cost=0.43..1389085.03 rows=4569 width=44) (actual time=80568.728..80568.743 rows=3 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6142009 Buffers: shared hit=5729875 read=297063 dirtied=1901 written=23581 I/O Timings: shared/local read=71003.146 write=278.708 -> Index Scan using input_document_13_created_at_idx on input_document_13 inputdocum0__14 (cost=0.43..1390915.23 rows=4537 width=44) (actual time=92845.510..92845.536 rows=2 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6140388 Buffers: shared hit=5718123 read=294846 dirtied=1978 I/O Timings: shared/local read=82457.429 -> Index Scan using input_document_14_created_at_idx on input_document_14 inputdocum0__15 (cost=0.43..1390496.37 rows=4391 width=44) (actual time=76680.146..76680.493 rows=3 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6145213 Buffers: shared hit=5730831 read=292745 dirtied=1938 I/O Timings: shared/local read=67345.796 -> Index Scan using input_document_15_created_at_idx on input_document_15 inputdocum0__16 (cost=0.43..1389344.68 rows=4434 width=44) (actual time=79121.128..79121.128 rows=1 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6142544 Buffers: shared hit=5736153 read=287998 dirtied=1944 I/O Timings: shared/local read=69545.597 -> Index Scan using input_document_16_created_at_idx on input_document_16 inputdocum0__17 (cost=0.43..1391248.91 rows=4373 width=44) (actual time=50357.406..50357.748 rows=4 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6143612 Buffers: shared hit=5783032 read=241665 dirtied=1998 I/O Timings: shared/local read=40910.123 -> Index Scan using input_document_17_created_at_idx on input_document_17 inputdocum0__18 (cost=0.43..1390490.21 rows=4540 width=44) (actual time=77469.969..77470.333 rows=3 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6144228 Buffers: shared hit=5747329 read=278125 dirtied=1988 I/O Timings: shared/local read=68235.691 -> Index Scan using input_document_18_created_at_idx on input_document_18 inputdocum0__19 (cost=0.43..1391527.45 rows=4029 width=44) (actual time=77176.667..77176.667 rows=1 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6144211 Buffers: shared hit=5745648 read=276205 dirtied=1989 I/O Timings: shared/local read=67795.868 -> Index Scan using input_document_19_created_at_idx on input_document_19 inputdocum0__20 (cost=0.43..1392918.55 rows=4466 width=44) (actual time=85353.600..85355.291 rows=5 loops=1) 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_domain_id = '2d29daf6-e151-479a-a52a-78b08bb3009d'::uuid) AND (indexation_subsidiary_id = '9f9df402-f70b-40d9-b283-a3c35232469a'::uuid) AND (creation_state = 'READY'::text) AND (processing_state = 'PENDING_INDEXATION'::text)) Rows Removed by Filter: 6143200 Buffers: shared hit=5721751 read=298419 dirtied=1952 I/O Timings: shared/local read=75760.042 Planning: Buffers: shared hit=7 Planning Time: 8.371 ms Execution Time: 1663700.900 ms (117 rows)