explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CgMh

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 11,018.572 128,046.110 ↓ 937.5 1,833,767 1

Sort (cost=49,569.18..49,574.07 rows=1,956 width=513) (actual time=127,352.393..128,046.110 rows=1,833,767 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 499328kB
2. 1,362.105 117,027.538 ↓ 937.5 1,833,767 1

Hash Left Join (cost=824.38..49,007.24 rows=1,956 width=513) (actual time=880.006..117,027.538 rows=1,833,767 loops=1)

  • Hash Cond: (i2_.id_jdd = i5_.id_jdd)
3. 391.388 115,661.374 ↓ 486.3 387,571 1

Hash Left Join (cost=680.50..48,823.88 rows=797 width=517) (actual time=875.926..115,661.374 rows=387,571 loops=1)

  • Hash Cond: (i3_.id_ca = i4_.id_ca)
4. 227.075 115,268.752 ↓ 355.2 144,220 1

Hash Join (cost=633.23..48,760.01 rows=406 width=521) (actual time=874.669..115,268.752 rows=144,220 loops=1)

  • Hash Cond: (i2_.id_ca = i3_.id_ca)
5. 336.378 115,040.704 ↓ 355.2 144,220 1

Hash Join (cost=549.90..48,671.10 rows=406 width=521) (actual time=873.678..115,040.704 rows=144,220 loops=1)

  • Hash Cond: (i1_.id_jdd = i2_.id_jdd)
6. 2,183.783 114,701.177 ↓ 355.2 144,220 1

Nested Loop (cost=292.39..48,408.01 rows=406 width=513) (actual time=870.502..114,701.177 rows=144,220 loops=1)

7. 20,637.991 21,503.730 ↓ 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=870.385..21,503.730 rows=2,166,992 loops=1)

  • Recheck Cond: (groupes_fonctionnels && '{12}'::integer[])
  • Rows Removed by Index Recheck: 1704409
8. 865.739 865.739 ↓ 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=865.739..865.739 rows=2,166,992 loops=1)

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
9. 91,013.664 91,013.664 ↓ 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.042..0.042 rows=0 loops=2,166,992)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
11. 2.356 2.356 ↑ 1.1 1,226 1

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

12. 0.232 0.973 ↑ 1.1 409 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
13. 0.741 0.741 ↑ 1.1 409 1

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

14. 0.443 1.234 ↓ 1.1 964 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
15. 0.791 0.791 ↓ 1.1 964 1

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

16. 1.856 4.059 ↑ 1.0 3,279 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 116kB
17. 2.203 2.203 ↑ 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.016..2.203 rows=3,279 loops=1)

Total runtime : 128,351.233 ms