explain.depesz.com

PostgreSQL's explain analyze made readable

Result: boSo : Optimization for: plan #fNcS

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 6.115 92.128 ↓ 168.9 2,871 1

Sort (cost=223,441.29..223,441.34 rows=17 width=346) (actual time=91.373..92.128 rows=2,871 loops=1)

  • Sort Key: a.oid0
  • Sort Method: external merge Disk: 832kB
2.          

CTE a

3. 6.380 68.399 ↑ 2.8 6,265 1

Nested Loop (cost=48.21..223,049.11 rows=17,415 width=548) (actual time=0.101..68.399 rows=6,265 loops=1)

4. 1.590 20.579 ↑ 5.7 2,960 1

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

5. 0.049 0.049 ↑ 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.014..0.049 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
6. 18.360 18.940 ↑ 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.101..1.894 rows=296 loops=10)

  • Recheck Cond: (id_jdd = i2_.id_jdd)
7. 0.580 0.580 ↑ 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.058..0.058 rows=296 loops=10)

  • Index Cond: (id_jdd = i2_.id_jdd)
8. 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=136) (actual time=0.007..0.014 rows=2 loops=2,960)

  • Index Cond: (id_releve = i1_.rid)
9. 86.013 86.013 ↓ 168.9 2,871 1

CTE Scan on a (cost=0.00..391.84 rows=17 width=346) (actual time=13.378..86.013 rows=2,871 loops=1)

  • Filter: (groupes_fonctionnels && '{12}'::integer[])
  • Rows Removed by Filter: 3394
Total runtime : 93.413 ms