explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e8cv

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 20.089 39,154.022 ↓ 130.5 2,871 1

Sort (cost=199,390.92..199,390.98 rows=22 width=501) (actual time=39,153.181..39,154.022 rows=2,871 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 744kB
2. 3,413.202 39,133.933 ↓ 130.5 2,871 1

Hash Join (cost=184,068.05..199,390.43 rows=22 width=501) (actual time=9,851.662..39,133.933 rows=2,871 loops=1)

  • Hash Cond: (i0_.id_releve = i1_.rid)
3. 25,905.332 26,506.110 ↓ 525.3 2,166,992 1

Bitmap Heap Scan on vm_requeteur_observations i0_ (cost=1,847.97..16,138.51 rows=4,125 width=101) (actual time=603.948..26,506.110 rows=2,166,992 loops=1)

  • Recheck Cond: (groupes_fonctionnels && '{12}'::integer[])
  • Rows Removed by Index Recheck: 1704409
4. 600.778 600.778 ↓ 525.3 2,166,992 1

Bitmap Index Scan on vm_requeteur_observations_groupes_fonctionnels_idx (cost=0.00..1,846.94 rows=4,125 width=0) (actual time=600.778..600.778 rows=2,166,992 loops=1)

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
5. 30.393 9,214.621 ↑ 5.7 2,960 1

Hash (cost=181,126.49..181,126.49 rows=17,007 width=400) (actual time=9,214.621..9,214.621 rows=2,960 loops=1)

  • Buckets: 1024 Batches: 8 Memory Usage: 68kB
6. 905.196 9,184.228 ↑ 5.7 2,960 1

Hash Join (cost=35.65..181,126.49 rows=17,007 width=400) (actual time=169.455..9,184.228 rows=2,960 loops=1)

  • Hash Cond: (i1_.id_jdd = i2_.id_jdd)
7. 8,262.689 8,262.689 ↑ 1.0 2,084,695 1

Seq Scan on vm_requeteur_releves i1_ (cost=0.00..173,101.74 rows=2,085,074 width=400) (actual time=0.014..8,262.689 rows=2,084,695 loops=1)

8. 0.019 16.343 ↑ 1.0 10 1

Hash (cost=35.53..35.53 rows=10 width=4) (actual time=16.343..16.343 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
9. 16.324 16.324 ↑ 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=12.833..16.324 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
Total runtime : 39,154.985 ms