explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9U8t

Settings
# exclusive inclusive rows x rows loops node
1. 31.996 562.011 ↑ 2.8 4,138 1

Sort (cost=241,627.11..241,655.66 rows=11,421 width=513) (actual time=558.915..562.011 rows=4,138 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 1312kB
2. 9.391 530.015 ↑ 2.8 4,138 1

Hash Join (cost=670.44..238,200.87 rows=11,421 width=513) (actual time=18.044..530.015 rows=4,138 loops=1)

  • Hash Cond: (i1_.id_jdd = i2_.id_jdd)
3. 47.846 517.370 ↑ 2.8 4,138 1

Nested Loop (cost=415.85..237,789.24 rows=11,421 width=513) (actual time=14.745..517.370 rows=4,138 loops=1)

4. 304.663 314.432 ↓ 1.0 22,156 1

Bitmap Heap Scan on vm_requeteur_observations i0_ (cost=415.43..59,738.96 rows=22,064 width=101) (actual time=14.675..314.432 rows=22,156 loops=1)

  • Recheck Cond: (cd_nom = 4474)
  • Rows Removed by Index Recheck: 184918
5. 9.769 9.769 ↓ 1.0 22,156 1

Bitmap Index Scan on vm_requeteur_observations_cd_nom_idx (cost=0.00..409.91 rows=22,064 width=0) (actual time=9.769..9.769 rows=22,156 loops=1)

  • Index Cond: (cd_nom = 4474)
6. 155.092 155.092 ↓ 0.0 0 22,156

Index Scan using vm_requeteur_releves_rid_idx on vm_requeteur_releves i1_ (cost=0.43..8.06 rows=1 width=412) (actual time=0.007..0.007 rows=0 loops=22,156)

  • Index Cond: (rid = i0_.id_releve)
7. 0.789 3.254 ↑ 1.0 1,225 1

Hash (cost=239.26..239.26 rows=1,226 width=4) (actual time=3.254..3.254 rows=1,225 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
8. 2.465 2.465 ↑ 1.0 1,225 1

Seq Scan on jdd i2_ (cost=0.00..239.26 rows=1,226 width=4) (actual time=0.024..2.465 rows=1,225 loops=1)

Total runtime : 564.249 ms