explain.depesz.com

PostgreSQL's explain analyze made readable

Result: obXX

Settings
# exclusive inclusive rows x rows loops node
1. 111.987 2,007.416 ↓ 36.5 146 1

Hash Join (cost=14,431.67..28,777.94 rows=4 width=11) (actual time=74.616..2,007.416 rows=146 loops=1)

  • Hash Cond: (i0_.id_releve = i1_.rid)
2. 1,825.143 1,884.548 ↓ 47.2 182,076 1

Bitmap Heap Scan on observations_interne i0_ (cost=249.92..14,567.20 rows=3,860 width=8) (actual time=61.082..1,884.548 rows=182,076 loops=1)

  • Recheck Cond: (groupes_fonctionnels && '{71}'::integer[])
  • Rows Removed by Index Recheck: 1194879
  • Filter: (the_geom IS NOT NULL)
3. 59.405 59.405 ↓ 47.2 182,076 1

Bitmap Index Scan on observations_interne_groupes_fonctionnels_idx (cost=0.00..248.95 rows=3,860 width=0) (actual time=59.405..59.405 rows=182,076 loops=1)

  • Index Cond: (groupes_fonctionnels && '{71}'::integer[])
4. 2.016 10.881 ↑ 1.1 3,580 1

Hash (cost=14,134.48..14,134.48 rows=3,782 width=11) (actual time=10.881..10.881 rows=3,580 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 158kB
5. 8.246 8.865 ↑ 1.1 3,580 1

Bitmap Heap Scan on vm_requeteur_releves i1_ (cost=73.74..14,134.48 rows=3,782 width=11) (actual time=1.029..8.865 rows=3,580 loops=1)

  • Recheck Cond: ((commune)::text = '33063'::text)
6. 0.619 0.619 ↑ 1.1 3,580 1

Bitmap Index Scan on vm_requeteur_releves_commune_idx (cost=0.00..72.80 rows=3,782 width=0) (actual time=0.619..0.619 rows=3,580 loops=1)

  • Index Cond: ((commune)::text = '33063'::text)
Total runtime : 2,007.606 ms