explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SLSR

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.224 806.110 ↑ 1.5 64 1

Sort (cost=148,958.21..148,958.45 rows=93 width=513) (actual time=806.086..806.110 rows=64 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: quicksort Memory: 42kB
2. 51.328 805.886 ↑ 1.5 64 1

Hash Join (cost=87,916.39..148,955.17 rows=93 width=513) (actual time=193.374..805.886 rows=64 loops=1)

  • Hash Cond: (i0_.id_releve = i1_.rid)
3. 573.831 583.764 ↓ 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.798..583.764 rows=22,156 loops=1)

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

  • Index Cond: (cd_nom = 4474)
5. 31.659 170.794 ↑ 5.7 2,960 1

Hash (cost=86,374.41..86,374.41 rows=17,004 width=412) (actual time=170.794..170.794 rows=2,960 loops=1)

  • Buckets: 1024 Batches: 8 Memory Usage: 68kB
6. 3.792 139.135 ↑ 5.7 2,960 1

Nested Loop (cost=47.78..86,374.41 rows=17,004 width=412) (actual time=0.152..139.135 rows=2,960 loops=1)

7. 0.113 0.113 ↑ 1.0 10 1

Index Scan using jdd_id_ca_idx on jdd i2_ (cost=0.28..35.63 rows=10 width=4) (actual time=0.037..0.113 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
8. 133.960 135.230 ↑ 8.3 296 10

Bitmap Heap Scan on vm_requeteur_releves i1_ (cost=47.50..8,609.27 rows=2,461 width=412) (actual time=0.223..13.523 rows=296 loops=10)

  • Recheck Cond: (id_jdd = i2_.id_jdd)
9. 1.270 1.270 ↑ 8.3 296 10

Bitmap Index Scan on vm_requeteur_releves_id_jdd_idx (cost=0.00..46.88 rows=2,461 width=0) (actual time=0.127..0.127 rows=296 loops=10)

  • Index Cond: (id_jdd = i2_.id_jdd)
Total runtime : 806.339 ms