explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zCb4

Settings
# exclusive inclusive rows x rows loops node
1. 16.164 225.965 ↑ 1.5 11,508 1

Gather Merge (cost=202,575.61..204,582.88 rows=17,204 width=1,309) (actual time=215.651..225.965 rows=11,508 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 6.393 209.801 ↑ 2.2 3,836 3 / 3

Sort (cost=201,575.58..201,597.09 rows=8,602 width=1,309) (actual time=208.815..209.801 rows=3,836 loops=3)

  • Sort Key: entity_value.created_at
  • Sort Method: quicksort Memory: 870kB
  • Worker 0: Sort Method: quicksort Memory: 897kB
  • Worker 1: Sort Method: quicksort Memory: 903kB
3. 4.486 203.408 ↑ 2.2 3,836 3 / 3

Nested Loop Left Join (cost=12,523.39..201,013.42 rows=8,602 width=1,309) (actual time=69.552..203.408 rows=3,836 loops=3)

4. 3.621 195.086 ↑ 2.2 3,836 3 / 3

Parallel Hash Left Join (cost=12,522.97..196,044.11 rows=8,602 width=1,273) (actual time=69.535..195.086 rows=3,836 loops=3)

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

Hash Left Join (cost=7,968.47..191,416.57 rows=8,602 width=1,208) (actual time=46.308..168.454 rows=3,836 loops=3)

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

Hash Left Join (cost=7,840.39..191,265.90 rows=8,602 width=1,054) (actual time=43.868..162.853 rows=3,836 loops=3)

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

Nested Loop Left Join (cost=7,726.49..191,129.42 rows=8,602 width=928) (actual time=41.896..157.642 rows=3,836 loops=3)

8. 5.605 151.835 ↑ 2.2 3,836 3 / 3

Nested Loop Left Join (cost=7,726.06..185,652.01 rows=8,602 width=885) (actual time=41.886..151.835 rows=3,836 loops=3)

9. 5.546 146.230 ↑ 2.2 3,836 3 / 3

Nested Loop Left Join (cost=7,725.64..181,287.06 rows=8,602 width=913) (actual time=41.877..146.230 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.586 140.684 ↑ 1.3 3,836 3 / 3

Nested Loop Left Join (cost=7,725.22..178,209.30 rows=4,917 width=848) (actual time=41.869..140.684 rows=3,836 loops=3)

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

Nested Loop Left Join (cost=7,724.93..176,693.90 rows=4,917 width=830) (actual time=41.860..135.098 rows=3,836 loops=3)

12. 5.686 129.495 ↑ 1.3 3,836 3 / 3

Nested Loop Left Join (cost=7,724.51..172,616.44 rows=4,917 width=758) (actual time=41.852..129.495 rows=3,836 loops=3)

13. 2.985 123.809 ↑ 1.3 3,836 3 / 3

Nested Loop Left Join (cost=7,724.09..169,712.16 rows=4,917 width=674) (actual time=41.843..123.809 rows=3,836 loops=3)

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

Parallel Hash Left Join (cost=7,723.67..166,128.13 rows=6,231 width=702) (actual time=41.830..116.988 rows=3,836 loops=3)

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

Nested Loop Left Join (cost=3,169.17..161,520.72 rows=6,231 width=637) (actual time=18.592..90.664 rows=3,836 loops=3)

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

Nested Loop Left Join (cost=3,168.75..157,494.80 rows=7,895 width=665) (actual time=18.583..78.774 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. 2.864 70.614 ↑ 1.2 3,836 3 / 3

Hash Left Join (cost=3,168.33..154,669.92 rows=4,513 width=600) (actual time=18.575..70.614 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. 2.924 65.249 ↑ 1.2 3,836 3 / 3

Hash Left Join (cost=3,040.24..154,529.99 rows=4,513 width=446) (actual time=16.054..65.249 rows=3,836 loops=3)

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

Nested Loop Left Join (cost=2,926.34..154,404.24 rows=4,513 width=320) (actual time=14.023..60.310 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.129 52.953 ↑ 1.2 3,836 3 / 3

Nested Loop Left Join (cost=2,925.92..151,530.54 rows=4,513 width=277) (actual time=14.016..52.953 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. 45.824 45.824 ↑ 1.2 3,836 3 / 3

Nested Loop Left Join (cost=2,925.63..150,139.65 rows=4,513 width=259) (actual time=14.009..45.824 rows=3,836 loops=3)

  • -> Parallel Bitmap Heap Scan on entity_value (cost=2925.20..140259.35 rows=4513 width=155) (actual time=13.992..33.776 rows=3836 loo (...)
  • Recheck Cond: (NOT deleted)
  • Filter: ((entity_config_uuid = '5bbba791-1638-4557-acdd-a812d38bded9'::uuid) AND (company_id = 389))
  • Rows Removed by Filter: 58936
  • Heap Blocks: exact=3106
  • -> Bitmap Index Scan on ux_entity_reference_value_for_field_in_entity (cost=0.00..2922.49 rows=186874 width=0) (actual time=12 (...)
  • -> 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.082 2.015 ↓ 1.0 2,044 3 / 3

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

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

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

24. 1.338 2.501 ↓ 1.0 2,542 3 / 3

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

  • Buckets: 4096 Batches: 1 Memory Usage: 392kB
25. 1.163 1.163 ↓ 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.008..1.163 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. 11.057 23.129 ↑ 1.2 21,454 3 / 3

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

  • Buckets: 65536 Batches: 1 Memory Usage: 8160kB
28. 12.072 12.072 ↑ 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.005..12.072 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.082 1.959 ↓ 1.0 2,044 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 371kB
36. 0.877 0.877 ↓ 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.004..0.877 rows=2,044 loops=3)

37. 1.312 2.419 ↓ 1.0 2,542 3 / 3

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

  • Buckets: 4096 Batches: 1 Memory Usage: 392kB
38. 1.107 1.107 ↓ 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.006..1.107 rows=2,542 loops=3)

39. 10.492 23.011 ↑ 1.2 21,454 3 / 3

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

  • Buckets: 65536 Batches: 1 Memory Usage: 8128kB
40. 12.519 12.519 ↑ 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..12.519 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 : 7.610 ms
Execution time : 229.666 ms