explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T7krC

Settings
# exclusive inclusive rows x rows loops node
1. 14.563 195.897 ↓ 19.8 11,508 1

Gather Merge (cost=155,459.95..155,527.62 rows=580 width=1,309) (actual time=186.910..195.897 rows=11,508 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 6.022 181.334 ↓ 13.2 3,836 3 / 3

Sort (cost=154,459.93..154,460.65 rows=290 width=1,309) (actual time=180.221..181.334 rows=3,836 loops=3)

  • Sort Key: entity_value.created_at
  • Sort Method: quicksort Memory: 904kB
  • Worker 0: Sort Method: quicksort Memory: 876kB
  • Worker 1: Sort Method: quicksort Memory: 889kB
3. 4.394 175.312 ↓ 13.2 3,836 3 / 3

Nested Loop Left Join (cost=7.61..154,448.07 rows=290 width=1,309) (actual time=1.053..175.312 rows=3,836 loops=3)

4. 6.426 167.082 ↓ 13.2 3,836 3 / 3

Nested Loop Left Join (cost=7.19..154,280.54 rows=290 width=1,273) (actual time=1.042..167.082 rows=3,836 loops=3)

5. 6.010 160.656 ↓ 13.2 3,836 3 / 3

Nested Loop Left Join (cost=6.77..153,743.01 rows=290 width=1,208) (actual time=1.034..160.656 rows=3,836 loops=3)

6. 5.831 154.646 ↓ 13.2 3,836 3 / 3

Nested Loop Left Join (cost=6.49..153,656.72 rows=290 width=1,054) (actual time=1.019..154.646 rows=3,836 loops=3)

7. 5.892 148.815 ↓ 13.2 3,836 3 / 3

Nested Loop Left Join (cost=6.21..153,571.16 rows=290 width=928) (actual time=1.011..148.815 rows=3,836 loops=3)

8. 5.804 142.923 ↓ 13.2 3,836 3 / 3

Nested Loop Left Join (cost=5.78..153,386.50 rows=290 width=885) (actual time=1.004..142.923 rows=3,836 loops=3)

9. 5.678 137.119 ↓ 13.2 3,836 3 / 3

Nested Loop Left Join (cost=5.36..153,239.34 rows=290 width=913) (actual time=0.996..137.119 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. 5.810 131.441 ↓ 23.1 3,836 3 / 3

Nested Loop Left Join (cost=4.94..153,135.43 rows=166 width=848) (actual time=0.990..131.441 rows=3,836 loops=3)

  • Index Cond: (item_uuid = referenced_select_option.uuid)
11. 5.855 125.631 ↓ 23.1 3,836 3 / 3

Nested Loop Left Join (cost=4.65..153,084.27 rows=166 width=830) (actual time=0.984..125.631 rows=3,836 loops=3)

12. 5.946 119.776 ↓ 23.1 3,836 3 / 3

Nested Loop Left Join (cost=4.22..152,947.30 rows=166 width=758) (actual time=0.976..119.776 rows=3,836 loops=3)

13. 3.139 113.830 ↓ 23.1 3,836 3 / 3

Nested Loop Left Join (cost=3.80..152,849.25 rows=166 width=674) (actual time=0.970..113.830 rows=3,836 loops=3)

  • Filter: ((workflow_status_translation.locale = 'en-US'::text) OR (workflow_status_translation.locale IS NULL))
14. 6.377 106.855 ↓ 18.3 3,836 3 / 3

Nested Loop Left Join (cost=3.38..152,728.46 rows=210 width=702) (actual time=0.963..106.855 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.036 100.478 ↓ 18.3 3,836 3 / 3

Nested Loop Left Join (cost=2.96..152,339.22 rows=210 width=637) (actual time=0.957..100.478 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.125 88.770 ↓ 14.4 3,836 3 / 3

Nested Loop Left Join (cost=2.54..152,203.57 rows=266 width=665) (actual time=0.950..88.770 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. 5.978 80.645 ↓ 25.2 3,836 3 / 3

Nested Loop Left Join (cost=2.12..152,108.43 rows=152 width=600) (actual time=0.944..80.645 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.522 74.667 ↓ 25.2 3,836 3 / 3

Nested Loop Left Join (cost=1.84..152,063.20 rows=152 width=446) (actual time=0.939..74.667 rows=3,836 loops=3)

  • Index Cond: (uuid = entity_reference_value.workflow_status_uuid)
19. 7.359 69.145 ↓ 25.2 3,836 3 / 3

Nested Loop Left Join (cost=1.56..152,018.36 rows=152 width=320) (actual time=0.930..69.145 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.122 61.786 ↓ 25.2 3,836 3 / 3

Nested Loop Left Join (cost=1.14..151,921.57 rows=152 width=277) (actual time=0.917..61.786 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. 54.664 54.664 ↓ 25.2 3,836 3 / 3

Nested Loop Left Join (cost=0.85..151,874.72 rows=152 width=259) (actual time=0.907..54.664 rows=3,836 loops=3)

  • -> Parallel Index Scan using ux_entity_reference_value_for_field_in_entity on entity_value (cost=0.42..151475.43 rows=152 width=155) (...)
  • Filter: ((entity_config_uuid = '5bbba791-1638-4557-acdd-a812d38bded9'::uuid) AND (company_id = 389))
  • Rows Removed by Filter: 58936
  • -> 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=132) (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 : 11.150 ms
Execution time : 199.929 ms