explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dqlT

Settings
# exclusive inclusive rows x rows loops node
1. 0.279 16,419.805 ↑ 1.0 100 1

Limit (cost=11,549,515.82..11,549,516.07 rows=100 width=534) (actual time=16,419.507..16,419.805 rows=100 loops=1)

2. 53.786 16,419.526 ↑ 643.6 100 1

Sort (cost=11,549,515.82..11,549,676.73 rows=64,365 width=534) (actual time=16,419.505..16,419.526 rows=100 loops=1)

  • Sort Key: job.actual_due_date, job.priority_id, job.id DESC
  • Sort Method: top-N heapsort Memory: 229kB
3. 1,025.987 16,365.740 ↑ 1.0 64,199 1

WindowAgg (cost=369,630.43..11,547,055.84 rows=64,365 width=534) (actual time=15,480.203..16,365.740 rows=64,199 loops=1)

4. 52.515 15,339.753 ↑ 1.0 64,199 1

Nested Loop Left Join (cost=369,630.43..11,544,803.06 rows=64,365 width=1,495) (actual time=13,390.811..15,339.753 rows=64,199 loops=1)

5. 81.518 15,223.039 ↑ 1.0 64,199 1

Nested Loop Left Join (cost=369,630.28..11,526,571.95 rows=64,365 width=1,494) (actual time=13,390.801..15,223.039 rows=64,199 loops=1)

6. 106.100 14,948.924 ↑ 1.0 64,199 1

Nested Loop Left Join (cost=369,551.92..6,480,871.35 rows=64,365 width=1,494) (actual time=13,390.775..14,948.924 rows=64,199 loops=1)

7. 117.553 14,200.834 ↑ 1.0 64,199 1

Hash Left Join (cost=369,457.53..403,401.95 rows=64,365 width=1,494) (actual time=13,390.275..14,200.834 rows=64,199 loops=1)

  • Hash Cond: (job.id = client_managers_group.job_id)
8. 134.220 13,459.708 ↑ 1.0 64,199 1

Hash Left Join (cost=362,647.69..396,423.14 rows=64,365 width=1,462) (actual time=12,766.666..13,459.708 rows=64,199 loops=1)

  • Hash Cond: (job.id = project_managers_group.job_id)
9. 42.930 12,360.134 ↑ 1.0 64,199 1

Hash Left Join (cost=356,136.31..389,742.79 rows=64,365 width=1,430) (actual time=11,801.174..12,360.134 rows=64,199 loops=1)

  • Hash Cond: (job.job_type_id = job_type.id)
10. 83.704 12,317.172 ↑ 1.0 64,199 1

Hash Left Join (cost=356,123.16..389,556.17 rows=64,365 width=914) (actual time=11,801.128..12,317.172 rows=64,199 loops=1)

  • Hash Cond: (job.id = job_alphas.job_id)
11. 100.797 4,161.581 ↑ 1.0 64,199 1

Hash Left Join (cost=48,716.78..67,145.82 rows=64,365 width=882) (actual time=3,729.150..4,161.581 rows=64,199 loops=1)

  • Hash Cond: (job.id = job_assignees.job_id)
12. 41.050 353.071 ↑ 1.0 64,199 1

Hash Left Join (cost=1,498.23..5,526.29 rows=64,365 width=850) (actual time=21.337..353.071 rows=64,199 loops=1)

  • Hash Cond: (job.client_team_id = client_group.id)
13. 43.293 311.979 ↑ 1.0 64,199 1

Hash Left Join (cost=1,495.85..5,353.58 rows=64,365 width=835) (actual time=21.288..311.979 rows=64,199 loops=1)

  • Hash Cond: (job.priority_id = priority.id)
14. 40.418 268.677 ↑ 1.0 64,199 1

Hash Left Join (cost=1,465.15..5,153.15 rows=64,365 width=791) (actual time=21.273..268.677 rows=64,199 loops=1)

  • Hash Cond: (job.line_of_business_id = line_of_business.id)
15. 41.239 228.245 ↑ 1.0 64,199 1

Hash Left Join (cost=1,433.33..4,951.63 rows=64,365 width=759) (actual time=21.252..228.245 rows=64,199 loops=1)

  • Hash Cond: (job.om_release_type_id = release_type.id)
16. 39.198 186.996 ↑ 1.0 64,199 1

Hash Left Join (cost=1,420.18..4,764.40 rows=64,365 width=243) (actual time=21.236..186.996 rows=64,199 loops=1)

  • Hash Cond: (job.job_office_id = vendor_location.id)
17. 39.965 147.561 ↑ 1.0 64,199 1

Hash Left Join (cost=1,402.88..4,576.21 rows=64,365 width=233) (actual time=20.992..147.561 rows=64,199 loops=1)

  • Hash Cond: (job.client_id = client.id)
18. 45.179 107.550 ↑ 1.0 64,199 1

Hash Left Join (cost=1,400.57..4,392.60 rows=64,365 width=222) (actual time=20.930..107.550 rows=64,199 loops=1)

  • Hash Cond: ((job.title_id)::text = (title.id)::text)
19. 41.508 41.508 ↑ 1.0 64,199 1

Seq Scan on om_jobs job (cost=0.00..2,823.05 rows=64,365 width=192) (actual time=0.013..41.508 rows=64,199 loops=1)

  • Filter: ((status_summary)::text = ANY ('{IN_PROGRESS,NOT_WORKABLE,WORKABLE}'::text[]))
  • Rows Removed by Filter: 1
20. 10.960 20.863 ↑ 1.0 29,454 1

Hash (cost=1,031.92..1,031.92 rows=29,492 width=41) (actual time=20.863..20.863 rows=29,454 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,421kB
21. 9.903 9.903 ↑ 1.0 29,454 1

Seq Scan on om_titles title (cost=0.00..1,031.92 rows=29,492 width=41) (actual time=0.006..9.903 rows=29,454 loops=1)

22. 0.022 0.046 ↑ 1.0 58 1

Hash (cost=1.58..1.58 rows=58 width=19) (actual time=0.046..0.046 rows=58 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
23. 0.024 0.024 ↑ 1.0 58 1

Seq Scan on clients client (cost=0.00..1.58 rows=58 width=19) (actual time=0.009..0.024 rows=58 loops=1)

24. 0.120 0.237 ↑ 1.0 369 1

Hash (cost=12.69..12.69 rows=369 width=18) (actual time=0.236..0.237 rows=369 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
25. 0.117 0.117 ↑ 1.0 369 1

Seq Scan on vendor_locations vendor_location (cost=0.00..12.69 rows=369 width=18) (actual time=0.005..0.117 rows=369 loops=1)

26. 0.004 0.010 ↑ 23.3 6 1

Hash (cost=11.40..11.40 rows=140 width=524) (actual time=0.009..0.010 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
27. 0.006 0.006 ↑ 23.3 6 1

Seq Scan on om_release_types release_type (cost=0.00..11.40 rows=140 width=524) (actual time=0.004..0.006 rows=6 loops=1)

28. 0.006 0.014 ↑ 80.8 12 1

Hash (cost=19.70..19.70 rows=970 width=40) (actual time=0.013..0.014 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
29. 0.008 0.008 ↑ 80.8 12 1

Seq Scan on line_of_businesses line_of_business (cost=0.00..19.70 rows=970 width=40) (actual time=0.004..0.008 rows=12 loops=1)

30. 0.004 0.009 ↑ 184.0 5 1

Hash (cost=19.20..19.20 rows=920 width=44) (actual time=0.009..0.009 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
31. 0.005 0.005 ↑ 184.0 5 1

Seq Scan on priorities priority (cost=0.00..19.20 rows=920 width=44) (actual time=0.004..0.005 rows=5 loops=1)

32. 0.022 0.042 ↑ 1.0 61 1

Hash (cost=1.61..1.61 rows=61 width=23) (actual time=0.042..0.042 rows=61 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
33. 0.020 0.020 ↑ 1.0 61 1

Seq Scan on client_teams client_group (cost=0.00..1.61 rows=61 width=23) (actual time=0.005..0.020 rows=61 loops=1)

34. 27.339 3,707.713 ↓ 1.2 64,197 1

Hash (cost=46,173.47..46,173.47 rows=51,447 width=40) (actual time=3,707.713..3,707.713 rows=64,197 loops=1)

  • Buckets: 65,536 Batches: 2 Memory Usage: 2,788kB
35. 28.329 3,680.374 ↓ 1.2 64,197 1

Subquery Scan on job_assignees (cost=44,630.06..46,173.47 rows=51,447 width=40) (actual time=3,242.731..3,680.374 rows=64,197 loops=1)

36. 258.703 3,652.045 ↓ 1.2 64,197 1

GroupAggregate (cost=44,630.06..45,659.00 rows=51,447 width=72) (actual time=3,242.730..3,652.045 rows=64,197 loops=1)

  • Group Key: om_jobs.id
37. 855.328 3,393.342 ↓ 11.4 585,434 1

Sort (cost=44,630.06..44,758.67 rows=51,447 width=16) (actual time=3,242.700..3,393.342 rows=585,434 loops=1)

  • Sort Key: om_jobs.id
  • Sort Method: external merge Disk: 14,904kB
38. 0.000 2,538.014 ↓ 11.4 585,434 1

Gather (cost=6,864.54..40,604.12 rows=51,447 width=16) (actual time=165.170..2,538.014 rows=585,434 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
39. 232.262 2,717.266 ↓ 9.1 195,145 3 / 3

Nested Loop (cost=5,864.54..34,459.42 rows=21,436 width=16) (actual time=147.484..2,717.266 rows=195,145 loops=3)

40. 209.018 1,899.570 ↓ 9.1 195,145 3 / 3

Hash Join (cost=5,864.11..24,343.24 rows=21,478 width=32) (actual time=147.440..1,899.570 rows=195,145 loops=3)

  • Hash Cond: (ojr.id = om_jobs.latest_job_run_id)
41. 216.483 1,617.342 ↓ 9.1 195,145 3 / 3

Hash Join (cost=2,477.86..20,661.62 rows=21,488 width=40) (actual time=74.018..1,617.342 rows=195,145 loops=3)

  • Hash Cond: (ojrt.job_run_id = ojr.id)
42. 436.494 1,329.625 ↓ 9.1 195,145 3 / 3

Nested Loop (cost=99.92..18,227.29 rows=21,488 width=32) (actual time=2.578..1,329.625 rows=195,145 loops=3)

43. 213.702 307.698 ↓ 9.1 195,144 3 / 3

Hash Join (cost=99.50..7,293.11 rows=21,488 width=16) (actual time=2.561..307.698 rows=195,144 loops=3)

  • Hash Cond: (om_task_assignees.user_id = users.id)
44. 91.486 91.486 ↑ 1.2 195,144 3 / 3

Parallel Seq Scan on om_task_assignees (cost=0.00..6,063.90 rows=243,890 width=16) (actual time=0.005..91.486 rows=195,144 loops=3)

45. 1.491 2.510 ↑ 1.0 415 3 / 3

Hash (cost=94.27..94.27 rows=418 width=8) (actual time=2.510..2.510 rows=415 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
46. 0.481 1.019 ↑ 1.0 415 3 / 3

Merge Join (cost=0.56..94.27 rows=418 width=8) (actual time=0.039..1.019 rows=415 loops=3)

  • Merge Cond: (users.contact_id = contacts.id)
47. 0.268 0.268 ↑ 11.4 416 3 / 3

Index Scan using index_users_on_contact_id on users (cost=0.28..504.68 rows=4,739 width=16) (actual time=0.011..0.268 rows=416 loops=3)

48. 0.270 0.270 ↓ 1.0 601 3 / 3

Index Only Scan using contacts_pkey on contacts (cost=0.28..42.88 rows=600 width=8) (actual time=0.024..0.270 rows=601 loops=3)

  • Heap Fetches: 601
49. 585.433 585.433 ↑ 1.0 1 585,433 / 3

Index Scan using idx_om_job_runs_tasks_task_id on om_job_runs_tasks ojrt (cost=0.42..0.50 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=585,433)

  • Index Cond: (task_id = om_task_assignees.task_id)
50. 42.023 71.234 ↑ 1.0 64,200 3 / 3

Hash (cost=1,572.97..1,572.97 rows=64,397 width=8) (actual time=71.234..71.234 rows=64,200 loops=3)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,020kB
51. 29.211 29.211 ↑ 1.0 64,200 3 / 3

Seq Scan on om_job_runs ojr (cost=0.00..1,572.97 rows=64,397 width=8) (actual time=0.011..29.211 rows=64,200 loops=3)

52. 32.192 73.210 ↑ 1.0 64,200 3 / 3

Hash (cost=2,581.67..2,581.67 rows=64,367 width=16) (actual time=73.210..73.210 rows=64,200 loops=3)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,522kB
53. 41.018 41.018 ↑ 1.0 64,200 3 / 3

Seq Scan on om_jobs (cost=0.00..2,581.67 rows=64,367 width=16) (actual time=0.025..41.018 rows=64,200 loops=3)

54. 585.434 585.434 ↑ 1.0 1 585,434 / 3

Index Only Scan using om_tasks_pkey on om_tasks ot (cost=0.42..0.47 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=585,434)

  • Index Cond: (id = ojrt.task_id)
  • Heap Fetches: 22,716
55. 3.325 8,071.887 ↑ 9.5 6,794 1

Hash (cost=306,098.80..306,098.80 rows=64,367 width=40) (actual time=8,071.886..8,071.887 rows=6,794 loops=1)

  • Buckets: 65,536 Batches: 2 Memory Usage: 805kB
56. 2.979 8,068.562 ↑ 9.5 6,794 1

Subquery Scan on job_alphas (cost=302,270.95..306,098.80 rows=64,367 width=40) (actual time=7,913.412..8,068.562 rows=6,794 loops=1)

57. 89.095 8,065.583 ↑ 9.5 6,794 1

GroupAggregate (cost=302,270.95..305,455.13 rows=64,367 width=72) (actual time=7,913.410..8,065.583 rows=6,794 loops=1)

  • Group Key: om_jobs_1.id
58. 288.924 7,976.488 ↑ 1.2 263,297 1

Sort (cost=302,270.95..303,064.15 rows=317,278 width=16) (actual time=7,913.372..7,976.488 rows=263,297 loops=1)

  • Sort Key: om_jobs_1.id
  • Sort Method: external sort Disk: 6,704kB
59. 167.561 7,687.564 ↑ 1.2 263,297 1

Hash Join (cost=6,986.36..267,854.06 rows=317,278 width=16) (actual time=104.087..7,687.564 rows=263,297 loops=1)

  • Hash Cond: (requirement.abstract_asset_id = asset.id)
60. 180.115 7,519.860 ↑ 1.0 314,053 1

Hash Join (cost=6,768.51..263,527.99 rows=317,278 width=16) (actual time=103.937..7,519.860 rows=314,053 loops=1)

  • Hash Cond: (job_run.id = om_jobs_1.latest_job_run_id)
61. 181.064 7,288.446 ↑ 1.0 314,053 1

Hash Join (cost=3,382.26..255,778.61 rows=317,426 width=24) (actual time=52.550..7,288.446 rows=314,053 loops=1)

  • Hash Cond: (job_run_task.job_run_id = job_run.id)
62. 508.040 7,060.797 ↑ 1.0 314,053 1

Merge Join (cost=1,004.32..252,567.38 rows=317,426 width=16) (actual time=5.869..7,060.797 rows=314,053 loops=1)

  • Merge Cond: (base_io_requiement.id = requirement.base_io_requirement_id)
63. 862.538 6,372.898 ↑ 1.0 1,134,076 1

Gather Merge (cost=1,001.76..2,736,033.88 rows=1,135,361 width=16) (actual time=5.844..6,372.898 rows=1,134,076 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
64. 608.049 5,510.360 ↑ 1.3 378,025 3 / 3

Nested Loop (cost=1.73..2,603,985.03 rows=473,067 width=16) (actual time=0.065..5,510.360 rows=378,025 loops=3)

65. 887.117 3,768.237 ↑ 1.3 378,025 3 / 3

Nested Loop (cost=1.31..2,362,021.54 rows=473,982 width=16) (actual time=0.051..3,768.237 rows=378,025 loops=3)

66. 234.947 234.947 ↑ 1.2 378,025 3 / 3

Parallel Index Only Scan using om_base_io_requirements_pkey on om_base_io_requirements base_io_requiement (cost=0.43..33,965.05 rows=472,026 width=8) (actual time=0.025..234.947 rows=378,025 loops=3)

  • Heap Fetches: 198,370
67. 378.025 2,646.173 ↑ 2.0 1 1,134,074 / 3

Bitmap Heap Scan on om_tasks task (cost=0.88..4.91 rows=2 width=24) (actual time=0.007..0.007 rows=1 loops=1,134,074)

  • Recheck Cond: ((base_io_requiement.id = input_requirement_id) OR (base_io_requiement.id = output_requirement_id))
  • Heap Blocks: exact=203,261
68. 756.049 2,268.148 ↓ 0.0 0 1,134,074 / 3

BitmapOr (cost=0.88..0.88 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1,134,074)

69. 756.049 756.049 ↑ 1.0 1 1,134,074 / 3

Bitmap Index Scan on idx_om_tasks_input_requirement_id (cost=0.00..0.44 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1,134,074)

  • Index Cond: (base_io_requiement.id = input_requirement_id)
70. 756.049 756.049 ↑ 1.0 1 1,134,074 / 3

Bitmap Index Scan on idx_om_tasks_output_requirement_id (cost=0.00..0.44 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1,134,074)

  • Index Cond: (base_io_requiement.id = output_requirement_id)
71. 1,134.074 1,134.074 ↑ 1.0 1 1,134,074 / 3

Index Scan using idx_om_job_runs_tasks_task_id on om_job_runs_tasks job_run_task (cost=0.42..0.50 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=1,134,074)

  • Index Cond: (task_id = task.id)
72. 179.859 179.859 ↑ 1.0 314,053 1

Index Scan using idx_om_requirements_base_io_requirement_id on om_requirements requirement (cost=0.42..19,777.88 rows=316,727 width=16) (actual time=0.019..179.859 rows=314,053 loops=1)

  • Filter: ((source_io_requirement_id IS NULL) AND ((dtype)::text = 'AssetRequirement'::text))
  • Rows Removed by Filter: 41,496
73. 21.457 46.585 ↑ 1.0 64,200 1

Hash (cost=1,572.97..1,572.97 rows=64,397 width=8) (actual time=46.584..46.585 rows=64,200 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,020kB
74. 25.128 25.128 ↑ 1.0 64,200 1

Seq Scan on om_job_runs job_run (cost=0.00..1,572.97 rows=64,397 width=8) (actual time=0.009..25.128 rows=64,200 loops=1)

75. 21.375 51.299 ↑ 1.0 64,200 1

Hash (cost=2,581.67..2,581.67 rows=64,367 width=16) (actual time=51.298..51.299 rows=64,200 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,522kB
76. 29.924 29.924 ↑ 1.0 64,200 1

Seq Scan on om_jobs om_jobs_1 (cost=0.00..2,581.67 rows=64,367 width=16) (actual time=0.008..29.924 rows=64,200 loops=1)

77. 0.013 0.143 ↓ 1.2 32 1

Hash (cost=217.51..217.51 rows=27 width=16) (actual time=0.142..0.143 rows=32 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
78. 0.033 0.130 ↓ 1.2 32 1

Nested Loop (cost=0.29..217.51 rows=27 width=16) (actual time=0.046..0.130 rows=32 loops=1)

79. 0.031 0.031 ↓ 1.2 33 1

Seq Scan on om_abstract_assets asset (cost=0.00..1.27 rows=27 width=16) (actual time=0.022..0.031 rows=33 loops=1)

80. 0.066 0.066 ↑ 1.0 1 33

Index Only Scan using alphas_pkey on alphas alpha (cost=0.29..8.01 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=33)

  • Index Cond: (id = asset.alpha_id)
  • Heap Fetches: 32
81. 0.009 0.032 ↑ 10.0 14 1

Hash (cost=11.40..11.40 rows=140 width=524) (actual time=0.032..0.032 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
82. 0.023 0.023 ↑ 10.0 14 1

Seq Scan on om_job_types job_type (cost=0.00..11.40 rows=140 width=524) (actual time=0.018..0.023 rows=14 loops=1)

83. 42.427 965.354 ↓ 6.0 64,200 1

Hash (cost=6,377.95..6,377.95 rows=10,674 width=40) (actual time=965.353..965.354 rows=64,200 loops=1)

  • Buckets: 32,768 (originally 16384) Batches: 4 (originally 1) Memory Usage: 3,841kB
84. 29.109 922.927 ↓ 6.0 64,200 1

Subquery Scan on project_managers_group (cost=3,683.68..6,377.95 rows=10,674 width=40) (actual time=197.042..922.927 rows=64,200 loops=1)

85. 543.274 893.818 ↓ 6.0 64,200 1

GroupAggregate (cost=3,683.68..6,271.21 rows=10,674 width=104) (actual time=197.040..893.818 rows=64,200 loops=1)

  • Group Key: job_1.id
86. 91.517 350.544 ↓ 11.3 120,719 1

Merge Join (cost=3,683.68..6,031.05 rows=10,674 width=31) (actual time=196.978..350.544 rows=120,719 loops=1)

  • Merge Cond: (om_jobs_project_managers.job_id = job_1.id)
87. 139.482 235.275 ↓ 11.3 120,719 1

Sort (cost=3,683.35..3,710.04 rows=10,674 width=31) (actual time=196.938..235.275 rows=120,719 loops=1)

  • Sort Key: om_jobs_project_managers.job_id
  • Sort Method: external sort Disk: 4,968kB
88. 64.902 95.793 ↓ 11.3 120,719 1

Hash Join (cost=99.50..2,969.17 rows=10,674 width=31) (actual time=1.210..95.793 rows=120,719 loops=1)

  • Hash Cond: (om_jobs_project_managers.user_id = users_1.id)
89. 29.695 29.695 ↑ 1.0 120,719 1

Seq Scan on om_jobs_project_managers (cost=0.00..2,309.13 rows=121,013 width=16) (actual time=0.008..29.695 rows=120,719 loops=1)

90. 0.162 1.196 ↑ 1.0 415 1

Hash (cost=94.27..94.27 rows=418 width=23) (actual time=1.195..1.196 rows=415 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 33kB
91. 0.491 1.034 ↑ 1.0 415 1

Merge Join (cost=0.56..94.27 rows=418 width=23) (actual time=0.037..1.034 rows=415 loops=1)

  • Merge Cond: (contacts_1.id = users_1.contact_id)
92. 0.257 0.257 ↓ 1.0 601 1

Index Scan using contacts_pkey on contacts contacts_1 (cost=0.28..42.88 rows=600 width=23) (actual time=0.020..0.257 rows=601 loops=1)

93. 0.286 0.286 ↑ 11.4 416 1

Index Scan using index_users_on_contact_id on users users_1 (cost=0.28..504.68 rows=4,739 width=16) (actual time=0.012..0.286 rows=416 loops=1)

94. 23.752 23.752 ↑ 1.0 64,200 1

Index Only Scan using om_jobs_pkey on om_jobs job_1 (cost=0.29..2,026.91 rows=64,367 width=8) (actual time=0.031..23.752 rows=64,200 loops=1)

  • Heap Fetches: 10,809
95. 32.700 623.573 ↓ 7.1 64,196 1

Hash (cost=6,696.39..6,696.39 rows=9,076 width=40) (actual time=623.573..623.573 rows=64,196 loops=1)

  • Buckets: 65,536 (originally 16384) Batches: 2 (originally 1) Memory Usage: 3,832kB
96. 29.951 590.873 ↓ 7.1 64,196 1

Subquery Scan on client_managers_group (cost=4,157.64..6,696.39 rows=9,076 width=40) (actual time=146.064..590.873 rows=64,196 loops=1)

97. 310.490 560.922 ↓ 7.1 64,196 1

GroupAggregate (cost=4,157.64..6,605.63 rows=9,076 width=72) (actual time=146.063..560.922 rows=64,196 loops=1)

  • Group Key: job_2.id
98. 59.429 250.432 ↓ 7.3 66,379 1

Merge Join (cost=4,157.64..6,401.42 rows=9,076 width=80) (actual time=146.013..250.432 rows=66,379 loops=1)

  • Merge Cond: (om_jobs_client_managers.job_id = job_2.id)
99. 68.304 168.120 ↓ 7.3 66,379 1

Sort (cost=4,157.31..4,180.00 rows=9,076 width=80) (actual time=145.970..168.120 rows=66,379 loops=1)

  • Sort Key: om_jobs_client_managers.job_id
  • Sort Method: external merge Disk: 3,192kB
100. 23.928 99.816 ↓ 7.3 66,379 1

Hash Join (cost=3,036.41..3,560.66 rows=9,076 width=80) (actual time=76.044..99.816 rows=66,379 loops=1)

  • Hash Cond: (client_contacts.user_id = users_2.id)
101. 0.028 0.028 ↑ 15.1 43 1

Seq Scan on client_contacts (cost=0.00..16.50 rows=650 width=72) (actual time=0.011..0.028 rows=43 loops=1)

102. 23.112 75.860 ↓ 1.0 66,379 1

Hash (cost=1,821.23..1,821.23 rows=66,174 width=24) (actual time=75.859..75.860 rows=66,379 loops=1)

  • Buckets: 65,536 Batches: 2 Memory Usage: 3,343kB
103. 33.341 52.748 ↓ 1.0 66,379 1

Hash Join (cost=224.63..1,821.23 rows=66,174 width=24) (actual time=2.780..52.748 rows=66,379 loops=1)

  • Hash Cond: (om_jobs_client_managers.user_id = users_2.id)
104. 16.651 16.651 ↓ 1.0 66,379 1

Seq Scan on om_jobs_client_managers (cost=0.00..1,422.74 rows=66,174 width=16) (actual time=0.008..16.651 rows=66,379 loops=1)

105. 1.322 2.756 ↑ 1.0 4,700 1

Hash (cost=165.39..165.39 rows=4,739 width=8) (actual time=2.755..2.756 rows=4,700 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 248kB
106. 1.434 1.434 ↑ 1.0 4,700 1

Seq Scan on users users_2 (cost=0.00..165.39 rows=4,739 width=8) (actual time=0.006..1.434 rows=4,700 loops=1)

107. 22.883 22.883 ↑ 1.0 64,200 1

Index Only Scan using om_jobs_pkey on om_jobs job_2 (cost=0.29..2,026.91 rows=64,367 width=8) (actual time=0.034..22.883 rows=64,200 loops=1)

  • Heap Fetches: 10,809
108. 385.194 641.990 ↑ 1.0 1 64,199

Aggregate (cost=94.39..94.40 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=64,199)

109. 127.964 256.796 ↑ 1.0 1 64,199

Hash Join (cost=24.78..94.38 rows=1 width=23) (actual time=0.003..0.004 rows=1 loops=64,199)

  • Hash Cond: (users_3.contact_id = contacts_2.id)
110. 128.398 128.398 ↑ 10.0 1 64,199

Index Scan using users_pkey on users users_3 (cost=0.28..69.86 rows=10 width=16) (actual time=0.002..0.002 rows=1 loops=64,199)

  • Index Cond: (id = ANY (job_assignees.assignees_user_id))
111. 0.221 0.434 ↓ 1.0 601 1

Hash (cost=17.00..17.00 rows=600 width=23) (actual time=0.434..0.434 rows=601 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 43kB
112. 0.213 0.213 ↓ 1.0 601 1

Seq Scan on contacts contacts_2 (cost=0.00..17.00 rows=600 width=23) (actual time=0.011..0.213 rows=601 loops=1)

113. 128.398 192.597 ↑ 1.0 1 64,199

Aggregate (cost=78.36..78.37 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=64,199)

114. 64.199 64.199 ↓ 0.0 0 64,199

Index Scan using alphas_pkey on alphas alpha_1 (cost=0.29..78.31 rows=10 width=37) (actual time=0.000..0.001 rows=0 loops=64,199)

  • Index Cond: (id = ANY (job_alphas.alphas_id))
115. 64.199 64.199 ↓ 0.0 0 64,199

Index Scan using idx_om_job_bookmarks_job_id on om_job_bookmarks (cost=0.15..0.27 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=64,199)

  • Index Cond: (job.id = job_id)
  • Filter: (user_id = 3,414)
Planning time : 37.331 ms
Execution time : 16,425.887 ms