explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nMG5

Settings
# exclusive inclusive rows x rows loops node
1. 0.646 4,586.505 ↓ 1.9 377 1

Sort (cost=162,260.29..162,260.79 rows=200 width=100) (actual time=4,586.495..4,586.505 rows=377 loops=1)

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

HashAggregate (cost=162,244.65..162,252.65 rows=200 width=100) (actual time=4,585.743..4,585.859 rows=377 loops=1)

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

Hash Join (cost=121.80..143,859.18 rows=1,050,598 width=8,103) (actual time=0.267..327.614 rows=145,493 loops=1)

  • Hash Cond: (p.psmorgid = r.id)
4. 268.071 268.071 ↓ 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.024..268.071 rows=363,567 loops=1)

5. 0.057 0.229 ↑ 4.5 377 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 44kB
6. 0.115 0.172 ↑ 4.5 377 1

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

  • Group Key: r.id, r.name, r.shapefilename
7. 0.013 0.057 ↑ 4.5 377 1

Append (cost=0.00..53.96 rows=1,696 width=68) (actual time=0.012..0.057 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.007..0.039 rows=377 loops=1)

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