explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IBt8

Settings
# exclusive inclusive rows x rows loops node
1. 15.975 211.796 ↓ 1.1 1,097 1

Nested Loop (cost=394.90..243,121.43 rows=1,009 width=11) (actual time=6.443..211.796 rows=1,097 loops=1)

  • Buffers: shared hit=101,205
2. 89.227 94.381 ↑ 1.0 20,288 1

Bitmap Heap Scan on observations_interne o (cost=394.47..69,015.48 rows=20,908 width=15) (actual time=6.196..94.381 rows=20,288 loops=1)

  • Recheck Cond: (cd_nom = 4,474)
  • Rows Removed by Index Recheck: 123,980
  • Filter: (the_geom IS NOT NULL)
  • Buffers: shared hit=19,935
3. 5.154 5.154 ↑ 1.0 20,288 1

Bitmap Index Scan on observations_interne_cd_nom_idx (cost=0.00..389.24 rows=20,908 width=0) (actual time=5.154..5.154 rows=20,288 loops=1)

  • Index Cond: (cd_nom = 4,474)
  • Buffers: shared hit=59
4. 101.440 101.440 ↓ 0.0 0 20,288

Index Scan using releves_rid_idx on releves r (cost=0.43..8.32 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=20,288)

  • Index Cond: (rid = o.id_releve)
  • Filter: ((departement)::text = '19'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=81,270
Total runtime : 212.073 ms