explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r4Zb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=304,330.48..304,408.73 rows=7,825 width=61) (actual rows= loops=)

  • Group Key: (st_difference(emo.geom, vt.geom)), emo.classe, emo.code_graph
2. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.43..303,743.60 rows=78,250 width=61) (actual rows= loops=)

  • Workers Planned: 9
3. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.43..294,918.60 rows=8,676 width=61) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..259,087.89 rows=9,185 width=61) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo (cost=0.15..9,780.73 rows=376 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000080000001CF1BA7982FE1A41FAADA00CFEF10941BB4A90FA81E31A41FE6F575D73150A41FC5312AE78E41A413981444226370A41324761C968ED1A4148978F70D45C0A4140F82A770A321B4179733CD37EB80A4186CA9935654E1B41D7DADAD2DD8B0A41BEA915CA5E471B416CD47D3BCB260A411CF1BA7982FE1A41FAADA00CFEF10941'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000080000001CF1BA7982FE1A41FAADA00CFEF10941BB4A90FA81E31A41FE6F575D73150A41FC5312AE78E41A413981444226370A41324761C968ED1A4148978F70D45C0A4140F82A770A321B4179733CD37EB80A4186CA9935654E1B41D7DADAD2DD8B0A41BEA915CA5E471B416CD47D3BCB260A411CF1BA7982FE1A41FAADA00CFEF10941'::geometry)
6. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt (cost=0.28..52.34 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo.geom) AND (geom && '01030000205B0C000001000000080000001CF1BA7982FE1A41FAADA00CFEF10941BB4A90FA81E31A41FE6F575D73150A41FC5312AE78E41A413981444226370A41324761C968ED1A4148978F70D45C0A4140F82A770A321B4179733CD37EB80A4186CA9935654E1B41D7DADAD2DD8B0A41BEA915CA5E471B416CD47D3BCB260A411CF1BA7982FE1A41FAADA00CFEF10941'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000080000001CF1BA7982FE1A41FAADA00CFEF10941BB4A90FA81E31A41FE6F575D73150A41FC5312AE78E41A413981444226370A41324761C968ED1A4148978F70D45C0A4140F82A770A321B4179733CD37EB80A4186CA9935654E1B41D7DADAD2DD8B0A41BEA915CA5E471B416CD47D3BCB260A411CF1BA7982FE1A41FAADA00CFEF10941'::geometry) AND st_intersects(emo.geom, geom))
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..216,374.24 rows=7,811 width=61) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_1 (cost=0.15..7,007.06 rows=269 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C0000010000000900000040F82A770A321B4179733CD37EB80A41D1493D19DE311B419231A4DA43D00A4113A76A2B695D1B41AF760FCA6F520B412580894445631B413B2C44A7FF520B410974A73BE0861B41C2AFF65FBB100B41D68C74B1AD8C1B41F7BC27220AC50A414863083E41861B41BD79816C28A50A4186CA9935654E1B41D7DADAD2DD8B0A4140F82A770A321B4179733CD37EB80A41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C0000010000000900000040F82A770A321B4179733CD37EB80A41D1493D19DE311B419231A4DA43D00A4113A76A2B695D1B41AF760FCA6F520B412580894445631B413B2C44A7FF520B410974A73BE0861B41C2AFF65FBB100B41D68C74B1AD8C1B41F7BC27220AC50A414863083E41861B41BD79816C28A50A4186CA9935654E1B41D7DADAD2DD8B0A4140F82A770A321B4179733CD37EB80A41'::geometry)
9. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_1 (cost=0.28..52.38 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_1.geom) AND (geom && '01030000205B0C0000010000000900000040F82A770A321B4179733CD37EB80A41D1493D19DE311B419231A4DA43D00A4113A76A2B695D1B41AF760FCA6F520B412580894445631B413B2C44A7FF520B410974A73BE0861B41C2AFF65FBB100B41D68C74B1AD8C1B41F7BC27220AC50A414863083E41861B41BD79816C28A50A4186CA9935654E1B41D7DADAD2DD8B0A4140F82A770A321B4179733CD37EB80A41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C0000010000000900000040F82A770A321B4179733CD37EB80A41D1493D19DE311B419231A4DA43D00A4113A76A2B695D1B41AF760FCA6F520B412580894445631B413B2C44A7FF520B410974A73BE0861B41C2AFF65FBB100B41D68C74B1AD8C1B41F7BC27220AC50A414863083E41861B41BD79816C28A50A4186CA9935654E1B41D7DADAD2DD8B0A4140F82A770A321B4179733CD37EB80A41'::geometry) AND st_intersects(emo_1.geom, geom))
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..100,095.26 rows=3,260 width=61) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_2 (cost=0.15..6,175.70 rows=237 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000050000004AC078F618EA1A41FADCB57E42360B412FD2AF082F201B4161312CEBC8920B4113A76A2B695D1B41AF760FCA6F520B41D1493D19DE311B419231A4DA43D00A414AC078F618EA1A41FADCB57E42360B41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000050000004AC078F618EA1A41FADCB57E42360B412FD2AF082F201B4161312CEBC8920B4113A76A2B695D1B41AF760FCA6F520B41D1493D19DE311B419231A4DA43D00A414AC078F618EA1A41FADCB57E42360B41'::geometry)
12. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_2 (cost=0.28..52.39 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_2.geom) AND (geom && '01030000205B0C000001000000050000004AC078F618EA1A41FADCB57E42360B412FD2AF082F201B4161312CEBC8920B4113A76A2B695D1B41AF760FCA6F520B41D1493D19DE311B419231A4DA43D00A414AC078F618EA1A41FADCB57E42360B41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000050000004AC078F618EA1A41FADCB57E42360B412FD2AF082F201B4161312CEBC8920B4113A76A2B695D1B41AF760FCA6F520B41D1493D19DE311B419231A4DA43D00A414AC078F618EA1A41FADCB57E42360B41'::geometry) AND st_intersects(emo_2.geom, geom))
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..94,920.21 rows=3,241 width=61) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_3 (cost=0.15..4,615.25 rows=177 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000006000000BAA9C5B108B41A415680F9C806DE0B418F2DD37A748D1A410A47D7EB14630C41C74580F03FCA1A41886C3E5FE7B10C410587891F21E21A415306045E21680C41B286C55573D61A41860265802DFC0B41BAA9C5B108B41A415680F9C806DE0B41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000006000000BAA9C5B108B41A415680F9C806DE0B418F2DD37A748D1A410A47D7EB14630C41C74580F03FCA1A41886C3E5FE7B10C410587891F21E21A415306045E21680C41B286C55573D61A41860265802DFC0B41BAA9C5B108B41A415680F9C806DE0B41'::geometry)
15. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_3 (cost=0.28..52.42 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_3.geom) AND (geom && '01030000205B0C00000100000006000000BAA9C5B108B41A415680F9C806DE0B418F2DD37A748D1A410A47D7EB14630C41C74580F03FCA1A41886C3E5FE7B10C410587891F21E21A415306045E21680C41B286C55573D61A41860265802DFC0B41BAA9C5B108B41A415680F9C806DE0B41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000006000000BAA9C5B108B41A415680F9C806DE0B418F2DD37A748D1A410A47D7EB14630C41C74580F03FCA1A41886C3E5FE7B10C410587891F21E21A415306045E21680C41B286C55573D61A41860265802DFC0B41BAA9C5B108B41A415680F9C806DE0B41'::geometry) AND st_intersects(emo_3.geom, geom))
16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..82,442.71 rows=2,651 width=61) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_4 (cost=0.15..5,370.45 rows=206 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C0000010000000600000061C8F458D1531B4176D9DDAB148A0941FA565BF1913B1B414BEA0434CFA109411CF1BA7982FE1A41FAADA00CFEF10941BEA915CA5E471B416CD47D3BCB260A41B7F89FB61C6F1B41BCB80E6736FE094161C8F458D1531B4176D9DDAB148A0941'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C0000010000000600000061C8F458D1531B4176D9DDAB148A0941FA565BF1913B1B414BEA0434CFA109411CF1BA7982FE1A41FAADA00CFEF10941BEA915CA5E471B416CD47D3BCB260A41B7F89FB61C6F1B41BCB80E6736FE094161C8F458D1531B4176D9DDAB148A0941'::geometry)
18. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_4 (cost=0.28..52.40 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_4.geom) AND (geom && '01030000205B0C0000010000000600000061C8F458D1531B4176D9DDAB148A0941FA565BF1913B1B414BEA0434CFA109411CF1BA7982FE1A41FAADA00CFEF10941BEA915CA5E471B416CD47D3BCB260A41B7F89FB61C6F1B41BCB80E6736FE094161C8F458D1531B4176D9DDAB148A0941'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C0000010000000600000061C8F458D1531B4176D9DDAB148A0941FA565BF1913B1B414BEA0434CFA109411CF1BA7982FE1A41FAADA00CFEF10941BEA915CA5E471B416CD47D3BCB260A41B7F89FB61C6F1B41BCB80E6736FE094161C8F458D1531B4176D9DDAB148A0941'::geometry) AND st_intersects(emo_4.geom, geom))
19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..67,107.49 rows=2,257 width=61) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_5 (cost=0.15..3,549.93 rows=136 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000008000000B191ECC3B01A1B41DB4575738ED80B41B566ECD6632C1B41BBE81253611B0C41F72F5FACF76C1B41B9096BBD7A280C4148792A0B18891B414792D4A994CD0B412580894445631B413B2C44A7FF520B4113A76A2B695D1B41AF760FCA6F520B412FD2AF082F201B4161312CEBC8920B41B191ECC3B01A1B41DB4575738ED80B41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000008000000B191ECC3B01A1B41DB4575738ED80B41B566ECD6632C1B41BBE81253611B0C41F72F5FACF76C1B41B9096BBD7A280C4148792A0B18891B414792D4A994CD0B412580894445631B413B2C44A7FF520B4113A76A2B695D1B41AF760FCA6F520B412FD2AF082F201B4161312CEBC8920B41B191ECC3B01A1B41DB4575738ED80B41'::geometry)
21. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_5 (cost=0.28..52.44 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_5.geom) AND (geom && '01030000205B0C00000100000008000000B191ECC3B01A1B41DB4575738ED80B41B566ECD6632C1B41BBE81253611B0C41F72F5FACF76C1B41B9096BBD7A280C4148792A0B18891B414792D4A994CD0B412580894445631B413B2C44A7FF520B4113A76A2B695D1B41AF760FCA6F520B412FD2AF082F201B4161312CEBC8920B41B191ECC3B01A1B41DB4575738ED80B41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000008000000B191ECC3B01A1B41DB4575738ED80B41B566ECD6632C1B41BBE81253611B0C41F72F5FACF76C1B41B9096BBD7A280C4148792A0B18891B414792D4A994CD0B412580894445631B413B2C44A7FF520B4113A76A2B695D1B41AF760FCA6F520B412FD2AF082F201B4161312CEBC8920B41B191ECC3B01A1B41DB4575738ED80B41'::geometry) AND st_intersects(emo_5.geom, geom))
22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..66,362.28 rows=1,989 width=61) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_6 (cost=0.15..5,526.06 rows=212 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000060000000974A73BE0861B41C2AFF65FBB100B41FD5D5B7E49C41B41F3D4D9979E410B4145504E175BEA1B41647B3CB783FC0A416657BF597BE91B4164F5C00B9EB40A41D68C74B1AD8C1B41F7BC27220AC50A410974A73BE0861B41C2AFF65FBB100B41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000060000000974A73BE0861B41C2AFF65FBB100B41FD5D5B7E49C41B41F3D4D9979E410B4145504E175BEA1B41647B3CB783FC0A416657BF597BE91B4164F5C00B9EB40A41D68C74B1AD8C1B41F7BC27220AC50A410974A73BE0861B41C2AFF65FBB100B41'::geometry)
24. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_6 (cost=0.28..52.40 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_6.geom) AND (geom && '01030000205B0C000001000000060000000974A73BE0861B41C2AFF65FBB100B41FD5D5B7E49C41B41F3D4D9979E410B4145504E175BEA1B41647B3CB783FC0A416657BF597BE91B4164F5C00B9EB40A41D68C74B1AD8C1B41F7BC27220AC50A410974A73BE0861B41C2AFF65FBB100B41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000060000000974A73BE0861B41C2AFF65FBB100B41FD5D5B7E49C41B41F3D4D9979E410B4145504E175BEA1B41647B3CB783FC0A416657BF597BE91B4164F5C00B9EB40A41D68C74B1AD8C1B41F7BC27220AC50A410974A73BE0861B41C2AFF65FBB100B41'::geometry) AND st_intersects(emo_6.geom, geom))
25. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..64,507.49 rows=2,153 width=61) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_7 (cost=0.15..3,549.93 rows=136 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000007000000BEA915CA5E471B416CD47D3BCB260A4186CA9935654E1B41D7DADAD2DD8B0A414863083E41861B41BD79816C28A50A410233D2D7C1931B41ED5468F4F2530A41864589C750791B41458E38C634020A41B7F89FB61C6F1B41BCB80E6736FE0941BEA915CA5E471B416CD47D3BCB260A41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000007000000BEA915CA5E471B416CD47D3BCB260A4186CA9935654E1B41D7DADAD2DD8B0A414863083E41861B41BD79816C28A50A410233D2D7C1931B41ED5468F4F2530A41864589C750791B41458E38C634020A41B7F89FB61C6F1B41BCB80E6736FE0941BEA915CA5E471B416CD47D3BCB260A41'::geometry)
27. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_7 (cost=0.28..52.44 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_7.geom) AND (geom && '01030000205B0C00000100000007000000BEA915CA5E471B416CD47D3BCB260A4186CA9935654E1B41D7DADAD2DD8B0A414863083E41861B41BD79816C28A50A410233D2D7C1931B41ED5468F4F2530A41864589C750791B41458E38C634020A41B7F89FB61C6F1B41BCB80E6736FE0941BEA915CA5E471B416CD47D3BCB260A41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000007000000BEA915CA5E471B416CD47D3BCB260A4186CA9935654E1B41D7DADAD2DD8B0A414863083E41861B41BD79816C28A50A410233D2D7C1931B41ED5468F4F2530A41864589C750791B41458E38C634020A41B7F89FB61C6F1B41BCB80E6736FE0941BEA915CA5E471B416CD47D3BCB260A41'::geometry) AND st_intersects(emo_7.geom, geom))
28. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..63,097.81 rows=1,730 width=61) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_8 (cost=0.15..6,591.38 rows=253 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000006000000D1493D19DE311B419231A4DA43D00A4140F82A770A321B4179733CD37EB80A41324761C968ED1A4148978F70D45C0A418977FA237CE41A4199F964EA90320B414AC078F618EA1A41FADCB57E42360B41D1493D19DE311B419231A4DA43D00A41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000006000000D1493D19DE311B419231A4DA43D00A4140F82A770A321B4179733CD37EB80A41324761C968ED1A4148978F70D45C0A418977FA237CE41A4199F964EA90320B414AC078F618EA1A41FADCB57E42360B41D1493D19DE311B419231A4DA43D00A41'::geometry)
30. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_8 (cost=0.28..52.39 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_8.geom) AND (geom && '01030000205B0C00000100000006000000D1493D19DE311B419231A4DA43D00A4140F82A770A321B4179733CD37EB80A41324761C968ED1A4148978F70D45C0A418977FA237CE41A4199F964EA90320B414AC078F618EA1A41FADCB57E42360B41D1493D19DE311B419231A4DA43D00A41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000006000000D1493D19DE311B419231A4DA43D00A4140F82A770A321B4179733CD37EB80A41324761C968ED1A4148978F70D45C0A418977FA237CE41A4199F964EA90320B414AC078F618EA1A41FADCB57E42360B41D1493D19DE311B419231A4DA43D00A41'::geometry) AND st_intersects(emo_8.geom, geom))
31. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..54,473.83 rows=1,667 width=61) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_9 (cost=0.15..4,251.80 rows=163 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000090000002261BC8F43B01A416C20534EE6C80B41BAA9C5B108B41A415680F9C806DE0B41B286C55573D61A41860265802DFC0B41B191ECC3B01A1B41DB4575738ED80B412FD2AF082F201B4161312CEBC8920B414AC078F618EA1A41FADCB57E42360B418977FA237CE41A4199F964EA90320B41BDA0FA9709DA1A41297290D906380B412261BC8F43B01A416C20534EE6C80B41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000090000002261BC8F43B01A416C20534EE6C80B41BAA9C5B108B41A415680F9C806DE0B41B286C55573D61A41860265802DFC0B41B191ECC3B01A1B41DB4575738ED80B412FD2AF082F201B4161312CEBC8920B414AC078F618EA1A41FADCB57E42360B418977FA237CE41A4199F964EA90320B41BDA0FA9709DA1A41297290D906380B412261BC8F43B01A416C20534EE6C80B41'::geometry)
33. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_9 (cost=0.28..52.43 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_9.geom) AND (geom && '01030000205B0C000001000000090000002261BC8F43B01A416C20534EE6C80B41BAA9C5B108B41A415680F9C806DE0B41B286C55573D61A41860265802DFC0B41B191ECC3B01A1B41DB4575738ED80B412FD2AF082F201B4161312CEBC8920B414AC078F618EA1A41FADCB57E42360B418977FA237CE41A4199F964EA90320B41BDA0FA9709DA1A41297290D906380B412261BC8F43B01A416C20534EE6C80B41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000090000002261BC8F43B01A416C20534EE6C80B41BAA9C5B108B41A415680F9C806DE0B41B286C55573D61A41860265802DFC0B41B191ECC3B01A1B41DB4575738ED80B412FD2AF082F201B4161312CEBC8920B414AC078F618EA1A41FADCB57E42360B418977FA237CE41A4199F964EA90320B41BDA0FA9709DA1A41297290D906380B412261BC8F43B01A416C20534EE6C80B41'::geometry) AND st_intersects(emo_9.geom, geom))
34. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..47,045.19 rows=1,420 width=61) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_10 (cost=0.15..3,836.12 rows=147 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000007000000075AE457D16F1A416168ADE45D8D0B41BE55D4B9B7571A4198940E6812E80B41BEC899C2D8871A41321B80A7AE650C418F2DD37A748D1A410A47D7EB14630C41BAA9C5B108B41A415680F9C806DE0B412261BC8F43B01A416C20534EE6C80B41075AE457D16F1A416168ADE45D8D0B41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000007000000075AE457D16F1A416168ADE45D8D0B41BE55D4B9B7571A4198940E6812E80B41BEC899C2D8871A41321B80A7AE650C418F2DD37A748D1A410A47D7EB14630C41BAA9C5B108B41A415680F9C806DE0B412261BC8F43B01A416C20534EE6C80B41075AE457D16F1A416168ADE45D8D0B41'::geometry)
36. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_10 (cost=0.28..52.43 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_10.geom) AND (geom && '01030000205B0C00000100000007000000075AE457D16F1A416168ADE45D8D0B41BE55D4B9B7571A4198940E6812E80B41BEC899C2D8871A41321B80A7AE650C418F2DD37A748D1A410A47D7EB14630C41BAA9C5B108B41A415680F9C806DE0B412261BC8F43B01A416C20534EE6C80B41075AE457D16F1A416168ADE45D8D0B41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000007000000075AE457D16F1A416168ADE45D8D0B41BE55D4B9B7571A4198940E6812E80B41BEC899C2D8871A41321B80A7AE650C418F2DD37A748D1A410A47D7EB14630C41BAA9C5B108B41A415680F9C806DE0B412261BC8F43B01A416C20534EE6C80B41075AE457D16F1A416168ADE45D8D0B41'::geometry) AND st_intersects(emo_10.geom, geom))
37. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..40,954.57 rows=1,236 width=61) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_11 (cost=0.15..3,340.99 rows=128 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000070000007B88469B64EF1B413827753496810A4100CA774A00EF1B4178F9D393CB9E0A411326104D6E4A1C41B6AD515238D80A41B5A0FFFDE8651C41FE10258EE3660A41FE8CD05A505E1C41F12AF44C97450A41C9CC5110761A1C41E493A61D463A0A417B88469B64EF1B413827753496810A41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000070000007B88469B64EF1B413827753496810A4100CA774A00EF1B4178F9D393CB9E0A411326104D6E4A1C41B6AD515238D80A41B5A0FFFDE8651C41FE10258EE3660A41FE8CD05A505E1C41F12AF44C97450A41C9CC5110761A1C41E493A61D463A0A417B88469B64EF1B413827753496810A41'::geometry)
39. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_11 (cost=0.28..52.44 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_11.geom) AND (geom && '01030000205B0C000001000000070000007B88469B64EF1B413827753496810A4100CA774A00EF1B4178F9D393CB9E0A411326104D6E4A1C41B6AD515238D80A41B5A0FFFDE8651C41FE10258EE3660A41FE8CD05A505E1C41F12AF44C97450A41C9CC5110761A1C41E493A61D463A0A417B88469B64EF1B413827753496810A41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000070000007B88469B64EF1B413827753496810A4100CA774A00EF1B4178F9D393CB9E0A411326104D6E4A1C41B6AD515238D80A41B5A0FFFDE8651C41FE10258EE3660A41FE8CD05A505E1C41F12AF44C97450A41C9CC5110761A1C41E493A61D463A0A417B88469B64EF1B413827753496810A41'::geometry) AND st_intersects(emo_11.geom, geom))
40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..37,095.32 rows=1,292 width=61) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_12 (cost=0.15..1,593.32 rows=61 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000070000008AB0C548D0E519413AE51312499C0C419547F5FF6BD51941F1049535B2260D410F55EC581C151A41A1A88FCF08600D4104BF871DF6291A4182DC6E274C420D414236E4A98F421A412A2E9B3809B90C4194E5F61352421A41F25ED13BA2B80C418AB0C548D0E519413AE51312499C0C41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000070000008AB0C548D0E519413AE51312499C0C419547F5FF6BD51941F1049535B2260D410F55EC581C151A41A1A88FCF08600D4104BF871DF6291A4182DC6E274C420D414236E4A98F421A412A2E9B3809B90C4194E5F61352421A41F25ED13BA2B80C418AB0C548D0E519413AE51312499C0C41'::geometry)
42. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_12 (cost=0.28..52.48 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_12.geom) AND (geom && '01030000205B0C000001000000070000008AB0C548D0E519413AE51312499C0C419547F5FF6BD51941F1049535B2260D410F55EC581C151A41A1A88FCF08600D4104BF871DF6291A4182DC6E274C420D414236E4A98F421A412A2E9B3809B90C4194E5F61352421A41F25ED13BA2B80C418AB0C548D0E519413AE51312499C0C41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000070000008AB0C548D0E519413AE51312499C0C419547F5FF6BD51941F1049535B2260D410F55EC581C151A41A1A88FCF08600D4104BF871DF6291A4182DC6E274C420D414236E4A98F421A412A2E9B3809B90C4194E5F61352421A41F25ED13BA2B80C418AB0C548D0E519413AE51312499C0C41'::geometry) AND st_intersects(emo_12.geom, geom))
43. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..32,681.69 rows=971 width=61) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_13 (cost=0.15..2,793.62 rows=107 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000006000000B286C55573D61A41860265802DFC0B410587891F21E21A415306045E21680C411DF6F9C42F201B4169953B29AB580C41B566ECD6632C1B41BBE81253611B0C41B191ECC3B01A1B41DB4575738ED80B41B286C55573D61A41860265802DFC0B41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000006000000B286C55573D61A41860265802DFC0B410587891F21E21A415306045E21680C411DF6F9C42F201B4169953B29AB580C41B566ECD6632C1B41BBE81253611B0C41B191ECC3B01A1B41DB4575738ED80B41B286C55573D61A41860265802DFC0B41'::geometry)
45. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_13 (cost=0.28..52.45 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_13.geom) AND (geom && '01030000205B0C00000100000006000000B286C55573D61A41860265802DFC0B410587891F21E21A415306045E21680C411DF6F9C42F201B4169953B29AB580C41B566ECD6632C1B41BBE81253611B0C41B191ECC3B01A1B41DB4575738ED80B41B286C55573D61A41860265802DFC0B41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000006000000B286C55573D61A41860265802DFC0B410587891F21E21A415306045E21680C411DF6F9C42F201B4169953B29AB580C41B566ECD6632C1B41BBE81253611B0C41B191ECC3B01A1B41DB4575738ED80B41B286C55573D61A41860265802DFC0B41'::geometry) AND st_intersects(emo_13.geom, geom))
46. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..32,216.78 rows=1,034 width=61) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_14 (cost=0.15..2,115.67 rows=81 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000060000006AFA63954EFB144163079091CFF211415FB0CA7206FA1441F39823EDF30312418DDB862E09331541479199A11C44124163668D18854D1541C1251E3F7B33124194916E30FA541541B136A5442DED11416AFA63954EFB144163079091CFF21141'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000060000006AFA63954EFB144163079091CFF211415FB0CA7206FA1441F39823EDF30312418DDB862E09331541479199A11C44124163668D18854D1541C1251E3F7B33124194916E30FA541541B136A5442DED11416AFA63954EFB144163079091CFF21141'::geometry)
48. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_14 (cost=0.28..52.47 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_14.geom) AND (geom && '01030000205B0C000001000000060000006AFA63954EFB144163079091CFF211415FB0CA7206FA1441F39823EDF30312418DDB862E09331541479199A11C44124163668D18854D1541C1251E3F7B33124194916E30FA541541B136A5442DED11416AFA63954EFB144163079091CFF21141'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000060000006AFA63954EFB144163079091CFF211415FB0CA7206FA1441F39823EDF30312418DDB862E09331541479199A11C44124163668D18854D1541C1251E3F7B33124194916E30FA541541B136A5442DED11416AFA63954EFB144163079091CFF21141'::geometry) AND st_intersects(emo_14.geom, geom))
49. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..28,235.23 rows=903 width=61) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_15 (cost=0.15..1,881.71 rows=72 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000008000000BEC899C2D8871A41321B80A7AE650C419A44E30714591A414BD3989797B50C41AA88CB30FE881A41BDAEF738B0220D411595E4A340A11A414848D7A2D6210D419C0D43037DCE1A41EF3F92233ECD0C41C74580F03FCA1A41886C3E5FE7B10C418F2DD37A748D1A410A47D7EB14630C41BEC899C2D8871A41321B80A7AE650C41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000008000000BEC899C2D8871A41321B80A7AE650C419A44E30714591A414BD3989797B50C41AA88CB30FE881A41BDAEF738B0220D411595E4A340A11A414848D7A2D6210D419C0D43037DCE1A41EF3F92233ECD0C41C74580F03FCA1A41886C3E5FE7B10C418F2DD37A748D1A410A47D7EB14630C41BEC899C2D8871A41321B80A7AE650C41'::geometry)
51. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_15 (cost=0.28..52.47 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_15.geom) AND (geom && '01030000205B0C00000100000008000000BEC899C2D8871A41321B80A7AE650C419A44E30714591A414BD3989797B50C41AA88CB30FE881A41BDAEF738B0220D411595E4A340A11A414848D7A2D6210D419C0D43037DCE1A41EF3F92233ECD0C41C74580F03FCA1A41886C3E5FE7B10C418F2DD37A748D1A410A47D7EB14630C41BEC899C2D8871A41321B80A7AE650C41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000008000000BEC899C2D8871A41321B80A7AE650C419A44E30714591A414BD3989797B50C41AA88CB30FE881A41BDAEF738B0220D411595E4A340A11A414848D7A2D6210D419C0D43037DCE1A41EF3F92233ECD0C41C74580F03FCA1A41886C3E5FE7B10C418F2DD37A748D1A410A47D7EB14630C41BEC899C2D8871A41321B80A7AE650C41'::geometry) AND st_intersects(emo_15.geom, geom))
52. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..27,491.07 rows=823 width=61) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_16 (cost=0.15..2,298.49 rows=88 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C0000010000000700000000CA774A00EF1B4178F9D393CB9E0A416657BF597BE91B4164F5C00B9EB40A4145504E175BEA1B41647B3CB783FC0A4152DE57C3A1161C41AAAAD73A29460B411B0B936EB34A1C4104AA2EA91DE10A411326104D6E4A1C41B6AD515238D80A4100CA774A00EF1B4178F9D393CB9E0A41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C0000010000000700000000CA774A00EF1B4178F9D393CB9E0A416657BF597BE91B4164F5C00B9EB40A4145504E175BEA1B41647B3CB783FC0A4152DE57C3A1161C41AAAAD73A29460B411B0B936EB34A1C4104AA2EA91DE10A411326104D6E4A1C41B6AD515238D80A4100CA774A00EF1B4178F9D393CB9E0A41'::geometry)
54. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_16 (cost=0.28..52.46 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_16.geom) AND (geom && '01030000205B0C0000010000000700000000CA774A00EF1B4178F9D393CB9E0A416657BF597BE91B4164F5C00B9EB40A4145504E175BEA1B41647B3CB783FC0A4152DE57C3A1161C41AAAAD73A29460B411B0B936EB34A1C4104AA2EA91DE10A411326104D6E4A1C41B6AD515238D80A4100CA774A00EF1B4178F9D393CB9E0A41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C0000010000000700000000CA774A00EF1B4178F9D393CB9E0A416657BF597BE91B4164F5C00B9EB40A4145504E175BEA1B41647B3CB783FC0A4152DE57C3A1161C41AAAAD73A29460B411B0B936EB34A1C4104AA2EA91DE10A411326104D6E4A1C41B6AD515238D80A4100CA774A00EF1B4178F9D393CB9E0A41'::geometry) AND st_intersects(emo_16.geom, geom))
55. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..25,160.86 rows=868 width=61) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_17 (cost=0.15..1,150.42 rows=44 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C0000010000000800000002684D8120BF19417B03C9A80CDA0D417A5EDB1996C819417B29796796EE0D41F1095DE4ABF019411AA3B2935EF10D4166BDA6ACF90F1A41B47DEBEE10D50D410F55EC581C151A41A1A88FCF08600D419547F5FF6BD51941F1049535B2260D413F35120889D419412C21783085270D4102684D8120BF19417B03C9A80CDA0D41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C0000010000000800000002684D8120BF19417B03C9A80CDA0D417A5EDB1996C819417B29796796EE0D41F1095DE4ABF019411AA3B2935EF10D4166BDA6ACF90F1A41B47DEBEE10D50D410F55EC581C151A41A1A88FCF08600D419547F5FF6BD51941F1049535B2260D413F35120889D419412C21783085270D4102684D8120BF19417B03C9A80CDA0D41'::geometry)
57. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_17 (cost=0.28..52.50 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_17.geom) AND (geom && '01030000205B0C0000010000000800000002684D8120BF19417B03C9A80CDA0D417A5EDB1996C819417B29796796EE0D41F1095DE4ABF019411AA3B2935EF10D4166BDA6ACF90F1A41B47DEBEE10D50D410F55EC581C151A41A1A88FCF08600D419547F5FF6BD51941F1049535B2260D413F35120889D419412C21783085270D4102684D8120BF19417B03C9A80CDA0D41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C0000010000000800000002684D8120BF19417B03C9A80CDA0D417A5EDB1996C819417B29796796EE0D41F1095DE4ABF019411AA3B2935EF10D4166BDA6ACF90F1A41B47DEBEE10D50D410F55EC581C151A41A1A88FCF08600D419547F5FF6BD51941F1049535B2260D413F35120889D419412C21783085270D4102684D8120BF19417B03C9A80CDA0D41'::geometry) AND st_intersects(emo_17.geom, geom))
58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..25,035.23 rows=775 width=61) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_18 (cost=0.15..1,881.71 rows=72 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C0000010000000600000004BF871DF6291A4182DC6E274C420D417C09E580A26D1A4175CEEC32B6880D41AA88CB30FE881A41BDAEF738B0220D419A44E30714591A414BD3989797B50C414236E4A98F421A412A2E9B3809B90C4104BF871DF6291A4182DC6E274C420D41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C0000010000000600000004BF871DF6291A4182DC6E274C420D417C09E580A26D1A4175CEEC32B6880D41AA88CB30FE881A41BDAEF738B0220D419A44E30714591A414BD3989797B50C414236E4A98F421A412A2E9B3809B90C4104BF871DF6291A4182DC6E274C420D41'::geometry)
60. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_18 (cost=0.28..52.47 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_18.geom) AND (geom && '01030000205B0C0000010000000600000004BF871DF6291A4182DC6E274C420D417C09E580A26D1A4175CEEC32B6880D41AA88CB30FE881A41BDAEF738B0220D419A44E30714591A414BD3989797B50C414236E4A98F421A412A2E9B3809B90C4104BF871DF6291A4182DC6E274C420D41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C0000010000000600000004BF871DF6291A4182DC6E274C420D417C09E580A26D1A4175CEEC32B6880D41AA88CB30FE881A41BDAEF738B0220D419A44E30714591A414BD3989797B50C414236E4A98F421A412A2E9B3809B90C4104BF871DF6291A4182DC6E274C420D41'::geometry) AND st_intersects(emo_18.geom, geom))
61. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..24,741.70 rows=801 width=61) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_19 (cost=0.15..1,567.20 rows=60 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C0000010000000700000094E5F61352421A41F25ED13BA2B80C414236E4A98F421A412A2E9B3809B90C419A44E30714591A414BD3989797B50C41BEC899C2D8871A41321B80A7AE650C41BE55D4B9B7571A4198940E6812E80B412A8795E6B42A1A41CA8C0D8E140A0C4194E5F61352421A41F25ED13BA2B80C41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C0000010000000700000094E5F61352421A41F25ED13BA2B80C414236E4A98F421A412A2E9B3809B90C419A44E30714591A414BD3989797B50C41BEC899C2D8871A41321B80A7AE650C41BE55D4B9B7571A4198940E6812E80B412A8795E6B42A1A41CA8C0D8E140A0C4194E5F61352421A41F25ED13BA2B80C41'::geometry)
63. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_19 (cost=0.28..52.48 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_19.geom) AND (geom && '01030000205B0C0000010000000700000094E5F61352421A41F25ED13BA2B80C414236E4A98F421A412A2E9B3809B90C419A44E30714591A414BD3989797B50C41BEC899C2D8871A41321B80A7AE650C41BE55D4B9B7571A4198940E6812E80B412A8795E6B42A1A41CA8C0D8E140A0C4194E5F61352421A41F25ED13BA2B80C41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C0000010000000700000094E5F61352421A41F25ED13BA2B80C414236E4A98F421A412A2E9B3809B90C419A44E30714591A414BD3989797B50C41BEC899C2D8871A41321B80A7AE650C41BE55D4B9B7571A4198940E6812E80B412A8795E6B42A1A41CA8C0D8E140A0C4194E5F61352421A41F25ED13BA2B80C41'::geometry) AND st_intersects(emo_19.geom, geom))
64. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..24,499.27 rows=829 width=61) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_20 (cost=0.15..1,254.89 rows=48 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000008000000CCCD6F8638AE1841ADC4B34D9B970F417466EB2344A518412AB2822D13BD0F4184ACCF1808C418414AF81D32261D10411706A6417E051941EDCDA20FF81C10415FFC4E6CFF08194183D21A56981310411D14BD156FE9184169F5B7770B7B0F4145ED904495CE18419368857A7A660F41CCCD6F8638AE1841ADC4B34D9B970F41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000008000000CCCD6F8638AE1841ADC4B34D9B970F417466EB2344A518412AB2822D13BD0F4184ACCF1808C418414AF81D32261D10411706A6417E051941EDCDA20FF81C10415FFC4E6CFF08194183D21A56981310411D14BD156FE9184169F5B7770B7B0F4145ED904495CE18419368857A7A660F41CCCD6F8638AE1841ADC4B34D9B970F41'::geometry)
66. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_20 (cost=0.28..52.48 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_20.geom) AND (geom && '01030000205B0C00000100000008000000CCCD6F8638AE1841ADC4B34D9B970F417466EB2344A518412AB2822D13BD0F4184ACCF1808C418414AF81D32261D10411706A6417E051941EDCDA20FF81C10415FFC4E6CFF08194183D21A56981310411D14BD156FE9184169F5B7770B7B0F4145ED904495CE18419368857A7A660F41CCCD6F8638AE1841ADC4B34D9B970F41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000008000000CCCD6F8638AE1841ADC4B34D9B970F417466EB2344A518412AB2822D13BD0F4184ACCF1808C418414AF81D32261D10411706A6417E051941EDCDA20FF81C10415FFC4E6CFF08194183D21A56981310411D14BD156FE9184169F5B7770B7B0F4145ED904495CE18419368857A7A660F41CCCD6F8638AE1841ADC4B34D9B970F41'::geometry) AND st_intersects(emo_20.geom, geom))
67. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..23,984.44 rows=777 width=61) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_21 (cost=0.15..1,514.96 rows=58 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000006000000207D563D7DD2174121BC7395BF90104194C630A5D19317415E3EA332F8C410410959044B00B71741053818EFD3011141F3B2149B9BF11741E53668BDC1BF1041AC7DCFF013E3174113AAB0B81C9E1041207D563D7DD2174121BC7395BF901041'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000006000000207D563D7DD2174121BC7395BF90104194C630A5D19317415E3EA332F8C410410959044B00B71741053818EFD3011141F3B2149B9BF11741E53668BDC1BF1041AC7DCFF013E3174113AAB0B81C9E1041207D563D7DD2174121BC7395BF901041'::geometry)
69. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_21 (cost=0.28..52.48 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_21.geom) AND (geom && '01030000205B0C00000100000006000000207D563D7DD2174121BC7395BF90104194C630A5D19317415E3EA332F8C410410959044B00B71741053818EFD3011141F3B2149B9BF11741E53668BDC1BF1041AC7DCFF013E3174113AAB0B81C9E1041207D563D7DD2174121BC7395BF901041'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000006000000207D563D7DD2174121BC7395BF90104194C630A5D19317415E3EA332F8C410410959044B00B71741053818EFD3011141F3B2149B9BF11741E53668BDC1BF1041AC7DCFF013E3174113AAB0B81C9E1041207D563D7DD2174121BC7395BF901041'::geometry) AND st_intersects(emo_21.geom, geom))
70. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..21,805.89 rows=627 width=61) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_22 (cost=0.15..2,037.31 rows=78 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C00000100000008000000B157B35736FA1441A03EB366CCF011416AFA63954EFB144163079091CFF2114194916E30FA541541B136A5442DED114171DA7263CA5D1541D5BC27CEC6E51141E1785A28DE621541630BCA7D5AD91141469D44D4104215419FE59A50C2AA114188C22F25930A15415C86796BD5AC1141B157B35736FA1441A03EB366CCF01141'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C00000100000008000000B157B35736FA1441A03EB366CCF011416AFA63954EFB144163079091CFF2114194916E30FA541541B136A5442DED114171DA7263CA5D1541D5BC27CEC6E51141E1785A28DE621541630BCA7D5AD91141469D44D4104215419FE59A50C2AA114188C22F25930A15415C86796BD5AC1141B157B35736FA1441A03EB366CCF01141'::geometry)
72. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_22 (cost=0.28..52.47 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_22.geom) AND (geom && '01030000205B0C00000100000008000000B157B35736FA1441A03EB366CCF011416AFA63954EFB144163079091CFF2114194916E30FA541541B136A5442DED114171DA7263CA5D1541D5BC27CEC6E51141E1785A28DE621541630BCA7D5AD91141469D44D4104215419FE59A50C2AA114188C22F25930A15415C86796BD5AC1141B157B35736FA1441A03EB366CCF01141'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C00000100000008000000B157B35736FA1441A03EB366CCF011416AFA63954EFB144163079091CFF2114194916E30FA541541B136A5442DED114171DA7263CA5D1541D5BC27CEC6E51141E1785A28DE621541630BCA7D5AD91141469D44D4104215419FE59A50C2AA114188C22F25930A15415C86796BD5AC1141B157B35736FA1441A03EB366CCF01141'::geometry) AND st_intersects(emo_22.geom, geom))
73. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..21,578.77 rows=552 width=61) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_23 (cost=0.15..2,584.68 rows=99 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000070000002580894445631B413B2C44A7FF520B4148792A0B18891B414792D4A994CD0B41EC40D8EA5EC91B41830BA70C8DD00B41327A15DFFACC1B41E111A0482FC40B41FD5D5B7E49C41B41F3D4D9979E410B410974A73BE0861B41C2AFF65FBB100B412580894445631B413B2C44A7FF520B41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000070000002580894445631B413B2C44A7FF520B4148792A0B18891B414792D4A994CD0B41EC40D8EA5EC91B41830BA70C8DD00B41327A15DFFACC1B41E111A0482FC40B41FD5D5B7E49C41B41F3D4D9979E410B410974A73BE0861B41C2AFF65FBB100B412580894445631B413B2C44A7FF520B41'::geometry)
75. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_23 (cost=0.28..52.46 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_23.geom) AND (geom && '01030000205B0C000001000000070000002580894445631B413B2C44A7FF520B4148792A0B18891B414792D4A994CD0B41EC40D8EA5EC91B41830BA70C8DD00B41327A15DFFACC1B41E111A0482FC40B41FD5D5B7E49C41B41F3D4D9979E410B410974A73BE0861B41C2AFF65FBB100B412580894445631B413B2C44A7FF520B41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000070000002580894445631B413B2C44A7FF520B4148792A0B18891B414792D4A994CD0B41EC40D8EA5EC91B41830BA70C8DD00B41327A15DFFACC1B41E111A0482FC40B41FD5D5B7E49C41B41F3D4D9979E410B410974A73BE0861B41C2AFF65FBB100B412580894445631B413B2C44A7FF520B41'::geometry) AND st_intersects(emo_23.geom, geom))
76. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..21,255.89 rows=605 width=61) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_24 (cost=0.15..2,037.31 rows=78 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000080000001326104D6E4A1C41B6AD515238D80A411B0B936EB34A1C4104AA2EA91DE10A41B09BC638B16F1C41CBC3C369E0360B41203074DA9D851C411958D6B4E0370B4154220AC5EEB51C412E89F01D2AF30A411AD7A66E6E6B1C41333A2AEBC26A0A41B5A0FFFDE8651C41FE10258EE3660A411326104D6E4A1C41B6AD515238D80A41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000080000001326104D6E4A1C41B6AD515238D80A411B0B936EB34A1C4104AA2EA91DE10A41B09BC638B16F1C41CBC3C369E0360B41203074DA9D851C411958D6B4E0370B4154220AC5EEB51C412E89F01D2AF30A411AD7A66E6E6B1C41333A2AEBC26A0A41B5A0FFFDE8651C41FE10258EE3660A411326104D6E4A1C41B6AD515238D80A41'::geometry)
78. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_24 (cost=0.28..52.47 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_24.geom) AND (geom && '01030000205B0C000001000000080000001326104D6E4A1C41B6AD515238D80A411B0B936EB34A1C4104AA2EA91DE10A41B09BC638B16F1C41CBC3C369E0360B41203074DA9D851C411958D6B4E0370B4154220AC5EEB51C412E89F01D2AF30A411AD7A66E6E6B1C41333A2AEBC26A0A41B5A0FFFDE8651C41FE10258EE3660A411326104D6E4A1C41B6AD515238D80A41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000080000001326104D6E4A1C41B6AD515238D80A411B0B936EB34A1C4104AA2EA91DE10A41B09BC638B16F1C41CBC3C369E0360B41203074DA9D851C411958D6B4E0370B4154220AC5EEB51C412E89F01D2AF30A411AD7A66E6E6B1C41333A2AEBC26A0A41B5A0FFFDE8651C41FE10258EE3660A411326104D6E4A1C41B6AD515238D80A41'::geometry) AND st_intersects(emo_24.geom, geom))
79. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..20,373.95 rows=620 width=61) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_25 (cost=0.15..1,619.43 rows=62 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000070000003337726C622F1741F484F5709D4111416C83C424753217418CA45487F34311419D1C1F984C5F174124FC3CB2A83B11415BA486313D71174164BD6237A71F114186375C211F5317418F8D70FBD7D510415751F32BC418174102A51DC65F1111413337726C622F1741F484F5709D411141'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000070000003337726C622F1741F484F5709D4111416C83C424753217418CA45487F34311419D1C1F984C5F174124FC3CB2A83B11415BA486313D71174164BD6237A71F114186375C211F5317418F8D70FBD7D510415751F32BC418174102A51DC65F1111413337726C622F1741F484F5709D411141'::geometry)
81. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_25 (cost=0.28..52.48 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_25.geom) AND (geom && '01030000205B0C000001000000070000003337726C622F1741F484F5709D4111416C83C424753217418CA45487F34311419D1C1F984C5F174124FC3CB2A83B11415BA486313D71174164BD6237A71F114186375C211F5317418F8D70FBD7D510415751F32BC418174102A51DC65F1111413337726C622F1741F484F5709D411141'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000070000003337726C622F1741F484F5709D4111416C83C424753217418CA45487F34311419D1C1F984C5F174124FC3CB2A83B11415BA486313D71174164BD6237A71F114186375C211F5317418F8D70FBD7D510415751F32BC418174102A51DC65F1111413337726C622F1741F484F5709D411141'::geometry) AND st_intersects(emo_25.geom, geom))
82. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..19,361.03 rows=457 width=61) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_26 (cost=0.15..2,636.92 rows=101 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000080000000233D2D7C1931B41ED5468F4F2530A414863083E41861B41BD79816C28A50A41D68C74B1AD8C1B41F7BC27220AC50A416657BF597BE91B4164F5C00B9EB40A4100CA774A00EF1B4178F9D393CB9E0A417B88469B64EF1B413827753496810A41C28619450BCB1B41ADC2DD8286380A410233D2D7C1931B41ED5468F4F2530A41'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000080000000233D2D7C1931B41ED5468F4F2530A414863083E41861B41BD79816C28A50A41D68C74B1AD8C1B41F7BC27220AC50A416657BF597BE91B4164F5C00B9EB40A4100CA774A00EF1B4178F9D393CB9E0A417B88469B64EF1B413827753496810A41C28619450BCB1B41ADC2DD8286380A410233D2D7C1931B41ED5468F4F2530A41'::geometry)
84. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_26 (cost=0.28..52.46 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_26.geom) AND (geom && '01030000205B0C000001000000080000000233D2D7C1931B41ED5468F4F2530A414863083E41861B41BD79816C28A50A41D68C74B1AD8C1B41F7BC27220AC50A416657BF597BE91B4164F5C00B9EB40A4100CA774A00EF1B4178F9D393CB9E0A417B88469B64EF1B413827753496810A41C28619450BCB1B41ADC2DD8286380A410233D2D7C1931B41ED5468F4F2530A41'::geometry))
  • Filter: (st_intersects(geom, '01030000205B0C000001000000080000000233D2D7C1931B41ED5468F4F2530A414863083E41861B41BD79816C28A50A41D68C74B1AD8C1B41F7BC27220AC50A416657BF597BE91B4164F5C00B9EB40A4100CA774A00EF1B4178F9D393CB9E0A417B88469B64EF1B413827753496810A41C28619450BCB1B41ADC2DD8286380A410233D2D7C1931B41ED5468F4F2530A41'::geometry) AND st_intersects(emo_26.geom, geom))
85. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..19,102.90 rows=610 width=61) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Index Scan using sidx_extraction_mos_oeil_geom on extraction_mos_oeil emo_27 (cost=0.15..1,281.01 rows=49 width=6,743) (actual rows= loops=)

  • Index Cond: (geom && '01030000205B0C000001000000070000005599572D3AD014415810E49BFC371241760FFE3DF4DB14412AB911AC2559124110C2A67FCD101541B136F132EE7112415E746DD43D2B154134DF3DBF295F12418DDB862E09331541479199A11C4412415FB0CA7206FA1441F39823EDF30312415599572D3AD014415810E49BFC371241'::geometry)
  • Filter: st_intersects(geom, '01030000205B0C000001000000070000005599572D3AD014415810E49BFC371241760FFE3DF4DB14412AB911AC2559124110C2A67FCD101541B136F132EE7112415E746DD43D2B154134DF3DBF295F12418DDB862E09331541479199A11C4412415FB0CA7206FA1441F39823EDF30312415599572D3AD014415810E49BFC371241'::geometry)
87. 0.000 0.000 ↓ 0.0

Index Scan using sidx_voirie_tampon_geom on voirie_tampon vt_27 (cost=0.28..52.48 rows=1 width=9,692) (actual rows= loops=)

  • Index Cond: ((geom && emo_27.geom) AND (geom && '01030000205B0C000001000000070000005599572D3AD014415810E49BFC371241760FFE3DF4DB14412AB911AC2559124110C2A67FCD101541B136F132EE7112415E746DD43D2B154134DF3DBF295F12418DDB862E09331541479199A11C4412415FB0CA7206FA1441F39823EDF30312415599572D3AD014415810E49BFC371241'::geometry))