explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vpRq

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 91,731.795 ↓ 0.0 0 1

Hash Join (cost=529,834.39..1,323,332.52 rows=429,124 width=4) (actual time=91,731.795..91,731.795 rows=0 loops=1)

  • Hash Cond: (i0_.id_releve = i1_.rid)
2. 89,614.899 91,731.792 ↓ 0.0 0 1

Nested Loop (cost=0.00..767,620.45 rows=429,124 width=8) (actual time=91,731.792..91,731.792 rows=0 loops=1)

  • Join Filter: st_contains(st_buffer(i2_.the_geom, 500::double precision), i0_.the_geom)
  • Rows Removed by Join Filter: 1287372
3. 0.014 0.014 ↑ 1.0 1 1

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

  • Filter: (id = 14)
  • Rows Removed by Filter: 7
4. 2,116.879 2,116.879 ↑ 1.0 1,287,372 1

Seq Scan on observations_habilite i0_ (cost=0.00..111,059.72 rows=1,287,372 width=506) (actual time=0.017..2,116.879 rows=1,287,372 loops=1)

5. 0.000 0.000 ↓ 0.0 0

Hash (cost=466,775.73..466,775.73 rows=3,843,573 width=4) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Seq Scan on releves i1_ (cost=0.00..466,775.73 rows=3,843,573 width=4) (never executed)

Total runtime : 91,731.865 ms