explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dtbAy

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

Unique (cost=192.17..192.18 rows=1 width=33) (actual time=24.169..24.169 rows=0 loops=1)

2. 0.011 24.168 ↓ 0.0 0 1

Sort (cost=192.17..192.17 rows=1 width=33) (actual time=24.168..24.168 rows=0 loops=1)

  • Sort Key: o.id, o.name
  • Sort Method: quicksort Memory: 25kB
3. 0.004 24.157 ↓ 0.0 0 1

Nested Loop (cost=4.84..192.16 rows=1 width=33) (actual time=24.157..24.157 rows=0 loops=1)

4. 0.010 24.009 ↑ 6.7 18 1

Nested Loop (cost=4.56..155.47 rows=121 width=4) (actual time=17.814..24.009 rows=18 loops=1)

5. 0.002 0.010 ↑ 1.0 1 1

Limit (cost=0.00..0.02 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=1)

6. 0.008 0.008 ↑ 1,360.0 1 1

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

7. 12.948 23.989 ↓ 1.5 18 1

Bitmap Heap Scan on psmgisareas psmorg (cost=4.56..155.33 rows=12 width=8,410) (actual time=17.799..23.989 rows=18 loops=1)

  • Recheck Cond: (loggedinorgareatable.polygeom && geom)
  • Filter: _st_intersects(loggedinorgareatable.polygeom, geom)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=15
8. 11.041 11.041 ↑ 1.8 20 1

Bitmap Index Scan on psmgisareas_geom_idx (cost=0.00..4.55 rows=36 width=0) (actual time=11.041..11.041 rows=20 loops=1)

  • Index Cond: (loggedinorgareatable.polygeom && geom)
9. 0.144 0.144 ↓ 0.0 0 18

Index Scan using pk_organisation on organisation o (cost=0.28..0.30 rows=1 width=33) (actual time=0.008..0.008 rows=0 loops=18)

  • Index Cond: (id = psmorg.psmorgid)
  • Filter: isprojectmodule
  • Rows Removed by Filter: 1