explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CW2x

Settings
# exclusive inclusive rows x rows loops node
1. 4,372.850 4,697.244 ↓ 1.9 377 1

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

  • Group Key: r.id, r.name, r.shapefilename
2. 57.903 324.394 ↑ 7.2 145,493 1

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

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

4. 0.055 0.241 ↑ 4.5 377 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 44kB
5. 0.125 0.186 ↑ 4.5 377 1

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

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

Append (cost=0.00..53.96 rows=1,696 width=68) (actual time=0.013..0.061 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.045 0.045 ↑ 2.2 377 1

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

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