explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vK4m

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,422.977 ↑ 65.0 1 1

Unique (cost=158,812.06..158,820.89 rows=65 width=33) (actual time=1,422.973..1,422.977 rows=1 loops=1)

2. 0.040 1,422.973 ↑ 69.3 17 1

Sort (cost=158,812.06..158,815.00 rows=1,178 width=33) (actual time=1,422.972..1,422.973 rows=17 loops=1)

  • Sort Key: o.id, o.name
  • Sort Method: quicksort Memory: 26kB
3. 0.658 1,422.933 ↑ 69.3 17 1

Hash Join (cost=335.80..158,751.97 rows=1,178 width=33) (actual time=325.958..1,422.933 rows=17 loops=1)

  • Hash Cond: (psmorg.psmorgid = o.id)
4. 1.910 1,420.174 ↑ 101.2 1,628 1

Nested Loop (cost=0.28..156,335.80 rows=164,817 width=4) (actual time=3.291..1,420.174 rows=1,628 loops=1)

5. 0.057 0.057 ↑ 27.8 49 1

Seq Scan on loggedinorgareatable (cost=0.00..23.60 rows=1,360 width=32) (actual time=0.009..0.057 rows=49 loops=1)

6. 1,418.207 1,418.207 ↓ 2.8 33 49

Index Scan using psmgisareas_geom_idx on psmgisareas psmorg (cost=0.28..114.82 rows=12 width=8,410) (actual time=7.334..28.943 rows=33 loops=49)

  • Index Cond: (loggedinorgareatable.polygeom && geom)
  • Filter: _st_intersects(loggedinorgareatable.polygeom, geom)
  • Rows Removed by Filter: 14
7. 0.014 2.101 ↑ 1.0 65 1

Hash (cost=334.70..334.70 rows=65 width=33) (actual time=2.101..2.101 rows=65 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
8. 2.087 2.087 ↑ 1.0 65 1

Seq Scan on organisation o (cost=0.00..334.70 rows=65 width=33) (actual time=0.068..2.087 rows=65 loops=1)

  • Filter: isprojectmodule
  • Rows Removed by Filter: 6,405