explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O3kz

Settings
# exclusive inclusive rows x rows loops node
1. 0.619 82.129 ↓ 1.9 377 1

Sort (cost=33,385.80..33,386.30 rows=200 width=68) (actual time=82.118..82.129 rows=377 loops=1)

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

HashAggregate (cost=33,376.16..33,378.16 rows=200 width=68) (actual time=81.467..81.510 rows=377 loops=1)

  • Group Key: r.name, r.id, r.shapefilename
3. 17.051 51.122 ↑ 7.2 145,493 1

Merge Join (cost=192.00..25,468.77 rows=1,054,319 width=68) (actual time=0.284..51.122 rows=145,493 loops=1)

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

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

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

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

  • Group Key: r.id, r.name, r.shapefilename
6. 0.012 0.063 ↑ 4.5 377 1

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

7. 0.009 0.009 ↓ 0.0 0 1

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

8. 0.042 0.042 ↑ 2.2 377 1

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

  • Filter: (shapefilename IS NOT NULL)
  • Rows Removed by Filter: 46
9. 17.935 33.766 ↑ 1.4 260,839 1

Materialize (cost=0.42..10,362.85 rows=363,567 width=4) (actual time=0.018..33.766 rows=260,839 loops=1)

10. 15.831 15.831 ↑ 1.4 260,839 1

Index Only Scan using ix_dks on psmgisareas p (cost=0.42..9,453.93 rows=363,567 width=4) (actual time=0.016..15.831 rows=260,839 loops=1)

  • Heap Fetches: 0
Planning time : 0.190 ms