explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z9cZ : difference_wmap

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on world2 (cost=35,446.62..35,447.88 rows=1 width=38) (actual rows= loops=)

2.          

Initplan (for Update)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=35,446.61..35,446.62 rows=1 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on granice_polygon_sve (cost=0.00..35,445.62 rows=392 width=2,297) (actual rows= loops=)

  • Filter: ((country)::text = 'BIH'::text)
5. 0.000 0.000 ↓ 0.0

Seq Scan on world2 (cost=0.00..1.26 rows=1 width=38) (actual rows= loops=)