explain.depesz.com

PostgreSQL's explain analyze made readable

Result: njV8

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

Unique (cost=25,507,410.40..25,507,412.18 rows=71 width=86) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=25,507,410.40..25,507,410.58 rows=71 width=86) (actual rows= loops=)

  • Sort Key: (0), o.id, (0), (NULL::text), (0), (0), (0), o.name, (CASE WHEN (SubPlan 1) THEN true ELSE false END)
3. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=25,507,365.61..25,507,408.22 rows=71 width=86) (actual rows= loops=)

  • Hash Cond: (o.id = di.partnerorganisationid)
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=25,507,344.40..25,507,383.09 rows=142 width=86) (actual rows= loops=)

  • Group Key: 0, o.id, 0, NULL::text, 0, 0, 0, o.name, CASE WHEN (SubPlan 1) THEN true ELSE false END
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=356.01..23,705,301.22 rows=80,090,808 width=86) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=355.76..1,079,647.71 rows=80,090,808 width=11,670) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=355.76..77,964.51 rows=2,901 width=11,638) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on drawareatable (cost=0.00..1.01 rows=1 width=32) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=355.76..77,934.49 rows=2,901 width=11,606) (actual rows= loops=)

  • Hash Cond: (psmorg.psmorgid = o.id)
10. 0.000 0.000 ↓ 0.0

Seq Scan on psmgisareas psmorg (cost=0.00..76,874.40 rows=268,140 width=11,577) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=354.88..354.88 rows=71 width=33) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on organisation o (cost=0.00..354.88 rows=71 width=33) (actual rows= loops=)

  • Filter: (isprojectmodule AND (id <> 3883))
13. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..617.12 rows=27,608 width=32) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on loggedinorgareatable (cost=0.00..479.08 rows=27,608 width=32) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Function Scan on y (cost=0.25..0.26 rows=1 width=0) (actual rows= loops=)

  • Filter: y
16.          

SubPlan (forNested Loop)

17. 0.000 0.000 ↓ 0.0

Function Scan on st_intersects (cost=0.25..0.26 rows=1 width=1) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=16.90..16.90 rows=345 width=4) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on drawpsmgisareaintersect di (cost=0.00..16.90 rows=345 width=4) (actual rows= loops=)