explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uLf6 : Deere List Fetch With Translation JOIN

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 827.522 ↑ 1.0 10 1

Limit (cost=21,623.06..21,623.09 rows=10 width=64) (actual time=827.474..827.522 rows=10 loops=1)

2. 0.915 827.475 ↑ 20.0 10 1

Sort (cost=21,623.06..21,623.56 rows=200 width=64) (actual time=827.472..827.475 rows=10 loops=1)

  • Sort Key: (max(filter_query.row_number))
  • Sort Method: top-N heapsort Memory: 169kB
3. 275.240 826.560 ↓ 3.0 607 1

GroupAggregate (cost=21,602.31..21,618.74 rows=200 width=64) (actual time=549.721..826.560 rows=607 loops=1)

  • Group Key: filter_query.uuid
4. 7.169 551.320 ↓ 7.4 7,991 1

Sort (cost=21,602.31..21,605.00 rows=1,074 width=6,594) (actual time=549.169..551.320 rows=7,991 loops=1)

  • Sort Key: filter_query.uuid
  • Sort Method: quicksort Memory: 3,192kB
5. 8.556 544.151 ↓ 7.4 7,991 1

Subquery Scan on filter_query (cost=21,518.71..21,548.24 rows=1,074 width=6,594) (actual time=524.046..544.151 rows=7,991 loops=1)

6. 9.727 535.595 ↓ 7.4 7,991 1

WindowAgg (cost=21,518.71..21,537.50 rows=1,074 width=6,554) (actual time=524.024..535.595 rows=7,991 loops=1)

7.          

CTE full

8. 19.512 486.700 ↓ 5.6 12,046 1

Sort (cost=21,291.93..21,297.30 rows=2,148 width=1,461) (actual time=483.456..486.700 rows=12,046 loops=1)

  • Sort Key: entity_value.created_at
  • Sort Method: quicksort Memory: 3,980kB
9. 23.333 467.188 ↓ 5.6 12,046 1

Nested Loop Left Join (cost=645.17..21,173.05 rows=2,148 width=1,461) (actual time=12.376..467.188 rows=12,046 loops=1)

10. 16.552 443.855 ↓ 5.6 12,046 1

Nested Loop Left Join (cost=644.75..18,685.64 rows=2,148 width=1,421) (actual time=12.363..443.855 rows=12,046 loops=1)

11. 19.158 427.303 ↓ 5.6 12,046 1

Nested Loop Left Join (cost=644.33..16,304.94 rows=2,148 width=1,372) (actual time=12.355..427.303 rows=12,046 loops=1)

12. 9.997 408.145 ↓ 5.6 12,046 1

Nested Loop Left Join (cost=643.91..13,869.64 rows=2,148 width=1,396) (actual time=12.344..408.145 rows=12,046 loops=1)

13. 17.356 386.102 ↓ 5.6 12,046 1

Nested Loop Left Join (cost=643.49..11,491.43 rows=2,148 width=1,420) (actual time=12.335..386.102 rows=12,046 loops=1)

14. 16.586 368.746 ↓ 10.5 12,046 1

Nested Loop Left Join (cost=643.07..9,757.42 rows=1,149 width=1,355) (actual time=12.328..368.746 rows=12,046 loops=1)

15. 9.194 352.160 ↓ 10.5 12,046 1

Hash Left Join (cost=642.65..8,483.95 rows=1,149 width=1,290) (actual time=12.317..352.160 rows=12,046 loops=1)

  • Hash Cond: (referenced_reference_value.workflow_status_uuid = referenced_workflow_status.uuid)
16. 9.152 340.270 ↓ 10.5 12,046 1

Hash Left Join (cost=473.32..8,311.61 rows=1,149 width=1,102) (actual time=9.599..340.270 rows=12,046 loops=1)

  • Hash Cond: (referenced_reference_value.document_uuid = referenced_document.uuid)
17. 16.459 326.637 ↓ 10.5 12,046 1

Nested Loop Left Join (cost=249.53..8,084.80 rows=1,149 width=972) (actual time=5.085..326.637 rows=12,046 loops=1)

18. 16.143 310.178 ↓ 10.5 12,046 1

Nested Loop Left Join (cost=249.10..6,198.48 rows=1,149 width=929) (actual time=5.075..310.178 rows=12,046 loops=1)

19. 11.491 294.035 ↓ 10.5 12,046 1

Nested Loop Left Join (cost=248.69..4,971.27 rows=1,149 width=906) (actual time=5.069..294.035 rows=12,046 loops=1)

20. 8.520 270.498 ↓ 10.5 12,046 1

Nested Loop Left Join (cost=248.26..3,646.72 rows=1,149 width=834) (actual time=5.063..270.498 rows=12,046 loops=1)

21. 8.483 249.932 ↓ 10.5 12,046 1

Hash Left Join (cost=247.84..911.89 rows=1,149 width=750) (actual time=5.055..249.932 rows=12,046 loops=1)

  • Hash Cond: (entity_reference_value.workflow_status_uuid = workflow_status_value.uuid)
22. 10.337 239.878 ↓ 10.5 12,046 1

Hash Right Join (cost=61.34..721.07 rows=1,149 width=496) (actual time=3.469..239.878 rows=12,046 loops=1)

  • Hash Cond: (entity_value.entity_uuid = entity.uuid)
23. 9.524 226.256 ↓ 1,720.9 12,046 1

Nested Loop Left Join (cost=2.81..662.53 rows=7 width=496) (actual time=0.169..226.256 rows=12,046 loops=1)

24. 9.260 180.594 ↓ 1,720.9 12,046 1

Nested Loop Left Join (cost=2.40..654.78 rows=7 width=520) (actual time=0.117..180.594 rows=12,046 loops=1)

25. 14.635 159.288 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.97..641.91 rows=4 width=455) (actual time=0.096..159.288 rows=12,046 loops=1)

26. 16.469 144.653 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.69..638.28 rows=4 width=325) (actual time=0.091..144.653 rows=12,046 loops=1)

27. 8.470 116.138 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.26..628.45 rows=4 width=282) (actual time=0.085..116.138 rows=12,046 loops=1)

28. 10.821 95.622 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=0.85..622.94 rows=4 width=259) (actual time=0.062..95.622 rows=12,046 loops=1)

29. 24.571 24.571 ↓ 3,011.5 12,046 1

Index Scan using ux_entity_reference_value_for_field_in_entity on entity_value (cost=0.42..612.35 rows=4 width=155) (actual time=0.040..24.571 rows=12,046 loops=1)

  • Index Cond: (entity_field_uuid = ANY ('{cfd670dd-97ad-49db-8228-2d816c9a71d7,79aad83f-0140-46ea-bf07-688553d48bc6,36cc5134-6c0f-49cd-b793-b76a4c4f720b,eff69611-b90e-4755-8a4c-3b2a41a7e901,09b017fd-2c7c-4867-8106-579a3dbb32ee,29f4fb8e-ede1-462c-9243-eb17ccde3af9,d145c622-aae5-4984-b6f9-a00127680994,7d92b04d-a18e-4c41-af05-b1b2f6368f2f,cc3d4d3e-a687-4ff7-b006-e8c5b91b3de0,e5eb2d8b-3054-4d85-a113-5fb0f9718249,6ea05dce-3661-44ac-8979-2c17a8b72605,438cc699-96ec-4cf0-91ea-5b93f906cfc1,c5fbe12d-193b-42e7-8b7b-060ea111011f,c56c7f58-2a4a-48c7-a8f8-74672a04ea4b,28d69d43-fbb3-4094-a914-62d82aa8dc6f,e68a03b1-a789-4236-8889-034f8af19329,3563ca49-e830-4b98-8fad-a172023ef258,487c2f5d-10dd-4350-817a-0e5b89725386,c886ef75-7609-48ef-8185-830ce0e1bd8e}'::uuid[]))
  • Filter: (company_id = 467)
30. 60.230 60.230 ↑ 1.0 1 12,046

Index Scan using ux_entity_reference_value_uuid on entity_reference_value (cost=0.43..2.65 rows=1 width=120) (actual time=0.005..0.005 rows=1 loops=12,046)

  • Index Cond: (uuid = entity_value.entity_reference_value_uuid)
  • Filter: ((NOT deleted) AND (company_id = 467))
31. 12.046 12.046 ↓ 0.0 0 12,046

Index Scan using select_option_uuid_unique on select_option (cost=0.41..1.38 rows=1 width=39) (actual time=0.001..0.001 rows=0 loops=12,046)

  • Index Cond: (uuid = entity_reference_value.select_option_uuid)
  • Filter: ((NOT deleted) AND (company_id = 467))
32. 12.046 12.046 ↓ 0.0 0 12,046

Index Scan using employee_uuid_unique on employee user_picker_employee (cost=0.43..2.46 rows=1 width=59) (actual time=0.001..0.001 rows=0 loops=12,046)

  • Index Cond: (uuid = entity_reference_value.employee_uuid)
  • Filter: (company_id = 467)
33. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using document_uuid_unique on document (cost=0.28..0.91 rows=1 width=146) (actual time=0.000..0.000 rows=0 loops=12,046)

  • Index Cond: (uuid = entity_reference_value.document_uuid)
  • Filter: ((NOT deleted) AND ((uploaded IS TRUE) OR (uploaded IS NULL)) AND (company_id = 467))
34. 12.046 12.046 ↓ 0.0 0 12,046

Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translation_unit select_option_translation_unit (cost=0.42..3.20 rows=2 width=81) (actual time=0.001..0.001 rows=0 loops=12,046)

  • Index Cond: (item_uuid = select_option.uuid)
35. 36.138 36.138 ↓ 0.0 0 12,046

Index Scan using ux_translation_key_locale on translation select_option_translation (cost=0.42..1.10 rows=1 width=106) (actual time=0.002..0.003 rows=0 loops=12,046)

  • Index Cond: (select_option_translation_unit.translation_key = translation_key)
  • Filter: ((locale = 'en-US'::text) OR (locale IS NULL))
  • Rows Removed by Filter: 6
36. 0.270 3.285 ↓ 1.4 840 1

Hash (cost=50.84..50.84 rows=615 width=16) (actual time=3.284..3.285 rows=840 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 48kB
37. 3.015 3.015 ↓ 1.4 840 1

Index Scan using ix_entity_config on entity (cost=0.41..50.84 rows=615 width=16) (actual time=0.031..3.015 rows=840 loops=1)

  • Index Cond: (entity_config_uuid = '917c328a-bcdd-4da9-9886-ba0b28a394ac'::uuid)
  • Filter: (actions_run AND (company_id = 467))
38. 0.023 1.571 ↑ 1.0 15 1

Hash (cost=186.31..186.31 rows=15 width=270) (actual time=1.571..1.571 rows=15 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
39. 0.020 1.548 ↑ 1.0 15 1

Nested Loop Left Join (cost=1.96..186.31 rows=15 width=270) (actual time=0.095..1.548 rows=15 loops=1)

40. 0.015 0.793 ↑ 1.0 15 1

Nested Loop Left Join (cost=1.54..169.02 rows=15 width=294) (actual time=0.070..0.793 rows=15 loops=1)

41. 0.024 0.733 ↑ 1.0 15 1

Nested Loop Left Join (cost=1.12..129.12 rows=15 width=229) (actual time=0.062..0.733 rows=15 loops=1)

42. 0.021 0.364 ↑ 1.0 15 1

Nested Loop Left Join (cost=0.70..112.11 rows=15 width=253) (actual time=0.035..0.364 rows=15 loops=1)

43. 0.193 0.193 ↑ 1.0 15 1

Index Scan using workflow_status_uuid_company_id_unique on workflow_status workflow_status_value (cost=0.28..72.21 rows=15 width=188) (actual time=0.019..0.193 rows=15 loops=1)

  • Index Cond: (company_id = 467)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 5
44. 0.150 0.150 ↑ 1.0 1 15

Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translation_unit workflow_status_name_translation_unit (cost=0.42..2.65 rows=1 width=81) (actual time=0.010..0.010 rows=1 loops=15)

  • Index Cond: ((item_uuid = workflow_status_value.uuid) AND (item_property_type = 'name'::text))
45. 0.345 0.345 ↑ 1.0 1 15

Index Scan using ux_translation_key_locale on translation workflow_status_name_translation (cost=0.42..1.12 rows=1 width=106) (actual time=0.020..0.023 rows=1 loops=15)

  • Index Cond: (workflow_status_name_translation_unit.translation_key = translation_key)
  • Filter: ((locale = 'en-US'::text) OR (locale IS NULL))
  • Rows Removed by Filter: 15
46. 0.045 0.045 ↑ 1.0 1 15

Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translation_unit workflow_status_description_translation_unit (cost=0.42..2.65 rows=1 width=81) (actual time=0.002..0.003 rows=1 loops=15)

  • Index Cond: ((item_uuid = workflow_status_value.uuid) AND (item_property_type = 'description'::text))
47. 0.735 0.735 ↑ 1.0 1 15

Index Scan using ux_translation_key_locale on translation workflow_status_description_translation (cost=0.42..1.14 rows=1 width=106) (actual time=0.044..0.049 rows=1 loops=15)

  • Index Cond: (workflow_status_description_translation_unit.translation_key = translation_key)
  • Filter: ((locale = 'en-US'::text) OR (locale IS NULL))
  • Rows Removed by Filter: 15
48. 12.046 12.046 ↓ 0.0 0 12,046

Index Scan using ux_entity_reference_value_for_field_in_entity on entity_value referenced_value (cost=0.42..2.37 rows=1 width=132) (actual time=0.001..0.001 rows=0 loops=12,046)

  • Index Cond: ((entity_field_uuid = entity_reference_value.referenced_entity_field_uuid) AND (entity_uuid = entity_reference_value.referenced_entity_uuid))
49. 12.046 12.046 ↓ 0.0 0 12,046

Index Scan using ux_entity_reference_value_uuid on entity_reference_value referenced_reference_value (cost=0.43..1.15 rows=1 width=88) (actual time=0.001..0.001 rows=0 loops=12,046)

  • Index Cond: (uuid = referenced_value.entity_reference_value_uuid)
  • Filter: (NOT deleted)
50. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using select_option_uuid_unique on select_option referenced_select_option (cost=0.41..1.07 rows=1 width=39) (actual time=0.000..0.000 rows=0 loops=12,046)

  • Index Cond: (uuid = referenced_reference_value.select_option_uuid)
  • Filter: (NOT deleted)
51. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using employee_uuid_unique on employee referenced_user (cost=0.43..1.64 rows=1 width=59) (actual time=0.000..0.000 rows=0 loops=12,046)

  • Index Cond: (uuid = referenced_reference_value.employee_uuid)
52. 2.048 4.481 ↓ 1.0 4,126 1

Hash (cost=172.24..172.24 rows=4,124 width=146) (actual time=4.481..4.481 rows=4,126 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 797kB
53. 2.433 2.433 ↓ 1.0 4,126 1

Seq Scan on document referenced_document (cost=0.00..172.24 rows=4,124 width=146) (actual time=0.012..2.433 rows=4,126 loops=1)

  • Filter: ((NOT deleted) AND ((uploaded IS TRUE) OR (uploaded IS NULL)))
54. 1.301 2.696 ↓ 1.0 2,506 1

Hash (cost=138.04..138.04 rows=2,503 width=188) (actual time=2.696..2.696 rows=2,506 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 459kB
55. 1.395 1.395 ↓ 1.0 2,506 1

Seq Scan on workflow_status referenced_workflow_status (cost=0.00..138.04 rows=2,503 width=188) (actual time=0.007..1.395 rows=2,506 loops=1)

  • Filter: (NOT deleted)
  • Rows Removed by Filter: 911
56. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translation_unit referenced_workflow_status_name_translation_unit (cost=0.42..1.10 rows=1 width=81) (actual time=0.000..0.000 rows=0 loops=12,046)

  • Index Cond: ((item_uuid = referenced_reference_value.workflow_status_uuid) AND (item_property_type = 'name'::text))
57. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translation_unit referenced_select_option_translation_unit (cost=0.42..1.49 rows=2 width=81) (actual time=0.000..0.000 rows=0 loops=12,046)

  • Index Cond: (item_uuid = referenced_select_option.uuid)
58. 12.046 12.046 ↓ 0.0 0 12,046

Index Scan using ux_translation_key_locale on translation referenced_select_option_translation (cost=0.42..1.10 rows=1 width=106) (actual time=0.001..0.001 rows=0 loops=12,046)

  • Index Cond: (referenced_select_option_translation_unit.translation_key = translation_key)
  • Filter: ((locale = 'en-US'::text) OR (locale IS NULL))
  • Rows Removed by Filter: 1
59. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using ux_translation_key_locale on translation referenced_workflow_status_name_translation (cost=0.42..1.12 rows=1 width=106) (actual time=0.000..0.000 rows=0 loops=12,046)

  • Index Cond: (referenced_workflow_status_name_translation_unit.translation_key = translation_key)
  • Filter: ((locale = 'en-US'::text) OR (locale IS NULL))
  • Rows Removed by Filter: 1
60. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using ux_translation_unit_item_uuid_item_type_item_property_type on translation_unit referenced_workflow_status_description_translation_unit (cost=0.42..1.10 rows=1 width=81) (actual time=0.000..0.000 rows=0 loops=12,046)

  • Index Cond: ((item_uuid = referenced_reference_value.workflow_status_uuid) AND (item_property_type = 'description'::text))
61. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using ux_translation_key_locale on translation referenced_workflow_status_description_translation (cost=0.42..1.14 rows=1 width=106) (actual time=0.000..0.000 rows=0 loops=12,046)

  • Index Cond: (referenced_workflow_status_description_translation_unit.translation_key = translation_key)
  • Filter: ((locale = 'en-US'::text) OR (locale IS NULL))
  • Rows Removed by Filter: 1
62. 8.451 525.868 ↓ 7.4 7,991 1

Sort (cost=221.41..224.10 rows=1,074 width=6,546) (actual time=524.001..525.868 rows=7,991 loops=1)

  • Sort Key: full_1."entityValueDate" DESC NULLS LAST
  • Sort Method: quicksort Memory: 2,421kB
63. 5.831 517.417 ↓ 7.4 7,991 1

Hash Left Join (cost=102.18..167.34 rows=1,074 width=6,546) (actual time=496.069..517.417 rows=7,991 loops=1)

  • Hash Cond: ("full".uuid = full_1.uuid)
64. 6.838 509.897 ↓ 7.4 7,991 1

Hash Semi Join (cost=53.71..114.26 rows=1,074 width=6,538) (actual time=494.362..509.897 rows=7,991 loops=1)

  • Hash Cond: ("full".uuid = full_2.uuid)
65. 492.176 492.176 ↓ 5.6 12,046 1

CTE Scan on "full" (cost=0.00..42.96 rows=2,148 width=6,538) (actual time=483.462..492.176 rows=12,046 loops=1)

66. 0.216 10.883 ↓ 607.0 607 1

Hash (cost=53.70..53.70 rows=1 width=16) (actual time=10.882..10.883 rows=607 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
67. 10.667 10.667 ↓ 607.0 607 1

CTE Scan on "full" full_2 (cost=0.00..53.70 rows=1 width=16) (actual time=0.011..10.667 rows=607 loops=1)

  • Filter: (("workflowStatusValueUuid" = '7650becf-f98e-4212-8b1a-c2f1d60d1819'::uuid) AND ("entityFieldUuid" = '7d92b04d-a18e-4c41-af05-b1b2f6368f2f'::uuid))
  • Rows Removed by Filter: 11,439
68. 0.270 1.689 ↓ 76.4 840 1

Hash (cost=48.33..48.33 rows=11 width=24) (actual time=1.689..1.689 rows=840 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 54kB
69. 1.419 1.419 ↓ 76.4 840 1

CTE Scan on "full" full_1 (cost=0.00..48.33 rows=11 width=24) (actual time=0.002..1.419 rows=840 loops=1)

  • Filter: ("entityFieldUuid" = 'd145c622-aae5-4984-b6f9-a00127680994'::uuid)
  • Rows Removed by Filter: 11,206