explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3F2w : teste2

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

Unique (cost=251,285.07..271,608.51 rows=451,632 width=161) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=251,285.07..252,414.15 rows=451,632 width=161) (actual rows= loops=)

  • Sort Key: issue0_.id, issue0_.protocol, issue0_.uniqueid, issue0_.subject, issue0_.date_sla, issue0_.date_add, issue0_.date_close, issue0_.date_last_change, user2_.id, user3_.id, issue0_.status, issue0_.id_issue_group, issue0_.id_issue_type, issue0 (...)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=24,544.94..171,815.01 rows=451,632 width=161) (actual rows= loops=)

  • Hash Cond: (issue0_.id_issue_contact = issueconta8_.id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=120.06..136,663.86 rows=451,632 width=161) (actual rows= loops=)

  • Hash Cond: (issue0_.id_issue_source = issuesourc7_.id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=85.31..130,419.17 rows=451,632 width=161) (actual rows= loops=)

  • Hash Cond: (issue0_.id_issue_category = issuecateg6_.id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=75.58..124,199.51 rows=451,632 width=161) (actual rows= loops=)

  • Hash Cond: (issue0_.id_issue_type = issuetype5_.id)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=41.28..117,955.27 rows=451,632 width=161) (actual rows= loops=)

  • Hash Cond: (issue0_.id_issue_group = issuegroup4_.id)
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=39.67..111,743.72 rows=451,632 width=161) (actual rows= loops=)

  • Hash Cond: (issue0_.id_user_create = user3_.id)
9. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=21.22..105,637.42 rows=451,632 width=161) (actual rows= loops=)

  • Hash Cond: (issue0_.id_user_last_change = user2_.id)
10. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2.78..99,410.08 rows=451,632 width=161) (actual rows= loops=)

  • Hash Cond: (issue0_.id = listissuea1_.id_issue)
  • Filter: ((((issue0_.visibility)::text = 'DEFAULT'::text) AND (issue0_.id_issue_group = ANY ('{2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28}'::integer[]))) OR (((issue0_.vis (...)
11. 0.000 0.000 ↓ 0.0

Seq Scan on issue issue0_ (cost=0.00..96,015.82 rows=451,632 width=161) (actual rows= loops=)

  • Filter: ((status)::text = ANY ('{OPEN,CLOSE,PENDING,WAITING,WORKING}'::text[]))
12. 0.000 0.000 ↓ 0.0

Hash (cost=1.79..1.79 rows=79 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on issue_assign_user listissuea1_ (cost=0.00..1.79 rows=79 width=8) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=14.31..14.31 rows=331 width=4) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on "user" user2_ (cost=0.00..14.31 rows=331 width=4) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash (cost=14.31..14.31 rows=331 width=4) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on "user" user3_ (cost=0.00..14.31 rows=331 width=4) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=1.27..1.27 rows=27 width=4) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on issue_group issuegroup4_ (cost=0.00..1.27 rows=27 width=4) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash (cost=20.80..20.80 rows=1,080 width=4) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on issue_type issuetype5_ (cost=0.00..20.80 rows=1,080 width=4) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash (cost=5.99..5.99 rows=299 width=4) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on issue_category issuecateg6_ (cost=0.00..5.99 rows=299 width=4) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash (cost=21.00..21.00 rows=1,100 width=4) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Seq Scan on issue_source issuesourc7_ (cost=0.00..21.00 rows=1,100 width=4) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Hash (cost=17,006.06..17,006.06 rows=593,506 width=4) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Seq Scan on issue_contact issueconta8_ (cost=0.00..17,006.06 rows=593,506 width=4) (actual rows= loops=)