explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0wIL

Settings
# exclusive inclusive rows x rows loops node
1. 10.853 20,036.815 ↓ 124.8 2,871 1

Sort (cost=199,445.72..199,445.78 rows=23 width=505) (actual time=20,036.060..20,036.815 rows=2,871 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 744kB
2. 1,615.642 20,025.962 ↓ 124.8 2,871 1

Hash Join (cost=184,105.81..199,445.20 rows=23 width=505) (actual time=12,374.355..20,025.962 rows=2,871 loops=1)

  • Hash Cond: (i0_.id_releve = i1_.rid)
3. 6,069.901 6,603.014 ↓ 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=535.258..6,603.014 rows=2,166,992 loops=1)

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

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
5. 41.721 11,807.306 ↑ 5.7 2,960 1

Hash (cost=181,147.10..181,147.10 rows=17,019 width=404) (actual time=11,807.306..11,807.306 rows=2,960 loops=1)

  • Buckets: 1024 Batches: 8 Memory Usage: 68kB
6. 526.572 11,765.585 ↑ 5.7 2,960 1

Hash Join (cost=35.65..181,147.10 rows=17,019 width=404) (actual time=10.748..11,765.585 rows=2,960 loops=1)

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

Seq Scan on vm_requeteur_releves i1_ (cost=0.00..173,116.64 rows=2,086,564 width=404) (actual time=0.016..11,238.941 rows=2,084,695 loops=1)

8. 0.005 0.072 ↑ 1.0 10 1

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

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

  • Index Cond: (id_ca = 451)
Total runtime : 20,038.018 ms