explain.depesz.com

PostgreSQL's explain analyze made readable

Result: peCd

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 17.813 87.284 ↑ 2.8 6,265 1

Sort (cost=288,050.66..288,094.21 rows=17,418 width=501) (actual time=85.195..87.284 rows=6,265 loops=1)

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

Nested Loop (cost=82.26..282,893.22 rows=17,418 width=501) (actual time=0.107..69.471 rows=6,265 loops=1)

3. 1.713 20.871 ↑ 5.7 2,960 1

Nested Loop (cost=81.83..146,194.30 rows=17,007 width=400) (actual time=0.085..20.871 rows=2,960 loops=1)

4. 0.068 0.068 ↑ 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.026..0.068 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
5. 18.500 19.090 ↑ 14.6 296 10

Bitmap Heap Scan on vm_requeteur_releves i1_ (cost=81.55..14,572.62 rows=4,326 width=400) (actual time=0.102..1.909 rows=296 loops=10)

  • Recheck Cond: (id_jdd = i2_.id_jdd)
6. 0.590 0.590 ↑ 14.6 296 10

Bitmap Index Scan on vm_requeteur_releves_id_jdd_idx (cost=0.00..80.47 rows=4,326 width=0) (actual time=0.059..0.059 rows=296 loops=10)

  • Index Cond: (id_jdd = i2_.id_jdd)
7. 41.440 41.440 ↓ 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.007..0.014 rows=2 loops=2,960)

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