explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HMZV

Settings
# exclusive inclusive rows x rows loops node
1. 3.120 294.845 ↓ 603.5 1,207 1

Sort (cost=462.88..462.88 rows=2 width=929) (actual time=294.762..294.845 rows=1,207 loops=1)

  • Sort Key: job.priority_id, job.id DESC
  • Sort Method: quicksort Memory: 1275kB
2. 45.341 291.725 ↓ 603.5 1,207 1

GroupAggregate (cost=462.58..462.87 rows=2 width=929) (actual time=246.291..291.725 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
3. 8.500 246.384 ↓ 1,221.5 2,443 1

Sort (cost=462.58..462.59 rows=2 width=2,303) (actual time=245.965..246.384 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
4. 3.125 237.884 ↓ 1,221.5 2,443 1

Nested Loop Left Join (cost=38.88..462.57 rows=2 width=2,303) (actual time=0.647..237.884 rows=2,443 loops=1)

5. 5.114 234.759 ↓ 1,221.5 2,443 1

Nested Loop Left Join (cost=38.60..454.58 rows=2 width=2,274) (actual time=0.637..234.759 rows=2,443 loops=1)

6. 10.366 224.759 ↓ 1,221.5 2,443 1

Nested Loop Left Join (cost=38.32..453.99 rows=2 width=2,274) (actual time=0.629..224.759 rows=2,443 loops=1)

7. 6.272 194.849 ↓ 1,221.5 2,443 1

Nested Loop Left Join (cost=38.04..453.19 rows=2 width=2,274) (actual time=0.617..194.849 rows=2,443 loops=1)

8. 2.321 176.357 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=37.41..448.51 rows=1 width=2,282) (actual time=0.604..176.357 rows=1,222 loops=1)

9. 3.080 167.926 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=37.27..447.55 rows=1 width=1,766) (actual time=0.591..167.926 rows=1,222 loops=1)

10. 1.861 163.624 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=37.13..447.39 rows=1 width=1,758) (actual time=0.577..163.624 rows=1,222 loops=1)

11. 2.181 161.763 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=36.86..447.08 rows=1 width=1,751) (actual time=0.568..161.763 rows=1,222 loops=1)

12. 4.901 159.582 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=36.58..446.38 rows=1 width=1,743) (actual time=0.559..159.582 rows=1,222 loops=1)

13. 2.159 152.237 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=36.30..446.07 rows=1 width=1,735) (actual time=0.548..152.237 rows=1,222 loops=1)

14. 4.516 150.078 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=36.15..443.09 rows=1 width=1,723) (actual time=0.540..150.078 rows=1,222 loops=1)

  • Join Filter: (om_job_countries.job_id = job.id)
  • Rows Removed by Join Filter: 12220
15. 3.797 143.118 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=36.15..441.86 rows=1 width=1,715) (actual time=0.530..143.118 rows=1,222 loops=1)

  • Join Filter: (territories.id = om_job_territories.territory_id)
  • Rows Removed by Join Filter: 8554
16. 5.432 136.877 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=36.15..440.70 rows=1 width=1,683) (actual time=0.520..136.877 rows=1,222 loops=1)

  • Join Filter: (om_job_territories.job_id = job.id)
  • Rows Removed by Join Filter: 2444
17. 1.860 129.001 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=36.15..439.66 rows=1 width=1,675) (actual time=0.510..129.001 rows=1,222 loops=1)

18. 1.891 127.141 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=36.01..439.49 rows=1 width=1,611) (actual time=0.501..127.141 rows=1,222 loops=1)

19. 1.871 125.250 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=35.73..435.75 rows=1 width=1,611) (actual time=0.491..125.250 rows=1,222 loops=1)

20. 6.513 122.157 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=35.59..435.57 rows=1 width=1,603) (actual time=0.479..122.157 rows=1,222 loops=1)

21. 2.727 108.312 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=35.31..435.27 rows=1 width=1,596) (actual time=0.467..108.312 rows=1,222 loops=1)

22. 2.189 103.141 ↓ 1,222.0 1,222 1

Nested Loop Left Join (cost=35.03..434.86 rows=1 width=1,588) (actual time=0.455..103.141 rows=1,222 loops=1)

23. 3.142 97.289 ↓ 1,221.0 1,221 1

Nested Loop Left Join (cost=34.75..434.51 rows=1 width=1,580) (actual time=0.443..97.289 rows=1,221 loops=1)

24. 2.156 81.937 ↓ 1,221.0 1,221 1

Nested Loop Left Join (cost=34.47..434.10 rows=1 width=1,545) (actual time=0.430..81.937 rows=1,221 loops=1)

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

Nested Loop Left Join (cost=34.18..433.71 rows=1 width=1,541) (actual time=0.416..68.918 rows=1,207 loops=1)

26. 1.257 66.793 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=34.04..433.52 rows=1 width=1,528) (actual time=0.408..66.793 rows=1,207 loops=1)

27. 1.887 63.122 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=33.77..433.21 rows=1 width=1,520) (actual time=0.397..63.122 rows=1,207 loops=1)

28. 1.187 61.235 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=33.62..433.01 rows=1 width=1,512) (actual time=0.386..61.235 rows=1,207 loops=1)

29. 1.190 57.634 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=33.35..432.68 rows=1 width=1,504) (actual time=0.372..57.634 rows=1,207 loops=1)

30. 3.028 54.030 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=33.21..432.51 rows=1 width=1,503) (actual time=0.361..54.030 rows=1,207 loops=1)

31. 1.661 48.588 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=33.07..432.35 rows=1 width=987) (actual time=0.351..48.588 rows=1,207 loops=1)

32. 1.351 46.927 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=32.93..432.19 rows=1 width=972) (actual time=0.343..46.927 rows=1,207 loops=1)

33. 6.446 43.162 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=32.80..432.03 rows=1 width=928) (actual time=0.333..43.162 rows=1,207 loops=1)

34. 1.503 34.302 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=32.66..431.87 rows=1 width=896) (actual time=0.294..34.302 rows=1,207 loops=1)

35. 4.365 30.385 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=32.53..431.71 rows=1 width=380) (actual time=0.284..30.385 rows=1,207 loops=1)

36. 2.516 26.020 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=32.26..431.41 rows=1 width=370) (actual time=0.272..26.020 rows=1,207 loops=1)

37. 5.607 21.090 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=32.12..431.25 rows=1 width=357) (actual time=0.260..21.090 rows=1,207 loops=1)

38. 11.859 13.069 ↓ 1,207.0 1,207 1

Hash Join (cost=23.53..414.92 rows=1 width=375) (actual time=0.249..13.069 rows=1,207 loops=1)

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

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

40. 0.008 0.098 ↓ 5.3 16 1

Hash (cost=23.49..23.49 rows=3 width=59) (actual time=0.098..0.098 rows=16 loops=1)

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

Bitmap Heap Scan on om_titles title (cost=12.02..23.49 rows=3 width=59) (actual time=0.058..0.090 rows=16 loops=1)

  • Recheck Cond: ((title)::text ~~* '%see%'::text)
  • Heap Blocks: exact=16
42. 0.047 0.047 ↓ 5.3 16 1

Bitmap Index Scan on index_titles_title (cost=0.00..12.02 rows=3 width=0) (actual time=0.047..0.047 rows=16 loops=1)

  • Index Cond: ((title)::text ~~* '%see%'::text)
43. 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))
44. 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)

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_season_id)::text)
46. 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)
47. 2.414 2.414 ↑ 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.002..0.002 rows=1 loops=1,207)

  • Index Cond: (id = job.client_id)
48. 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)
49. 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)
50. 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)
51. 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)
52. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=1,207)

  • Index Cond: (id = job.client_team_id)
53. 2.414 2.414 ↑ 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.002..0.002 rows=1 loops=1,207)

  • Index Cond: (id = job.job_type_id)
54. 2.414 2.414 ↓ 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.002..0.002 rows=0 loops=1,207)

  • Index Cond: (job_id = job.id)
  • Filter: (user_id = 7496)
55. 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
56. 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)
57. 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)
58. 0.000 0.000 ↓ 0.0 0 1,207

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

  • Index Cond: (id = ojl.language_id)
59. 10.863 10.863 ↑ 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.009..0.009 rows=1 loops=1,207)

  • Index Cond: (job_run_id = job.latest_job_run_id)
60. 12.210 12.210 ↑ 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.010..0.010 rows=1 loops=1,221)

  • Index Cond: (id = ojrt.task_id)
61. 3.663 3.663 ↑ 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.003 rows=1 loops=1,221)

  • Index Cond: (job_id = job.id)
62. 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)
63. 7.332 7.332 ↑ 1.0 1 1,222

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

  • Index Cond: (id = users.contact_id)
64. 1.222 1.222 ↓ 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.001..0.001 rows=0 loops=1,222)

  • Index Cond: (job_id = job.id)
65. 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
66. 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)
67. 2.444 2.444 ↑ 1.0 2 1,222

Seq Scan on om_job_territories (cost=0.00..1.02 rows=2 width=16) (actual time=0.001..0.002 rows=2 loops=1,222)

68. 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)

69. 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)

70. 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)
71. 2.444 2.444 ↓ 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.002 rows=0 loops=1,222)

  • Index Cond: (task_id = inner_task.id)
72. 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)
73. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=1,222)

  • Index Cond: (id = task_assignees_users.contact_id)
74. 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
75. 6.110 6.110 ↓ 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.005..0.005 rows=0 loops=1,222)

  • Index Cond: (id = ojjc.job_configuration_id)
76. 2.444 12.220 ↑ 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.010..0.010 rows=2 loops=1,222)

  • Recheck Cond: ((id = inner_task.input_requirement_id) OR (id = inner_task.output_requirement_id))
  • Heap Blocks: exact=1233
77. 4.888 9.776 ↓ 0.0 0 1,222

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

78. 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)
79. 1.222 1.222 ↑ 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.001..0.001 rows=1 loops=1,222)

  • Index Cond: (id = inner_task.output_requirement_id)
80. 19.544 19.544 ↑ 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.008..0.008 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
81. 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)
82. 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 : 56.947 ms
Execution time : 296.351 ms