explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hweU : Optimization for: plan #peCd

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 44.285 164.848 ↑ 2.8 6,265 1

Sort (cost=228,325.32..228,368.86 rows=17,415 width=513) (actual time=160.071..164.848 rows=6,265 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 1672kB
2. 12.547 120.563 ↑ 2.8 6,265 1

Nested Loop (cost=48.21..223,049.11 rows=17,415 width=513) (actual time=0.109..120.563 rows=6,265 loops=1)

3. 3.700 36.976 ↑ 5.7 2,960 1

Nested Loop (cost=47.78..86,374.31 rows=17,004 width=412) (actual time=0.081..36.976 rows=2,960 loops=1)

4. 0.076 0.076 ↑ 1.0 10 1

Index Scan using jdd_id_ca_idx on jdd i2_ (cost=0.28..35.53 rows=10 width=4) (actual time=0.015..0.076 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
5. 32.040 33.200 ↑ 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.197..3.320 rows=296 loops=10)

  • Recheck Cond: (id_jdd = i2_.id_jdd)
6. 1.160 1.160 ↑ 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.116..0.116 rows=296 loops=10)

  • Index Cond: (id_jdd = i2_.id_jdd)
7. 71.040 71.040 ↓ 2.0 2 2,960

Index Scan using vm_requeteur_observations_id_releve_idx on vm_requeteur_observations i0_ (cost=0.43..8.03 rows=1 width=101) (actual time=0.012..0.024 rows=2 loops=2,960)

  • Index Cond: (id_releve = i1_.rid)
Total runtime : 167.833 ms