explain.depesz.com

PostgreSQL's explain analyze made readable

Result: biox : Optimization for: plan #CgMh

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 616.842 13,251.278 ↓ 937.5 1,833,767 1

Hash Left Join (cost=824.38..49,007.24 rows=1,956 width=513) (actual time=354.391..13,251.278 rows=1,833,767 loops=1)

  • Hash Cond: (i2_.id_jdd = i5_.id_jdd)
2. 168.982 12,632.881 ↓ 486.3 387,571 1

Hash Left Join (cost=680.50..48,823.88 rows=797 width=517) (actual time=352.824..12,632.881 rows=387,571 loops=1)

  • Hash Cond: (i3_.id_ca = i4_.id_ca)
3. 101.841 12,463.391 ↓ 355.2 144,220 1

Hash Join (cost=633.23..48,760.01 rows=406 width=521) (actual time=352.299..12,463.391 rows=144,220 loops=1)

  • Hash Cond: (i2_.id_ca = i3_.id_ca)
4. 129.791 12,361.121 ↓ 355.2 144,220 1

Hash Join (cost=549.90..48,671.10 rows=406 width=521) (actual time=351.858..12,361.121 rows=144,220 loops=1)

  • Hash Cond: (i1_.id_jdd = i2_.id_jdd)
5. 576.712 12,230.038 ↓ 355.2 144,220 1

Nested Loop (cost=292.39..48,408.01 rows=406 width=513) (actual time=350.550..12,230.038 rows=144,220 loops=1)

6. 2,636.840 2,985.358 ↓ 525.3 2,166,992 1

Bitmap Heap Scan on vm_requeteur_observations i0_ (cost=291.97..14,582.51 rows=4,125 width=101) (actual time=350.479..2,985.358 rows=2,166,992 loops=1)

  • Recheck Cond: (groupes_fonctionnels && '{12}'::integer[])
  • Rows Removed by Index Recheck: 1704409
7. 348.518 348.518 ↓ 525.3 2,166,992 1

Bitmap Index Scan on vm_requeteur_observations_groupes_fonctionnels_idx (cost=0.00..290.93 rows=4,125 width=0) (actual time=348.518..348.518 rows=2,166,992 loops=1)

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
8. 8,667.968 8,667.968 ↓ 0.0 0 2,166,992

Index Scan using vm_requeteur_releves_rid_idx on vm_requeteur_releves i1_ (cost=0.43..8.19 rows=1 width=412) (actual time=0.004..0.004 rows=0 loops=2,166,992)

  • Index Cond: (rid = i0_.id_releve)
  • Filter: ((departement)::text = '33'::text)
  • Rows Removed by Filter: 0
9. 0.330 1.292 ↑ 1.1 1,226 1

Hash (cost=240.56..240.56 rows=1,356 width=8) (actual time=1.292..1.292 rows=1,226 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
10. 0.962 0.962 ↑ 1.1 1,226 1

Seq Scan on jdd i2_ (cost=0.00..240.56 rows=1,356 width=8) (actual time=0.003..0.962 rows=1,226 loops=1)

11. 0.107 0.429 ↑ 1.1 409 1

Hash (cost=77.59..77.59 rows=459 width=4) (actual time=0.429..0.429 rows=409 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
12. 0.322 0.322 ↑ 1.1 409 1

Seq Scan on ca i3_ (cost=0.00..77.59 rows=459 width=4) (actual time=0.007..0.322 rows=409 loops=1)

13. 0.229 0.508 ↓ 1.1 964 1

Hash (cost=36.01..36.01 rows=901 width=4) (actual time=0.508..0.508 rows=964 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
14. 0.279 0.279 ↓ 1.1 964 1

Seq Scan on ca_contact i4_ (cost=0.00..36.01 rows=901 width=4) (actual time=0.009..0.279 rows=964 loops=1)

15. 0.746 1.555 ↑ 1.0 3,279 1

Hash (cost=102.28..102.28 rows=3,328 width=4) (actual time=1.555..1.555 rows=3,279 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 116kB
16. 0.809 0.809 ↑ 1.0 3,279 1

Seq Scan on jdd_contact_donnees i5_ (cost=0.00..102.28 rows=3,328 width=4) (actual time=0.006..0.809 rows=3,279 loops=1)

Total runtime : 13,488.855 ms