explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5qBy : Optimization for: plan #LC38

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 25.199 45,911.263 ↓ 662.5 8,613 1

Sort (cost=218,147.01..218,147.05 rows=13 width=513) (actual time=45,908.132..45,911.263 rows=8,613 loops=1)

  • Sort Key: o.oid
  • Sort Method: external merge Disk: 2216kB
2. 3,239.073 45,886.064 ↓ 662.5 8,613 1

Hash Join (cost=203,035.48..218,146.77 rows=13 width=513) (actual time=14,150.928..45,886.064 rows=8,613 loops=1)

  • Hash Cond: (o.id_releve = r.rid)
3. 28,556.540 29,130.864 ↓ 525.3 2,166,992 1

Bitmap Heap Scan on vm_requeteur_observations o (cost=291.97..14,582.51 rows=4,125 width=101) (actual time=587.046..29,130.864 rows=2,166,992 loops=1)

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

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
5. 59.176 13,516.127 ↑ 1.4 8,880 1

Hash (cost=201,917.74..201,917.74 rows=12,462 width=412) (actual time=13,516.127..13,516.127 rows=8,880 loops=1)

  • Buckets: 1024 Batches: 8 Memory Usage: 203kB
6. 883.288 13,456.951 ↑ 1.4 8,880 1

Hash Join (cost=30.61..201,917.74 rows=12,462 width=412) (actual time=26.453..13,456.951 rows=8,880 loops=1)

  • Hash Cond: (r.id_jdd = m.id_jdd)
7. 12,573.445 12,573.445 ↑ 1.0 2,084,695 1

Seq Scan on vm_requeteur_releves r (cost=0.00..173,097.95 rows=2,084,695 width=412) (actual time=0.022..12,573.445 rows=2,084,695 loops=1)

8. 0.014 0.218 ↓ 3.3 30 1

Hash (cost=30.50..30.50 rows=9 width=4) (actual time=0.218..0.218 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
9. 0.167 0.204 ↓ 3.3 30 1

Bitmap Heap Scan on vm_requeteur_metadonnees m (cost=4.35..30.50 rows=9 width=4) (actual time=0.052..0.204 rows=30 loops=1)

  • Recheck Cond: (id_ca = 451)
10. 0.037 0.037 ↓ 3.3 30 1

Bitmap Index Scan on vm_requeteur_metadonnees_id_ca_idx (cost=0.00..4.35 rows=9 width=0) (actual time=0.037..0.037 rows=30 loops=1)

  • Index Cond: (id_ca = 451)
Total runtime : 45,913.231 ms