explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X2Ga

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 52.152 ↓ 0.0 0 1

Nested Loop (cost=9.82..4,071.51 rows=429 width=4) (actual time=52.152..52.152 rows=0 loops=1)

2. 0.007 52.151 ↓ 0.0 0 1

Nested Loop (cost=9.39..546.67 rows=429 width=8) (actual time=52.151..52.151 rows=0 loops=1)

3. 0.022 0.022 ↑ 1.0 1 1

Seq Scan on temp_requete_geom i2_ (cost=0.00..1.01 rows=1 width=32) (actual time=0.017..0.022 rows=1 loops=1)

  • Filter: (id = 14)
  • Rows Removed by Filter: 7
4. 51.303 52.122 ↓ 0.0 0 1

Bitmap Heap Scan on observations_habilite i0_ (cost=9.39..545.23 rows=43 width=506) (actual time=52.122..52.122 rows=0 loops=1)

  • Recheck Cond: (i2_.the_geom && the_geom)
  • Filter: _st_contains(i2_.the_geom, the_geom)
  • Rows Removed by Filter: 867
5. 0.819 0.819 ↓ 6.7 867 1

Bitmap Index Scan on observations_habilite_idx_geom (cost=0.00..9.38 rows=129 width=0) (actual time=0.819..0.819 rows=867 loops=1)

  • Index Cond: (i2_.the_geom && the_geom)
6. 0.000 0.000 ↓ 0.0 0

Index Only Scan using releves_rid_idx on releves i1_ (cost=0.43..8.21 rows=1 width=4) (never executed)

  • Index Cond: (rid = i0_.id_releve)
  • Heap Fetches: 0
Total runtime : 52.399 ms