explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3a7t

Settings
# exclusive inclusive rows x rows loops node
1. 53.968 105.883 ↓ 1.2 1,097 1

Bitmap Heap Scan on observations_interne o (cost=3,636.20..7,286.52 rows=943 width=11) (actual time=52.441..105.883 rows=1,097 loops=1)

  • Recheck Cond: ((cd_nom = 4,474) AND ((departement)::text = '19'::text))
  • Rows Removed by Index Recheck: 53,785
  • Filter: (the_geom IS NOT NULL)
  • Buffers: shared hit=7,527
2. 2.674 51.915 ↓ 0.0 0 1

BitmapAnd (cost=3,636.20..3,636.20 rows=943 width=0) (actual time=51.915..51.915 rows=0 loops=1)

  • Buffers: shared hit=555
3. 5.485 5.485 ↑ 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.485..5.485 rows=20,288 loops=1)

  • Index Cond: (cd_nom = 4,474)
  • Buffers: shared hit=59
4. 43.756 43.756 ↓ 1.0 180,348 1

Bitmap Index Scan on observations_interne_departement_idx (cost=0.00..3,246.24 rows=175,708 width=0) (actual time=43.756..43.756 rows=180,348 loops=1)

  • Index Cond: ((departement)::text = '19'::text)
  • Buffers: shared hit=496
Total runtime : 106.211 ms