explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 62Pnd : Optimization for: plan #4wlv

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 6,739.499 ↓ 1.2 1,629,252 1

Nested Loop Left Join (cost=315,737.73..1,954,148.05 rows=1,352,215 width=3,929) (actual time=1,492.049..6,739.499 rows=1,629,252 loops=1)

2. 454.573 5,265.303 ↓ 1.2 1,629,252 1

Hash Left Join (cost=315,737.30..1,255,934.81 rows=1,352,215 width=3,832) (actual time=1,492.027..5,265.303 rows=1,629,252 loops=1)

  • Hash Cond: (personneop5_.personne_morale_id = personnemo7_.id)
3. 2,064.472 4,678.136 ↓ 1.2 1,629,252 1

Hash Join (cost=292,135.14..1,227,261.83 rows=1,352,215 width=3,708) (actual time=1,359.424..4,678.136 rows=1,629,252 loops=1)

  • Hash Cond: (actionenti0_.orientation_id = orientatio1_.id)
4. 411.883 1,937.653 ↓ 1.0 1,629,252 1

Merge Left Join (cost=170,690.18..345,378.01 rows=1,593,262 width=1,704) (actual time=592.845..1,937.653 rows=1,629,252 loops=1)

  • Merge Cond: (actionenti0_.personne_opportunite_id = personneop5_.id)
5. 775.614 775.614 ↓ 1.0 1,629,252 1

Index Scan using crm_action_personne_opportunite_id_fk_idx on crm_action actionenti0_ (cost=0.43..163,947.69 rows=1,593,262 width=1,513) (actual time=0.022..775.614 rows=1,629,252 loops=1)

  • Filter: (((supprime IS NULL) OR (NOT supprime)) AND ((type_echeance)::text <> 'ANNULEE'::text) AND (((date_realisation IS NULL) AND (date_echeance < '2019-09-05 00:00:00'::timestamp without time zone)) OR ((date_realisation IS NULL) AND (date_echeance >= '2019-09-05 00:00:00'::timestamp without time zone) AND (date_echeance <= '2019-09-05 23:59:59'::timestamp without time zone)) OR ((date_realisation IS NULL) AND (date_echeance > '2019-09-05 23:59:59'::timestamp without time zone)) OR ((type_echeance)::text = 'FAIT'::text)))
  • Rows Removed by Filter: 4275
6. 65.141 750.156 ↓ 1.9 752,089 1

Materialize (cost=169,417.02..171,388.07 rows=394,209 width=191) (actual time=584.116..750.156 rows=752,089 loops=1)

7. 320.066 685.015 ↓ 1.0 394,215 1

Sort (cost=169,417.02..170,402.54 rows=394,209 width=191) (actual time=584.111..685.015 rows=394,215 loops=1)

  • Sort Key: personneop5_.id
  • Sort Method: external merge Disk: 37248kB
8. 156.961 364.949 ↓ 1.0 394,216 1

Merge Left Join (cost=125.69..60,013.05 rows=394,209 width=191) (actual time=0.040..364.949 rows=394,216 loops=1)

  • Merge Cond: (personneop5_.personne_physique_id = personneph6_.id)
9. 95.476 95.476 ↓ 1.0 394,216 1

Index Scan using crm_personne_opportunite_personne_physique_id_fk_idx on crm_personne_opportunite personneop5_ (cost=0.42..23,071.93 rows=394,209 width=48) (actual time=0.017..95.476 rows=394,216 loops=1)

10. 112.512 112.512 ↓ 1.0 895,782 1

Index Scan using core_personne_physique_pk on core_personne_physique personneph6_ (cost=0.42..29,866.69 rows=863,491 width=143) (actual time=0.015..112.512 rows=895,782 loops=1)

11. 331.902 676.011 ↓ 1.2 326,734 1

Hash (cost=49,194.73..49,194.73 rows=277,299 width=2,004) (actual time=676.011..676.011 rows=326,734 loops=1)

  • Buckets: 2048 Batches: 256 Memory Usage: 598kB
12. 125.486 344.109 ↓ 1.2 326,734 1

Hash Join (cost=224.27..49,194.73 rows=277,299 width=2,004) (actual time=0.631..344.109 rows=326,734 loops=1)

  • Hash Cond: (orientatio1_.etablissement_id = etablissem3_.id)
13. 112.758 218.004 ↓ 1.0 326,734 1

Merge Join (cost=1.59..44,973.81 rows=326,731 width=1,780) (actual time=0.009..218.004 rows=326,734 loops=1)

  • Merge Cond: (opportunit2_.id = orientatio1_.opportunite_id)
14. 44.764 44.764 ↓ 1.0 164,942 1

Index Scan using crm_opportunite_pk on crm_opportunite opportunit2_ (cost=0.42..10,861.65 rows=164,939 width=1,151) (actual time=0.004..44.764 rows=164,942 loops=1)

15. 60.482 60.482 ↓ 1.0 326,734 1

Index Scan using crm_orientation_opportunite_id_etablissement_id_idx on crm_orientation orientatio1_ (cost=0.42..29,634.82 rows=326,731 width=629) (actual time=0.003..60.482 rows=326,734 loops=1)

16. 0.085 0.619 ↓ 1.2 271 1

Hash (cost=219.81..219.81 rows=230 width=224) (actual time=0.619..0.619 rows=271 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 69kB
17. 0.083 0.534 ↓ 1.2 271 1

Merge Join (cost=190.90..219.81 rows=230 width=224) (actual time=0.243..0.534 rows=271 loops=1)

  • Merge Cond: (etablissem3_.personne_morale_id = personnemo4_.id)
18. 0.107 0.411 ↓ 1.2 271 1

Merge Join (cost=190.62..206.07 rows=230 width=197) (actual time=0.240..0.411 rows=271 loops=1)

  • Merge Cond: (personnemo4_1_.id = etablissem3_.personne_morale_id)
19. 0.040 0.040 ↑ 3,047.5 285 1

Index Scan using core_personne_pk on core_personne personnemo4_1_ (cost=0.42..33,971.90 rows=868,532 width=97) (actual time=0.002..0.040 rows=285 loops=1)

20. 0.073 0.264 ↓ 1.2 271 1

Sort (cost=190.17..190.75 rows=230 width=100) (actual time=0.237..0.264 rows=271 loops=1)

  • Sort Key: etablissem3_.personne_morale_id
  • Sort Method: quicksort Memory: 63kB
21. 0.191 0.191 ↓ 1.2 271 1

Seq Scan on core_etablissement etablissem3_ (cost=0.00..181.15 rows=230 width=100) (actual time=0.006..0.191 rows=271 loops=1)

  • Filter: (uuid = ANY ('{3901e7ee-d55f-4243-b535-440670ad8e6c,9df56380-8547-47f0-8774-8c973b0a8c2e,d06f4ced-54cb-4fe6-ba5d-2cc21ed4ffed,a4127f2f-dd40-4747-a72e-7cbee5c56966,97d43695-7292-421e-b1a5-3555429ecba8,39a0af11-ec17-4c16-b917-df307ebcf025,767e79c2-8494-41eb-9853-d1d78ea569ec,b9a02d53-f4f3-413c-b729-3afa3bfb9904,8f066cf8-9b73-4214-ae00-04ad61015b27,9ccd8aab-c033-426f-be33-bcb55622f68d,b65459d8-8a45-44eb-b15a-a8140bc47fbb,641a0ae3-ffe5-4885-8bde-fb6eedfad0c7,7cd7c703-e6de-47b1-b0ea-bd0caaef21a6,d255fed3-3394-4ab3-89ad-219738cd2f43,15c1e94b-877c-480e-94b1-4ef6807dbfd4,ea7ef2da-329e-4896-ba98-104a0c1b6472,95f643e6-949d-4983-8b8f-c02b77826d30,eca1f7da-2694-4147-86a3-5781d61ec98c,22f6cd50-82b9-4d37-a0dd-af7a177adcef,61a319db-ab81-4777-ae4f-a25398bbca32,a15ddd69-09d4-4503-9ab2-48b015669d99,5f80a05a-a6c7-4a99-a6da-428ceb542a98,93dcd167-4d60-465f-b7f6-21d422b90f3a,3976e7c2-ebe7-4da3-a466-9a88a4c372fa,3b972476-9eb7-417f-9a1a-ccfdf06c4a8a,de1bf506-d44b-4125-9480-a423e9da4120,7a8ab542-d436-4fe2-975a-736a7bf287f4,bc7feb4a-9f47-4178-838a-d273086828b1,58b4c8f4-4cc8-4798-9813-60e26be6de2c,b63c22dc-47cd-4175-9aca-5ee2138a23d6,b82f0a59-0711-495e-8c58-af93b73112ec,0873cad8-8330-4fff-9b30-b87d3e80ed9c,d4b28b13-5e9a-443d-a46d-90a95c1a7def,3bddfd93-fb3e-4c71-a82d-314f535bc10f,b66f54a5-6216-4e6f-98e0-ca793527c537,e87e9c0a-28b2-491e-9e74-b78afc462a5b,32b2b29a-7aff-4bbc-b550-10a3f1c03965,24a6b517-5fec-4424-a5dc-6637b86aa5c6,5ab364a2-6d56-4fa3-83ff-82ac40e37915,e1981603-96e1-49e1-9a12-d931ecc7033e,369cc99b-46d2-424b-a407-58adcd9e26eb,25330bfe-70c7-4acd-92dc-89fe8e803f23,6fcd2381-88b4-492e-bff0-6845e69f64bb,07394282-bf2c-4624-8464-4f9ee273ef72,685d81cc-d2ca-47eb-80ac-f367a020d512,5bb06cce-0ccc-42ac-940e-b68ce36c20ba,b0337825-5a35-42a8-9577-b65f5d89de60,560ed040-64ca-4be9-b8ca-c96ae7295bb6,7e6f157e-ab6f-4f36-94ec-5eec09ce28d5,c4289b26-8ee0-47d2-9f90-ade01adaa8c3,cd2ba0d4-60d3-4f72-a4d3-7a7149e72541,3e84f032-2604-4154-b5ff-2c6dc274645b,ccc21a9c-2c08-43ed-870b-1e5fac3c8e8f,3522cb5f-fa8a-4a90-9e93-4ffae141e613,e6c1b194-3595-4ddb-90c8-1e5d20ee8102,5ae322c6-bde1-4c66-a73f-510249882075,6ec5fa7a-e24f-4ed7-853b-0edb651332b7,90a55e2f-4988-4d33-abbe-6995f65bdc24,975aaeac-2a6d-4ff0-b319-3f7b1431f85d,2d8c7bc2-7303-4f9f-9170-9ac00df344f6,243fd3d2-40d5-454d-946e-905df7c801e9,e8e9395c-8da1-4a6f-9f16-c4dd0dcb0c17,380feeb1-13a5-4080-a42a-1987806cbc34,95ee5ebb-2fe4-4436-9ab4-e550c51a0416,ae6d904a-1dbd-476d-be2d-0f25b83fffaf,083a1538-648a-467e-8f6e-c0da57ff83c8,84632f8d-c338-4e0a-a478-228da541a11e,58c6891a-c9fe-4ab1-861f-64783c7acef7,0ad890e1-c158-4c57-8aef-1d371454d8c4,b2d3db6f-8c7a-490f-884d-2d0bde50535a,bf508e6c-1fca-4005-af4c-523c12d26dd9,7fdf5d0b-b058-4294-a03c-9ac790db16b2,c90dd932-032f-4969-abd7-5326176bb96e,19b3b140-bd65-458b-8bb2-3370e25fbe0e,fcfab359-422d-42c8-9b79-58411cf1f001,0523f947-c714-4829-b844-c504bd246fb2,7fd8c4d6-702c-4509-9205-65df984b192b,0706b2de-65ef-4700-8509-e3d018960fed,defcfc39-a598-4bdb-8f13-0f632d561f35,220c955e-50a1-43af-8827-0545146749c3,52c8f2e0-1db2-45c1-8d31-9de9730f7f11,459c04ad-4120-44fa-98fc-0b715173c48b,3e34219b-9840-46f7-a26a-1fac6407ae47,82e09254-b679-4a03-a364-c5612b99bdcc,2f65b729-3eab-4d26-9ca9-20a54852313f,509ff380-05f9-424c-aceb-45c6914cdc6a,1ac93fe1-d88f-49d3-bd9b-bb65dcaef886,d87d487d-3bc9-4344-bfca-ff1fdd07ddf8,67759657-cb1a-44ef-ad95-ca2c70d8fd11,dcbc72a5-5526-4fc8-a112-7720668bbae9,c042a090-9e84-416e-8ac1-797415ad9787,8ebb0424-1993-421c-a8df-e7a93f7fd5b1,86f44132-2e57-4221-b72c-8405db2e911c,7a04c86d-9f7e-4fef-bb58-37540da5c9fa,b22e5086-5a26-407a-b7d5-b8511bdc3200,d5c7b6b4-a73d-4916-9ff7-53ecab82e46d,01d294ed-7851-4e5c-9b67-eb46bb1f4aa2,37c69088-195d-4395-9019-bba2e55c8fcf,afd8fef0-0f9d-4cd9-ba08-b353b703749a,ad993ec0-e669-43e8-9904-b809f73be25a,632ce036-3927-468c-83d1-acdf898ed885,1ae3c28f-3c85-48cc-b9d0-4db0080d50fe,87200e27-0dc3-4168-b7f6-526e4bacd92f,a04b542e-0488-4dfe-bb99-9e43c8f81286,48c5a2a7-0bdc-42ac-802c-e5f7dbcc7bbf,14019f48-6d2b-4679-96d0-339318708593,2ff8a0ab-9270-457e-9660-3ac7115ea71b,f0c091ec-d92b-453f-94d2-9d53387a6800,18fd880b-708b-4286-aa63-32514fd7d9db,bb7c7a2b-52db-4220-b4fc-ea5ac90bdcc7,e15d5924-8397-454a-b01b-94cef800fcb6,94bdfdc9-fe87-4874-9aeb-83721c551282,0631184e-8505-415d-8a19-3d2c805d7986,8962046e-6326-4612-ba42-5a30fb3ab5ba,cd45191c-a27b-42b4-9a81-b9a09663dd1b,a34bc999-8b12-4d95-89bf-67d7b6cece2b,f2fbfd67-d79b-4e28-b98a-5f2d040ad25b,f982650e-fcc3-4f85-bf31-f6d64958cbae,16e6656b-b302-457c-aae3-67f0a7b50b8e,af0d0fd9-9b1b-49c8-9f7a-077e00e2e83c,4bf89689-db03-4df7-be24-8fec04d1b07c,4c8fa158-d5d6-4c9d-9e2a-8535faa669c7,72a50520-0f56-4a3e-9241-d35b67c1f4d2,f758e78b-5b22-419f-a800-859a7e44bd55,dfee69dd-85de-477e-8481-5dfbcf02be0d,824d6b14-c136-4ff2-bd17-bbf431053097,b2484e7c-0611-475c-90e2-b20dedb7e0cc,97e9cdf4-bd27-4027-b88b-8b27309b9ac5,6ff97867-cb1c-4f5f-9f1d-2fca4b54deae,5173fd22-d49b-40fa-b050-32caffbce5e6,ba2fa2a8-df45-4b75-add3-f3d61a273e64,3be97788-51e6-484e-93ae-72a2026b245d,94c81181-b725-4c26-86b0-26b875111fa0,2e34e0b6-a70d-42b2-8e13-1063d6d71b62,d0a6ea9a-5fcb-4046-9c56-94f662a53b4d,b30a2412-b1e9-473b-b941-4f531c22cd03,42b9c4e0-3d34-4750-b077-b656feb02a56,af26a77d-1848-4507-9f3e-c4594c36babf,7f13dffe-9ff1-422f-9e7b-ecd59af1b791,1ef05cee-0b9a-4d4a-abf8-ecd312aa17b0,5c38bdfa-b796-43f0-beb0-8949f3655bc7,25c59c8a-5728-4a79-9653-7be8d71b61be,65ea0df8-6935-4fd6-9399-09177531f049,cb70f156-ec38-4726-bdc4-0ea7f3d07482,54d0e9c9-64d4-41ac-80d9-1078913048fe,6806419b-37a8-4369-8224-0cf08ba23124,ba026dec-9ede-4f10-a959-301474180866,6fcfe51c-e535-4263-84f0-58a081f6b336,91b4ee88-09e9-48af-9978-3582674ec8d8,ccd9e6b0-be82-4b76-9e2f-9605c54c03e1,c9813a95-41e0-430e-abfb-00541367ba16,22b11d22-12a4-4633-ad8c-0560bf118bdc,cb87e6e5-7131-4569-a581-9a3629b38417,7370343d-3b48-44d5-bd22-a2f06c9dfab6,2e8e170b-ae14-4d46-ae0f-73a210ed8cbd,34291af4-7bf4-4459-963b-beed8070acfc,2585bb42-feb5-42bb-a961-033e681765ad,e2e98256-0e30-4e6e-ac25-c02e7c3a43e1,4bd07f21-90c9-4b3c-82e5-81c1477bda68,1bd48272-6967-4239-9477-a4f399e492ac,a30a3c75-e431-4e31-95d5-86ab33d240ee,935ef801-de24-4e0e-886b-f313a132e202,c7264606-304f-42db-9549-360789f8c43d,2ef5479e-2f63-4d36-b1ce-8c5b01c5de2a,15ae2e12-67c4-4e76-bccc-9053766ff7b9,3f007965-a7d7-44b9-8d9f-1edc45124613,6567ba93-a7e5-41ac-8862-87ccb8a369fd,7087caac-cce4-4061-8ca2-9f5409af8dba,e1bc2271-4bed-4de3-ad40-dddc868e3e80,f7e89181-2074-4bf8-8b7b-e94d818cb30d,21dd7506-d83d-4e82-b766-04ba1ba0194a,618dd287-1663-46d3-822c-e975593caa89,d7d885ce-c1e5-4189-a95e-8a8f2a922863,ea58fe19-e7e0-4a52-b213-b294b864d24b,a2bbdfdc-173d-4ae0-9fd3-789f611a35b7,3db2229f-dbb0-4e94-a388-365bf14fc7c8,b359452b-2b7e-4691-be04-335a9f7604d0,0e7e2458-60b8-4346-a564-da198d230ce3,e6856296-486d-434b-81db-f6acc50bf02f,b18b68ff-3a3c-4b24-9003-339ef71f4387,987f5768-2997-4d2f-a63d-aed04ec6eaee,ae5847f9-3879-4bfe-b30a-43d86f1a6485,8e316106-9e2d-492c-8846-d9f7fb1b4ff1,a6e2506a-3f4f-4515-a13b-45090f88ea06,7d447f05-da8b-4040-8040-f0f225ee84b9,af676ad7-1baa-4938-86f6-654cc7943463,f3839107-55cd-4313-970b-a04fd71dbf72,0013041c-a305-4a17-b37f-bba45b4899ff,72157f49-06d1-4344-b26b-bf0786829654,7d64187d-4287-4497-b1bc-ac701b2bb29b,75e8b1d0-0f4d-47be-b669-2eb38ba316c5,eb539cae-8955-4d40-819d-eeb008eb2d56,8c84bb20-5b23-44a8-a076-fc1d7e20e91f,08905aff-92d5-46ab-a2d7-d199c0d88007,0be5db5f-fb3a-419f-b9cb-9a2f9c4dca36,9585c30a-e716-40bf-bc6c-ecdbd3abe9b8,3292b57f-5126-4fbd-830a-e67e72ff957e,b0b639c7-87b9-4ff3-8b32-2baf6089d4a9,5c779686-66d7-4817-aeda-999512b9b24d,dceddde2-9e18-4752-8a87-bc3f722cff5b,eb525281-6dd7-4b8f-8a16-5f1974dab5d2,6e4ee864-c035-47ee-8193-6654b989e033,6101cd2a-fefd-4f52-b777-979e660702e5,487472fc-f56b-4821-b9c8-4eed241db96a,246bb474-64c5-48f2-882d-117905d75539,d898d686-6c19-4f67-9559-f41d192a7e9d,361aca9d-15ba-4c1e-8830-70b5e6685a5b,d91bca0f-48fa-4c46-84b8-bf38379e5620,44bb1d07-2151-419f-896d-4b075df24b72,e9084640-3bee-45ad-9e9e-9f1f27a376b1,198e4b89-db84-4eb2-b106-eab099883697,831226a8-4348-41a9-bd1e-cb53e8fe7276,f6231273-44f8-45f7-a219-66db1ef08af3,3fe72003-224a-47c2-9a8b-1d8dcd2155eb,984795e1-2737-41ac-bb54-8cfb8c92e5a3,6c638a35-957d-4d3b-a064-b507d3d06707,59a1e968-6b39-4e0e-b9af-b62e90c4a71d,4a422b63-c540-48be-88d4-e5be2b2a5137,6aec7755-42b8-4692-b396-362cebc71047,873caada-9c21-4d03-85a6-b59376d19d89,ddd062e7-9b41-4bdc-baab-4b4eabeb620e,0669efe0-c762-4655-a314-60798b063f7e,d097fb10-71b8-4580-8c04-c72baef0ddcf,e9659555-9204-487f-a47f-5ce3cd544231,21fbba66-9612-4ba3-9f75-aef1addcd9c7,bbe7c397-09c1-4902-b2ba-7f763c20c4ea,2348219c-6cae-4619-a1f6-c041dd065f67,8c234810-697d-4fdb-895c-8af6003f2ab5,d78258b9-5ebe-4f7a-9c6f-05bffd6189f8,362cfe3a-5429-4dbb-85fa-0de948157435,56d49fce-a0f6-4c9e-8f8f-26b4a0e8f516,5ff6b0a6-62c3-4738-ad45-68254ba079d1,0378bccb-5e18-4160-9865-2a2584bed38f,11a179cb-2e49-4057-b533-37baafc8d089,f396f6ca-fcbc-4b9d-8ac0-fe89503999b0,1ae1d443-548e-4d9b-8540-522704682979,1a643488-4353-4564-9826-b979509ddcda,0b808f26-dff1-4a6d-b203-b12ee0cf891b,980138e5-f4db-40fa-b101-a72642aead8f,bc76b3d9-632f-41e7-8f29-8640adfed835,6a6f59ca-c995-4715-98c8-57708be81ab3,201466ec-6b56-4479-b203-52d21bd34b13,c4d101b1-5e70-42d2-94e8-380ea80b6ee6,58c53889-3e9e-45ae-978d-4ca84763b2f0,32c5df14-6d05-4b7b-9d6a-bc29b0429765,0b77cc22-3a12-467d-9229-9c8bacd5da9c,7b08083e-8992-48b6-b32e-a666e4023489,3778118f-af36-4aee-a2c0-11c038eb2517,8a9ab5dd-4158-45d0-8976-dac7b8a0770d,2c649763-792a-4014-a69c-ee703f9b9e9d,f67910a8-d66c-4d95-974a-02291e02819e,be96d949-daf9-43cd-a055-f34a76d474f7,909c65e4-a6e0-4c2c-a24e-46dad620bcd8,fb550cb1-09ee-41b3-9291-56d10f2d9b0d,000701d0-d436-4caa-a903-2541069c624c,c759cd79-9220-4b8b-b3d3-e119d7c59f5e,baa7c2f9-1362-409c-a79e-12b3b1eeb8bf,e6cc317e-ba21-4a9b-8157-0b36a6203897,5276043d-086f-496a-9c69-31a34a02f358,b75b16fc-05c3-49c5-848d-725de4fa8c6b,f77645c1-7ca0-406a-86c8-45e8079a0521,e99cee5c-a6f2-4163-9b1d-6c0721386d9b,ba88a335-c26c-4ce1-a434-a29c6538374b,a95a765c-ab8c-4ee0-8cba-c61ce8d617f6,cd121f15-8a7c-41dc-9ddc-f2b792b87999,81d8d2bb-42fe-422f-81a0-13e642a684a3,82aa88cb-02ea-4dec-bbd9-b34c2aceb4c8,12f1f1f6-bbbe-4614-8c5c-5b240a517072,89cc42d0-95dd-453f-b0eb-470ee62d25ca,82259e7e-bb90-4f26-a664-df03f2f9888e,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668,4f0be4d3-a8c0-44cc-9bfc-367731c9d668}'::uuid[]))
22. 0.040 0.040 ↑ 17.9 282 1

Index Scan using core_personne_morale_pk on core_personne_morale personnemo4_ (cost=0.28..178.11 rows=5,041 width=27) (actual time=0.002..0.040 rows=282 loops=1)

23. 1.133 132.594 ↓ 1.0 5,042 1

Hash (cost=23,539.15..23,539.15 rows=5,041 width=124) (actual time=132.594..132.594 rows=5,042 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 665kB
24. 59.663 131.461 ↓ 1.0 5,042 1

Hash Right Join (cost=148.42..23,539.15 rows=5,041 width=124) (actual time=0.982..131.461 rows=5,042 loops=1)

  • Hash Cond: (personnemo7_1_.id = personnemo7_.id)
25. 70.828 70.828 ↓ 1.0 868,538 1

Seq Scan on core_personne personnemo7_1_ (cost=0.00..20,083.32 rows=868,532 width=97) (actual time=0.006..70.828 rows=868,538 loops=1)

26. 0.534 0.970 ↓ 1.0 5,042 1

Hash (cost=85.41..85.41 rows=5,041 width=27) (actual time=0.970..0.970 rows=5,042 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 340kB
27. 0.436 0.436 ↓ 1.0 5,042 1

Seq Scan on core_personne_morale personnemo7_ (cost=0.00..85.41 rows=5,041 width=27) (actual time=0.008..0.436 rows=5,042 loops=1)

28. 1,629.252 1,629.252 ↓ 0.0 0 1,629,252

Index Scan using core_personne_pk on core_personne personneph6_1_ (cost=0.42..0.51 rows=1 width=97) (actual time=0.000..0.001 rows=0 loops=1,629,252)

  • Index Cond: (personneph6_.id = id)
Planning time : 2.541 ms
Execution time : 6,799.703 ms