explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PAXp

Settings
# exclusive inclusive rows x rows loops node
1. 0.616 84.671 ↓ 1.9 377 1

Sort (cost=24,631.78..24,632.28 rows=200 width=68) (actual time=84.660..84.671 rows=377 loops=1)

  • Sort Key: r.name
  • Sort Method: quicksort Memory: 58kB
2. 30.918 84.055 ↓ 1.9 377 1

HashAggregate (cost=24,622.13..24,624.13 rows=200 width=68) (actual time=84.008..84.055 rows=377 loops=1)

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

Merge Join (cost=192.00..18,957.00 rows=755,351 width=68) (actual time=0.298..53.137 rows=145,493 loops=1)

  • Merge Cond: (r.id = p.psmorgid)
4. 0.122 0.309 ↑ 4.5 377 1

Sort (cost=191.57..195.81 rows=1,696 width=68) (actual time=0.265..0.309 rows=377 loops=1)

  • Sort Key: r.id
  • Sort Method: quicksort Memory: 58kB
5. 0.122 0.187 ↑ 4.5 377 1

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

  • Group Key: r.id, r.name, r.shapefilename
6. 0.011 0.065 ↑ 4.5 377 1

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

7. 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)

8. 0.046 0.046 ↑ 2.2 377 1

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

  • Filter: (shapefilename IS NOT NULL)
  • Rows Removed by Filter: 46
9. 18.368 35.502 ↓ 1.0 260,838 1

Materialize (cost=0.42..8,077.86 rows=260,472 width=4) (actual time=0.030..35.502 rows=260,838 loops=1)

10. 17.134 17.134 ↓ 1.0 260,838 1

Index Only Scan using ix_dks on psmgisareas p (cost=0.42..7,426.68 rows=260,472 width=4) (actual time=0.028..17.134 rows=260,838 loops=1)

  • Index Cond: (psmorgid IS NOT NULL)
  • Heap Fetches: 0
Planning time : 0.391 ms