#	exclusive	inclusive	rows x	rows	loops	node
1.	1,605.463	84,105.005	↓ 342.5	731,510	1	→ Nested Loop (cost=292.39..48,397.69 rows=2,136 width=8) (actual time=568.605..84,105.005 rows=731,510 loops=1)
2.	19,114.411	19,656.774	↓ 525.3	2,166,992	1	→ Bitmap Heap Scan on vm_requeteur_observations o (cost=291.97..14,582.51 rows=4,125 width=8) (actual time=554.146..19,656.774 rows=2,166,992 loops=1) Recheck Cond: (groupes_fonctionnels && '{12}'::integer[]) Rows Removed by Index Recheck: 1,704,409
3.	542.363	542.363	↓ 525.3	2,166,992	1	→ Bitmap Index Scan on vm_requeteur_observations_groupes_fonctionnels_idx (cost=0.00..290.93 rows=4,125 width=0) (actual time=542.363..542.363 rows=2,166,992 loops=1) Index Cond: (groupes_fonctionnels && '{12}'::integer[])
4.	62,842.768	62,842.768	↓ 0.0	0	2,166,992	→ Index Only Scan using vm_requeteur_releves_rid_idx on vm_requeteur_releves r (cost=0.43..8.19 rows=1 width=4) (actual time=0.028..0.029 rows=0 loops=2,166,992) Index Cond: (rid = o.id_releve) Heap Fetches: 731,510

Total runtime	:	84,275.618 ms

Nested Loop  (cost=292.39..48397.69 rows=2136 width=8) (actual time=568.605..84105.005 rows=731510 loops=1)
  ->  Bitmap Heap Scan on vm_requeteur_observations o  (cost=291.97..14582.51 rows=4125 width=8) (actual time=554.146..19656.774 rows=2166992 loops=1)
        Recheck Cond: (groupes_fonctionnels && '{12}'::integer[])
        Rows Removed by Index Recheck: 1704409
        ->  Bitmap Index Scan on vm_requeteur_observations_groupes_fonctionnels_idx  (cost=0.00..290.93 rows=4125 width=0) (actual time=542.363..542.363 rows=2166992 loops=1)
              Index Cond: (groupes_fonctionnels && '{12}'::integer[])
  ->  Index Only Scan using vm_requeteur_releves_rid_idx on vm_requeteur_releves r  (cost=0.43..8.19 rows=1 width=4) (actual time=0.028..0.029 rows=0 loops=2166992)
        Index Cond: (rid = o.id_releve)
        Heap Fetches: 731510
Total runtime: 84275.618 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	19,114.411 ms	22.7 %
Bitmap Index Scan	1	542.363 ms	0.6 %
Index Only Scan	1	62,842.768 ms	74.7 %
Nested Loop	1	1,605.463 ms	1.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
vm_requeteur_observations	1	19,114.411 ms	22.7 %
Bitmap Heap Scan	1	19,114.411 ms	100.0 %
vm_requeteur_releves	1	62,842.768 ms	74.7 %
Index Only Scan	1	62,842.768 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dzi

Color mode:

Visible columns:

Optimization(s) for this plan:

Per node type stats

Per table stats