explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T2mR : Deere List Fetch With Different Translation WHERE

Settings
# exclusive inclusive rows x rows loops node
1. 0.050 973.673 ↑ 1.0 10 1

Limit (cost=10,329.02..10,329.04 rows=10 width=64) (actual time=973.623..973.673 rows=10 loops=1)

2. 0.979 973.623 ↑ 20.0 10 1

Sort (cost=10,329.02..10,329.52 rows=200 width=64) (actual time=973.620..973.623 rows=10 loops=1)

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

GroupAggregate (cost=10,318.24..10,324.69 rows=200 width=64) (actual time=697.382..972.644 rows=607 loops=1)

  • Group Key: filter_query.uuid
4. 7.378 699.067 ↓ 29.0 7,991 1

Sort (cost=10,318.24..10,318.93 rows=276 width=6,594) (actual time=696.838..699.067 rows=7,991 loops=1)

  • Sort Key: filter_query.uuid
  • Sort Method: quicksort Memory: 3,192kB
5. 8.610 691.689 ↓ 29.0 7,991 1

Subquery Scan on filter_query (cost=10,299.46..10,307.05 rows=276 width=6,594) (actual time=671.671..691.689 rows=7,991 loops=1)

6. 9.649 683.079 ↓ 29.0 7,991 1

WindowAgg (cost=10,299.46..10,304.29 rows=276 width=6,554) (actual time=671.653..683.079 rows=7,991 loops=1)

7.          

CTE full

8. 20.298 634.071 ↓ 21.9 12,046 1

Sort (cost=10,244.06..10,245.44 rows=551 width=1,461) (actual time=630.802..634.071 rows=12,046 loops=1)

  • Sort Key: entity_value.created_at
  • Sort Method: quicksort Memory: 3,980kB
9. 14.590 613.773 ↓ 21.9 12,046 1

Nested Loop Left Join (cost=647.40..10,218.98 rows=551 width=1,461) (actual time=19.062..613.773 rows=12,046 loops=1)

  • Filter: ((referenced_workflow_status_description_translation.locale = 'en-US'::text) OR (referenced_workflow_status_description_translation.locale IS NULL))
  • Rows Removed by Filter: 6,468
10. 16.879 587.137 ↓ 17.4 12,046 1

Nested Loop Left Join (cost=646.98..9,419.49 rows=691 width=1,421) (actual time=19.049..587.137 rows=12,046 loops=1)

11. 9.805 570.258 ↓ 17.4 12,046 1

Nested Loop Left Join (cost=646.56..8,653.63 rows=691 width=1,372) (actual time=19.041..570.258 rows=12,046 loops=1)

  • Filter: ((referenced_workflow_status_name_translation.locale = 'en-US'::text) OR (referenced_workflow_status_name_translation.locale IS NULL))
  • Rows Removed by Filter: 6,468
12. 15.689 548.407 ↓ 13.9 12,046 1

Nested Loop Left Join (cost=646.14..7,670.67 rows=867 width=1,396) (actual time=19.032..548.407 rows=12,046 loops=1)

  • Filter: ((referenced_select_option_translation.locale = 'en-US'::text) OR (referenced_select_option_translation.locale IS NULL))
  • Rows Removed by Filter: 13,160
13. 17.333 520.672 ↓ 11.1 12,046 1

Nested Loop Left Join (cost=645.72..6,466.07 rows=1,088 width=1,420) (actual time=19.021..520.672 rows=12,046 loops=1)

14. 16.619 503.339 ↓ 20.7 12,046 1

Nested Loop Left Join (cost=645.30..5,587.74 rows=582 width=1,355) (actual time=19.010..503.339 rows=12,046 loops=1)

15. 9.463 486.720 ↓ 20.7 12,046 1

Hash Left Join (cost=644.88..4,942.69 rows=582 width=1,290) (actual time=19.001..486.720 rows=12,046 loops=1)

  • Hash Cond: (referenced_reference_value.workflow_status_uuid = referenced_workflow_status.uuid)
16. 9.407 474.717 ↓ 20.7 12,046 1

Hash Left Join (cost=475.56..4,771.84 rows=582 width=1,102) (actual time=16.437..474.717 rows=12,046 loops=1)

  • Hash Cond: (referenced_reference_value.document_uuid = referenced_document.uuid)
17. 16.860 461.408 ↓ 20.7 12,046 1

Nested Loop Left Join (cost=251.77..4,546.52 rows=582 width=972) (actual time=12.492..461.408 rows=12,046 loops=1)

18. 15.946 444.548 ↓ 20.7 12,046 1

Nested Loop Left Join (cost=251.34..3,591.05 rows=582 width=929) (actual time=12.485..444.548 rows=12,046 loops=1)

19. 6.720 428.602 ↓ 20.7 12,046 1

Nested Loop Left Join (cost=250.92..2,969.43 rows=582 width=906) (actual time=12.481..428.602 rows=12,046 loops=1)

20. 7.673 409.836 ↓ 20.7 12,046 1

Nested Loop Left Join (cost=250.50..2,298.51 rows=582 width=834) (actual time=12.477..409.836 rows=12,046 loops=1)

21. 120.065 390.117 ↓ 20.7 12,046 1

Hash Left Join (cost=250.07..913.24 rows=582 width=750) (actual time=12.471..390.117 rows=12,046 loops=1)

  • Hash Cond: (entity_reference_value.workflow_status_uuid = workflow_status_value.uuid)
  • Filter: (((workflow_status_name_translation.locale = 'en-US'::text) OR (workflow_status_name_translation.locale IS NULL)) AND ((workflow_status_description_translation.locale = 'en-US'::text) OR (workflow_status_description_translation.locale IS NULL)))
  • Rows Removed by Filter: 705,600
22. 33.922 258.877 ↓ 13.2 12,046 1

Hash Right Join (cost=61.34..721.06 rows=916 width=496) (actual time=1.287..258.877 rows=12,046 loops=1)

  • Hash Cond: (entity_value.entity_uuid = entity.uuid)
  • Filter: ((select_option_translation.locale = 'en-US'::text) OR (select_option_translation.locale IS NULL))
  • Rows Removed by Filter: 69,748
23. 54.309 223.749 ↓ 10,224.2 81,794 1

Nested Loop Left Join (cost=2.81..662.51 rows=8 width=496) (actual time=0.058..223.749 rows=81,794 loops=1)

24. 8.759 133.302 ↓ 1,720.9 12,046 1

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

25. 14.703 112.497 ↓ 3,011.5 12,046 1

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

26. 9.899 97.794 ↓ 3,011.5 12,046 1

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

27. 7.409 75.849 ↓ 3,011.5 12,046 1

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

28. 18.745 56.394 ↓ 3,011.5 12,046 1

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

29. 13.557 13.557 ↓ 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.012..13.557 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. 24.092 24.092 ↑ 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.002..0.002 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 ↓ 6.0 6 12,046

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

  • Index Cond: (select_option_translation_unit.translation_key = translation_key)
36. 0.291 1.206 ↓ 1.4 840 1

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

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

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

  • Index Cond: (entity_config_uuid = '917c328a-bcdd-4da9-9886-ba0b28a394ac'::uuid)
  • Filter: (actions_run AND (company_id = 467))
38. 3.808 11.175 ↓ 354.5 6,735 1

Hash (cost=188.50..188.50 rows=19 width=270) (actual time=11.174..11.175 rows=6,735 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 3,834kB
39. 3.407 7.367 ↓ 354.5 6,735 1

Nested Loop Left Join (cost=1.96..188.50 rows=19 width=270) (actual time=0.045..7.367 rows=6,735 loops=1)

40. 0.142 0.614 ↓ 14.1 239 1

Nested Loop Left Join (cost=1.54..169.27 rows=17 width=294) (actual time=0.034..0.614 rows=239 loops=1)

41. 0.025 0.262 ↑ 1.0 15 1

Nested Loop Left Join (cost=1.12..152.01 rows=15 width=318) (actual time=0.022..0.262 rows=15 loops=1)

42. 0.024 0.207 ↑ 1.0 15 1

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

43. 0.123 0.123 ↑ 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.010..0.123 rows=15 loops=1)

  • Index Cond: (company_id = 467)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 5
44. 0.060 0.060 ↑ 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.004..0.004 rows=1 loops=15)

  • Index Cond: ((item_uuid = workflow_status_value.uuid) AND (item_property_type = 'name'::text))
45. 0.030 0.030 ↑ 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.002 rows=1 loops=15)

  • Index Cond: ((item_uuid = workflow_status_value.uuid) AND (item_property_type = 'description'::text))
46. 0.210 0.210 ↓ 16.0 16 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.008..0.014 rows=16 loops=15)

  • Index Cond: (workflow_status_description_translation_unit.translation_key = translation_key)
47. 3.346 3.346 ↓ 28.0 28 239

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.005..0.014 rows=28 loops=239)

  • Index Cond: (workflow_status_name_translation_unit.translation_key = translation_key)
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.070 3.902 ↓ 1.0 4,126 1

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

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

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

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

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 459kB
55. 1.238 1.238 ↓ 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.005..1.238 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 ↑ 1.0 1 12,046

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

  • Index Cond: (referenced_select_option_translation_unit.translation_key = translation_key)
59. 12.046 12.046 ↑ 1.0 1 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.001 rows=1 loops=12,046)

  • Index Cond: (referenced_workflow_status_name_translation_unit.translation_key = translation_key)
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. 12.046 12.046 ↑ 1.0 1 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.001 rows=1 loops=12,046)

  • Index Cond: (referenced_workflow_status_description_translation_unit.translation_key = translation_key)
62. 8.391 673.430 ↓ 29.0 7,991 1

Sort (cost=54.02..54.71 rows=276 width=6,546) (actual time=671.629..673.430 rows=7,991 loops=1)

  • Sort Key: full_1."entityValueDate" DESC NULLS LAST
  • Sort Method: quicksort Memory: 2,421kB
63. 5.815 665.039 ↓ 29.0 7,991 1

Hash Left Join (cost=26.22..42.83 rows=276 width=6,546) (actual time=643.560..665.039 rows=7,991 loops=1)

  • Hash Cond: ("full".uuid = full_1.uuid)
64. 6.840 657.425 ↓ 29.0 7,991 1

Hash Semi Join (cost=13.79..29.32 rows=276 width=6,538) (actual time=641.750..657.425 rows=7,991 loops=1)

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

CTE Scan on "full" (cost=0.00..11.02 rows=551 width=6,538) (actual time=630.809..639.662 rows=12,046 loops=1)

66. 0.218 10.923 ↓ 607.0 607 1

Hash (cost=13.78..13.78 rows=1 width=16) (actual time=10.922..10.923 rows=607 loops=1)

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

CTE Scan on "full" full_2 (cost=0.00..13.78 rows=1 width=16) (actual time=0.007..10.705 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.268 1.799 ↓ 280.0 840 1

Hash (cost=12.40..12.40 rows=3 width=24) (actual time=1.798..1.799 rows=840 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 54kB
69. 1.531 1.531 ↓ 280.0 840 1

CTE Scan on "full" full_1 (cost=0.00..12.40 rows=3 width=24) (actual time=0.002..1.531 rows=840 loops=1)

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