explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rN5r

Settings
# exclusive inclusive rows x rows loops node
1. 14.125 194.391 ↓ 23.1 11,508 1

Gather Merge (cost=154,562.34..154,620.44 rows=498 width=1,311) (actual time=185.515..194.391 rows=11,508 loops=1)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, entity_value.entity_reference_value_uuid, entity_refer (...)
  • Workers Planned: 2
  • Workers Launched: 2
2. 6.181 180.266 ↓ 15.4 3,836 3 / 3

Sort (cost=153,562.31..153,562.93 rows=249 width=1,311) (actual time=179.109..180.266 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, entity_value.entity_reference_value_uuid, entity (...)
  • Sort Key: entity_value.created_at
  • Sort Method: quicksort Memory: 883kB
  • Worker 0: Sort Method: quicksort Memory: 907kB
  • Worker 1: Sort Method: quicksort Memory: 879kB
  • Worker 0: actual time=177.381..178.616 rows=3991 loops=1
  • Worker 1: actual time=177.408..178.607 rows=3738 loops=1
3. 4.298 174.085 ↓ 15.4 3,836 3 / 3

Nested Loop Left Join (cost=7.61..153,552.40 rows=249 width=1,311) (actual time=1.038..174.085 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, entity_value.entity_reference_value_uuid, (...)
  • Worker 0: actual time=0.157..172.497 rows=3991 loops=1
  • Worker 1: actual time=0.158..172.509 rows=3738 loops=1
4. 6.261 165.951 ↓ 15.4 3,836 3 / 3

Nested Loop Left Join (cost=7.19..153,408.56 rows=249 width=1,275) (actual time=1.028..165.951 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, entity_value.entity_reference_value_ (...)
  • Worker 0: actual time=0.148..164.341 rows=3991 loops=1
  • Worker 1: actual time=0.146..164.494 rows=3738 loops=1
  • -> Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translations.translation_unit referenced_workflow_status_translation_unit (cost=0.42..1.84 rows=1 width=81) (actual time=0.000..0.000 rows=0 loops=11508 (...)
5. 5.864 159.690 ↓ 15.4 3,836 3 / 3

Nested Loop Left Join (cost=6.77..152,947.03 rows=249 width=1,210) (actual time=1.021..159.690 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, entity_value.entity_reference_ (...)
  • Inner Unique: true
  • Worker 0: actual time=0.140..157.969 rows=3991 loops=1
  • Worker 1: actual time=0.138..158.366 rows=3738 loops=1
  • Output: referenced_workflow_status_translation_unit.uuid, referenced_workflow_status_translation_unit.company_id, referenced_workflow_status_translation_unit.item_uuid, referenced_workflow_status_translation_unit.item_type, refere (...)
  • Index Cond: ((referenced_workflow_status_translation_unit.item_uuid = workflow_status_value.uuid) AND (referenced_workflow_status_translation_unit.item_property_type = 'name'::text))
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
6. 5.770 153.826 ↓ 15.4 3,836 3 / 3

Nested Loop Left Join (cost=6.49..152,872.94 rows=249 width=1,056) (actual time=1.015..153.826 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, entity_value.entity_refe (...)
  • Inner Unique: true
  • Worker 0: actual time=0.133..151.989 rows=3991 loops=1
  • Worker 1: actual time=0.131..152.720 rows=3738 loops=1
7. 5.768 148.056 ↓ 15.4 3,836 3 / 3

Nested Loop Left Join (cost=6.21..152,799.47 rows=249 width=930) (actual time=1.009..148.056 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, entity_value.entit (...)
  • Inner Unique: true
  • Worker 0: actual time=0.126..146.040 rows=3991 loops=1
  • Worker 1: actual time=0.124..147.002 rows=3738 loops=1
8. 5.605 142.288 ↓ 15.4 3,836 3 / 3

Nested Loop Left Join (cost=5.78..152,640.91 rows=249 width=887) (actual time=1.004..142.288 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, entity_value (...)
  • Worker 0: actual time=0.120..140.143 rows=3991 loops=1
  • Worker 1: actual time=0.118..141.421 rows=3738 loops=1
9. 5.661 136.683 ↓ 15.4 3,836 3 / 3

Nested Loop Left Join (cost=5.36..152,514.56 rows=249 width=915) (actual time=0.998..136.683 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, entity (...)
  • Worker 0: actual time=0.112..134.364 rows=3991 loops=1
  • Worker 1: actual time=0.111..136.044 rows=3738 loops=1
  • -> Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translations.translation_unit referenced_select_option_translation_unit (cost=0.42..0.61 rows=2 width=81) (actual time=0.0 (...)
10. 5.782 131.022 ↓ 27.0 3,836 3 / 3

Nested Loop Left Join (cost=4.94..152,425.68 rows=142 width=850) (actual time=0.993..131.022 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_type, (...)
  • Inner Unique: true
  • Worker 0: actual time=0.106..128.619 rows=3991 loops=1
  • Worker 1: actual time=0.105..130.579 rows=3738 loops=1
  • Output: referenced_select_option_translation_unit.uuid, referenced_select_option_translation_unit.company_id, referenced_select_option_translation_unit.item_uuid, referenced_select_option_translation_ (...)
  • Index Cond: (referenced_select_option_translation_unit.item_uuid = referenced_select_option.uuid)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
11. 5.565 125.240 ↓ 27.0 3,836 3 / 3

Nested Loop Left Join (cost=4.65..152,381.92 rows=142 width=832) (actual time=0.987..125.240 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_field_ (...)
  • Inner Unique: true
  • Worker 0: actual time=0.101..122.905 rows=3991 loops=1
  • Worker 1: actual time=0.099..124.858 rows=3738 loops=1
12. 5.642 119.675 ↓ 27.0 3,836 3 / 3

Nested Loop Left Join (cost=4.22..152,264.51 rows=142 width=760) (actual time=0.980..119.675 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.entity_ (...)
  • Worker 0: actual time=0.092..117.218 rows=3991 loops=1
  • Worker 1: actual time=0.091..119.369 rows=3738 loops=1
13. 6.703 114.033 ↓ 27.0 3,836 3 / 3

Nested Loop Left Join (cost=3.80..152,180.63 rows=142 width=675) (actual time=0.975..114.033 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_value.e (...)
  • Filter: ((workflow_status_translation.locale = 'en-US'::text) OR (workflow_status_translation.locale IS NULL))
  • Worker 0: actual time=0.086..111.389 rows=3991 loops=1
  • Worker 1: actual time=0.084..113.887 rows=3738 loops=1
  • -> Index Scan using ux_translation_key_locale on translations.translation workflow_status_translation (cost=0.42..0.56 rows=1 width=102) (actual time=0.001..0.001 rows=0 loops=1150 (...)
14. 6.073 107.330 ↓ 21.3 3,836 3 / 3

Nested Loop Left Join (cost=3.38..152,077.10 rows=180 width=703) (actual time=0.969..107.330 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, entity_v (...)
  • Worker 0: actual time=0.080..104.577 rows=3991 loops=1
  • Worker 1: actual time=0.078..107.179 rows=3738 loops=1
  • -> Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translations.translation_unit workflow_status_translation_unit (cost=0.42..1.84 rows=1 width (...)
  • Output: workflow_status_translation.uuid, workflow_status_translation.company_id, workflow_status_translation.translation_key, workflow_status_translation.locale, workflow_stat (...)
  • Index Cond: (workflow_status_translation_unit.translation_key = workflow_status_translation.translation_key)
  • Worker 0: actual time=0.000..0.001 rows=0 loops=3991
  • Worker 1: actual time=0.001..0.001 rows=0 loops=3738
15. 11.520 101.257 ↓ 21.3 3,836 3 / 3

Nested Loop Left Join (cost=2.96..151,743.46 rows=180 width=638) (actual time=0.964..101.257 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_type, en (...)
  • Filter: ((select_option_translation.locale = 'en-US'::text) OR (select_option_translation.locale IS NULL))
  • Worker 0: actual time=0.074..98.335 rows=3991 loops=1
  • Worker 1: actual time=0.072..101.202 rows=3738 loops=1
  • -> Index Scan using ux_translation_key_locale on translations.translation select_option_translation (cost=0.42..0.50 rows=1 width=102) (actual time=0.002..0.002 rows=0 (...)
  • Output: workflow_status_translation_unit.uuid, workflow_status_translation_unit.company_id, workflow_status_translation_unit.item_uuid, workflow_status_translation_unit.i (...)
  • Index Cond: ((workflow_status_translation_unit.item_uuid = workflow_status_value.uuid) AND (workflow_status_translation_unit.item_property_type = 'name'::text))
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
16. 7.993 89.737 ↓ 16.8 3,836 3 / 3

Nested Loop Left Join (cost=2.54..151,627.20 rows=228 width=666) (actual time=0.959..89.737 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.data_ty (...)
  • Worker 0: actual time=0.067..86.358 rows=3991 loops=1
  • Worker 1: actual time=0.066..89.584 rows=3738 loops=1
  • -> Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translations.translation_unit select_option_translation_unit (cost=0.42..0.61 ro (...)
  • Output: select_option_translation.uuid, select_option_translation.company_id, select_option_translation.translation_key, select_option_translation.locale, select_op (...)
  • Index Cond: (select_option_translation_unit.translation_key = select_option_translation.translation_key)
  • Worker 0: actual time=0.002..0.002 rows=0 loops=3991
  • Worker 1: actual time=0.002..0.002 rows=0 loops=3738
17. 5.783 81.744 ↓ 29.5 3,836 3 / 3

Nested Loop Left Join (cost=2.12..151,545.82 rows=130 width=601) (actual time=0.954..81.744 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_value.d (...)
  • Inner Unique: true
  • Worker 0: actual time=0.061..78.182 rows=3991 loops=1
  • Worker 1: actual time=0.060..81.693 rows=3738 loops=1
  • -> Index Scan using workflow_status_uuid_unique on workflow.workflow_status workflow_status_value (cost=0.28..0.30 rows=1 width=170) (actual time=0.000..0.0 (...)
  • Output: select_option_translation_unit.uuid, select_option_translation_unit.company_id, select_option_translation_unit.item_uuid, select_option_translation_un (...)
  • Index Cond: (select_option_translation_unit.item_uuid = select_option.uuid)
  • Worker 0: actual time=0.001..0.001 rows=0 loops=3991
  • Worker 1: actual time=0.001..0.001 rows=0 loops=3738
18. 5.465 75.961 ↓ 29.5 3,836 3 / 3

Nested Loop Left Join (cost=1.84..151,507.14 rows=130 width=447) (actual time=0.946..75.961 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, entity_v (...)
  • Inner Unique: true
  • Worker 0: actual time=0.053..72.472 rows=3991 loops=1
  • Worker 1: actual time=0.051..75.964 rows=3738 loops=1
  • Output: workflow_status_value.uuid, workflow_status_value.name, workflow_status_value.created_at, workflow_status_value.metadata, workflow_status_value. (...)
  • Index Cond: (workflow_status_value.uuid = entity_reference_value.workflow_status_uuid)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
19. 7.313 70.496 ↓ 29.5 3,836 3 / 3

Nested Loop Left Join (cost=1.56..151,468.79 rows=130 width=321) (actual time=0.940..70.496 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.number, en (...)
  • Inner Unique: true
  • Worker 0: actual time=0.045..66.991 rows=3991 loops=1
  • Worker 1: actual time=0.043..70.666 rows=3738 loops=1
  • -> Index Scan using employee_uuid_unique on public.employee user_picker_employee (cost=0.43..0.64 rows=1 width=59) (actual time=0.001..0.001 row (...)
20. 7.047 63.183 ↓ 29.5 3,836 3 / 3

Nested Loop Left Join (cost=1.14..151,386.01 rows=130 width=278) (actual time=0.927..63.183 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_value.numb (...)
  • Inner Unique: true
  • Worker 0: actual time=0.029..59.903 rows=3991 loops=1
  • Worker 1: actual time=0.029..63.643 rows=3738 loops=1
  • -> Index Scan using select_option_uuid_unique on workflow.select_option (cost=0.29..0.31 rows=1 width=34) (actual time=0.001..0.001 rows=0 (...)
  • Output: user_picker_employee.first_name, user_picker_employee.last_name, user_picker_employee.email, user_picker_employee.uuid
  • Index Cond: (user_picker_employee.uuid = entity_reference_value.employee_uuid)
  • Worker 0: actual time=0.001..0.001 rows=0 loops=3991
  • Worker 1: actual time=0.001..0.001 rows=0 loops=3738
21. 56.136 56.136 ↓ 29.5 3,836 3 / 3

Nested Loop Left Join (cost=0.85..151,345.94 rows=130 width=260) (actual time=0.920..56.136 rows=3,836 loops=3)

  • Output: entity_value.entity_uuid, entity_value.entity_field_uuid, entity_value.uuid, entity_value.text, entity_value.date, entity_valu (...)
  • Inner Unique: true
  • Worker 0: actual time=0.021..52.683 rows=3991 loops=1
  • Worker 1: actual time=0.021..56.686 rows=3738 loops=1
  • -> Parallel Index Scan using ux_entity_reference_value_for_field_in_entity on engine.entity_value (cost=0.42..151003.92 rows=130 wid (...)
  • Output: entity_value.id, entity_value.uuid, entity_value.created_at, entity_value.updated_at, entity_value.deleted, entity_value (...)
  • Filter: ((entity_value.entity_config_uuid = '5bbba791-1638-4557-acdd-a812d38bded9'::uuid) AND (entity_value.company_id = 389))
  • Rows Removed by Filter: 58921
  • Worker 0: actual time=0.009..40.909 rows=3991 loops=1
  • Worker 1: actual time=0.009..44.682 rows=3738 loops=1
  • -> Index Scan using ux_entity_reference_value_uuid on engine.entity_reference_value (cost=0.43..2.63 rows=1 width=120) (actual time= (...)
  • Output: entity_reference_value.id, entity_reference_value.uuid, entity_reference_value.created_at, entity_reference_value.update (...)
  • Index Cond: (entity_reference_value.uuid = entity_value.entity_reference_value_uuid)
  • Worker 0: actual time=0.002..0.002 rows=0 loops=3991
  • Worker 1: actual time=0.002..0.002 rows=0 loops=3738
  • Output: select_option.id, select_option.uuid, select_option.created_at, select_option.updated_at, select_option.deleted, select_option (...)
  • Index Cond: (select_option.uuid = entity_reference_value.select_option_uuid)
  • Worker 0: actual time=0.001..0.001 rows=0 loops=3991
  • Worker 1: actual time=0.001..0.001 rows=0 loops=3738
22. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using document_uuid_unique on document.document (cost=0.28..0.30 rows=1 width=142) (actual time=0.000..0.000 rows=0 loops=11,508)

  • Output: document.id, document.uuid, document.created_at, document.updated_at, document.deleted, document.deleted_at, document.created_by, document (...)
  • Index Cond: (document.uuid = entity_reference_value.document_uuid)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
23. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using ux_entity_reference_value_for_field_in_entity on engine.entity_value referenced_value (cost=0.42..0.58 rows=1 width=133) (actual time=0.000..0.000 rows=0 loops=11,508)

  • Output: referenced_value.id, referenced_value.uuid, referenced_value.created_at, referenced_value.updated_at, referenced_value.deleted, referenced_value.deleted_at, referenced_value. (...)
  • Index Cond: ((referenced_value.entity_field_uuid = entity_reference_value.referenced_entity_field_uuid) AND (referenced_value.entity_uuid = entity_reference_value.referenced_entity_u (...)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
24. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using ux_entity_reference_value_uuid on engine.entity_reference_value referenced_reference_value (cost=0.43..0.83 rows=1 width=88) (actual time=0.000..0.000 rows=0 loops=11,508)

  • Output: referenced_reference_value.id, referenced_reference_value.uuid, referenced_reference_value.created_at, referenced_reference_value.updated_at, referenced_reference_value.deleted, re (...)
  • Index Cond: (referenced_reference_value.uuid = referenced_value.entity_reference_value_uuid)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
25. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using select_option_uuid_unique on workflow.select_option referenced_select_option (cost=0.29..0.31 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=11,508)

  • Output: referenced_select_option.id, referenced_select_option.uuid, referenced_select_option.created_at, referenced_select_option.updated_at, referenced_select_option.deleted, referenced_select_ (...)
  • Index Cond: (referenced_select_option.uuid = referenced_reference_value.select_option_uuid)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
26. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using ux_translation_key_locale on translations.translation referenced_select_option_translation (cost=0.42..0.50 rows=1 width=102) (actual time=0.000..0.000 rows=0 loops=11,508)

  • Output: referenced_select_option_translation.uuid, referenced_select_option_translation.company_id, referenced_select_option_translation.translation_key, referenced_select_option_translation.locale, referen (...)
  • Index Cond: (referenced_select_option_translation_unit.translation_key = referenced_select_option_translation.translation_key)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
27. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using employee_uuid_unique on public.employee referenced_user (cost=0.43..0.64 rows=1 width=59) (actual time=0.000..0.000 rows=0 loops=11,508)

  • Output: referenced_user.first_name, referenced_user.last_name, referenced_user.email, referenced_user.uuid
  • Index Cond: (referenced_user.uuid = referenced_reference_value.employee_uuid)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
28. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using document_uuid_unique on document.document referenced_document (cost=0.28..0.30 rows=1 width=142) (actual time=0.000..0.000 rows=0 loops=11,508)

  • Output: referenced_document.id, referenced_document.uuid, referenced_document.created_at, referenced_document.updated_at, referenced_document.deleted, referenced_document.deleted_at, referenced_document.created_by, ref (...)
  • Index Cond: (referenced_document.uuid = referenced_reference_value.document_uuid)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
29. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using workflow_status_uuid_unique on workflow.workflow_status referenced_workflow_status (cost=0.28..0.30 rows=1 width=170) (actual time=0.000..0.000 rows=0 loops=11,508)

  • Output: referenced_workflow_status.uuid, referenced_workflow_status.name, referenced_workflow_status.created_at, referenced_workflow_status.metadata, referenced_workflow_status.description, referenced_workflow_status.initial
  • Index Cond: (referenced_workflow_status.uuid = referenced_reference_value.workflow_status_uuid)
  • Worker 0: actual time=0.000..0.000 rows=0 loops=3991
  • Worker 1: actual time=0.000..0.000 rows=0 loops=3738
30. 3.836 3.836 ↓ 0.0 0 11,508 / 3

Index Scan using ux_translation_key_locale on translations.translation referenced_workflow_status_translation (cost=0.42..0.56 rows=1 width=102) (actual time=0.001..0.001 rows=0 loops=11,508)

  • Output: referenced_workflow_status_translation.uuid, referenced_workflow_status_translation.company_id, referenced_workflow_status_translation.translation_key, referenced_workflow_status_translation.locale, referenced_workflow_status_tr (...)
  • Index Cond: (referenced_workflow_status_translation_unit.translation_key = referenced_workflow_status_translation.translation_key)
  • Worker 0: actual time=0.001..0.001 rows=0 loops=3991
  • Worker 1: actual time=0.001..0.001 rows=0 loops=3738
Planning time : 7.780 ms
Execution time : 198.065 ms