explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rKZ

Settings
# exclusive inclusive rows x rows loops node
1. 14.501 204.083 ↓ 23.1 11,508 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 6.287 189.582 ↓ 15.4 3,836 3 / 3

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

  • Sort Key: entity_value.created_at
  • Sort Method: quicksort Memory: 873kB
  • Worker 0: Sort Method: quicksort Memory: 917kB
  • Worker 1: Sort Method: quicksort Memory: 879kB
3. 4.823 183.295 ↓ 15.4 3,836 3 / 3

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

4. 6.610 174.636 ↓ 15.4 3,836 3 / 3

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

5. 6.202 168.026 ↓ 15.4 3,836 3 / 3

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

6. 6.046 161.824 ↓ 15.4 3,836 3 / 3

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

7. 6.462 155.778 ↓ 15.4 3,836 3 / 3

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

8. 5.988 149.316 ↓ 15.4 3,836 3 / 3

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

9. 5.978 143.328 ↓ 15.4 3,836 3 / 3

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

  • -> Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translation_unit referenced_select_option_translation_unit (cost=0.42..0.61 rows=2 width=81) (actual time=0.000..0.000 row (...)
10. 6.054 137.350 ↓ 27.0 3,836 3 / 3

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

  • Index Cond: (item_uuid = referenced_select_option.uuid)
11. 5.890 131.296 ↓ 27.0 3,836 3 / 3

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

12. 5.990 125.406 ↓ 27.0 3,836 3 / 3

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

13. 3.391 119.416 ↓ 27.0 3,836 3 / 3

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

  • Filter: ((workflow_status_translation.locale = 'en-US'::text) OR (workflow_status_translation.locale IS NULL))
14. 6.532 112.189 ↓ 21.3 3,836 3 / 3

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

  • -> Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translation_unit workflow_status_translation_unit (cost=0.42..1.84 rows=1 width=81) (actual (...)
15. 4.633 105.657 ↓ 21.3 3,836 3 / 3

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

  • Filter: ((select_option_translation.locale = 'en-US'::text) OR (select_option_translation.locale IS NULL))
  • Index Cond: ((item_uuid = workflow_status_value.uuid) AND (item_property_type = 'name'::text))
16. 8.779 93.352 ↓ 16.8 3,836 3 / 3

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

  • -> Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translation_unit select_option_translation_unit (cost=0.42..0.61 rows=2 width=81 (...)
17. 6.209 84.573 ↓ 29.5 3,836 3 / 3

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

  • -> Index Scan using workflow_status_uuid_unique on workflow_status workflow_status_value (cost=0.28..0.30 rows=1 width=170) (actual time=0.000..0.000 rows=0 (...)
  • Index Cond: (item_uuid = select_option.uuid)
18. 5.712 78.364 ↓ 29.5 3,836 3 / 3

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

  • Index Cond: (uuid = entity_reference_value.workflow_status_uuid)
19. 7.543 72.652 ↓ 29.5 3,836 3 / 3

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

  • -> Index Scan using employee_uuid_unique on employee user_picker_employee (cost=0.43..0.64 rows=1 width=59) (actual time=0.001..0.001 rows=0 loo (...)
20. 7.510 65.109 ↓ 29.5 3,836 3 / 3

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

  • -> Index Scan using select_option_uuid_unique on select_option (cost=0.29..0.31 rows=1 width=34) (actual time=0.001..0.001 rows=0 loops=11 (...)
  • Index Cond: (uuid = entity_reference_value.employee_uuid)
21. 57.599 57.599 ↓ 29.5 3,836 3 / 3

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

  • -> Parallel Index Scan using ux_entity_reference_value_for_field_in_entity on entity_value (cost=0.42..151003.92 rows=130 width=156) (...)
  • Filter: ((entity_config_uuid = '5bbba791-1638-4557-acdd-a812d38bded9'::uuid) AND (company_id = 389))
  • Rows Removed by Filter: 58921
  • -> Index Scan using ux_entity_reference_value_uuid on entity_reference_value (cost=0.43..2.63 rows=1 width=120) (actual time=0.002.. (...)
  • Index Cond: (uuid = entity_value.entity_reference_value_uuid)
  • Index Cond: (uuid = entity_reference_value.select_option_uuid)
22. 0.000 0.000 ↓ 0.0 0 11,508 / 3

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

  • Index Cond: (uuid = entity_reference_value.document_uuid)
23. 7.672 7.672 ↓ 0.0 0 11,508 / 3

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

  • Index Cond: (select_option_translation_unit.translation_key = translation_key)
24. 3.836 3.836 ↓ 0.0 0 11,508 / 3

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

  • Index Cond: (workflow_status_translation_unit.translation_key = translation_key)
25. 0.000 0.000 ↓ 0.0 0 11,508 / 3

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

  • Index Cond: ((entity_field_uuid = entity_reference_value.referenced_entity_field_uuid) AND (entity_uuid = entity_reference_value.referenced_entity_uuid))
26. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using ux_entity_reference_value_uuid on 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)

  • Index Cond: (uuid = referenced_value.entity_reference_value_uuid)
27. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using select_option_uuid_unique on 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)

  • Index Cond: (uuid = referenced_reference_value.select_option_uuid)
28. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using ux_translation_key_locale on 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)

  • Index Cond: (referenced_select_option_translation_unit.translation_key = translation_key)
29. 0.000 0.000 ↓ 0.0 0 11,508 / 3

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

  • Index Cond: (uuid = referenced_reference_value.employee_uuid)
30. 0.000 0.000 ↓ 0.0 0 11,508 / 3

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

  • Index Cond: (uuid = referenced_reference_value.document_uuid)
31. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using workflow_status_uuid_unique on 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)

  • Index Cond: (uuid = referenced_reference_value.workflow_status_uuid)
32. 0.000 0.000 ↓ 0.0 0 11,508 / 3

Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on 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=11,508)

  • Index Cond: ((item_uuid = workflow_status_value.uuid) AND (item_property_type = 'name'::text))
33. 3.836 3.836 ↓ 0.0 0 11,508 / 3

Index Scan using ux_translation_key_locale on 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)

  • Index Cond: (referenced_workflow_status_translation_unit.translation_key = translation_key)
Planning time : 7.922 ms
Execution time : 207.818 ms