explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1EU3 : Optimization for: plan #dzi

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1,211.922 14,504.892 ↓ 342.5 731,510 1

Merge Join (cost=14,830.64..7,965,298.68 rows=2,136 width=8) (actual time=5,169.832..14,504.892 rows=731,510 loops=1)

  • Merge Cond: (o.id_releve = r.rid)
2. 3,184.887 6,075.303 ↓ 525.3 2,166,992 1

Sort (cost=14,830.22..14,840.53 rows=4,125 width=8) (actual time=5,169.715..6,075.303 rows=2,166,992 loops=1)

  • Sort Key: o.id_releve
  • Sort Method: external merge Disk: 38144kB
3. 2,445.401 2,890.416 ↓ 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=446.971..2,890.416 rows=2,166,992 loops=1)

  • Recheck Cond: (groupes_fonctionnels && '{12}'::integer[])
  • Rows Removed by Index Recheck: 1704409
4. 445.015 445.015 ↓ 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=445.015..445.015 rows=2,166,992 loops=1)

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
5. 7,217.667 7,217.667 ↓ 1.0 2,118,151 1

Index Only Scan using vm_requeteur_releves_rid_idx on vm_requeteur_releves r (cost=0.43..7,945,214.74 rows=2,084,695 width=4) (actual time=0.099..7,217.667 rows=2,118,151 loops=1)

  • Heap Fetches: 2118151
Total runtime : 14,622.958 ms