explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qAL7 : List Tasks

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 5.937 ↑ 250.8 44 1

Unique (cost=169,093.44..171,410.79 rows=11,035 width=16,665) (actual time=5.912..5.937 rows=44 loops=1)

2.          

Initplan (forUnique)

3. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on task_mgt_tag taskmanage13_ (cost=0.00..1.79 rows=1 width=8) (actual time=0.003..0.006 rows=1 loops=1)

  • Filter: ((label)::text = 'ARCHIVED'::text)
  • Rows Removed by Filter: 62
4. 0.106 5.913 ↑ 250.8 44 1

Sort (cost=169,091.65..169,119.24 rows=11,035 width=16,665) (actual time=5.911..5.913 rows=44 loops=1)

  • Sort Key: taskentity0_.id, actions1_.business_id, comments8_.creation_date, comments2_.creation_date, actions1_.id, comments8_.id, taskmanage10_.id, taskmanage11_.id, children12_.id, comments2_.id, checklisti3_.id, taskmanage5_.id, taskmanage6_.id, (...)
  • Sort Method: quicksort Memory: 48kB
5. 0.036 5.807 ↑ 250.8 44 1

Hash Left Join (cost=8,429.11..10,913.66 rows=11,035 width=16,665) (actual time=5.710..5.807 rows=44 loops=1)

  • Hash Cond: (tags4_.tag_id = taskmanage5_.id)
6. 0.031 5.682 ↑ 250.8 44 1

Hash Left Join (cost=8,420.28..10,828.70 rows=11,035 width=11,893) (actual time=5.614..5.682 rows=44 loops=1)

  • Hash Cond: (taskentity0_.id = tags4_.task_id)
7. 0.017 5.395 ↑ 283.9 26 1

Hash Left Join (cost=8,379.46..9,311.85 rows=7,382 width=11,877) (actual time=5.349..5.395 rows=26 loops=1)

  • Hash Cond: (taskentity0_.id = checklisti3_.task_id)
8. 0.020 5.368 ↑ 283.9 26 1

Hash Semi Join (cost=8,378.03..9,281.30 rows=7,382 width=10,821) (actual time=5.332..5.368 rows=26 loops=1)

  • Hash Cond: (taskentity0_.project_business_id = project16_.business_id)
9. 0.020 5.303 ↑ 527.3 28 1

Hash Left Join (cost=8,372.59..9,154.98 rows=14,765 width=10,821) (actual time=5.279..5.303 rows=28 loops=1)

  • Hash Cond: (actions1_.id = tags9_.action_id)
10. 1.215 5.173 ↑ 527.3 28 1

Hash Right Join (cost=8,365.45..9,090.84 rows=14,765 width=6,113) (actual time=5.160..5.173 rows=28 loops=1)

  • Hash Cond: (comments8_.action_id = actions1_.id)
11. 1.258 1.258 ↑ 1.0 16,490 1

Seq Scan on task_mgt_action_comment comments8_ (cost=0.00..515.90 rows=16,490 width=1,088) (actual time=0.002..1.258 rows=16,490 loops=1)

12. 0.017 2.700 ↑ 17.4 28 1

Hash (cost=8,359.35..8,359.35 rows=488 width=5,025) (actual time=2.700..2.700 rows=28 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
13. 0.016 2.683 ↑ 17.4 28 1

Hash Left Join (cost=34.39..8,359.35 rows=488 width=5,025) (actual time=0.558..2.683 rows=28 loops=1)

  • Hash Cond: (taskentity0_.id = comments2_.task_id)
14. 0.018 2.581 ↑ 17.4 28 1

Hash Left Join (cost=24.26..8,332.83 rows=488 width=3,937) (actual time=0.467..2.581 rows=28 loops=1)

  • Hash Cond: (taskentity0_.id = actions1_.task_id)
15. 1.331 2.307 ↑ 27.1 18 1

Seq Scan on task_mgt_task taskentity0_ (cost=0.00..8,294.26 rows=488 width=3,788) (actual time=0.206..2.307 rows=18 loops=1)

  • Filter: (NOT (SubPlan 2))
  • Rows Removed by Filter: 958
16.          

SubPlan (forSeq Scan)

17. 0.000 0.976 ↑ 7.0 1 976

Bitmap Heap Scan on task_mgt_tag_to_task tags14_ (cost=4.33..12.56 rows=7 width=8) (actual time=0.001..0.001 rows=1 loops=976)

  • Recheck Cond: (taskentity0_.id = task_id)
  • Heap Blocks: exact=1129
18. 0.976 0.976 ↑ 7.0 1 976

Bitmap Index Scan on task_mgt_tag_to_task_pk (cost=0.00..4.33 rows=7 width=0) (actual time=0.001..0.001 rows=1 loops=976)

  • Index Cond: (taskentity0_.id = task_id)
19. 0.134 0.256 ↑ 1.0 545 1

Hash (cost=17.45..17.45 rows=545 width=149) (actual time=0.256..0.256 rows=545 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 108kB
20. 0.122 0.122 ↑ 1.0 545 1

Seq Scan on task_mgt_action actions1_ (cost=0.00..17.45 rows=545 width=149) (actual time=0.003..0.122 rows=545 loops=1)

21. 0.048 0.086 ↑ 1.0 228 1

Hash (cost=7.28..7.28 rows=228 width=1,088) (actual time=0.086..0.086 rows=228 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
22. 0.038 0.038 ↑ 1.0 228 1

Seq Scan on task_mgt_task_comment comments2_ (cost=0.00..7.28 rows=228 width=1,088) (actual time=0.003..0.038 rows=228 loops=1)

23. 0.004 0.110 ↑ 1.0 6 1

Hash (cost=7.06..7.06 rows=6 width=4,708) (actual time=0.110..0.110 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.011 0.106 ↑ 1.0 6 1

Hash Right Join (cost=5.14..7.06 rows=6 width=4,708) (actual time=0.104..0.106 rows=6 loops=1)

  • Hash Cond: (children12_.parent_id = taskmanage10_.id)
25. 0.004 0.004 ↑ 1.0 63 1

Seq Scan on task_mgt_tag children12_ (cost=0.00..1.63 rows=63 width=1,564) (actual time=0.001..0.004 rows=63 loops=1)

26. 0.020 0.091 ↑ 1.0 6 1

Hash (cost=5.06..5.06 rows=6 width=3,144) (actual time=0.091..0.091 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
27. 0.014 0.071 ↑ 1.0 6 1

Hash Right Join (cost=3.14..5.06 rows=6 width=3,144) (actual time=0.069..0.071 rows=6 loops=1)

  • Hash Cond: (taskmanage11_.id = taskmanage10_.parent_id)
28. 0.004 0.004 ↑ 1.0 63 1

Seq Scan on task_mgt_tag taskmanage11_ (cost=0.00..1.63 rows=63 width=1,564) (actual time=0.002..0.004 rows=63 loops=1)

29. 0.006 0.053 ↑ 1.0 6 1

Hash (cost=3.06..3.06 rows=6 width=1,580) (actual time=0.053..0.053 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.036 0.047 ↑ 1.0 6 1

Hash Right Join (cost=1.14..3.06 rows=6 width=1,580) (actual time=0.021..0.047 rows=6 loops=1)

  • Hash Cond: (taskmanage10_.id = tags9_.tag_id)
31. 0.006 0.006 ↑ 1.0 63 1

Seq Scan on task_mgt_tag taskmanage10_ (cost=0.00..1.63 rows=63 width=1,564) (actual time=0.003..0.006 rows=63 loops=1)

32. 0.002 0.005 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=16) (actual time=0.005..0.005 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
33. 0.003 0.003 ↑ 1.0 6 1

Seq Scan on task_mgt_tag_to_action tags9_ (cost=0.00..1.06 rows=6 width=16) (actual time=0.002..0.003 rows=6 loops=1)

34. 0.002 0.045 ↓ 8.0 8 1

Hash (cost=5.42..5.42 rows=1 width=8) (actual time=0.045..0.045 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
35. 0.018 0.043 ↓ 8.0 8 1

Nested Loop (cost=0.00..5.42 rows=1 width=8) (actual time=0.012..0.043 rows=8 loops=1)

  • Join Filter: (projectmem15_.project_id = project16_.id)
  • Rows Removed by Join Filter: 117
36. 0.017 0.017 ↓ 8.0 8 1

Seq Scan on task_mgt_project_member projectmem15_ (cost=0.00..3.30 rows=1 width=8) (actual time=0.009..0.017 rows=8 loops=1)

  • Filter: ((user_id)::text = 'b976d6f8-a036-4898-84ef-b6e33ac4dd98'::text)
  • Rows Removed by Filter: 96
37. 0.008 0.008 ↑ 3.1 16 8

Seq Scan on task_mgt_project project16_ (cost=0.00..1.50 rows=50 width=16) (actual time=0.001..0.001 rows=16 loops=8)

38. 0.005 0.010 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=1,056) (actual time=0.010..0.010 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
39. 0.005 0.005 ↑ 1.0 19 1

Seq Scan on task_mgt_checklist_item checklisti3_ (cost=0.00..1.19 rows=19 width=1,056) (actual time=0.003..0.005 rows=19 loops=1)

40. 0.160 0.256 ↑ 1.0 1,459 1

Hash (cost=22.59..22.59 rows=1,459 width=16) (actual time=0.256..0.256 rows=1,459 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 85kB
41. 0.096 0.096 ↑ 1.0 1,459 1

Seq Scan on task_mgt_tag_to_task tags4_ (cost=0.00..22.59 rows=1,459 width=16) (actual time=0.003..0.096 rows=1,459 loops=1)

42. 0.015 0.089 ↑ 1.0 63 1

Hash (cost=8.04..8.04 rows=63 width=4,692) (actual time=0.089..0.089 rows=63 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
43. 0.020 0.074 ↑ 1.0 63 1

Hash Left Join (cost=4.83..8.04 rows=63 width=4,692) (actual time=0.048..0.074 rows=63 loops=1)

  • Hash Cond: (taskmanage5_.parent_id = taskmanage6_.id)
44. 0.021 0.040 ↑ 1.0 63 1

Hash Right Join (cost=2.42..4.83 rows=63 width=3,128) (actual time=0.028..0.040 rows=63 loops=1)

  • Hash Cond: (children7_.parent_id = taskmanage5_.id)
45. 0.005 0.005 ↑ 1.0 63 1

Seq Scan on task_mgt_tag children7_ (cost=0.00..1.63 rows=63 width=1,564) (actual time=0.002..0.005 rows=63 loops=1)

46. 0.009 0.014 ↑ 1.0 63 1

Hash (cost=1.63..1.63 rows=63 width=1,564) (actual time=0.014..0.014 rows=63 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
47. 0.005 0.005 ↑ 1.0 63 1

Seq Scan on task_mgt_tag taskmanage5_ (cost=0.00..1.63 rows=63 width=1,564) (actual time=0.002..0.005 rows=63 loops=1)

48. 0.009 0.014 ↑ 1.0 63 1

Hash (cost=1.63..1.63 rows=63 width=1,564) (actual time=0.014..0.014 rows=63 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
49. 0.005 0.005 ↑ 1.0 63 1

Seq Scan on task_mgt_tag taskmanage6_ (cost=0.00..1.63 rows=63 width=1,564) (actual time=0.001..0.005 rows=63 loops=1)