#	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: 3,394

Total runtime	:	93.413 ms

Sort  (cost=223441.29..223441.34 rows=17 width=346) (actual time=91.373..92.128 rows=2871 loops=1)
  Sort Key: a.oid0
  Sort Method: external merge  Disk: 832kB
  CTE a
    ->  Nested Loop  (cost=48.21..223049.11 rows=17415 width=548) (actual time=0.101..68.399 rows=6265 loops=1)
          ->  Nested Loop  (cost=47.78..86374.31 rows=17004 width=412) (actual time=0.079..20.579 rows=2960 loops=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)
                ->  Bitmap Heap Scan on vm_requeteur_releves i1_  (cost=47.50..8609.27 rows=2461 width=412) (actual time=0.101..1.894 rows=296 loops=10)
                      Recheck Cond: (id_jdd = i2_.id_jdd)
                      ->  Bitmap Index Scan on vm_requeteur_releves_id_jdd_idx  (cost=0.00..46.88 rows=2461 width=0) (actual time=0.058..0.058 rows=296 loops=10)
                            Index Cond: (id_jdd = i2_.id_jdd)
          ->  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=2960)
                Index Cond: (id_releve = i1_.rid)
  ->  CTE Scan on a  (cost=0.00..391.84 rows=17 width=346) (actual time=13.378..86.013 rows=2871 loops=1)
        Filter: (groupes_fonctionnels && '{12}'::integer[])
        Rows Removed by Filter: 3394
Total runtime: 93.413 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	18.360 ms	19.9 %
Bitmap Index Scan	1	0.580 ms	0.6 %
CTE Scan	1	86.013 ms	93.4 %
Index Scan	2	41.489 ms	45.0 %
Nested Loop	2	7.970 ms	8.7 %
Sort	1	6.115 ms	6.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
jdd	1	0.049 ms	0.1 %
Index Scan	1	0.049 ms	100.0 %
vm_requeteur_observations	1	41.440 ms	45.0 %
Index Scan	1	41.440 ms	100.0 %
vm_requeteur_releves	1	18.360 ms	19.9 %
Bitmap Heap Scan	1	18.360 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: boSo : Optimization for: plan #fNcS

Color mode:

Visible columns:

Optimization path:

Optimization(s) for this plan:

Per node type stats

Per table stats