explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PyXM

Settings
# exclusive inclusive rows x rows loops node
1. 10.462 8,101.313 ↓ 168.9 2,871 1

Sort (cost=199,451.45..199,451.49 rows=17 width=513) (actual time=8,100.542..8,101.313 rows=2,871 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 744kB
2. 1,553.989 8,090.851 ↓ 168.9 2,871 1

Hash Join (cost=184,095.77..199,451.10 rows=17 width=513) (actual time=3,768.009..8,090.851 rows=2,871 loops=1)

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

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

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

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
5. 26.329 3,357.619 ↑ 5.7 2,960 1

Hash (cost=181,121.25..181,121.25 rows=17,004 width=412) (actual time=3,357.619..3,357.619 rows=2,960 loops=1)

  • Buckets: 1024 Batches: 8 Memory Usage: 68kB
6. 564.386 3,331.290 ↑ 5.7 2,960 1

Hash Join (cost=35.65..181,121.25 rows=17,004 width=412) (actual time=0.415..3,331.290 rows=2,960 loops=1)

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

Seq Scan on vm_requeteur_releves i1_ (cost=0.00..173,097.95 rows=2,084,695 width=412) (actual time=0.013..2,766.845 rows=2,084,695 loops=1)

8. 0.005 0.059 ↑ 1.0 10 1

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

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

  • Index Cond: (id_ca = 451)
Total runtime : 8,101.989 ms