explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jNVt

Settings
# exclusive inclusive rows x rows loops node
1. 0.777 354.220 ↓ 603.5 1,207 1

Subquery Scan on res (cost=1,567.84..1,567.87 rows=2 width=854) (actual time=353.353..354.220 rows=1,207 loops=1)

2. 4.450 353.443 ↓ 603.5 1,207 1

Sort (cost=1,567.84..1,567.85 rows=2 width=929) (actual time=353.347..353.443 rows=1,207 loops=1)

  • Sort Key: job.priority_id, job.id DESC
  • Sort Method: quicksort Memory: 1275kB
3. 99.683 348.993 ↓ 603.5 1,207 1

GroupAggregate (cost=1,567.55..1,567.83 rows=2 width=929) (actual time=254.304..348.993 rows=1,207 loops=1)

  • Group Key: job.id, (true), title.id, line_of_business.id, priority.id, client.id, vendor_location.id, release_type.id, client_group.id, job_type.id
4. 9.758 249.310 ↓ 1,221.5 2,443 1

Sort (cost=1,567.55..1,567.55 rows=2 width=2,303) (actual time=248.753..249.310 rows=2,443 loops=1)

  • Sort Key: job.id DESC, (true), title.id, line_of_business.id, priority.id, client.id, vendor_location.id, release_type.id, client_group.id, job_type.id
  • Sort Method: quicksort Memory: 1356kB
5. 4.103 239.552 ↓ 1,221.5 2,443 1

Nested Loop Left Join (cost=1,144.91..1,567.54 rows=2 width=2,303) (actual time=63.155..239.552 rows=2,443 loops=1)

6. 3.268 235.449 ↓ 1,221.5 2,443 1

Nested Loop Left Join (cost=1,144.63..1,559.55 rows=2 width=2,274) (actual time=63.103..235.449 rows=2,443 loops=1)

7. 2.579 227.295 ↓ 1,221.5 2,443 1

Nested Loop Left Join (cost=1,144.35..1,558.96 rows=2 width=2,274) (actual time=63.064..227.295 rows=2,443 loops=1)

8. 6.198 214.944 ↓ 1,221.5 2,443 1

Nested Loop Left Join (cost=1,144.07..1,558.16 rows=2 width=2,274) (actual time=62.222..214.944 rows=2,443 loops=1)

9. 1.965 198.970 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,143.44..1,553.48 rows=1 width=2,282) (actual time=62.170..198.970 rows=1,222 loops=1)

10. 2.115 195.783 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,143.30..1,552.52 rows=1 width=1,766) (actual time=61.274..195.783 rows=1,222 loops=1)

11. 1.910 192.446 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,143.16..1,552.35 rows=1 width=1,758) (actual time=61.173..192.446 rows=1,222 loops=1)

12. 2.023 189.314 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,142.89..1,552.05 rows=1 width=1,751) (actual time=60.299..189.314 rows=1,222 loops=1)

13. 0.930 187.291 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,142.61..1,551.35 rows=1 width=1,743) (actual time=60.258..187.291 rows=1,222 loops=1)

14. 2.101 182.695 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,142.33..1,551.04 rows=1 width=1,735) (actual time=60.205..182.695 rows=1,222 loops=1)

15. 5.569 180.594 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,142.18..1,548.05 rows=1 width=1,723) (actual time=60.174..180.594 rows=1,222 loops=1)

  • Join Filter: (om_job_countries.job_id = job.id)
  • Rows Removed by Join Filter: 12220
16. 2.190 172.581 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,142.18..1,546.83 rows=1 width=1,715) (actual time=60.154..172.581 rows=1,222 loops=1)

17. 6.544 170.391 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,142.04..1,546.66 rows=1 width=1,651) (actual time=60.114..170.391 rows=1,222 loops=1)

  • Join Filter: (om_job_territories.job_id = job.id)
  • Rows Removed by Join Filter: 2444
18. 1.818 152.849 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,141.00..1,544.47 rows=1 width=1,611) (actual time=58.006..152.849 rows=1,222 loops=1)

19. 1.986 151.031 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,140.72..1,540.73 rows=1 width=1,611) (actual time=57.876..151.031 rows=1,222 loops=1)

20. 2.322 146.601 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,140.57..1,540.56 rows=1 width=1,603) (actual time=56.558..146.601 rows=1,222 loops=1)

21. 2.487 141.835 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,140.30..1,540.25 rows=1 width=1,596) (actual time=56.515..141.835 rows=1,222 loops=1)

22. 1.219 136.904 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=1,140.02..1,539.84 rows=1 width=1,588) (actual time=56.487..136.904 rows=1,222 loops=1)

23. 3.007 130.801 ↓ 1,221.0 1,221 1

Nested Loop Left Join (cost=1,139.73..1,539.49 rows=1 width=1,580) (actual time=56.444..130.801 rows=1,221 loops=1)

24. 2.246 124.131 ↓ 1,221.0 1,221 1

Nested Loop Left Join (cost=1,139.45..1,539.08 rows=1 width=1,545) (actual time=56.416..124.131 rows=1,221 loops=1)

  • Filter: (ojrt.skipped IS NOT TRUE)
25. 2.369 118.264 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,139.17..1,538.69 rows=1 width=1,541) (actual time=56.383..118.264 rows=1,207 loops=1)

26. 1.302 114.688 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,139.03..1,538.51 rows=1 width=1,528) (actual time=56.342..114.688 rows=1,207 loops=1)

27. 1.926 110.972 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,138.75..1,538.20 rows=1 width=1,520) (actual time=56.028..110.972 rows=1,207 loops=1)

28. 1.193 109.046 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,138.61..1,538.00 rows=1 width=1,512) (actual time=55.996..109.046 rows=1,207 loops=1)

29. 2.162 105.439 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,138.34..1,537.66 rows=1 width=1,504) (actual time=55.806..105.439 rows=1,207 loops=1)

30. 2.094 102.070 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,138.20..1,537.49 rows=1 width=1,503) (actual time=55.746..102.070 rows=1,207 loops=1)

31. 1.102 98.769 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,138.06..1,537.33 rows=1 width=987) (actual time=55.689..98.769 rows=1,207 loops=1)

32. 1.304 96.460 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,137.92..1,537.17 rows=1 width=972) (actual time=54.796..96.460 rows=1,207 loops=1)

33. 12.208 92.742 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,137.78..1,537.01 rows=1 width=928) (actual time=54.744..92.742 rows=1,207 loops=1)

34. 1.176 78.120 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,137.65..1,536.85 rows=1 width=896) (actual time=54.690..78.120 rows=1,207 loops=1)

35. 1.653 74.530 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,137.52..1,536.69 rows=1 width=380) (actual time=54.636..74.530 rows=1,207 loops=1)

36. 1.369 72.877 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,137.24..1,536.39 rows=1 width=370) (actual time=54.597..72.877 rows=1,207 loops=1)

37. 6.466 67.887 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=1,137.10..1,536.23 rows=1 width=357) (actual time=54.261..67.887 rows=1,207 loops=1)

38. 3.819 59.007 ↓ 1,207.0 1,207 1

Hash Join (cost=1,128.51..1,519.90 rows=1 width=375) (actual time=54.194..59.007 rows=1,207 loops=1)

  • Hash Cond: ((job.title_id)::text = (title.id)::text)
39. 1.271 1.271 ↑ 1.0 4,704 1

Seq Scan on om_jobs job (cost=0.00..379.04 rows=4,704 width=327) (actual time=0.010..1.271 rows=4,704 loops=1)

40. 0.082 53.917 ↓ 5.3 16 1

Hash (cost=1,128.47..1,128.47 rows=3 width=59) (actual time=53.917..53.917 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
41. 53.835 53.835 ↓ 5.3 16 1

Seq Scan on om_titles title (cost=0.00..1,128.47 rows=3 width=59) (actual time=2.141..53.835 rows=16 loops=1)

  • Filter: ((title)::text ~~* '%see%'::text)
  • Rows Removed by Filter: 30102
42. 1.207 2.414 ↓ 0.0 0 1,207

Bitmap Heap Scan on om_titles parent_title (cost=8.59..16.31 rows=2 width=10) (actual time=0.002..0.002 rows=0 loops=1,207)

  • Recheck Cond: (((title.tv_season_id)::text = (id)::text) OR ((title.tv_show_id)::text = (id)::text))
43. 1.207 1.207 ↓ 0.0 0 1,207

BitmapOr (cost=8.59..8.59 rows=2 width=0) (actual time=0.001..0.001 rows=0 loops=1,207)

44. 0.000 0.000 ↓ 0.0 0 1,207

Bitmap Index Scan on om_titles_pkey (cost=0.00..4.29 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=1,207)

  • Index Cond: ((id)::text = (title.tv_season_id)::text)
45. 0.000 0.000 ↓ 0.0 0 1,207

Bitmap Index Scan on om_titles_pkey (cost=0.00..4.29 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=1,207)

  • Index Cond: ((id)::text = (title.tv_show_id)::text)
46. 3.621 3.621 ↑ 1.0 1 1,207

Index Scan using clients_pkey on clients client (cost=0.14..0.16 rows=1 width=21) (actual time=0.003..0.003 rows=1 loops=1,207)

  • Index Cond: (id = job.client_id)
47. 0.000 0.000 ↓ 0.0 0 1,207

Index Scan using vendor_locations_pkey on vendor_locations vendor_location (cost=0.27..0.30 rows=1 width=18) (actual time=0.000..0.000 rows=0 loops=1,207)

  • Index Cond: (id = job.job_office_id)
48. 2.414 2.414 ↑ 1.0 1 1,207

Index Scan using om_release_types_pkey on om_release_types release_type (cost=0.13..0.15 rows=1 width=524) (actual time=0.002..0.002 rows=1 loops=1,207)

  • Index Cond: (id = job.om_release_type_id)
49. 2.414 2.414 ↑ 1.0 1 1,207

Index Scan using line_of_businesses_pkey on line_of_businesses line_of_business (cost=0.14..0.16 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=1,207)

  • Index Cond: (id = job.line_of_business_id)
50. 2.414 2.414 ↑ 1.0 1 1,207

Index Scan using priorities_pkey on priorities priority (cost=0.13..0.15 rows=1 width=44) (actual time=0.002..0.002 rows=1 loops=1,207)

  • Index Cond: (id = job.priority_id)
51. 1.207 1.207 ↓ 0.0 0 1,207

Index Scan using client_teams_pkey on client_teams client_group (cost=0.14..0.16 rows=1 width=23) (actual time=0.001..0.001 rows=0 loops=1,207)

  • Index Cond: (id = job.client_team_id)
52. 1.207 1.207 ↑ 1.0 1 1,207

Index Scan using om_job_types_pkey on om_job_types job_type (cost=0.14..0.16 rows=1 width=524) (actual time=0.001..0.001 rows=1 loops=1,207)

  • Index Cond: (id = job.job_type_id)
53. 1.207 1.207 ↓ 0.0 0 1,207

Index Scan using idx_om_job_bookmarks_job_id on om_job_bookmarks (cost=0.14..0.16 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=1,207)

  • Index Cond: (job_id = job.id)
  • Filter: (user_id = 7496)
54. 2.414 2.414 ↓ 0.0 0 1,207

Index Only Scan using idx_om_jobs_job_tags_job_id_tag_id on om_jobs_job_tags ojjt (cost=0.27..0.31 rows=2 width=16) (actual time=0.002..0.002 rows=0 loops=1,207)

  • Index Cond: (job_id = job.id)
  • Heap Fetches: 3
55. 0.000 0.000 ↓ 0.0 0 1,207

Index Scan using om_job_tags_pkey on om_job_tags (cost=0.14..0.20 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=1,207)

  • Index Cond: (id = ojjt.tag_id)
56. 2.414 2.414 ↓ 0.0 0 1,207

Index Scan using idx_om_jobs_languages_om_job_id on om_jobs_languages ojl (cost=0.28..0.30 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,207)

  • Index Cond: (om_job_id = job.id)
57. 1.207 1.207 ↓ 0.0 0 1,207

Index Scan using languages_pkey on languages (cost=0.14..0.18 rows=1 width=21) (actual time=0.001..0.001 rows=0 loops=1,207)

  • Index Cond: (id = ojl.language_id)
58. 3.621 3.621 ↑ 1.0 1 1,207

Index Scan using idx_om_job_runs_tasks_job_run_id on om_job_runs_tasks ojrt (cost=0.28..0.38 rows=1 width=21) (actual time=0.003..0.003 rows=1 loops=1,207)

  • Index Cond: (job_run_id = job.latest_job_run_id)
59. 3.663 3.663 ↑ 1.0 1 1,221

Index Scan using om_tasks_pkey on om_tasks inner_task (cost=0.28..0.41 rows=1 width=43) (actual time=0.003..0.003 rows=1 loops=1,221)

  • Index Cond: (id = ojrt.task_id)
60. 4.884 4.884 ↑ 1.0 1 1,221

Index Scan using idx_om_jobs_project_managers_job_id on om_jobs_project_managers (cost=0.28..0.33 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=1,221)

  • Index Cond: (job_id = job.id)
61. 2.444 2.444 ↑ 1.0 1 1,222

Index Scan using users_pkey on users (cost=0.28..0.41 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,222)

  • Index Cond: (id = om_jobs_project_managers.user_id)
62. 2.444 2.444 ↑ 1.0 1 1,222

Index Scan using contacts_pkey on contacts (cost=0.28..0.31 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=1,222)

  • Index Cond: (id = users.contact_id)
63. 2.444 2.444 ↓ 0.0 0 1,222

Index Scan using idx_om_jobs_client_managers_job_id on om_jobs_client_managers (cost=0.14..0.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,222)

  • Index Cond: (job_id = job.id)
64. 0.000 0.000 ↓ 0.0 0 1,222

Index Only Scan using users_pkey on users client_users (cost=0.28..3.74 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,222)

  • Index Cond: (id = om_jobs_client_managers.user_id)
  • Heap Fetches: 0
65. 8.517 10.998 ↑ 1.0 2 1,222

Hash Right Join (cost=1.04..2.16 rows=2 width=48) (actual time=0.004..0.009 rows=2 loops=1,222)

  • Hash Cond: (territories.id = om_job_territories.territory_id)
66. 2.444 2.444 ↑ 1.0 7 1,222

Seq Scan on territories (cost=0.00..1.07 rows=7 width=40) (actual time=0.001..0.002 rows=7 loops=1,222)

67. 0.018 0.037 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=16) (actual time=0.037..0.037 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
68. 0.019 0.019 ↑ 1.0 2 1

Seq Scan on om_job_territories (cost=0.00..1.02 rows=2 width=16) (actual time=0.019..0.019 rows=2 loops=1)

69. 0.000 0.000 ↓ 0.0 0 1,222

Index Scan using index_client_contacts_on_user_id on client_contacts (cost=0.14..0.16 rows=1 width=72) (actual time=0.000..0.000 rows=0 loops=1,222)

  • Index Cond: (user_id = client_users.id)
70. 2.444 2.444 ↑ 1.0 10 1,222

Seq Scan on om_job_countries (cost=0.00..1.10 rows=10 width=16) (actual time=0.001..0.002 rows=10 loops=1,222)

71. 0.000 0.000 ↓ 0.0 0 1,222

Index Scan using countries_pkey on countries (cost=0.14..2.96 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=1,222)

  • Index Cond: (id = om_job_countries.country_id)
72. 3.666 3.666 ↓ 0.0 0 1,222

Index Scan using idx_om_task_assignees_task_id on om_task_assignees (cost=0.28..0.30 rows=1 width=16) (actual time=0.002..0.003 rows=0 loops=1,222)

  • Index Cond: (task_id = inner_task.id)
73. 0.000 0.000 ↓ 0.0 0 1,222

Index Scan using users_pkey on users task_assignees_users (cost=0.28..0.70 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=1,222)

  • Index Cond: (id = om_task_assignees.user_id)
74. 1.222 1.222 ↓ 0.0 0 1,222

Index Scan using contacts_pkey on contacts task_assignees_contacts (cost=0.28..0.31 rows=1 width=23) (actual time=0.001..0.001 rows=0 loops=1,222)

  • Index Cond: (id = task_assignees_users.contact_id)
75. 1.222 1.222 ↓ 0.0 0 1,222

Index Only Scan using idx_om_jobs_job_configurations_job_id_config_id on om_jobs_job_configurations ojjc (cost=0.14..0.16 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,222)

  • Index Cond: (job_id = job.id)
  • Heap Fetches: 9
76. 1.222 1.222 ↓ 0.0 0 1,222

Index Scan using om_job_configurations_pkey on om_job_configurations (cost=0.14..0.82 rows=1 width=524) (actual time=0.001..0.001 rows=0 loops=1,222)

  • Index Cond: (id = ojjc.job_configuration_id)
77. 2.444 9.776 ↑ 1.0 2 1,222

Bitmap Heap Scan on om_base_io_requirements base_io_requiement (cost=0.63..4.66 rows=2 width=8) (actual time=0.008..0.008 rows=2 loops=1,222)

  • Recheck Cond: ((id = inner_task.input_requirement_id) OR (id = inner_task.output_requirement_id))
  • Heap Blocks: exact=1233
78. 1.222 7.332 ↓ 0.0 0 1,222

BitmapOr (cost=0.63..0.63 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1,222)

79. 3.666 3.666 ↑ 1.0 1 1,222

Bitmap Index Scan on om_base_io_requirements_pkey (cost=0.00..0.32 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=1,222)

  • Index Cond: (id = inner_task.input_requirement_id)
80. 2.444 2.444 ↑ 1.0 1 1,222

Bitmap Index Scan on om_base_io_requirements_pkey (cost=0.00..0.32 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1,222)

  • Index Cond: (id = inner_task.output_requirement_id)
81. 9.772 9.772 ↑ 1.0 1 2,443

Index Scan using idx_om_requirements_base_io_requirement_id on om_requirements requirement (cost=0.29..0.39 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=2,443)

  • Index Cond: (base_io_requirement_id = base_io_requiement.id)
  • Filter: ((source_io_requirement_id IS NULL) AND ((dtype)::text = 'AssetRequirement'::text))
  • Rows Removed by Filter: 0
82. 4.886 4.886 ↑ 1.0 1 2,443

Index Scan using om_abstract_assets_pkey on om_abstract_assets asset (cost=0.27..0.30 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=2,443)

  • Index Cond: (id = requirement.abstract_asset_id)
83. 0.000 0.000 ↓ 0.0 0 2,443

Index Scan using alphas_pkey on alphas alpha (cost=0.29..4.00 rows=1 width=37) (actual time=0.000..0.000 rows=0 loops=2,443)

  • Index Cond: (id = asset.alpha_id)
Planning time : 188.095 ms
Execution time : 357.733 ms