explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ky3j

Settings
# exclusive inclusive rows x rows loops node
1. 0.655 4,579.659 ↓ 1.9 377 1

Sort (cost=162,205.15..162,205.65 rows=200 width=100) (actual time=4,579.649..4,579.659 rows=377 loops=1)

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

HashAggregate (cost=162,189.51..162,197.51 rows=200 width=100) (actual time=4,578.885..4,579.004 rows=377 loops=1)

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

Hash Join (cost=66.66..143,804.04 rows=1,050,598 width=8,103) (actual time=0.148..324.071 rows=145,493 loops=1)

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

Seq Scan on psmgisareas p (cost=0.00..55,164.04 rows=363,104 width=8,039) (actual time=0.036..264.744 rows=363,567 loops=1)

5. 0.039 0.097 ↑ 4.5 377 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 44kB
6. 0.010 0.058 ↑ 4.5 377 1

Append (cost=0.00..45.46 rows=1,696 width=68) (actual time=0.014..0.058 rows=377 loops=1)

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

8. 0.043 0.043 ↑ 2.2 377 1

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

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