explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wZEQ

Settings
# exclusive inclusive rows x rows loops node
1. 14.483 32,039.597 ↓ 3,836.0 11,508 1

Sort (cost=497,884.38..497,884.39 rows=3 width=1,309) (actual time=32,037.096..32,039.597 rows=11,508 loops=1)

  • Sort Key: entity_value.created_at
  • Sort Method: quicksort Memory: 2764kB
2. 19.779 32,025.114 ↓ 3,836.0 11,508 1

Nested Loop Left Join (cost=142,470.37..497,884.36 rows=3 width=1,309) (actual time=31,858.334..32,025.114 rows=11,508 loops=1)

3. 15.366 32,005.335 ↓ 3,836.0 11,508 1

Nested Loop Left Join (cost=142,469.95..497,882.63 rows=3 width=1,273) (actual time=31,858.320..32,005.335 rows=11,508 loops=1)

4. 14.186 31,989.969 ↓ 3,836.0 11,508 1

Nested Loop Left Join (cost=142,469.53..497,877.06 rows=3 width=1,208) (actual time=31,858.313..31,989.969 rows=11,508 loops=1)

5. 13.521 31,975.783 ↓ 3,836.0 11,508 1

Nested Loop Left Join (cost=142,469.25..497,876.17 rows=3 width=1,054) (actual time=31,858.305..31,975.783 rows=11,508 loops=1)

6. 13.820 31,962.262 ↓ 3,836.0 11,508 1

Nested Loop Left Join (cost=142,468.97..497,875.29 rows=3 width=928) (actual time=31,858.298..31,962.262 rows=11,508 loops=1)

7. 13.368 31,948.442 ↓ 3,836.0 11,508 1

Nested Loop Left Join (cost=142,468.54..497,873.38 rows=3 width=885) (actual time=31,858.291..31,948.442 rows=11,508 loops=1)

8. 13.312 31,935.074 ↓ 3,836.0 11,508 1

Nested Loop Left Join (cost=142,468.12..497,871.85 rows=3 width=913) (actual time=31,858.285..31,935.074 rows=11,508 loops=1)

  • -> 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 rows=0 lo (...)
9. 13.209 31,921.762 ↓ 5,754.0 11,508 1

Nested Loop Left Join (cost=142,467.70..497,870.60 rows=2 width=848) (actual time=31,858.279..31,921.762 rows=11,508 loops=1)

  • Index Cond: (item_uuid = referenced_select_option.uuid)
10. 13.381 31,908.553 ↓ 5,754.0 11,508 1

Nested Loop Left Join (cost=142,467.41..497,869.99 rows=2 width=830) (actual time=31,858.272..31,908.553 rows=11,508 loops=1)

11. 16.355 31,895.172 ↓ 5,754.0 11,508 1

Nested Loop Left Join (cost=142,466.99..497,869.08 rows=2 width=758) (actual time=31,858.266..31,895.172 rows=11,508 loops=1)

  • Filter: ((workflow_status_translation.locale = 'en-US'::text) OR (workflow_status_translation.locale IS NULL))
12. 14.446 31,878.817 ↓ 5,754.0 11,508 1

Nested Loop Left Join (cost=142,466.57..497,867.93 rows=2 width=786) (actual time=31,858.259..31,878.817 rows=11,508 loops=1)

  • -> 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 time=0.000.. (...)
13. 2,766.358 31,864.371 ↓ 5,754.0 11,508 1

Hash Right Join (cost=142,466.15..497,864.22 rows=2 width=721) (actual time=31,858.245..31,864.371 rows=11,508 loops=1)

  • Hash Cond: ((referenced_value.entity_uuid = entity_reference_value.referenced_entity_uuid) AND (referenced_value.entity_field_uuid = entity_reference_value.referenced_entity_field_uu (...)
  • Index Cond: ((item_uuid = workflow_status_value.uuid) AND (item_property_type = 'name'::text))
14. 1,689.608 1,689.608 ↓ 1.0 7,140,675 1

Seq Scan on entity_value referenced_value (cost=0.00..301,861.75 rows=7,138,175 width=132) (actual time=0.004..1,689.608 rows=7,140,675 loops=1)

15. 13.914 27,408.405 ↓ 5,754.0 11,508 1

Hash (cost=142,466.12..142,466.12 rows=2 width=637) (actual time=27,408.405..27,408.405 rows=11,508 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1909kB
16. 14.923 27,394.491 ↓ 5,754.0 11,508 1

Nested Loop Left Join (cost=2.40..142,466.12 rows=2 width=637) (actual time=15.622..27,394.491 rows=11,508 loops=1)

  • Filter: ((select_option_translation.locale = 'en-US'::text) OR (select_option_translation.locale IS NULL))
17. 28.385 27,356.552 ↓ 5,754.0 11,508 1

Nested Loop Left Join (cost=1.98..142,465.10 rows=2 width=665) (actual time=15.615..27,356.552 rows=11,508 loops=1)

  • -> 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 (...)
18. 6,047.361 27,328.167 ↓ 11,508.0 11,508 1

Nested Loop Left Join (cost=1.56..142,464.47 rows=1 width=600) (actual time=15.607..27,328.167 rows=11,508 loops=1)

  • Join Filter: (workflow_status_value.uuid = entity_reference_value.workflow_status_uuid)
  • Rows Removed by Join Filter: 28656358
  • Index Cond: (item_uuid = select_option.uuid)
19. 5,198.190 10,912.098 ↓ 11,508.0 11,508 1

Nested Loop Left Join (cost=1.56..142,336.39 rows=1 width=446) (actual time=10.906..10,912.098 rows=11,508 loops=1)

  • Join Filter: (document.uuid = entity_reference_value.document_uuid)
  • Rows Removed by Join Filter: 23457363
20. 24.405 328.164 ↓ 11,508.0 11,508 1

Nested Loop Left Join (cost=1.56..142,222.49 rows=1 width=320) (actual time=8.843..328.164 rows=11,508 loops=1)

  • -> 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 (...)
21. 20.932 303.759 ↓ 11,508.0 11,508 1

Nested Loop Left Join (cost=1.14..142,221.85 rows=1 width=277) (actual time=8.822..303.759 rows=11,508 loops=1)

  • -> 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)
22. 282.827 282.827 ↓ 11,508.0 11,508 1

Nested Loop Left Join (cost=0.85..142,221.54 rows=1 width=259) (actual time=8.818..282.827 rows=11,508 loops=1)

  • -> Index Scan using ux_entity_reference_value_for_field_in_entity on entity_value (cost=0.42..142218.90 rows=1 width=155) (actual ti (...)
  • Filter: ((entity_config_uuid = '5bbba791-1638-4557-acdd-a812d38bded9'::uuid) AND (company_id = 389))
  • Rows Removed by Filter: 176743
  • -> Index Scan using ux_entity_reference_value_uuid on entity_reference_value (cost=0.43..2.65 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)
23. 5,385.744 5,385.744 ↑ 1.0 2,038 11,508

Seq Scan on document (cost=0.00..88.40 rows=2,040 width=142) (actual time=0.001..0.468 rows=2,038 loops=11,508)

24. 10,368.708 10,368.708 ↑ 1.0 2,490 11,508

Seq Scan on workflow_status workflow_status_value (cost=0.00..96.37 rows=2,537 width=170) (actual time=0.002..0.901 rows=2,490 loops=11,508)

25. 23.016 23.016 ↓ 0.0 0 11,508

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)
26. 0.000 0.000 ↓ 0.0 0 11,508

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

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

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

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

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)
29. 0.000 0.000 ↓ 0.0 0 11,508

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)
30. 0.000 0.000 ↓ 0.0 0 11,508

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)
31. 0.000 0.000 ↓ 0.0 0 11,508

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)
32. 0.000 0.000 ↓ 0.0 0 11,508

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)
33. 0.000 0.000 ↓ 0.0 0 11,508

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))
34. 0.000 0.000 ↓ 0.0 0 11,508

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.000..0.000 rows=0 loops=11,508)

  • Index Cond: (referenced_workflow_status_translation_unit.translation_key = translation_key)
Planning time : 10.446 ms
Execution time : 32,045.741 ms