explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2fkz

Settings
# exclusive inclusive rows x rows loops node
1. 17.344 275.886 ↑ 1.5 11,508 1

Gather Merge (cost=215,515.38..217,522.66 rows=17,204 width=1,309) (actual time=265.562..275.886 rows=11,508 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 6.866 258.542 ↑ 2.2 3,836 3 / 3

Sort (cost=214,515.36..214,536.86 rows=8,602 width=1,309) (actual time=257.520..258.542 rows=3,836 loops=3)

  • Sort Key: entity_value.created_at
  • Sort Method: quicksort Memory: 822kB
  • Worker 0: Sort Method: quicksort Memory: 803kB
  • Worker 1: Sort Method: quicksort Memory: 1141kB
3. 5.891 251.676 ↑ 2.2 3,836 3 / 3

Nested Loop Left Join (cost=9,598.62..211,077.05 rows=8,602 width=1,309) (actual time=72.932..251.676 rows=3,836 loops=3)

4. 4.234 241.949 ↑ 2.2 3,836 3 / 3

Parallel Hash Left Join (cost=9,598.20..206,107.73 rows=8,602 width=1,273) (actual time=72.914..241.949 rows=3,836 loops=3)

  • Hash Cond: (workflow_status_value.uuid = referenced_workflow_status_translation_unit.item_uuid)
5. 3.585 207.620 ↑ 2.2 3,836 3 / 3

Hash Left Join (cost=5,043.70..201,480.20 rows=8,602 width=1,208) (actual time=42.576..207.620 rows=3,836 loops=3)

  • Hash Cond: (referenced_reference_value.workflow_status_uuid = referenced_workflow_status.uuid)
6. 3.720 200.766 ↑ 2.2 3,836 3 / 3

Hash Left Join (cost=4,915.61..201,329.53 rows=8,602 width=1,054) (actual time=39.283..200.766 rows=3,836 loops=3)

  • Hash Cond: (referenced_reference_value.document_uuid = referenced_document.uuid)
7. 6.629 194.370 ↑ 2.2 3,836 3 / 3

Nested Loop Left Join (cost=4,801.71..201,193.05 rows=8,602 width=928) (actual time=36.586..194.370 rows=3,836 loops=3)

8. 6.279 187.741 ↑ 2.2 3,836 3 / 3

Nested Loop Left Join (cost=4,801.29..195,715.63 rows=8,602 width=885) (actual time=36.576..187.741 rows=3,836 loops=3)

9. 6.425 181.462 ↑ 2.2 3,836 3 / 3

Nested Loop Left Join (cost=4,800.87..191,350.69 rows=8,602 width=913) (actual time=36.565..181.462 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.408 175.037 ↑ 1.3 3,836 3 / 3

Nested Loop Left Join (cost=4,800.45..188,272.93 rows=4,917 width=848) (actual time=36.555..175.037 rows=3,836 loops=3)

  • Index Cond: (item_uuid = referenced_select_option.uuid)
11. 6.348 168.629 ↑ 1.3 3,836 3 / 3

Nested Loop Left Join (cost=4,800.16..186,757.53 rows=4,917 width=830) (actual time=36.546..168.629 rows=3,836 loops=3)

12. 6.645 162.281 ↑ 1.3 3,836 3 / 3

Nested Loop Left Join (cost=4,799.73..182,680.06 rows=4,917 width=758) (actual time=36.536..162.281 rows=3,836 loops=3)

13. 4.114 155.636 ↑ 1.3 3,836 3 / 3

Nested Loop Left Join (cost=4,799.31..179,775.78 rows=4,917 width=674) (actual time=36.525..155.636 rows=3,836 loops=3)

  • Filter: ((workflow_status_translation.locale = 'en-US'::text) OR (workflow_status_translation.locale IS NULL))
14. 3.677 147.686 ↑ 1.6 3,836 3 / 3

Parallel Hash Left Join (cost=4,798.89..176,191.75 rows=6,231 width=702) (actual time=36.516..147.686 rows=3,836 loops=3)

  • Hash Cond: (workflow_status_value.uuid = workflow_status_translation_unit.item_uuid)
15. 6.255 114.945 ↑ 1.6 3,836 3 / 3

Nested Loop Left Join (cost=244.39..171,584.35 rows=6,231 width=637) (actual time=7.336..114.945 rows=3,836 loops=3)

  • Filter: ((select_option_translation.locale = 'en-US'::text) OR (select_option_translation.locale IS NULL))
16. 9.262 101.018 ↑ 2.1 3,836 3 / 3

Nested Loop Left Join (cost=243.97..167,558.42 rows=7,895 width=665) (actual time=7.326..101.018 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. 3.296 91.756 ↑ 1.2 3,836 3 / 3

Hash Left Join (cost=243.55..164,733.54 rows=4,513 width=600) (actual time=7.316..91.756 rows=3,836 loops=3)

  • Hash Cond: (entity_reference_value.workflow_status_uuid = workflow_status_value.uuid)
  • Index Cond: (item_uuid = select_option.uuid)
18. 3.331 85.114 ↑ 1.2 3,836 3 / 3

Hash Left Join (cost=115.47..164,593.61 rows=4,513 width=446) (actual time=3.946..85.114 rows=3,836 loops=3)

  • Hash Cond: (entity_reference_value.document_uuid = document.uuid)
19. 7.982 79.052 ↑ 1.2 3,836 3 / 3

Nested Loop Left Join (cost=1.56..164,467.87 rows=4,513 width=320) (actual time=1.197..79.052 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.972 71.070 ↑ 1.2 3,836 3 / 3

Nested Loop Left Join (cost=1.14..161,594.17 rows=4,513 width=277) (actual time=1.170..71.070 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. 63.098 63.098 ↑ 1.2 3,836 3 / 3

Nested Loop Left Join (cost=0.85..160,203.28 rows=4,513 width=259) (actual time=1.162..63.098 rows=3,836 loops=3)

  • -> Parallel Index Scan using ux_entity_reference_value_for_field_in_entity on entity_value (cost=0.42..150322.97 rows=4513 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.19 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. 1.473 2.731 ↓ 1.0 2,044 3 / 3

Hash (cost=88.40..88.40 rows=2,040 width=142) (actual time=2.731..2.731 rows=2,044 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 371kB
23. 1.258 1.258 ↓ 1.0 2,044 3 / 3

Seq Scan on document (cost=0.00..88.40 rows=2,040 width=142) (actual time=0.013..1.258 rows=2,044 loops=3)

24. 1.782 3.346 ↓ 1.0 2,542 3 / 3

Hash (cost=96.37..96.37 rows=2,537 width=170) (actual time=3.346..3.346 rows=2,542 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 392kB
25. 1.564 1.564 ↓ 1.0 2,542 3 / 3

Seq Scan on workflow_status workflow_status_value (cost=0.00..96.37 rows=2,537 width=170) (actual time=0.010..1.564 rows=2,542 loops=3)

26. 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)
27. 13.364 29.064 ↑ 1.2 21,454 3 / 3

Parallel Hash (cost=4,221.53..4,221.53 rows=26,638 width=81) (actual time=29.064..29.064 rows=21,454 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 8128kB
28. 15.700 15.700 ↑ 1.2 21,454 3 / 3

Parallel Seq Scan on translation_unit workflow_status_translation_unit (cost=0.00..4,221.53 rows=26,638 width=81) (actual time=0.006..15.700 rows=21,454 loops=3)

  • Filter: (item_property_type = 'name'::text)
  • Rows Removed by Filter: 23453
29. 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)
30. 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))
31. 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)
32. 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)
33. 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)
34. 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)
35. 1.467 2.676 ↓ 1.0 2,044 3 / 3

Hash (cost=88.40..88.40 rows=2,040 width=142) (actual time=2.676..2.676 rows=2,044 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 371kB
36. 1.209 1.209 ↓ 1.0 2,044 3 / 3

Seq Scan on document referenced_document (cost=0.00..88.40 rows=2,040 width=142) (actual time=0.005..1.209 rows=2,044 loops=3)

37. 1.751 3.269 ↓ 1.0 2,542 3 / 3

Hash (cost=96.37..96.37 rows=2,537 width=170) (actual time=3.269..3.269 rows=2,542 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 392kB
38. 1.518 1.518 ↓ 1.0 2,542 3 / 3

Seq Scan on workflow_status referenced_workflow_status (cost=0.00..96.37 rows=2,537 width=170) (actual time=0.004..1.518 rows=2,542 loops=3)

39. 13.089 30.095 ↑ 1.2 21,454 3 / 3

Parallel Hash (cost=4,221.53..4,221.53 rows=26,638 width=81) (actual time=30.095..30.095 rows=21,454 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 8096kB
40. 17.006 17.006 ↑ 1.2 21,454 3 / 3

Parallel Seq Scan on translation_unit referenced_workflow_status_translation_unit (cost=0.00..4,221.53 rows=26,638 width=81) (actual time=0.006..17.006 rows=21,454 loops=3)

  • Filter: (item_property_type = 'name'::text)
  • Rows Removed by Filter: 23453
41. 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 : 8.662 ms
Execution time : 279.572 ms