explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XIL9

Settings
# exclusive inclusive rows x rows loops node
1. 0.681 4,596.494 ↓ 1.9 377 1

Sort (cost=132,079.75..132,080.25 rows=200 width=100) (actual time=4,596.485..4,596.494 rows=377 loops=1)

  • Sort Key: r.name
  • Sort Method: quicksort Memory: 79kB
2. 4,267.370 4,595.813 ↓ 1.9 377 1

HashAggregate (cost=132,064.10..132,072.10 rows=200 width=100) (actual time=4,595.698..4,595.813 rows=377 loops=1)

  • Group Key: r.name, r.id, r.shapefilename
3. 44.968 328.443 ↑ 5.2 145,493 1

Hash Join (cost=121.80..118,845.46 rows=755,351 width=8,176) (actual time=0.483..328.443 rows=145,493 loops=1)

  • Hash Cond: (p.psmorgid = r.id)
4. 283.087 283.087 ↓ 1.0 260,838 1

Seq Scan on psmgisareas p (cost=0.00..55,168.67 rows=260,472 width=8,112) (actual time=0.079..283.087 rows=260,838 loops=1)

  • Filter: (psmorgid IS NOT NULL)
  • Rows Removed by Filter: 102729
5. 0.081 0.388 ↑ 4.5 377 1

Hash (cost=100.60..100.60 rows=1,696 width=68) (actual time=0.388..0.388 rows=377 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 44kB
6. 0.217 0.307 ↑ 4.5 377 1

HashAggregate (cost=66.68..83.64 rows=1,696 width=68) (actual time=0.255..0.307 rows=377 loops=1)

  • Group Key: r.id, r.name, r.shapefilename
7. 0.019 0.090 ↑ 4.5 377 1

Append (cost=0.00..53.96 rows=1,696 width=68) (actual time=0.026..0.090 rows=377 loops=1)

8. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on returnorgtable1 r (cost=0.00..18.50 rows=850 width=68) (actual time=0.008..0.008 rows=0 loops=1)

9. 0.063 0.063 ↑ 2.2 377 1

Seq Scan on mainreturnorgtable m (cost=0.00..18.50 rows=846 width=68) (actual time=0.017..0.063 rows=377 loops=1)

  • Filter: (shapefilename IS NOT NULL)
  • Rows Removed by Filter: 46
Planning time : 0.329 ms