explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qCJC

Settings
# exclusive inclusive rows x rows loops node
1. 0.141 2,301.439 ↑ 1.0 500 1

Limit (cost=4,198,748.35..4,198,864.60 rows=500 width=1,152) (actual time=2,300.011..2,301.439 rows=500 loops=1)

2. 0.473 2,301.298 ↑ 90.2 500 1

Subquery Scan on localization_job_listings (cost=4,198,748.35..4,209,228.52 rows=45,076 width=1,152) (actual time=2,300.011..2,301.298 rows=500 loops=1)

3. 0.710 2,300.825 ↑ 90.2 500 1

Unique (cost=4,198,748.35..4,208,777.76 rows=45,076 width=1,192) (actual time=2,300.006..2,300.825 rows=500 loops=1)

4. 232.261 2,300.115 ↑ 90.2 500 1

Sort (cost=4,198,748.35..4,198,861.04 rows=45,076 width=1,192) (actual time=2,300.005..2,300.115 rows=500 loops=1)

  • Sort Key: localization_jobs.created_at DESC, localization_jobs.id, localization_job_groups.id, localization_job_groups.name, localization_jobs.skip_linguistic, localization_jobs.status, localization_jobs.internal_due_date, localization_jobs.client_rate, currencies.currency_code, unit_of_measures.unit_of_measure, titles.title, titles.id, alphas.id, (NULLIF(btrim((alphas.name)::text), ''::text)), alphas.is_vip_workflow, (CASE WHEN (states.name IS NULL) THEN concat(vendor_locations.city, ', ', countries.name) ELSE concat(vendor_locations.city, ', ', states.name, ', ', countries.name) END), languages.name, languages.id, localization_jobs.workflow, localization_jobs.milestone, localization_jobs.content_spec, batches.name, batches.id, localization_jobs.client_po, localization_jobs.notes, service_types.name, service_types.id, localization_jobs.release_type, localization_configurations.name, localization_configurations.id, localization_jobs.client_due_date, ljt.name, translation.assignee_id, translation.assignee_type, translation.contact_user_id, translation.contact_user_name, translation.vendor_location_id, translation.vendor_location_name, translation.due_date, translation.status, translation.billable, (string_agg(DISTINCT (clients.company)::text, ', '::text)), (CASE WHEN ((translation.assignee_type)::text = 'Vendor'::text) THEN (SubPlan 1) WHEN ((translation.assignee_type)::text = 'Individual'::text) THEN ((SubPlan 2))::character varying ELSE NULL::character varying END), (CASE WHEN ((translation.assignee_type)::text = 'Vendor'::text) THEN (SubPlan 3) ELSE NULL::text END), scripting_creation.id, scripting_creation.due_date, scripting_creation.status, linguistic_qc.assignee_id, linguistic_qc.assignee_type, linguistic_qc.contact_user_id, linguistic_qc.contact_user_name, linguistic_qc.vendor_location_id, linguistic_qc.vendor_location_name, linguistic_qc.due_date, linguistic_qc.status, linguistic_qc.billable, (CASE WHEN ((linguistic_qc.assignee_type)::text = 'Vendor'::text) THEN (SubPlan 4) WHEN ((linguistic_qc.assignee_type)::text = 'Individual'::text) THEN ((SubPlan 5))::character varying ELSE NULL::character varying END), (CASE WHEN ((linguistic_qc.assignee_type)::text = 'Vendor'::text) THEN (SubPlan 6) ELSE NULL::text END), postprocessing.assignee_id, postprocessing.assignee_type, postprocessing.contact_user_id, postprocessing.contact_user_name, postprocessing.vendor_location_id, postprocessing.vendor_location_name, postprocessing.due_date, postprocessing.status, postprocessing.billable, (CASE WHEN ((postprocessing.assignee_type)::text = 'Vendor'::text) THEN (SubPlan 7) WHEN ((postprocessing.assignee_type)::text = 'Individual'::text) THEN ((SubPlan 8))::character varying ELSE NULL::character varying END), (CASE WHEN ((translation.assignee_id IS NULL) OR ((localization_jobs.skip_linguistic IS FALSE) AND (linguistic_qc.assignee_id IS NULL))) THEN false ELSE true END), (CASE WHEN ((languages.name)::text ~~* '%english%'::text) THEN true ELSE false END), (CASE WHEN ((translation.assignee_id IS NULL) OR ((translation.status)::text = 'created'::text) OR (((translation.status)::text = 'open'::text) AND translation.billable)) THEN true ELSE false END), (CASE WHEN ((linguistic_qc.assignee_id IS NULL) OR ((linguistic_qc.status)::text = 'created'::text) OR (((linguistic_qc.status)::text = 'open'::text) AND linguistic_qc.billable)) THEN true ELSE false END), (CASE WHEN (localization_jobs.status = 1) THEN localization_jobs.completed_at ELSE NULL::timestamp without time zone END), (string_agg(DISTINCT (users.id)::text, ', '::text)), (string_agg(DISTINCT CASE WHEN (contacts.id IS NOT NULL) THEN concat(contacts.first_name, ' ', contacts.last_name) WHEN (individuals.id IS NOT NULL) THEN concat(individuals.legal_first_name, ' ', individuals.legal_last_name) ELSE (users.email)::text END, ', '::text)), (CASE WHEN ((translation.assignee_type)::text = 'Vendor'::text) THEN (SubPlan 9) ELSE false END), (CASE WHEN ((linguistic_qc.assignee_type)::text = 'Vendor'::text) THEN (SubPlan 10) ELSE false END), (CASE WHEN ((postprocessing.assignee_type)::text = 'Vendor'::text) THEN (SubPlan 11) ELSE false END), (CASE WHEN (localization_jobs.status = 1) THEN false WHEN (localization_jobs.internal_due_date < now()) THEN true WHEN (localization_jobs.client_due_date < now()) THEN true WHEN (((translation.status)::text = 'open'::text) AND (translation.due_date < now())) THEN true WHEN (((linguistic_qc.status)::text = 'open'::text) AND (linguistic_qc.due_date < now())) THEN true WHEN (((postprocessing.status)::text = 'open'::text) AND (postprocessing.due_date < now())) THEN true ELSE false END), (CASE WHEN ((source_mat.program_runtime IS NOT NULL) AND (source_mat.program_runtime > '0'::numeric)) THEN ceil((source_mat.program_runtime / '60'::numeric)) WHEN ((source_mat.actual_runtime IS NOT NULL) AND (source_mat.actual_runtime > '0'::numeric)) THEN ceil((source_mat.actual_runtime / '60'::numeric)) ELSE ceil((source_mat.estimated_runtime / '60'::numeric)) END), priorities.name, (CASE WHEN (client_manager_contact.id IS NOT NULL) THEN concat(client_manager_contact.first_name, ' ', client_manager_contact.last_name) ELSE (client_manager.email)::text END), client_teams.name, bill_to_client.id, bill_to_client.company, localization_jobs.order_id, localization_jobs.client_notes, (string_agg(DISTINCT (localization_job_deliverable_types.name)::text, ', '::text))
  • Sort Method: external merge Disk: 21856kB
5. 568.616 2,067.854 ↓ 1.3 59,119 1

GroupAggregate (cost=46,489.94..4,171,845.46 rows=45,076 width=1,192) (actual time=1,415.741..2,067.854 rows=59,119 loops=1)

  • Group Key: localization_jobs.id, titles.id, alphas.id, languages.id, batches.id, service_types.id, localization_configurations.id, ljt.id, translation.assignee_id, translation.assignee_type, translation.vendor_location_id, translation.vendor_location_name, translation.contact_user_id, translation.contact_user_name, linguistic_qc.contact_user_id, linguistic_qc.contact_user_name, translation.due_date, translation.status, translation.billable, linguistic_qc.assignee_id, linguistic_qc.assignee_type, linguistic_qc.vendor_location_id, linguistic_qc.vendor_location_name, linguistic_qc.due_date, linguistic_qc.status, linguistic_qc.billable, postprocessing.vendor_location_id, postprocessing.vendor_location_name, postprocessing.contact_user_id, postprocessing.contact_user_name, postprocessing.assignee_type, postprocessing.assignee_id, postprocessing.due_date, postprocessing.status, postprocessing.billable, source_mat.program_runtime, source_mat.actual_runtime, source_mat.estimated_runtime, vendor_locations.id, (CASE WHEN (states.name IS NULL) THEN concat(vendor_locations.city, ', ', countries.name) ELSE concat(vendor_locations.city, ', ', states.name, ', ', countries.name) END), scripting_creation.id, scripting_creation.due_date, scripting_creation.status, currencies.currency_code, unit_of_measures.unit_of_measure, priorities.id, client_manager.id, client_manager_contact.id, client_teams.id, bill_to_client.id, localization_job_groups.id
6. 234.535 1,437.262 ↓ 1.4 61,090 1

Sort (cost=46,489.94..46,602.63 rows=45,076 width=1,066) (actual time=1,415.497..1,437.262 rows=61,090 loops=1)

  • Sort Key: localization_jobs.id, titles.id, alphas.id, languages.id, batches.id, service_types.id, localization_configurations.id, ljt.id, translation.assignee_id, translation.assignee_type, translation.vendor_location_id, translation.vendor_location_name, translation.contact_user_id, translation.contact_user_name, linguistic_qc.contact_user_id, linguistic_qc.contact_user_name, translation.due_date, translation.status, translation.billable, linguistic_qc.assignee_id, linguistic_qc.assignee_type, linguistic_qc.vendor_location_id, linguistic_qc.vendor_location_name, linguistic_qc.due_date, linguistic_qc.status, linguistic_qc.billable, postprocessing.vendor_location_id, postprocessing.vendor_location_name, postprocessing.contact_user_id, postprocessing.contact_user_name, postprocessing.assignee_type, postprocessing.assignee_id, postprocessing.due_date, postprocessing.status, postprocessing.billable, source_mat.program_runtime, source_mat.actual_runtime, source_mat.estimated_runtime, vendor_locations.id, (CASE WHEN (states.name IS NULL) THEN concat(vendor_locations.city, ', ', countries.name) ELSE concat(vendor_locations.city, ', ', states.name, ', ', countries.name) END), scripting_creation.id, scripting_creation.due_date, scripting_creation.status, currencies.currency_code, unit_of_measures.unit_of_measure, priorities.id, client_manager.id, client_manager_contact.id, client_teams.id, bill_to_client.id, localization_job_groups.id
  • Sort Method: external merge Disk: 22288kB
7. 31.599 1,202.727 ↓ 1.4 61,090 1

Hash Left Join (cost=12,897.11..21,897.05 rows=45,076 width=1,066) (actual time=373.330..1,202.727 rows=61,090 loops=1)

  • Hash Cond: (localization_job_deliverables.localization_job_deliverable_type_id = localization_job_deliverable_types.id)
8. 46.592 1,171.102 ↓ 1.4 61,090 1

Hash Left Join (cost=12,895.57..21,756.71 rows=45,076 width=1,038) (actual time=373.284..1,171.102 rows=61,090 loops=1)

  • Hash Cond: (localization_jobs.id = localization_job_deliverables.localization_job_id)
9. 28.942 1,101.118 ↓ 1.3 60,114 1

Hash Left Join (cost=11,503.49..19,001.87 rows=45,076 width=1,034) (actual time=349.518..1,101.118 rows=60,114 loops=1)

  • Hash Cond: (localization_jobs.bill_to_client_id = bill_to_client.id)
10. 28.372 1,072.140 ↓ 1.3 60,114 1

Hash Left Join (cost=11,501.41..18,881.29 rows=45,076 width=1,002) (actual time=349.459..1,072.140 rows=60,114 loops=1)

  • Hash Cond: (localization_jobs.client_team_id = client_teams.id)
11. 27.620 1,043.736 ↓ 1.3 60,114 1

Hash Left Join (cost=11,499.67..18,761.22 rows=45,076 width=970) (actual time=349.390..1,043.736 rows=60,114 loops=1)

  • Hash Cond: (localization_jobs.priority_id = priorities.id)
12. 33.041 1,016.097 ↓ 1.3 60,114 1

Hash Left Join (cost=11,498.56..18,641.08 rows=45,076 width=938) (actual time=349.363..1,016.097 rows=60,114 loops=1)

  • Hash Cond: (localization_jobs.unit_of_measure_id = unit_of_measures.id)
13. 34.493 983.033 ↓ 1.3 60,114 1

Hash Left Join (cost=11,497.38..18,460.00 rows=45,076 width=910) (actual time=349.330..983.033 rows=60,114 loops=1)

  • Hash Cond: (localization_jobs.currency_id = currencies.id)
14. 28.558 948.365 ↓ 1.3 60,114 1

Hash Left Join (cost=11,491.91..18,333.00 rows=45,076 width=910) (actual time=349.133..948.365 rows=60,114 loops=1)

  • Hash Cond: (users.id = individuals.user_id)
15. 30.023 918.244 ↓ 1.3 60,114 1

Hash Left Join (cost=11,400.44..17,847.27 rows=45,076 width=890) (actual time=347.539..918.244 rows=60,114 loops=1)

  • Hash Cond: (users.contact_id = contacts.id)
16. 27.913 888.038 ↓ 1.3 60,114 1

Hash Left Join (cost=11,384.42..17,712.84 rows=45,076 width=876) (actual time=347.338..888.038 rows=60,114 loops=1)

  • Hash Cond: (localization_jobs.client_manager_id = client_manager.id)
17. 27.743 857.296 ↓ 1.3 60,114 1

Hash Left Join (cost=11,176.09..17,335.40 rows=45,076 width=775) (actual time=344.463..857.296 rows=60,114 loops=1)

  • Hash Cond: (localization_jobs.localization_job_group_id = localization_job_groups.id)
18. 39.480 829.543 ↓ 1.3 60,114 1

Hash Left Join (cost=11,144.27..17,184.74 rows=45,076 width=743) (actual time=344.431..829.543 rows=60,114 loops=1)

  • Hash Cond: (localization_jobs.id = source_mat.sm_loc_id)
19. 27.727 638.751 ↓ 1.3 60,114 1

Hash Left Join (cost=9,496.36..15,418.50 rows=45,076 width=727) (actual time=193.087..638.751 rows=60,114 loops=1)

  • Hash Cond: (localization_jobs.id = scripting_creation.localization_job_id)
20. 37.516 610.434 ↓ 1.3 60,114 1

Hash Left Join (cost=8,343.01..14,146.81 rows=45,076 width=709) (actual time=192.424..610.434 rows=60,114 loops=1)

  • Hash Cond: (alphas.id = alphas_clients.alpha_id)
21. 34.804 554.310 ↓ 1.3 59,294 1

Hash Left Join (cost=7,608.04..12,241.76 rows=45,076 width=677) (actual time=173.656..554.310 rows=59,294 loops=1)

  • Hash Cond: (alphas.id = alphas_users.alpha_id)
22. 37.122 513.711 ↓ 1.3 59,119 1

Hash Left Join (cost=7,206.43..11,306.83 rows=45,076 width=636) (actual time=167.797..513.711 rows=59,119 loops=1)

  • Hash Cond: (localization_jobs.id = postprocessing.localization_job_id)
23. 28.832 403.899 ↓ 1.3 59,119 1

Hash Left Join (cost=5,746.45..9,728.52 rows=45,076 width=561) (actual time=95.101..403.899 rows=59,119 loops=1)

  • Hash Cond: (localization_jobs.id = linguistic_qc.localization_job_id)
24. 35.763 365.524 ↓ 1.3 59,119 1

Hash Left Join (cost=4,286.48..8,150.21 rows=45,076 width=486) (actual time=85.531..365.524 rows=59,119 loops=1)

  • Hash Cond: (localization_jobs.id = translation.localization_job_id)
25. 23.260 269.365 ↓ 1.3 59,119 1

Hash Left Join (cost=2,826.50..6,571.90 rows=45,076 width=411) (actual time=25.117..269.365 rows=59,119 loops=1)

  • Hash Cond: (localization_jobs.localization_job_type_id = ljt.id)
26. 25.361 246.087 ↓ 1.3 59,119 1

Hash Left Join (cost=2,825.28..6,402.20 rows=45,076 width=379) (actual time=25.086..246.087 rows=59,119 loops=1)

  • Hash Cond: (localization_jobs.localization_configuration_id = localization_configurations.id)
27. 25.628 220.708 ↓ 1.3 59,119 1

Hash Left Join (cost=2,823.85..6,256.06 rows=45,076 width=347) (actual time=25.056..220.708 rows=59,119 loops=1)

  • Hash Cond: (localization_jobs.language_id = languages.id)
28. 25.002 195.044 ↓ 1.3 59,119 1

Hash Left Join (cost=2,820.39..6,126.56 rows=45,076 width=335) (actual time=25.008..195.044 rows=59,119 loops=1)

  • Hash Cond: (localization_jobs.service_type_id = service_types.id)
29. 22.890 170.030 ↓ 1.3 59,119 1

Hash Left Join (cost=2,819.25..5,923.52 rows=45,076 width=303) (actual time=24.983..170.030 rows=59,119 loops=1)

  • Hash Cond: (localization_jobs.batch_id = batches.id)
30. 27.258 146.744 ↓ 1.3 59,119 1

Hash Left Join (cost=2,786.26..5,771.88 rows=45,076 width=259) (actual time=24.572..146.744 rows=59,119 loops=1)

  • Hash Cond: (alphas.financial_recognition_office_id = vendor_locations.id)
31. 29.607 119.096 ↓ 1.3 59,119 1

Hash Join (cost=2,760.30..5,575.49 rows=45,076 width=227) (actual time=24.164..119.096 rows=59,119 loops=1)

  • Hash Cond: (alphas.title_id = titles.id)
32. 36.611 81.122 ↓ 1.3 59,173 1

Hash Join (cost=1,936.65..4,632.31 rows=45,523 width=203) (actual time=15.707..81.122 rows=59,173 loops=1)

  • Hash Cond: (localization_jobs.alpha_id = alphas.id)
33. 29.022 29.022 ↓ 1.3 59,220 1

Seq Scan on localization_jobs (cost=0.00..2,574.70 rows=46,070 width=163) (actual time=0.011..29.022 rows=59,220 loops=1)

  • Filter: ((deleted_at IS NULL) AND (((milestone)::text <> 'Complete'::text) OR (milestone IS NULL)) AND (production_status = 0))
  • Rows Removed by Filter: 5960
34. 5.300 15.489 ↑ 1.0 22,796 1

Hash (cost=1,651.70..1,651.70 rows=22,796 width=44) (actual time=15.489..15.489 rows=22,796 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2011kB
35. 10.189 10.189 ↑ 1.0 22,796 1

Seq Scan on alphas (cost=0.00..1,651.70 rows=22,796 width=44) (actual time=0.009..10.189 rows=22,796 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 274
36. 3.041 8.367 ↓ 1.0 15,828 1

Hash (cost=625.83..625.83 rows=15,826 width=28) (actual time=8.367..8.367 rows=15,828 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1075kB
37. 5.326 5.326 ↓ 1.0 15,828 1

Seq Scan on titles (cost=0.00..625.83 rows=15,826 width=28) (actual time=0.016..5.326 rows=15,828 loops=1)

  • Filter: ((deleted_at IS NULL) AND (freelance_test IS FALSE))
  • Rows Removed by Filter: 157
38. 0.015 0.390 ↓ 32.0 32 1

Hash (cost=25.94..25.94 rows=1 width=36) (actual time=0.389..0.390 rows=32 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
39. 0.062 0.375 ↓ 32.0 32 1

Nested Loop Left Join (cost=4.45..25.94 rows=1 width=36) (actual time=0.223..0.375 rows=32 loops=1)

40. 0.010 0.281 ↓ 32.0 32 1

Nested Loop (cost=4.31..25.74 rows=1 width=29) (actual time=0.185..0.281 rows=32 loops=1)

41. 0.019 0.207 ↓ 32.0 32 1

Nested Loop (cost=4.16..25.47 rows=1 width=21) (actual time=0.174..0.207 rows=32 loops=1)

42. 0.141 0.141 ↑ 1.0 1 1

Seq Scan on vendors (cost=0.00..16.47 rows=1 width=4) (actual time=0.141..0.141 rows=1 loops=1)

  • Filter: is_pixelogic
  • Rows Removed by Filter: 746
43. 0.027 0.047 ↓ 16.0 32 1

Bitmap Heap Scan on vendor_locations (cost=4.16..8.98 rows=2 width=25) (actual time=0.026..0.047 rows=32 loops=1)

  • Recheck Cond: (vendor_id = vendors.id)
  • Heap Blocks: exact=5
44. 0.020 0.020 ↓ 17.0 34 1

Bitmap Index Scan on index_vendor_locations_on_vendor_id (cost=0.00..4.16 rows=2 width=0) (actual time=0.020..0.020 rows=34 loops=1)

  • Index Cond: (vendor_id = vendors.id)
45. 0.064 0.064 ↑ 1.0 1 32

Index Scan using countries_pkey on countries (cost=0.14..0.27 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=32)

  • Index Cond: (id = vendor_locations.country_id)
46. 0.032 0.032 ↓ 0.0 0 32

Index Scan using states_pkey on states (cost=0.14..0.20 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = vendor_locations.state_id)
47. 0.193 0.396 ↑ 1.0 933 1

Hash (cost=21.33..21.33 rows=933 width=48) (actual time=0.396..0.396 rows=933 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 84kB
48. 0.203 0.203 ↑ 1.0 933 1

Seq Scan on batches (cost=0.00..21.33 rows=933 width=48) (actual time=0.011..0.203 rows=933 loops=1)

49. 0.004 0.012 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=36) (actual time=0.012..0.012 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
50. 0.008 0.008 ↑ 1.0 6 1

Seq Scan on service_types (cost=0.00..1.06 rows=6 width=36) (actual time=0.007..0.008 rows=6 loops=1)

51. 0.015 0.036 ↑ 1.0 65 1

Hash (cost=2.65..2.65 rows=65 width=16) (actual time=0.036..0.036 rows=65 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
52. 0.021 0.021 ↑ 1.0 65 1

Seq Scan on languages (cost=0.00..2.65 rows=65 width=16) (actual time=0.011..0.021 rows=65 loops=1)

53. 0.006 0.018 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=36) (actual time=0.018..0.018 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
54. 0.012 0.012 ↑ 1.0 19 1

Seq Scan on localization_configurations (cost=0.00..1.19 rows=19 width=36) (actual time=0.010..0.012 rows=19 loops=1)

55. 0.006 0.018 ↓ 1.4 14 1

Hash (cost=1.10..1.10 rows=10 width=36) (actual time=0.017..0.018 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
56. 0.012 0.012 ↓ 1.4 14 1

Seq Scan on localization_job_types ljt (cost=0.00..1.10 rows=10 width=36) (actual time=0.010..0.012 rows=14 loops=1)

57. 4.839 60.396 ↓ 9.5 17,841 1

Hash (cost=1,436.61..1,436.61 rows=1,869 width=79) (actual time=60.396..60.396 rows=17,841 loops=1)

  • Buckets: 32768 (originally 2048) Batches: 1 (originally 1) Memory Usage: 1431kB
58. 4.522 55.557 ↓ 9.5 17,842 1

Subquery Scan on translation (cost=1,408.58..1,436.61 rows=1,869 width=79) (actual time=45.620..55.557 rows=17,842 loops=1)

59. 3.483 51.035 ↓ 9.5 17,842 1

Unique (cost=1,408.58..1,417.92 rows=1,869 width=325) (actual time=45.619..51.035 rows=17,842 loops=1)

60. 11.789 47.552 ↓ 10.0 18,771 1

Sort (cost=1,408.58..1,413.25 rows=1,869 width=325) (actual time=45.618..47.552 rows=18,771 loops=1)

  • Sort Key: localization_assignments.localization_job_id, localization_assignments.created_at DESC
  • Sort Method: quicksort Memory: 2682kB
61. 8.341 35.763 ↓ 10.0 18,771 1

Hash Left Join (cost=329.35..1,307.02 rows=1,869 width=325) (actual time=4.633..35.763 rows=18,771 loops=1)

  • Hash Cond: (users_1.contact_id = contacts_1.id)
62. 3.415 27.235 ↓ 10.0 18,771 1

Hash Left Join (cost=313.33..1,281.42 rows=1,869 width=59) (actual time=4.426..27.235 rows=18,771 loops=1)

  • Hash Cond: (localization_assignments_users.user_id = users_1.id)
63. 3.968 21.454 ↓ 10.0 18,771 1

Hash Left Join (cost=122.35..1,085.54 rows=1,869 width=55) (actual time=2.014..21.454 rows=18,771 loops=1)

  • Hash Cond: (localization_assignments.id = localization_assignments_users.localization_assignment_id)
64. 3.597 16.901 ↓ 10.0 18,764 1

Hash Left Join (cost=68.30..1,019.29 rows=1,869 width=55) (actual time=1.414..16.901 rows=18,764 loops=1)

  • Hash Cond: (localization_assignments.vendor_location_id = vendor_locations_1.id)
65. 2.861 13.178 ↓ 10.0 18,764 1

Nested Loop (cost=54.35..1,000.39 rows=1,869 width=46) (actual time=1.278..13.178 rows=18,764 loops=1)

66. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on localization_assignment_types (cost=0.00..1.41 rows=1 width=4) (actual time=0.011..0.013 rows=1 loops=1)

  • Filter: ((name)::text = 'translation'::text)
  • Rows Removed by Filter: 32
67. 9.115 10.304 ↓ 6.7 18,764 1

Bitmap Heap Scan on localization_assignments (cost=54.35..970.95 rows=2,803 width=50) (actual time=1.263..10.304 rows=18,764 loops=1)

  • Recheck Cond: (localization_assignment_type_id = localization_assignment_types.id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 339
  • Heap Blocks: exact=751
68. 1.189 1.189 ↓ 6.7 19,103 1

Bitmap Index Scan on index_localization_assignments_on_its_type_id (cost=0.00..53.65 rows=2,848 width=0) (actual time=1.189..1.189 rows=19,103 loops=1)

  • Index Cond: (localization_assignment_type_id = localization_assignment_types.id)
69. 0.060 0.126 ↑ 1.0 309 1

Hash (cost=10.09..10.09 rows=309 width=13) (actual time=0.126..0.126 rows=309 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
70. 0.066 0.066 ↑ 1.0 309 1

Seq Scan on vendor_locations vendor_locations_1 (cost=0.00..10.09 rows=309 width=13) (actual time=0.009..0.066 rows=309 loops=1)

71. 0.273 0.585 ↑ 1.0 1,758 1

Hash (cost=31.80..31.80 rows=1,780 width=8) (actual time=0.585..0.585 rows=1,758 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 85kB
72. 0.312 0.312 ↑ 1.0 1,780 1

Seq Scan on localization_assignments_users (cost=0.00..31.80 rows=1,780 width=8) (actual time=0.008..0.312 rows=1,780 loops=1)

73. 0.813 2.366 ↑ 1.0 4,221 1

Hash (cost=138.21..138.21 rows=4,221 width=8) (actual time=2.366..2.366 rows=4,221 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 214kB
74. 1.553 1.553 ↑ 1.0 4,221 1

Seq Scan on users users_1 (cost=0.00..138.21 rows=4,221 width=8) (actual time=0.016..1.553 rows=4,221 loops=1)

75. 0.087 0.187 ↑ 1.0 401 1

Hash (cost=11.01..11.01 rows=401 width=18) (actual time=0.186..0.187 rows=401 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
76. 0.100 0.100 ↑ 1.0 401 1

Seq Scan on contacts contacts_1 (cost=0.00..11.01 rows=401 width=18) (actual time=0.010..0.100 rows=401 loops=1)

77. 0.578 9.543 ↓ 1.1 2,125 1

Hash (cost=1,436.61..1,436.61 rows=1,869 width=79) (actual time=9.543..9.543 rows=2,125 loops=1)

  • Buckets: 4096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 190kB
78. 0.544 8.965 ↓ 1.1 2,126 1

Subquery Scan on linguistic_qc (cost=1,408.58..1,436.61 rows=1,869 width=79) (actual time=7.893..8.965 rows=2,126 loops=1)

79. 0.378 8.421 ↓ 1.1 2,126 1

Unique (cost=1,408.58..1,417.92 rows=1,869 width=325) (actual time=7.891..8.421 rows=2,126 loops=1)

80. 1.309 8.043 ↓ 1.2 2,329 1

Sort (cost=1,408.58..1,413.25 rows=1,869 width=325) (actual time=7.891..8.043 rows=2,329 loops=1)

  • Sort Key: localization_assignments_1.localization_job_id, localization_assignments_1.created_at DESC
  • Sort Method: quicksort Memory: 368kB
81. 1.084 6.734 ↓ 1.2 2,329 1

Hash Left Join (cost=329.35..1,307.02 rows=1,869 width=325) (actual time=2.800..6.734 rows=2,329 loops=1)

  • Hash Cond: (users_2.contact_id = contacts_2.id)
82. 0.481 5.496 ↓ 1.2 2,329 1

Hash Left Join (cost=313.33..1,281.42 rows=1,869 width=59) (actual time=2.628..5.496 rows=2,329 loops=1)

  • Hash Cond: (localization_assignments_users_1.user_id = users_2.id)
83. 0.504 3.384 ↓ 1.2 2,329 1

Hash Left Join (cost=122.35..1,085.54 rows=1,869 width=55) (actual time=0.953..3.384 rows=2,329 loops=1)

  • Hash Cond: (localization_assignments_1.id = localization_assignments_users_1.localization_assignment_id)
84. 0.455 2.367 ↓ 1.2 2,329 1

Hash Left Join (cost=68.30..1,019.29 rows=1,869 width=55) (actual time=0.421..2.367 rows=2,329 loops=1)

  • Hash Cond: (localization_assignments_1.vendor_location_id = vendor_locations_2.id)
85. 0.358 1.799 ↓ 1.2 2,329 1

Nested Loop (cost=54.35..1,000.39 rows=1,869 width=46) (actual time=0.300..1.799 rows=2,329 loops=1)

86. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on localization_assignment_types localization_assignment_types_1 (cost=0.00..1.41 rows=1 width=4) (actual time=0.018..0.019 rows=1 loops=1)

  • Filter: ((name)::text = 'linguistic_qc'::text)
  • Rows Removed by Filter: 32
87. 1.198 1.422 ↑ 1.2 2,329 1

Bitmap Heap Scan on localization_assignments localization_assignments_1 (cost=54.35..970.95 rows=2,803 width=50) (actual time=0.276..1.422 rows=2,329 loops=1)

  • Recheck Cond: (localization_assignment_type_id = localization_assignment_types_1.id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 111
  • Heap Blocks: exact=530
88. 0.224 0.224 ↑ 1.2 2,440 1

Bitmap Index Scan on index_localization_assignments_on_its_type_id (cost=0.00..53.65 rows=2,848 width=0) (actual time=0.224..0.224 rows=2,440 loops=1)

  • Index Cond: (localization_assignment_type_id = localization_assignment_types_1.id)
89. 0.059 0.113 ↑ 1.0 309 1

Hash (cost=10.09..10.09 rows=309 width=13) (actual time=0.112..0.113 rows=309 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
90. 0.054 0.054 ↑ 1.0 309 1

Seq Scan on vendor_locations vendor_locations_2 (cost=0.00..10.09 rows=309 width=13) (actual time=0.007..0.054 rows=309 loops=1)

91. 0.269 0.513 ↑ 1.0 1,758 1

Hash (cost=31.80..31.80 rows=1,780 width=8) (actual time=0.513..0.513 rows=1,758 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 85kB
92. 0.244 0.244 ↑ 1.0 1,780 1

Seq Scan on localization_assignments_users localization_assignments_users_1 (cost=0.00..31.80 rows=1,780 width=8) (actual time=0.007..0.244 rows=1,780 loops=1)

93. 0.680 1.631 ↑ 1.0 4,221 1

Hash (cost=138.21..138.21 rows=4,221 width=8) (actual time=1.631..1.631 rows=4,221 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 214kB
94. 0.951 0.951 ↑ 1.0 4,221 1

Seq Scan on users users_2 (cost=0.00..138.21 rows=4,221 width=8) (actual time=0.006..0.951 rows=4,221 loops=1)

95. 0.082 0.154 ↑ 1.0 401 1

Hash (cost=11.01..11.01 rows=401 width=18) (actual time=0.153..0.154 rows=401 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
96. 0.072 0.072 ↑ 1.0 401 1

Seq Scan on contacts contacts_2 (cost=0.00..11.01 rows=401 width=18) (actual time=0.007..0.072 rows=401 loops=1)

97. 6.334 72.690 ↓ 11.6 21,687 1

Hash (cost=1,436.61..1,436.61 rows=1,869 width=79) (actual time=72.690..72.690 rows=21,687 loops=1)

  • Buckets: 32768 (originally 2048) Batches: 1 (originally 1) Memory Usage: 1996kB
98. 5.457 66.356 ↓ 11.6 21,688 1

Subquery Scan on postprocessing (cost=1,408.58..1,436.61 rows=1,869 width=79) (actual time=54.520..66.356 rows=21,688 loops=1)

99. 4.263 60.899 ↓ 11.6 21,688 1

Unique (cost=1,408.58..1,417.92 rows=1,869 width=325) (actual time=54.518..60.899 rows=21,688 loops=1)

100. 15.570 56.636 ↓ 12.5 23,322 1

Sort (cost=1,408.58..1,413.25 rows=1,869 width=325) (actual time=54.517..56.636 rows=23,322 loops=1)

  • Sort Key: localization_assignments_2.localization_job_id, localization_assignments_2.created_at DESC
  • Sort Method: quicksort Memory: 3780kB
101. 10.414 41.066 ↓ 12.5 23,322 1

Hash Left Join (cost=329.35..1,307.02 rows=1,869 width=325) (actual time=4.312..41.066 rows=23,322 loops=1)

  • Hash Cond: (users_3.contact_id = contacts_3.id)
102. 4.420 30.495 ↓ 12.5 23,322 1

Hash Left Join (cost=313.33..1,281.42 rows=1,869 width=59) (actual time=4.139..30.495 rows=23,322 loops=1)

  • Hash Cond: (localization_assignments_users_2.user_id = users_3.id)
103. 5.091 24.426 ↓ 12.5 23,322 1

Hash Left Join (cost=122.35..1,085.54 rows=1,869 width=55) (actual time=2.428..24.426 rows=23,322 loops=1)

  • Hash Cond: (localization_assignments_2.id = localization_assignments_users_2.localization_assignment_id)
104. 5.526 18.532 ↓ 12.5 23,322 1

Hash Left Join (cost=68.30..1,019.29 rows=1,869 width=55) (actual time=1.609..18.532 rows=23,322 loops=1)

  • Hash Cond: (localization_assignments_2.vendor_location_id = vendor_locations_3.id)
105. 3.610 12.898 ↓ 12.5 23,322 1

Nested Loop (cost=54.35..1,000.39 rows=1,869 width=46) (actual time=1.491..12.898 rows=23,322 loops=1)

106. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on localization_assignment_types localization_assignment_types_2 (cost=0.00..1.41 rows=1 width=4) (actual time=0.006..0.010 rows=1 loops=1)

  • Filter: ((name)::text = 'postprocessing_assignment'::text)
  • Rows Removed by Filter: 32
107. 7.871 9.278 ↓ 8.3 23,322 1

Bitmap Heap Scan on localization_assignments localization_assignments_2 (cost=54.35..970.95 rows=2,803 width=50) (actual time=1.481..9.278 rows=23,322 loops=1)

  • Recheck Cond: (localization_assignment_type_id = localization_assignment_types_2.id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 507
  • Heap Blocks: exact=850
108. 1.407 1.407 ↓ 8.4 23,829 1

Bitmap Index Scan on index_localization_assignments_on_its_type_id (cost=0.00..53.65 rows=2,848 width=0) (actual time=1.407..1.407 rows=23,829 loops=1)

  • Index Cond: (localization_assignment_type_id = localization_assignment_types_2.id)
109. 0.058 0.108 ↑ 1.0 309 1

Hash (cost=10.09..10.09 rows=309 width=13) (actual time=0.108..0.108 rows=309 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
110. 0.050 0.050 ↑ 1.0 309 1

Seq Scan on vendor_locations vendor_locations_3 (cost=0.00..10.09 rows=309 width=13) (actual time=0.006..0.050 rows=309 loops=1)

111. 0.437 0.803 ↑ 1.0 1,758 1

Hash (cost=31.80..31.80 rows=1,780 width=8) (actual time=0.803..0.803 rows=1,758 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 85kB
112. 0.366 0.366 ↑ 1.0 1,780 1

Seq Scan on localization_assignments_users localization_assignments_users_2 (cost=0.00..31.80 rows=1,780 width=8) (actual time=0.005..0.366 rows=1,780 loops=1)

113. 0.676 1.649 ↑ 1.0 4,221 1

Hash (cost=138.21..138.21 rows=4,221 width=8) (actual time=1.649..1.649 rows=4,221 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 214kB
114. 0.973 0.973 ↑ 1.0 4,221 1

Seq Scan on users users_3 (cost=0.00..138.21 rows=4,221 width=8) (actual time=0.009..0.973 rows=4,221 loops=1)

115. 0.084 0.157 ↑ 1.0 401 1

Hash (cost=11.01..11.01 rows=401 width=18) (actual time=0.157..0.157 rows=401 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
116. 0.073 0.073 ↑ 1.0 401 1

Seq Scan on contacts contacts_3 (cost=0.00..11.01 rows=401 width=18) (actual time=0.007..0.073 rows=401 loops=1)

117. 1.459 5.795 ↑ 1.0 7,109 1

Hash (cost=312.75..312.75 rows=7,109 width=45) (actual time=5.795..5.795 rows=7,109 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 587kB
118. 1.726 4.336 ↑ 1.0 7,109 1

Hash Left Join (cost=190.97..312.75 rows=7,109 width=45) (actual time=1.919..4.336 rows=7,109 loops=1)

  • Hash Cond: (alphas_users.user_id = users.id)
119. 0.761 0.761 ↑ 1.0 7,109 1

Seq Scan on alphas_users (cost=0.00..103.09 rows=7,109 width=8) (actual time=0.024..0.761 rows=7,109 loops=1)

120. 0.847 1.849 ↑ 1.0 4,221 1

Hash (cost=138.21..138.21 rows=4,221 width=41) (actual time=1.849..1.849 rows=4,221 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 350kB
121. 1.002 1.002 ↑ 1.0 4,221 1

Seq Scan on users (cost=0.00..138.21 rows=4,221 width=41) (actual time=0.007..1.002 rows=4,221 loops=1)

122. 6.508 18.608 ↑ 1.0 22,393 1

Hash (cost=455.02..455.02 rows=22,396 width=36) (actual time=18.608..18.608 rows=22,393 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1210kB
123. 7.802 12.100 ↑ 1.0 22,393 1

Hash Left Join (cost=2.08..455.02 rows=22,396 width=36) (actual time=0.054..12.100 rows=22,393 loops=1)

  • Hash Cond: (alphas_clients.client_id = clients.id)
124. 4.266 4.266 ↑ 1.0 22,393 1

Seq Scan on alphas_clients (cost=0.00..388.96 rows=22,396 width=8) (actual time=0.016..4.266 rows=22,393 loops=1)

125. 0.013 0.032 ↑ 1.0 48 1

Hash (cost=1.48..1.48 rows=48 width=36) (actual time=0.032..0.032 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
126. 0.019 0.019 ↑ 1.0 48 1

Seq Scan on clients (cost=0.00..1.48 rows=48 width=36) (actual time=0.013..0.019 rows=48 loops=1)

127. 0.063 0.590 ↑ 9.8 190 1

Hash (cost=1,129.99..1,129.99 rows=1,869 width=22) (actual time=0.590..0.590 rows=190 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 26kB
128. 0.051 0.527 ↑ 9.8 190 1

Subquery Scan on scripting_creation (cost=1,101.96..1,129.99 rows=1,869 width=22) (actual time=0.408..0.527 rows=190 loops=1)

129. 0.052 0.476 ↑ 9.8 190 1

Unique (cost=1,101.96..1,111.30 rows=1,869 width=305) (actual time=0.406..0.476 rows=190 loops=1)

130. 0.141 0.424 ↑ 9.8 190 1

Sort (cost=1,101.96..1,106.63 rows=1,869 width=305) (actual time=0.405..0.424 rows=190 loops=1)

  • Sort Key: localization_assignments_3.localization_job_id, localization_assignments_3.created_at DESC
  • Sort Method: quicksort Memory: 39kB
131. 0.059 0.283 ↑ 9.8 190 1

Nested Loop (cost=54.35..1,000.39 rows=1,869 width=305) (actual time=0.080..0.283 rows=190 loops=1)

132. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on localization_assignment_types localization_assignment_types_3 (cost=0.00..1.41 rows=1 width=4) (actual time=0.012..0.014 rows=1 loops=1)

  • Filter: ((name)::text = 'scripting_creation'::text)
  • Rows Removed by Filter: 32
133. 0.165 0.210 ↑ 14.8 190 1

Bitmap Heap Scan on localization_assignments localization_assignments_3 (cost=54.35..970.95 rows=2,803 width=34) (actual time=0.060..0.210 rows=190 loops=1)

  • Recheck Cond: (localization_assignment_type_id = localization_assignment_types_3.id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 10
  • Heap Blocks: exact=78
134. 0.045 0.045 ↑ 14.2 200 1

Bitmap Index Scan on index_localization_assignments_on_its_type_id (cost=0.00..53.65 rows=2,848 width=0) (actual time=0.045..0.045 rows=200 loops=1)

  • Index Cond: (localization_assignment_type_id = localization_assignment_types_3.id)
135. 6.468 151.312 ↓ 19.9 31,251 1

Hash (cost=1,628.28..1,628.28 rows=1,570 width=20) (actual time=151.312..151.312 rows=31,251 loops=1)

  • Buckets: 32768 (originally 2048) Batches: 1 (originally 1) Memory Usage: 1723kB
136. 7.194 144.844 ↓ 19.9 31,251 1

Subquery Scan on source_mat (cost=1,604.73..1,628.28 rows=1,570 width=20) (actual time=129.298..144.844 rows=31,251 loops=1)

137. 5.534 137.650 ↓ 19.9 31,251 1

Unique (cost=1,604.73..1,612.58 rows=1,570 width=541) (actual time=129.297..137.650 rows=31,251 loops=1)

138. 19.857 132.116 ↓ 19.9 31,272 1

Sort (cost=1,604.73..1,608.65 rows=1,570 width=541) (actual time=129.295..132.116 rows=31,272 loops=1)

  • Sort Key: localization_jobs_1.id, alpha_sm.id DESC
  • Sort Method: quicksort Memory: 2925kB
139. 12.676 112.259 ↓ 19.9 31,272 1

Nested Loop (cost=18.33..1,521.39 rows=1,570 width=541) (actual time=1.036..112.259 rows=31,272 loops=1)

140. 4.088 36.523 ↓ 19.7 31,530 1

Nested Loop (cost=18.04..801.21 rows=1,599 width=24) (actual time=0.963..36.523 rows=31,530 loops=1)

141. 1.451 8.804 ↓ 21.4 7,877 1

Nested Loop (cost=17.75..559.24 rows=368 width=20) (actual time=0.920..8.804 rows=7,877 loops=1)

142. 0.004 0.101 ↓ 4.0 4 1

Unique (cost=2.51..2.52 rows=1 width=4) (actual time=0.095..0.101 rows=4 loops=1)

143. 0.015 0.097 ↓ 4.0 4 1

Sort (cost=2.51..2.52 rows=1 width=4) (actual time=0.095..0.097 rows=4 loops=1)

  • Sort Key: source_material_types.id
  • Sort Method: quicksort Memory: 25kB
144. 0.040 0.082 ↓ 4.0 4 1

Hash Join (cost=1.09..2.50 rows=1 width=4) (actual time=0.074..0.082 rows=4 loops=1)

  • Hash Cond: (source_material_types.category_id = categories.id)
145. 0.019 0.019 ↓ 1.0 33 1

Seq Scan on source_material_types (cost=0.00..1.32 rows=32 width=8) (actual time=0.016..0.019 rows=33 loops=1)

146. 0.003 0.023 ↑ 1.0 1 1

Hash (cost=1.07..1.07 rows=1 width=4) (actual time=0.023..0.023 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
147. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on categories (cost=0.00..1.07 rows=1 width=4) (actual time=0.019..0.020 rows=1 loops=1)

  • Filter: ((name)::text = 'video'::text)
  • Rows Removed by Filter: 5
148. 6.440 7.252 ↓ 5.4 1,969 4

Bitmap Heap Scan on alpha_source_materials alpha_sm (cost=15.24..553.03 rows=368 width=24) (actual time=0.327..1.813 rows=1,969 loops=4)

  • Recheck Cond: (source_material_type_id = source_material_types.id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 60
  • Heap Blocks: exact=976
149. 0.812 0.812 ↓ 5.3 2,029 4

Bitmap Index Scan on index_alpha_source_materials_on_source_material_type_id (cost=0.00..15.15 rows=382 width=0) (actual time=0.203..0.203 rows=2,029 loops=4)

  • Index Cond: (source_material_type_id = source_material_types.id)
150. 23.631 23.631 ↑ 2.0 4 7,877

Index Scan using index_loc_job_source_materials_on_alpha_source_material_id on loc_job_source_materials (cost=0.29..0.58 rows=8 width=8) (actual time=0.002..0.003 rows=4 loops=7,877)

  • Index Cond: (alpha_source_material_id = alpha_sm.id)
151. 63.060 63.060 ↑ 1.0 1 31,530

Index Scan using localization_jobs_pkey on localization_jobs localization_jobs_1 (cost=0.29..0.45 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=31,530)

  • Index Cond: (id = loc_job_source_materials.localization_job_id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 0
152. 0.000 0.010 ↓ 0.0 0 1

Hash (cost=19.70..19.70 rows=970 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
153. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on localization_job_groups (cost=0.00..19.70 rows=970 width=36) (actual time=0.010..0.010 rows=0 loops=1)

154. 1.054 2.829 ↑ 1.0 4,221 1

Hash (cost=155.56..155.56 rows=4,221 width=105) (actual time=2.829..2.829 rows=4,221 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 355kB
155. 1.129 1.775 ↑ 1.0 4,221 1

Hash Left Join (cost=1.36..155.56 rows=4,221 width=105) (actual time=0.043..1.775 rows=4,221 loops=1)

  • Hash Cond: (client_manager.id = client_manager_contact.user_id)
156. 0.626 0.626 ↑ 1.0 4,221 1

Seq Scan on users client_manager (cost=0.00..138.21 rows=4,221 width=37) (actual time=0.011..0.626 rows=4,221 loops=1)

157. 0.007 0.020 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=72) (actual time=0.019..0.020 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
158. 0.013 0.013 ↑ 1.0 16 1

Seq Scan on client_contacts client_manager_contact (cost=0.00..1.16 rows=16 width=72) (actual time=0.010..0.013 rows=16 loops=1)

159. 0.096 0.183 ↑ 1.0 401 1

Hash (cost=11.01..11.01 rows=401 width=18) (actual time=0.183..0.183 rows=401 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
160. 0.087 0.087 ↑ 1.0 401 1

Seq Scan on contacts (cost=0.00..11.01 rows=401 width=18) (actual time=0.011..0.087 rows=401 loops=1)

161. 0.641 1.563 ↑ 1.0 2,109 1

Hash (cost=65.10..65.10 rows=2,110 width=24) (actual time=1.563..1.563 rows=2,109 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 153kB
162. 0.922 0.922 ↑ 1.0 2,110 1

Seq Scan on individuals (cost=0.00..65.10 rows=2,110 width=24) (actual time=0.017..0.922 rows=2,110 loops=1)

163. 0.082 0.175 ↑ 1.0 154 1

Hash (cost=3.54..3.54 rows=154 width=8) (actual time=0.175..0.175 rows=154 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
164. 0.093 0.093 ↑ 1.0 154 1

Seq Scan on currencies (cost=0.00..3.54 rows=154 width=8) (actual time=0.024..0.093 rows=154 loops=1)

165. 0.004 0.023 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=36) (actual time=0.023..0.023 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
166. 0.019 0.019 ↑ 1.0 8 1

Seq Scan on unit_of_measures (cost=0.00..1.08 rows=8 width=36) (actual time=0.017..0.019 rows=8 loops=1)

167. 0.003 0.019 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=36) (actual time=0.019..0.019 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
168. 0.016 0.016 ↑ 1.0 5 1

Seq Scan on priorities (cost=0.00..1.05 rows=5 width=36) (actual time=0.015..0.016 rows=5 loops=1)

169. 0.011 0.032 ↑ 1.0 33 1

Hash (cost=1.33..1.33 rows=33 width=36) (actual time=0.031..0.032 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
170. 0.021 0.021 ↑ 1.0 33 1

Seq Scan on client_teams (cost=0.00..1.33 rows=33 width=36) (actual time=0.016..0.021 rows=33 loops=1)

171. 0.017 0.036 ↑ 1.0 48 1

Hash (cost=1.48..1.48 rows=48 width=36) (actual time=0.036..0.036 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
172. 0.019 0.019 ↑ 1.0 48 1

Seq Scan on clients bill_to_client (cost=0.00..1.48 rows=48 width=36) (actual time=0.011..0.019 rows=48 loops=1)

173. 9.594 23.392 ↑ 1.0 42,270 1

Hash (cost=863.30..863.30 rows=42,302 width=8) (actual time=23.391..23.392 rows=42,270 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2161kB
174. 13.798 13.798 ↓ 1.0 42,316 1

Seq Scan on localization_job_deliverables (cost=0.00..863.30 rows=42,302 width=8) (actual time=0.019..13.798 rows=42,316 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 1214
175. 0.009 0.026 ↓ 1.0 25 1

Hash (cost=1.24..1.24 rows=24 width=36) (actual time=0.025..0.026 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
176. 0.017 0.017 ↓ 1.0 25 1

Seq Scan on localization_job_deliverable_types (cost=0.00..1.24 rows=24 width=36) (actual time=0.014..0.017 rows=25 loops=1)

177.          

SubPlan (forGroupAggregate)

178. 3.991 3.991 ↑ 1.0 1 3,991

Index Scan using vendors_pkey on vendors vendors_1 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=3,991)

  • Index Cond: (id = translation.assignee_id)
179. 3.290 3.290 ↑ 1.0 1 1,645

Index Scan using individuals_pkey on individuals individuals_1 (cost=0.28..8.30 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1,645)

  • Index Cond: (id = translation.assignee_id)
180. 7.982 7.982 ↑ 1.0 1 3,991

Index Scan using vendors_pkey on vendors vendors_2 (cost=0.28..8.29 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=3,991)

  • Index Cond: (id = translation.assignee_id)
181. 0.463 0.463 ↑ 1.0 1 463

Index Scan using vendors_pkey on vendors vendors_3 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=463)

  • Index Cond: (id = linguistic_qc.assignee_id)
182. 1.244 1.244 ↑ 1.0 1 622

Index Scan using individuals_pkey on individuals individuals_2 (cost=0.28..8.30 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=622)

  • Index Cond: (id = linguistic_qc.assignee_id)
183. 0.926 0.926 ↑ 1.0 1 463

Index Scan using vendors_pkey on vendors vendors_4 (cost=0.28..8.29 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=463)

  • Index Cond: (id = linguistic_qc.assignee_id)
184. 19.813 19.813 ↑ 1.0 1 19,813

Index Scan using vendors_pkey on vendors vendors_5 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=19,813)

  • Index Cond: (id = postprocessing.assignee_id)
185. 0.000 0.000 ↓ 0.0 0

Index Scan using individuals_pkey on individuals individuals_3 (cost=0.28..8.30 rows=1 width=32) (never executed)

  • Index Cond: (id = postprocessing.assignee_id)
186. 3.991 3.991 ↑ 1.0 1 3,991

Index Scan using vendors_pkey on vendors vendors_6 (cost=0.28..8.29 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=3,991)

  • Index Cond: (id = translation.assignee_id)
187. 0.463 0.463 ↑ 1.0 1 463

Index Scan using vendors_pkey on vendors vendors_7 (cost=0.28..8.29 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=463)

  • Index Cond: (id = linguistic_qc.assignee_id)
188. 19.813 19.813 ↑ 1.0 1 19,813

Index Scan using vendors_pkey on vendors vendors_8 (cost=0.28..8.29 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=19,813)

  • Index Cond: (id = postprocessing.assignee_id)