explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s7eL

Settings
# exclusive inclusive rows x rows loops node
1. 3,027.403 8,948.079 ↓ 23.3 731,398 1

Hash Join (cost=312,470.59..816,469.76 rows=31,369 width=513) (actual time=2,732.838..8,948.079 rows=731,398 loops=1)

  • Hash Cond: (i0_.id_releve = i1_.rid)
2. 1,953.119 3,216.059 ↓ 35.5 2,151,139 1

Hash Join (cost=1,342.96..390,860.50 rows=60,588 width=101) (actual time=1.480..3,216.059 rows=2,151,139 loops=1)

  • Hash Cond: (i0_.cd_nom = g.cd_ref)
3. 1,261.487 1,261.487 ↑ 1.0 4,124,641 1

Seq Scan on vm_requeteur_observations i0_ (cost=0.00..187,835.41 rows=4,124,641 width=105) (actual time=0.011..1,261.487 rows=4,124,641 loops=1)

4. 0.356 1.453 ↓ 1.1 1,467 1

Hash (cost=1,326.39..1,326.39 rows=1,325 width=4) (actual time=1.453..1.453 rows=1,467 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
5. 0.958 1.097 ↓ 1.1 1,467 1

Bitmap Heap Scan on vm_requeteur_groupes g (cost=26.69..1,326.39 rows=1,325 width=4) (actual time=0.162..1.097 rows=1,467 loops=1)

  • Recheck Cond: (gid = 12)
6. 0.139 0.139 ↓ 1.1 1,467 1

Bitmap Index Scan on vm_requeteur_groupes_gid_idx (cost=0.00..26.36 rows=1,325 width=0) (actual time=0.139..0.139 rows=1,467 loops=1)

  • Index Cond: (gid = 12)
7. 1,468.978 2,704.617 ↑ 1.0 2,084,695 1

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

  • Buckets: 1024 Batches: 1024 Memory Usage: 717kB
8. 1,235.639 1,235.639 ↑ 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.008..1,235.639 rows=2,084,695 loops=1)

Total runtime : 9,039.213 ms