explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4sX

Settings
# exclusive inclusive rows x rows loops node
1. 0.073 182,218.589 ↓ 100.0 100 1

Limit (cost=39,475.92..39,475.93 rows=1 width=837) (actual time=182,218.507..182,218.589 rows=100 loops=1)

2. 8.539 182,218.516 ↓ 100.0 100 1

Sort (cost=39,475.92..39,475.93 rows=1 width=837) (actual time=182,218.506..182,218.516 rows=100 loops=1)

  • Sort Key: job.priority_id, job.id DESC
  • Sort Method: top-N heapsort Memory: 223kB
3. 516.997 182,209.977 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=37,891.82..39,475.91 rows=1 width=837) (actual time=311.121..182,209.977 rows=1,207 loops=1)

  • Join Filter: (om_jobs.id = job.id)
  • Rows Removed by Join Filter: 2753918
4. 6.347 184.320 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=48.39..459.57 rows=1 width=447) (actual time=3.203..184.320 rows=1,207 loops=1)

  • Join Filter: (job.id = om_job_bookmarks.job_id)
  • Rows Removed by Join Filter: 2414
5. 14.979 165.903 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=48.39..457.94 rows=1 width=446) (actual time=3.190..165.903 rows=1,207 loops=1)

  • Join Filter: (job_type.id = job.job_type_id)
  • Rows Removed by Join Filter: 53031
6. 18.027 143.682 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=48.39..455.92 rows=1 width=428) (actual time=3.176..143.682 rows=1,207 loops=1)

  • Join Filter: (job.client_team_id = client_group.id)
  • Rows Removed by Join Filter: 76041
7. 7.186 115.999 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=48.39..453.51 rows=1 width=413) (actual time=3.156..115.999 rows=1,207 loops=1)

  • Join Filter: (job.priority_id = priority.id)
  • Rows Removed by Join Filter: 10
8. 6.703 107.606 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=48.39..452.39 rows=1 width=394) (actual time=3.150..107.606 rows=1,207 loops=1)

  • Join Filter: (job.line_of_business_id = line_of_business.id)
  • Rows Removed by Join Filter: 1205
9. 8.949 98.489 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=48.39..451.08 rows=1 width=380) (actual time=3.143..98.489 rows=1,207 loops=1)

  • Join Filter: (job.om_release_type_id = release_type.id)
  • Rows Removed by Join Filter: 1220
10. 4.940 87.126 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=48.39..449.94 rows=1 width=372) (actual time=3.136..87.126 rows=1,207 loops=1)

11. 18.175 80.979 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=48.12..449.64 rows=1 width=362) (actual time=3.125..80.979 rows=1,207 loops=1)

  • Join Filter: (job.client_id = client.id)
  • Rows Removed by Join Filter: 65178
12. 21.992 50.734 ↓ 1,207.0 1,207 1

Nested Loop Left Join (cost=48.12..447.25 rows=1 width=349) (actual time=3.106..50.734 rows=1,207 loops=1)

13. 10.242 17.879 ↓ 1,207.0 1,207 1

Hash Join (cost=39.53..430.92 rows=1 width=367) (actual time=3.091..17.879 rows=1,207 loops=1)

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

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

15. 0.012 2.937 ↓ 1.3 4 1

Hash (cost=39.49..39.49 rows=3 width=59) (actual time=2.937..2.937 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.034 2.925 ↓ 1.3 4 1

Bitmap Heap Scan on om_titles title (cost=28.02..39.49 rows=3 width=59) (actual time=2.906..2.925 rows=4 loops=1)

  • Recheck Cond: ((title)::text ~~* 'see%'::text)
  • Rows Removed by Index Recheck: 9
  • Heap Blocks: exact=13
17. 2.891 2.891 ↓ 4.3 13 1

Bitmap Index Scan on index_titles_title (cost=0.00..28.02 rows=3 width=0) (actual time=2.891..2.891 rows=13 loops=1)

  • Index Cond: ((title)::text ~~* 'see%'::text)
18. 3.621 10.863 ↓ 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.009..0.009 rows=0 loops=1,207)

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

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

20. 2.414 2.414 ↓ 0.0 0 1,207

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

  • Index Cond: ((id)::text = (title.tv_season_id)::text)
21. 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)
22. 12.070 12.070 ↑ 1.1 55 1,207

Seq Scan on clients client (cost=0.00..1.62 rows=62 width=21) (actual time=0.006..0.010 rows=55 loops=1,207)

23. 1.207 1.207 ↓ 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.001..0.001 rows=0 loops=1,207)

  • Index Cond: (id = job.job_office_id)
24. 2.414 2.414 ↑ 3.0 2 1,207

Seq Scan on om_release_types release_type (cost=0.00..1.06 rows=6 width=16) (actual time=0.002..0.002 rows=2 loops=1,207)

25. 2.414 2.414 ↑ 7.0 2 1,207

Seq Scan on line_of_businesses line_of_business (cost=0.00..1.14 rows=14 width=22) (actual time=0.001..0.002 rows=2 loops=1,207)

26. 1.207 1.207 ↑ 5.0 1 1,207

Seq Scan on priorities priority (cost=0.00..1.05 rows=5 width=19) (actual time=0.001..0.001 rows=1 loops=1,207)

27. 9.656 9.656 ↑ 1.0 63 1,207

Seq Scan on client_teams client_group (cost=0.00..1.63 rows=63 width=23) (actual time=0.002..0.008 rows=63 loops=1,207)

28. 7.242 7.242 ↑ 1.0 45 1,207

Seq Scan on om_job_types job_type (cost=0.00..1.45 rows=45 width=26) (actual time=0.002..0.006 rows=45 loops=1,207)

29. 12.070 12.070 ↑ 1.0 2 1,207

Seq Scan on om_job_bookmarks (cost=0.00..1.61 rows=2 width=9) (actual time=0.004..0.010 rows=2 loops=1,207)

  • Filter: (user_id = 7496)
  • Rows Removed by Filter: 47
30. 171,933.529 181,508.660 ↑ 2.1 2,283 1,207

GroupAggregate (cost=37,843.42..38,910.47 rows=4,704 width=712) (actual time=0.526..150.380 rows=2,283 loops=1,207)

  • Group Key: om_jobs.id
31. 6,935.422 9,575.131 ↑ 1.4 10,146 1,207

Merge Left Join (cost=37,843.42..37,913.57 rows=13,871 width=241) (actual time=0.176..7.933 rows=10,146 loops=1,207)

  • Merge Cond: (om_jobs.id = ojjc.job_id)
32. 2,257.614 2,455.038 ↑ 1.4 9,708 1,207

Sort (cost=37,840.60..37,875.27 rows=13,871 width=226) (actual time=0.174..2.034 rows=9,708 loops=1,207)

  • Sort Key: om_jobs.id
  • Sort Method: quicksort Memory: 3684kB
33. 5.057 197.424 ↓ 1.3 17,801 1

Hash Left Join (cost=36,149.52..36,886.29 rows=13,871 width=226) (actual time=170.226..197.424 rows=17,801 loops=1)

  • Hash Cond: (asset.alpha_id = alpha.id)
34. 4.943 173.731 ↓ 1.3 17,801 1

Hash Left Join (cost=34,811.38..35,511.74 rows=13,871 width=197) (actual time=151.354..173.731 rows=17,801 loops=1)

  • Hash Cond: (requirement.abstract_asset_id = asset.id)
35. 5.495 168.597 ↓ 1.3 17,801 1

Hash Left Join (cost=34,794.92..35,458.60 rows=13,871 width=197) (actual time=151.142..168.597 rows=17,801 loops=1)

  • Hash Cond: (inner_task.id = om_task_assignees.task_id)
36. 9.515 134.976 ↓ 1.3 17,474 1

Hash Right Join (cost=34,498.92..34,927.65 rows=13,871 width=174) (actual time=122.909..134.976 rows=17,474 loops=1)

  • Hash Cond: (requirement.base_io_requirement_id = base_io_requiement.id)
37. 2.671 2.671 ↑ 1.0 7,051 1

Seq Scan on om_requirements requirement (cost=0.00..328.52 rows=7,286 width=16) (actual time=0.033..2.671 rows=7,051 loops=1)

  • Filter: ((source_io_requirement_id IS NULL) AND ((dtype)::text = 'AssetRequirement'::text))
  • Rows Removed by Filter: 4271
38. 11.060 122.790 ↓ 1.1 15,905 1

Hash (cost=34,325.53..34,325.53 rows=13,871 width=174) (actual time=122.790..122.790 rows=15,905 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 2126kB
39. 18.070 111.730 ↓ 1.1 15,905 1

Nested Loop Left Join (cost=1,416.34..34,325.53 rows=13,871 width=174) (actual time=17.510..111.730 rows=15,905 loops=1)

40. 7.011 53.895 ↓ 1.1 7,953 1

Hash Left Join (cost=1,415.71..1,849.59 rows=6,936 width=182) (actual time=17.487..53.895 rows=7,953 loops=1)

  • Hash Cond: (om_jobs.id = om_job_countries.job_id)
41. 3.307 46.822 ↓ 1.1 7,788 1

Hash Left Join (cost=1,412.33..1,768.03 rows=6,936 width=162) (actual time=17.417..46.822 rows=7,788 loops=1)

  • Hash Cond: (users.contact_id = contacts.id)
42. 3.307 43.147 ↓ 1.1 7,788 1

Hash Left Join (cost=1,386.24..1,723.73 rows=6,936 width=155) (actual time=17.041..43.147 rows=7,788 loops=1)

  • Hash Cond: (om_jobs_project_managers.user_id = users.id)
43. 3.074 38.019 ↓ 1.1 7,788 1

Hash Left Join (cost=1,161.57..1,480.84 rows=6,936 width=147) (actual time=15.181..38.019 rows=7,788 loops=1)

  • Hash Cond: (om_jobs.id = om_job_territories.job_id)
44. 2.582 34.920 ↓ 1.1 7,788 1

Hash Left Join (cost=1,159.38..1,452.60 rows=6,936 width=126) (actual time=15.151..34.920 rows=7,788 loops=1)

  • Hash Cond: (om_jobs.id = om_jobs_client_managers.job_id)
45. 4.481 32.118 ↓ 1.1 7,667 1

Hash Left Join (cost=1,063.75..1,320.83 rows=6,936 width=100) (actual time=14.923..32.118 rows=7,667 loops=1)

  • Hash Cond: (ojrt.task_id = inner_task.id)
46. 11.538 23.472 ↓ 1.1 7,667 1

Hash Right Join (cost=729.01..967.87 rows=6,936 width=65) (actual time=10.713..23.472 rows=7,667 loops=1)

  • Hash Cond: (ojrt.job_run_id = om_jobs.latest_job_run_id)
  • Filter: (ojrt.skipped IS NOT TRUE)
  • Rows Removed by Filter: 10
47. 1.249 1.249 ↑ 1.0 7,005 1

Seq Scan on om_job_runs_tasks ojrt (cost=0.00..143.05 rows=7,005 width=21) (actual time=0.009..1.249 rows=7,005 loops=1)

48. 1.475 10.685 ↓ 1.0 4,930 1

Hash (cost=669.83..669.83 rows=4,734 width=61) (actual time=10.685..10.685 rows=4,930 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 353kB
49. 0.957 9.210 ↓ 1.0 4,930 1

Hash Left Join (cost=478.68..669.83 rows=4,734 width=61) (actual time=4.802..9.210 rows=4,930 loops=1)

  • Hash Cond: (om_jobs.id = ojjt.job_id)
50. 1.165 7.908 ↓ 1.0 4,758 1

Hash Left Join (cost=465.91..606.64 rows=4,734 width=45) (actual time=4.451..7.908 rows=4,758 loops=1)

  • Hash Cond: (om_jobs.id = ojl.om_job_id)
51. 1.824 5.967 ↑ 1.0 4,734 1

Hash Right Join (cost=437.84..523.62 rows=4,734 width=24) (actual time=3.664..5.967 rows=4,734 loops=1)

  • Hash Cond: (om_jobs_project_managers.job_id = om_jobs.id)
52. 0.535 0.535 ↑ 1.0 4,734 1

Seq Scan on om_jobs_project_managers (cost=0.00..73.34 rows=4,734 width=16) (actual time=0.017..0.535 rows=4,734 loops=1)

53. 1.319 3.608 ↑ 1.0 4,704 1

Hash (cost=379.04..379.04 rows=4,704 width=16) (actual time=3.608..3.608 rows=4,704 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 285kB
54. 2.289 2.289 ↑ 1.0 4,704 1

Seq Scan on om_jobs (cost=0.00..379.04 rows=4,704 width=16) (actual time=0.004..2.289 rows=4,704 loops=1)

55. 0.254 0.776 ↑ 1.0 756 1

Hash (cost=18.62..18.62 rows=756 width=29) (actual time=0.776..0.776 rows=756 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 50kB
56. 0.333 0.522 ↑ 1.0 756 1

Hash Left Join (cost=3.98..18.62 rows=756 width=29) (actual time=0.101..0.522 rows=756 loops=1)

  • Hash Cond: (ojl.language_id = languages.id)
57. 0.109 0.109 ↑ 1.0 756 1

Seq Scan on om_jobs_languages ojl (cost=0.00..12.56 rows=756 width=16) (actual time=0.013..0.109 rows=756 loops=1)

58. 0.045 0.080 ↑ 1.0 88 1

Hash (cost=2.88..2.88 rows=88 width=21) (actual time=0.079..0.080 rows=88 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
59. 0.035 0.035 ↑ 1.0 88 1

Seq Scan on languages (cost=0.00..2.88 rows=88 width=21) (actual time=0.008..0.035 rows=88 loops=1)

60. 0.093 0.345 ↑ 1.0 306 1

Hash (cost=8.94..8.94 rows=306 width=24) (actual time=0.344..0.345 rows=306 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
61. 0.145 0.252 ↑ 1.0 306 1

Hash Left Join (cost=3.05..8.94 rows=306 width=24) (actual time=0.073..0.252 rows=306 loops=1)

  • Hash Cond: (ojjt.tag_id = om_job_tags.id)
62. 0.045 0.045 ↑ 1.0 306 1

Seq Scan on om_jobs_job_tags ojjt (cost=0.00..5.06 rows=306 width=16) (actual time=0.007..0.045 rows=306 loops=1)

63. 0.035 0.062 ↑ 1.0 91 1

Hash (cost=1.91..1.91 rows=91 width=16) (actual time=0.061..0.062 rows=91 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
64. 0.027 0.027 ↑ 1.0 91 1

Seq Scan on om_job_tags (cost=0.00..1.91 rows=91 width=16) (actual time=0.006..0.027 rows=91 loops=1)

65. 2.014 4.165 ↑ 1.0 6,922 1

Hash (cost=248.22..248.22 rows=6,922 width=43) (actual time=4.165..4.165 rows=6,922 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 606kB
66. 2.151 2.151 ↑ 1.0 6,922 1

Seq Scan on om_tasks inner_task (cost=0.00..248.22 rows=6,922 width=43) (actual time=0.005..2.151 rows=6,922 loops=1)

67. 0.026 0.220 ↑ 1.0 100 1

Hash (cost=94.38..94.38 rows=100 width=34) (actual time=0.219..0.220 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
68. 0.030 0.194 ↑ 1.0 100 1

Hash Left Join (cost=2.27..94.38 rows=100 width=34) (actual time=0.049..0.194 rows=100 loops=1)

  • Hash Cond: (client_users.id = client_contacts.user_id)
69. 0.025 0.140 ↑ 1.0 100 1

Nested Loop Left Join (cost=0.28..92.00 rows=100 width=16) (actual time=0.019..0.140 rows=100 loops=1)

70. 0.015 0.015 ↑ 1.0 100 1

Seq Scan on om_jobs_client_managers (cost=0.00..2.00 rows=100 width=16) (actual time=0.007..0.015 rows=100 loops=1)

71. 0.100 0.100 ↑ 1.0 1 100

Index Only Scan using users_pkey on users client_users (cost=0.28..0.90 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=100)

  • Index Cond: (id = om_jobs_client_managers.user_id)
  • Heap Fetches: 0
72. 0.012 0.024 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=26) (actual time=0.024..0.024 rows=44 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
73. 0.012 0.012 ↑ 1.0 44 1

Seq Scan on client_contacts (cost=0.00..1.44 rows=44 width=26) (actual time=0.005..0.012 rows=44 loops=1)

74. 0.004 0.025 ↑ 1.0 2 1

Hash (cost=2.17..2.17 rows=2 width=29) (actual time=0.024..0.025 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
75. 0.008 0.021 ↑ 1.0 2 1

Hash Right Join (cost=1.04..2.17 rows=2 width=29) (actual time=0.017..0.021 rows=2 loops=1)

  • Hash Cond: (territories.id = om_job_territories.territory_id)
76. 0.004 0.004 ↑ 1.0 7 1

Seq Scan on territories (cost=0.00..1.07 rows=7 width=21) (actual time=0.003..0.004 rows=7 loops=1)

77. 0.005 0.009 ↑ 1.0 2 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
78. 0.004 0.004 ↑ 1.0 2 1

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

79. 0.795 1.821 ↑ 1.0 4,741 1

Hash (cost=165.41..165.41 rows=4,741 width=16) (actual time=1.821..1.821 rows=4,741 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 253kB
80. 1.026 1.026 ↑ 1.0 4,741 1

Seq Scan on users (cost=0.00..165.41 rows=4,741 width=16) (actual time=0.004..1.026 rows=4,741 loops=1)

81. 0.206 0.368 ↑ 1.0 626 1

Hash (cost=18.26..18.26 rows=626 width=23) (actual time=0.368..0.368 rows=626 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
82. 0.162 0.162 ↑ 1.0 626 1

Seq Scan on contacts (cost=0.00..18.26 rows=626 width=23) (actual time=0.006..0.162 rows=626 loops=1)

83. 0.009 0.062 ↑ 1.0 10 1

Hash (cost=3.25..3.25 rows=10 width=28) (actual time=0.062..0.062 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
84. 0.012 0.053 ↑ 1.0 10 1

Merge Right Join (cost=1.65..3.25 rows=10 width=28) (actual time=0.036..0.053 rows=10 loops=1)

  • Merge Cond: (countries.id = om_job_countries.country_id)
85. 0.023 0.023 ↑ 15.8 16 1

Index Scan using countries_pkey on countries (cost=0.14..29.94 rows=252 width=20) (actual time=0.011..0.023 rows=16 loops=1)

86. 0.011 0.018 ↑ 1.0 10 1

Sort (cost=1.27..1.29 rows=10 width=16) (actual time=0.016..0.018 rows=10 loops=1)

  • Sort Key: om_job_countries.country_id
  • Sort Method: quicksort Memory: 25kB
87. 0.007 0.007 ↑ 1.0 10 1

Seq Scan on om_job_countries (cost=0.00..1.10 rows=10 width=16) (actual time=0.005..0.007 rows=10 loops=1)

88. 15.906 39.765 ↑ 1.0 2 7,953

Bitmap Heap Scan on om_base_io_requirements base_io_requiement (cost=0.63..4.66 rows=2 width=8) (actual time=0.004..0.005 rows=2 loops=7,953)

  • Recheck Cond: ((id = inner_task.input_requirement_id) OR (id = inner_task.output_requirement_id))
  • Heap Blocks: exact=8051
89. 0.000 23.859 ↓ 0.0 0 7,953

BitmapOr (cost=0.63..0.63 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=7,953)

90. 15.906 15.906 ↑ 1.0 1 7,953

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=7,953)

  • Index Cond: (id = inner_task.input_requirement_id)
91. 7.953 7.953 ↑ 1.0 1 7,953

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=7,953)

  • Index Cond: (id = inner_task.output_requirement_id)
92. 0.384 28.126 ↑ 1.0 1,342 1

Hash (cost=279.22..279.22 rows=1,342 width=31) (actual time=28.125..28.126 rows=1,342 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 97kB
93. 0.375 27.742 ↑ 1.0 1,342 1

Hash Left Join (cost=250.76..279.22 rows=1,342 width=31) (actual time=26.909..27.742 rows=1,342 loops=1)

  • Hash Cond: (task_assignees_users.contact_id = task_assignees_contacts.id)
94. 5.664 27.029 ↑ 1.0 1,342 1

Hash Left Join (cost=224.67..249.62 rows=1,342 width=24) (actual time=26.543..27.029 rows=1,342 loops=1)

  • Hash Cond: (om_task_assignees.user_id = task_assignees_users.id)
95. 0.221 0.221 ↑ 1.0 1,342 1

Seq Scan on om_task_assignees (cost=0.00..21.42 rows=1,342 width=16) (actual time=0.080..0.221 rows=1,342 loops=1)

96. 18.575 21.144 ↑ 1.0 4,741 1

Hash (cost=165.41..165.41 rows=4,741 width=16) (actual time=21.143..21.144 rows=4,741 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 253kB
97. 2.569 2.569 ↑ 1.0 4,741 1

Seq Scan on users task_assignees_users (cost=0.00..165.41 rows=4,741 width=16) (actual time=0.030..2.569 rows=4,741 loops=1)

98. 0.151 0.338 ↑ 1.0 626 1

Hash (cost=18.26..18.26 rows=626 width=23) (actual time=0.338..0.338 rows=626 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
99. 0.187 0.187 ↑ 1.0 626 1

Seq Scan on contacts task_assignees_contacts (cost=0.00..18.26 rows=626 width=23) (actual time=0.029..0.187 rows=626 loops=1)

100. 0.086 0.191 ↑ 1.0 465 1

Hash (cost=10.65..10.65 rows=465 width=16) (actual time=0.191..0.191 rows=465 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
101. 0.105 0.105 ↑ 1.0 465 1

Seq Scan on om_abstract_assets asset (cost=0.00..10.65 rows=465 width=16) (actual time=0.015..0.105 rows=465 loops=1)

102. 9.540 18.636 ↑ 1.0 30,806 1

Hash (cost=953.06..953.06 rows=30,806 width=37) (actual time=18.635..18.636 rows=30,806 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2350kB
103. 9.096 9.096 ↑ 1.0 30,806 1

Seq Scan on alphas alpha (cost=0.00..953.06 rows=30,806 width=37) (actual time=0.022..9.096 rows=30,806 loops=1)

104. 184.627 184.671 ↓ 70.4 1,268 1,207

Sort (cost=2.83..2.87 rows=18 width=23) (actual time=0.000..0.153 rows=1,268 loops=1,207)

  • Sort Key: ojjc.job_id
  • Sort Method: quicksort Memory: 26kB
105. 0.013 0.044 ↑ 1.0 18 1

Hash Left Join (cost=1.20..2.45 rows=18 width=23) (actual time=0.036..0.044 rows=18 loops=1)

  • Hash Cond: (ojjc.job_configuration_id = om_job_configurations.id)
106. 0.017 0.017 ↑ 1.0 18 1

Seq Scan on om_jobs_job_configurations ojjc (cost=0.00..1.18 rows=18 width=16) (actual time=0.015..0.017 rows=18 loops=1)

107. 0.005 0.014 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=15) (actual time=0.014..0.014 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
108. 0.009 0.009 ↑ 1.0 9 1

Seq Scan on om_job_configurations (cost=0.00..1.09 rows=9 width=15) (actual time=0.007..0.009 rows=9 loops=1)

Planning time : 21.750 ms
Execution time : 182,221.563 ms