explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ojsm

Settings
# exclusive inclusive rows x rows loops node
1. 3.658 27.034 ↑ 3.6 6,265 1

Sort (cost=284,509.53..284,565.46 rows=22,372 width=4) (actual time=26.087..27.034 rows=6,265 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: quicksort Memory: 486kB
2. 2.228 23.376 ↑ 3.6 6,265 1

Nested Loop (cost=82.26..282,893.22 rows=22,372 width=4) (actual time=0.069..23.376 rows=6,265 loops=1)

3. 1.091 6.348 ↑ 5.7 2,960 1

Nested Loop (cost=81.83..146,194.30 rows=17,007 width=4) (actual time=0.059..6.348 rows=2,960 loops=1)

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

  • Index Cond: (id_ca = 451)
5. 4.800 5.230 ↑ 14.6 296 10

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

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

  • Index Cond: (id_jdd = i2_.id_jdd)
7. 14.800 14.800 ↓ 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=8) (actual time=0.003..0.005 rows=2 loops=2,960)

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