explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kYMH : Optimization for: plan #dzi

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1,913.322 13,964.989 ↓ 342.5 731,510 1

Hash Join (cost=207,592.60..230,113.44 rows=2,136 width=8) (actual time=8,478.380..13,964.989 rows=731,510 loops=1)

  • Hash Cond: (o.id_releve = r.rid)
2. 3,840.644 4,183.687 ↓ 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=344.986..4,183.687 rows=2,166,992 loops=1)

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

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
4. 1,529.457 7,867.980 ↑ 1.0 2,084,695 1

Hash (cost=173,097.95..173,097.95 rows=2,084,695 width=4) (actual time=7,867.980..7,867.980 rows=2,084,695 loops=1)

  • Buckets: 4096 Batches: 128 Memory Usage: 583kB
5. 6,338.523 6,338.523 ↑ 1.0 2,084,695 1

Seq Scan on vm_requeteur_releves r (cost=0.00..173,097.95 rows=2,084,695 width=4) (actual time=0.014..6,338.523 rows=2,084,695 loops=1)

Total runtime : 14,058.131 ms