explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5aH3

Settings
# exclusive inclusive rows x rows loops node
1. 16.184 16,793.985 ↑ 2.8 4,138 1

Sort (cost=487,590.00..487,618.55 rows=11,421 width=513) (actual time=16,791.557..16,793.985 rows=4,138 loops=1)

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

Hash Join (cost=311,797.65..484,163.75 rows=11,421 width=513) (actual time=15,770.055..16,777.801 rows=4,138 loops=1)

  • Hash Cond: (i1_.id_jdd = i2_.id_jdd)
3. 2,200.465 16,770.775 ↑ 2.8 4,138 1

Hash Join (cost=311,543.06..483,752.13 rows=11,421 width=513) (actual time=15,767.128..16,770.775 rows=4,138 loops=1)

  • Hash Cond: (i0_.id_releve = i1_.rid)
4. 220.429 229.527 ↓ 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=13.604..229.527 rows=22,156 loops=1)

  • Recheck Cond: (cd_nom = 4474)
  • Rows Removed by Index Recheck: 184918
5. 9.098 9.098 ↓ 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.098..9.098 rows=22,156 loops=1)

  • Index Cond: (cd_nom = 4474)
6. 5,439.149 14,340.783 ↑ 1.0 2,084,695 1

Hash (cost=173,097.95..173,097.95 rows=2,084,695 width=412) (actual time=14,340.783..14,340.783 rows=2,084,695 loops=1)

  • Buckets: 1024 Batches: 1024 Memory Usage: 717kB
7. 8,901.634 8,901.634 ↑ 1.0 2,084,695 1

Seq Scan on vm_requeteur_releves i1_ (cost=0.00..173,097.95 rows=2,084,695 width=412) (actual time=0.016..8,901.634 rows=2,084,695 loops=1)

8. 0.695 2.912 ↑ 1.0 1,225 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
9. 2.217 2.217 ↑ 1.0 1,225 1

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

Total runtime : 16,795.802 ms