explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UgQM

Settings
# exclusive inclusive rows x rows loops node
1. 0.643 4,577.750 ↓ 1.9 377 1

Sort (cost=154,554.90..154,555.40 rows=200 width=76) (actual time=4,577.737..4,577.750 rows=377 loops=1)

  • Sort Key: r.name
  • Sort Method: quicksort Memory: 64kB
2. 4,252.354 4,577.107 ↓ 1.9 377 1

HashAggregate (cost=154,543.75..154,547.25 rows=200 width=76) (actual time=4,577.034..4,577.107 rows=377 loops=1)

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

Hash Join (cost=121.80..144,000.57 rows=1,054,319 width=8,176) (actual time=0.291..324.753 rows=145,493 loops=1)

  • Hash Cond: (p.psmorgid = r.id)
4. 264.470 264.470 ↑ 1.0 363,567 1

Seq Scan on psmgisareas p (cost=0.00..55,168.67 rows=363,567 width=8,112) (actual time=0.027..264.470 rows=363,567 loops=1)

5. 0.049 0.255 ↑ 4.5 377 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 44kB
6. 0.150 0.206 ↑ 4.5 377 1

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

  • Group Key: r.id, r.name, r.shapefilename
7. 0.012 0.056 ↑ 4.5 377 1

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

8. 0.005 0.005 ↓ 0.0 0 1

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

9. 0.039 0.039 ↑ 2.2 377 1

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

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