explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mwYH

Settings
# exclusive inclusive rows x rows loops node
1. 2.243 1,860.741 ↑ 1.3 2,531 1

Nested Loop (cost=0.43..522,823.60 rows=3,375 width=11) (actual time=0.058..1,860.741 rows=2,531 loops=1)

2. 1,843.146 1,843.146 ↑ 1.7 1,919 1

Seq Scan on releves i1_ (cost=0.00..495,007.48 rows=3,322 width=4) (actual time=0.033..1,843.146 rows=1,919 loops=1)

  • Filter: ((r_date_min >= '2019-09-03'::date) AND (((r_date_max IS NULL) AND (r_date_min <= '2020-01-09'::date)) OR (r_date_max <= '2020-01-09'::date)))
  • Rows Removed by Filter: 3833480
3. 15.352 15.352 ↑ 1.0 1 1,919

Index Scan using observations_interne_id_releve_idx on observations_interne i0_ (cost=0.43..8.36 rows=1 width=15) (actual time=0.006..0.008 rows=1 loops=1,919)

  • Index Cond: (id_releve = i1_.rid)
  • Filter: (the_geom IS NOT NULL)
Total runtime : 1,861.242 ms