explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MgSU

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 638.864 ↓ 0.0 0 1

Limit (cost=619.15..619.54 rows=2 width=711) (actual time=638.864..638.864 rows=0 loops=1)

2. 0.001 638.863 ↓ 0.0 0 1

GroupAggregate (cost=619.15..619.52 rows=2 width=711) (actual time=638.863..638.863 rows=0 loops=1)

  • Group Key: localization_jobs.id
3. 0.021 638.862 ↓ 0.0 0 1

Sort (cost=619.15..619.15 rows=2 width=606) (actual time=638.862..638.862 rows=0 loops=1)

  • Sort Key: localization_jobs.id
  • Sort Method: quicksort Memory: 25kB
4. 0.001 638.841 ↓ 0.0 0 1

Nested Loop Left Join (cost=301.38..619.14 rows=2 width=606) (actual time=638.841..638.841 rows=0 loops=1)

5. 0.001 638.840 ↓ 0.0 0 1

Nested Loop Left Join (cost=301.09..593.05 rows=2 width=602) (actual time=638.840..638.840 rows=0 loops=1)

6. 0.000 638.839 ↓ 0.0 0 1

Nested Loop Left Join (cost=289.48..569.78 rows=2 width=594) (actual time=638.839..638.839 rows=0 loops=1)

7. 0.001 638.839 ↓ 0.0 0 1

Nested Loop Left Join (cost=251.79..494.35 rows=2 width=594) (actual time=638.839..638.839 rows=0 loops=1)

8. 203.699 638.838 ↓ 0.0 0 1

Nested Loop Left Join (cost=251.51..469.74 rows=2 width=594) (actual time=638.838..638.838 rows=0 loops=1)

  • Join Filter: (alphas.financial_recognition_office_id = vendor_locations.id)
  • Rows Removed by Join Filter: 654398
  • Filter: (((localization_job_groups.name)::text ~~* '%yes%'::text) OR ((languages.name)::text ~~* '%yes%'::text) OR ((service_types.name)::text ~~* '%yes%'::text) OR ((localization_configurations.name)::text ~~* '%yes%'::text) OR ((localization_job_types.name)::text ~~* '%yes%'::text) OR ((localization_jobs.content_spec)::text ~~* '%yes%'::text) OR ((batches.name)::text ~~* '%yes%'::text) OR ((CASE WHEN (states.name IS NULL) THEN concat(vendor_locations.city, ', ', countries.name) ELSE concat(vendor_locations.city, ', ', states.name, ', ', countries.name) END) ~~* '%yes%'::text) OR ((users.id)::text ~~* '%yes%'::text) OR ((alphas.is_vip_workflow)::text ~~* '%yes%'::text) OR ((localization_jobs.milestone)::text ~~* '%yes%'::text) OR ((source_materials.root_source_material_id)::text ~~* '%yes%'::text) OR ((localization_jobs.parent_job_id)::text ~~* '%yes%'::text) OR ((reference_materials.root_source_material_id)::text ~~* '%yes%'::text) OR ((localization_jobs.production_status)::text ~~* '%yes%'::text) OR ((localization_jobs.post_processing_qc)::text ~~* '%yes%'::text) OR (localization_jobs.notes ~~* '%yes%'::text))
  • Rows Removed by Filter: 17221
9. 23.515 383.476 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=247.06..441.90 rows=5 width=574) (actual time=3.386..383.476 rows=17,221 loops=1)

  • Join Filter: (search_reference_material_type.category_id = reference_material_categories.id)
  • Rows Removed by Join Filter: 43856
10. 10.958 359.961 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=247.06..440.43 rows=5 width=569) (actual time=3.362..359.961 rows=17,221 loops=1)

11. 16.507 331.782 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=246.36..396.47 rows=5 width=532) (actual time=3.338..331.782 rows=17,221 loops=1)

12. 20.260 298.054 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=246.22..395.68 rows=5 width=520) (actual time=3.315..298.054 rows=17,221 loops=1)

13. 17.321 260.573 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=246.08..394.87 rows=5 width=511) (actual time=3.288..260.573 rows=17,221 loops=1)

14. 19.829 208.810 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=245.79..388.69 rows=5 width=447) (actual time=3.241..208.810 rows=17,221 loops=1)

15. 17.160 171.760 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=245.65..387.89 rows=5 width=439) (actual time=3.229..171.760 rows=17,221 loops=1)

16. 26.108 137.379 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=245.51..387.09 rows=5 width=430) (actual time=3.209..137.379 rows=17,221 loops=1)

17. 12.799 76.829 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=245.22..385.45 rows=5 width=361) (actual time=3.180..76.829 rows=17,221 loops=1)

18. 7.473 29.588 ↓ 3,444.2 17,221 1

Nested Loop Left Join (cost=244.94..383.67 rows=5 width=342) (actual time=3.156..29.588 rows=17,221 loops=1)

19. 0.622 8.219 ↓ 154.4 772 1

Nested Loop Left Join (cost=244.65..340.00 rows=5 width=334) (actual time=3.124..8.219 rows=772 loops=1)

20. 1.408 6.053 ↓ 154.4 772 1

Nested Loop Left Join (cost=244.38..302.49 rows=5 width=293) (actual time=3.085..6.053 rows=772 loops=1)

  • Join Filter: (alphas.id = alphas_users.alpha_id)
21. 1.621 4.645 ↓ 154.4 772 1

Hash Right Join (cost=243.54..285.51 rows=5 width=238) (actual time=2.939..4.645 rows=772 loops=1)

  • Hash Cond: (loc_job_reference_materials.localization_job_id = localization_jobs.id)
22. 0.416 0.416 ↑ 1.0 2,179 1

Seq Scan on loc_job_reference_materials (cost=0.00..33.79 rows=2,179 width=8) (actual time=0.009..0.416 rows=2,179 loops=1)

23. 0.061 2.608 ↓ 14.4 72 1

Hash (cost=243.47..243.47 rows=5 width=230) (actual time=2.608..2.608 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
24. 0.198 2.547 ↓ 14.4 72 1

Hash Right Join (cost=213.61..243.47 rows=5 width=230) (actual time=2.282..2.547 rows=72 loops=1)

  • Hash Cond: (batches.id = localization_jobs.batch_id)
25. 0.099 0.099 ↑ 1.0 951 1

Seq Scan on batches (cost=0.00..21.51 rows=951 width=48) (actual time=0.007..0.099 rows=951 loops=1)

26. 0.053 2.250 ↓ 14.4 72 1

Hash (cost=213.55..213.55 rows=5 width=190) (actual time=2.250..2.250 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
27. 0.148 2.197 ↓ 14.4 72 1

Hash Right Join (cost=197.10..213.55 rows=5 width=190) (actual time=2.165..2.197 rows=72 loops=1)

  • Hash Cond: (localization_job_groups.id = localization_jobs.localization_job_group_id)
28. 0.068 0.068 ↓ 1.0 611 1

Seq Scan on localization_job_groups (cost=0.00..11.10 rows=610 width=15) (actual time=0.007..0.068 rows=611 loops=1)

29. 0.070 1.981 ↓ 14.4 72 1

Hash (cost=197.04..197.04 rows=5 width=183) (actual time=1.981..1.981 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
30. 0.010 1.911 ↓ 14.4 72 1

Nested Loop Left Join (cost=8.55..197.04 rows=5 width=183) (actual time=0.985..1.911 rows=72 loops=1)

  • Join Filter: (localization_jobs.alpha_id = alphas.id)
31. 0.016 1.829 ↓ 14.4 72 1

Nested Loop Left Join (cost=8.26..188.66 rows=5 width=178) (actual time=0.949..1.829 rows=72 loops=1)

  • Join Filter: (localization_jobs.localization_job_type_id = localization_job_types.id)
  • Rows Removed by Join Filter: 58
32. 0.126 1.741 ↓ 14.4 72 1

Nested Loop Left Join (cost=8.26..186.43 rows=5 width=144) (actual time=0.920..1.741 rows=72 loops=1)

  • Join Filter: (localization_jobs.localization_configuration_id = localization_configurations.id)
  • Rows Removed by Join Filter: 781
33. 0.047 0.751 ↓ 14.4 72 1

Nested Loop Left Join (cost=8.26..183.77 rows=5 width=130) (actual time=0.124..0.751 rows=72 loops=1)

  • Join Filter: (localization_jobs.service_type_id = service_types.id)
  • Rows Removed by Join Filter: 220
34. 0.070 0.632 ↓ 14.4 72 1

Hash Left Join (cost=8.26..182.31 rows=5 width=118) (actual time=0.099..0.632 rows=72 loops=1)

  • Hash Cond: (localization_jobs.language_id = languages.id)
35. 0.303 0.525 ↓ 14.4 72 1

Nested Loop Left Join (cost=4.64..178.63 rows=5 width=109) (actual time=0.041..0.525 rows=72 loops=1)

36. 0.078 0.078 ↓ 14.4 72 1

Index Scan using index_jobs_on_alpha_id_deleted_null on localization_jobs (cost=0.29..22.35 rows=5 width=105) (actual time=0.027..0.078 rows=72 loops=1)

  • Index Cond: (alpha_id = 1138)
37. 0.000 0.144 ↓ 0.0 0 72

Bitmap Heap Scan on localization_jobs dependent_jobs (cost=4.35..31.19 rows=7 width=8) (actual time=0.002..0.002 rows=0 loops=72)

  • Recheck Cond: (parent_job_id = localization_jobs.id)
  • Filter: (deleted_at IS NULL)
  • Heap Blocks: exact=1
38. 0.144 0.144 ↓ 0.0 0 72

Bitmap Index Scan on index_localization_jobs_on_parent_job_id (cost=0.00..4.35 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=72)

  • Index Cond: (parent_job_id = localization_jobs.id)
39. 0.016 0.037 ↑ 1.0 72 1

Hash (cost=2.72..2.72 rows=72 width=17) (actual time=0.037..0.037 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
40. 0.021 0.021 ↑ 1.0 72 1

Seq Scan on languages (cost=0.00..2.72 rows=72 width=17) (actual time=0.008..0.021 rows=72 loops=1)

41. 0.067 0.072 ↑ 1.5 4 72

Materialize (cost=0.00..1.09 rows=6 width=16) (actual time=0.000..0.001 rows=4 loops=72)

42. 0.005 0.005 ↑ 1.0 6 1

Seq Scan on service_types (cost=0.00..1.06 rows=6 width=16) (actual time=0.004..0.005 rows=6 loops=1)

43. 0.835 0.864 ↑ 1.6 12 72

Materialize (cost=0.00..1.28 rows=19 width=22) (actual time=0.011..0.012 rows=12 loops=72)

44. 0.029 0.029 ↑ 1.1 17 1

Seq Scan on localization_configurations (cost=0.00..1.19 rows=19 width=22) (actual time=0.023..0.029 rows=17 loops=1)

45. 0.061 0.072 ↑ 7.0 2 72

Materialize (cost=0.00..1.21 rows=14 width=42) (actual time=0.000..0.001 rows=2 loops=72)

46. 0.011 0.011 ↑ 1.1 13 1

Seq Scan on localization_job_types (cost=0.00..1.14 rows=14 width=42) (actual time=0.007..0.011 rows=13 loops=1)

47. 0.048 0.072 ↑ 1.0 1 72

Materialize (cost=0.29..8.31 rows=1 width=9) (actual time=0.001..0.001 rows=1 loops=72)

48. 0.024 0.024 ↑ 1.0 1 1

Index Scan using alphas_pkey on alphas (cost=0.29..8.30 rows=1 width=9) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: (id = 1138)
  • Filter: (deleted_at IS NULL)
49. 0.000 0.000 ↑ 1.0 1 772

Materialize (cost=0.84..16.91 rows=1 width=59) (actual time=0.000..0.000 rows=1 loops=772)

50. 0.003 0.139 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.84..16.91 rows=1 width=59) (actual time=0.137..0.139 rows=1 loops=1)

51. 0.005 0.032 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.56..16.60 rows=1 width=45) (actual time=0.030..0.032 rows=1 loops=1)

52. 0.014 0.014 ↑ 1.0 1 1

Index Scan using index_alphas_users_on_alpha_id on alphas_users (cost=0.28..8.30 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (alpha_id = 1138)
53. 0.013 0.013 ↑ 1.0 1 1

Index Scan using users_pkey on users (cost=0.28..8.30 rows=1 width=41) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (alphas_users.user_id = id)
54. 0.104 0.104 ↑ 1.0 1 1

Index Scan using contacts_pkey on contacts (cost=0.28..0.30 rows=1 width=18) (actual time=0.104..0.104 rows=1 loops=1)

  • Index Cond: (id = users.contact_id)
55. 1.544 1.544 ↓ 0.0 0 772

Index Scan using index_netflix_jobs_on_localization_job_id on netflix_jobs (cost=0.28..7.49 rows=1 width=45) (actual time=0.002..0.002 rows=0 loops=772)

  • Index Cond: (localization_jobs.id = localization_job_id)
56. 13.896 13.896 ↓ 11.0 22 772

Index Scan using index_loc_job_source_materials_on_localization_job_id on loc_job_source_materials (cost=0.29..8.71 rows=2 width=8) (actual time=0.003..0.018 rows=22 loops=772)

  • Index Cond: (localization_job_id = localization_jobs.id)
57. 34.442 34.442 ↓ 0.0 0 17,221

Index Scan using index_individuals_on_user_id on individuals (cost=0.28..0.35 rows=1 width=23) (actual time=0.002..0.002 rows=0 loops=17,221)

  • Index Cond: (user_id = users.id)
58. 34.442 34.442 ↑ 1.0 1 17,221

Index Scan using alpha_source_materials_pkey on alpha_source_materials source_materials (cost=0.29..0.33 rows=1 width=69) (actual time=0.002..0.002 rows=1 loops=17,221)

  • Index Cond: (id = loc_job_source_materials.alpha_source_material_id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 0
59. 17.221 17.221 ↑ 1.0 1 17,221

Index Scan using languages_pkey on languages source_material_language (cost=0.14..0.16 rows=1 width=17) (actual time=0.001..0.001 rows=1 loops=17,221)

  • Index Cond: (source_materials.language_id = id)
60. 17.221 17.221 ↑ 1.0 1 17,221

Index Scan using source_material_types_pkey on source_material_types search_source_material_type (cost=0.14..0.16 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=17,221)

  • Index Cond: (source_materials.source_material_type_id = id)
61. 34.442 34.442 ↑ 1.0 1 17,221

Index Scan using alpha_source_materials_pkey on alpha_source_materials reference_materials (cost=0.29..1.24 rows=1 width=64) (actual time=0.002..0.002 rows=1 loops=17,221)

  • Index Cond: (id = loc_job_reference_materials.alpha_source_material_id)
  • Filter: (deleted_at IS NULL)
62. 17.221 17.221 ↑ 1.0 1 17,221

Index Scan using languages_pkey on languages reference_material_language (cost=0.14..0.16 rows=1 width=17) (actual time=0.001..0.001 rows=1 loops=17,221)

  • Index Cond: (reference_materials.language_id = id)
63. 17.221 17.221 ↑ 1.0 1 17,221

Index Scan using source_material_types_pkey on source_material_types search_reference_material_type (cost=0.14..0.16 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=17,221)

  • Index Cond: (reference_materials.source_material_type_id = id)
64. 0.000 17.221 ↓ 0.0 0 17,221

Nested Loop (cost=0.71..8.78 rows=1 width=37) (actual time=0.001..0.001 rows=0 loops=17,221)

65. 17.215 17.221 ↓ 0.0 0 17,221

Nested Loop (cost=0.57..8.63 rows=1 width=64) (actual time=0.001..0.001 rows=0 loops=17,221)

66. 0.000 0.000 ↓ 0.0 0 17,221

Nested Loop (cost=0.42..8.47 rows=1 width=55) (actual time=0.000..0.000 rows=0 loops=17,221)

67. 0.000 0.000 ↓ 0.0 0 17,221

Index Scan using localization_jobs_pkey on localization_jobs localization_jobs_1 (cost=0.29..8.31 rows=1 width=47) (actual time=0.000..0.000 rows=0 loops=17,221)

  • Index Cond: (id = localization_jobs.parent_job_id)
  • Filter: (deleted_at IS NULL)
68. 0.009 0.009 ↑ 1.0 1 3

Index Scan using service_types_pkey on service_types service_types_1 (cost=0.13..0.15 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=3)

  • Index Cond: (id = localization_jobs_1.service_type_id)
69. 0.006 0.006 ↑ 1.0 1 3

Index Scan using languages_pkey on languages languages_1 (cost=0.14..0.16 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (id = localization_jobs_1.language_id)
70. 0.042 0.042 ↑ 1.0 1 3

Index Scan using localization_configurations_pkey on localization_configurations localization_configurations_1 (cost=0.14..0.16 rows=1 width=22) (actual time=0.014..0.014 rows=1 loops=3)

  • Index Cond: (id = localization_jobs_1.localization_configuration_id)
71. 0.000 0.000 ↑ 1.5 4 17,221

Materialize (cost=0.00..1.09 rows=6 width=13) (actual time=0.000..0.000 rows=4 loops=17,221)

72. 0.012 0.012 ↑ 1.0 6 1

Seq Scan on categories reference_material_categories (cost=0.00..1.06 rows=6 width=13) (actual time=0.009..0.012 rows=6 loops=1)

73. 50.532 51.663 ↓ 39.0 39 17,221

Materialize (cost=4.45..27.37 rows=1 width=36) (actual time=0.000..0.003 rows=39 loops=17,221)

74. 0.052 1.131 ↓ 39.0 39 1

Nested Loop Left Join (cost=4.45..27.36 rows=1 width=36) (actual time=0.783..1.131 rows=39 loops=1)

75. 0.029 1.040 ↓ 39.0 39 1

Nested Loop (cost=4.31..27.16 rows=1 width=29) (actual time=0.757..1.040 rows=39 loops=1)

76. 0.025 0.933 ↓ 39.0 39 1

Nested Loop (cost=4.16..26.91 rows=1 width=21) (actual time=0.723..0.933 rows=39 loops=1)

77. 0.184 0.184 ↑ 1.0 1 1

Seq Scan on vendors (cost=0.00..17.70 rows=1 width=4) (actual time=0.009..0.184 rows=1 loops=1)

  • Filter: is_pixelogic
  • Rows Removed by Filter: 769
78. 0.033 0.724 ↓ 19.5 39 1

Bitmap Heap Scan on vendor_locations (cost=4.16..9.19 rows=2 width=25) (actual time=0.706..0.724 rows=39 loops=1)

  • Recheck Cond: (vendor_id = vendors.id)
  • Heap Blocks: exact=8
79. 0.691 0.691 ↓ 19.5 39 1

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

  • Index Cond: (vendor_id = vendors.id)
80. 0.078 0.078 ↑ 1.0 1 39

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

  • Index Cond: (id = vendor_locations.country_id)
81. 0.039 0.039 ↓ 0.0 0 39

Index Scan using states_pkey on states (cost=0.14..0.19 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=39)

  • Index Cond: (id = vendor_locations.state_id)
82. 0.000 0.000 ↓ 0.0 0

Index Scan using subtitle_files_pkey on subtitle_files latest_subtitle_file (cost=0.28..8.30 rows=1 width=8) (never executed)

  • Index Cond: (id = localization_jobs.last_subtitle_file_id)
83. 0.000 0.000 ↓ 0.0 0

Limit (cost=37.69..37.70 rows=1 width=530) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Sort (cost=37.69..37.70 rows=1 width=530) (never executed)

  • Sort Key: subtitle_files.approved_at DESC NULLS LAST
85. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.15..37.68 rows=1 width=530) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..36.86 rows=1 width=4) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..36.54 rows=1 width=4) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Index Scan using index_localization_assignments_on_localization_job_id on localization_assignments (cost=0.29..11.59 rows=3 width=4) (never executed)

  • Index Cond: (localization_job_id = localization_jobs_1.id)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_l10n_assignments_output_assets_on_l10n_assignment_id on localization_assignments_output_assets laoa (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (localization_assignment_id = localization_assignments.id)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using localization_assets_pkey on localization_assets (cost=0.29..0.32 rows=1 width=8) (never executed)

  • Index Cond: (id = laoa.localization_asset_id)
  • Filter: ((localization_assetable_type)::text = 'SubtitleFile'::text)
91. 0.000 0.000 ↓ 0.0 0

Index Scan using subtitle_files_pkey on subtitle_files (cost=0.28..0.82 rows=1 width=12) (never executed)

  • Index Cond: (id = localization_assets.localization_assetable_id)
92. 0.000 0.000 ↓ 0.0 0

Limit (cost=11.61..11.61 rows=1 width=332) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Sort (cost=11.61..11.61 rows=1 width=332) (never executed)

  • Sort Key: localization_assignments_1.assignee_id DESC NULLS LAST
94. 0.000 0.000 ↓ 0.0 0

Index Scan using index_localization_assignments_on_localization_job_id on localization_assignments localization_assignments_1 (cost=0.29..11.60 rows=1 width=332) (never executed)

  • Index Cond: (localization_job_id = localization_jobs.id)
  • Filter: ((deleted_at IS NULL) AND ((status)::text <> 'created'::text))
95. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.29..13.02 rows=1 width=332) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..13.02 rows=1 width=332) (never executed)

  • Join Filter: (localization_assignments_2.localization_assignment_type_id = lat.id)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using index_localization_assignments_on_localization_job_id on localization_assignments localization_assignments_2 (cost=0.29..11.60 rows=1 width=8) (never executed)

  • Index Cond: (localization_job_id = localization_jobs.id)
  • Filter: ((deleted_at IS NULL) AND ((status)::text = 'open'::text))
98. 0.000 0.000 ↓ 0.0 0

Seq Scan on localization_assignment_types lat (cost=0.00..1.41 rows=1 width=4) (never executed)

  • Filter: ((name)::text = 'translation'::text)