explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U9Kl : Deere List Fetch With Different Translation

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 10,047.328 ↑ 1.0 10 1

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

2. 0.916 10,047.276 ↑ 20.0 10 1

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

  • Sort Key: (max(filter_query.row_number))
  • Sort Method: top-N heapsort Memory: 169kB
3. 276.884 10,046.360 ↓ 3.0 607 1

GroupAggregate (cost=10,318.24..10,324.69 rows=200 width=64) (actual time=9,768.376..10,046.360 rows=607 loops=1)

  • Group Key: filter_query.uuid
4. 7.317 9,769.476 ↓ 29.0 7,991 1

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

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

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

6. 9.767 9,753.512 ↓ 29.0 7,991 1

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

7.          

CTE full

8. 26.982 9,704.351 ↓ 21.9 12,046 1

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

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

Nested Loop Left Join (cost=647.40..10,218.98 rows=551 width=1,461) (actual time=628.212..9,677.369 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. 18.467 9,645.297 ↓ 17.4 12,046 1

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

11. 12.067 9,626.830 ↓ 17.4 12,046 1

Nested Loop Left Join (cost=646.56..8,653.63 rows=691 width=1,372) (actual time=628.184..9,626.830 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. 16.119 9,602.717 ↓ 13.9 12,046 1

Nested Loop Left Join (cost=646.14..7,670.67 rows=867 width=1,396) (actual time=628.174..9,602.717 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. 15.518 9,562.506 ↓ 11.1 12,046 1

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

14. 19.169 9,534.942 ↓ 20.7 12,046 1

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

15. 10.167 9,515.773 ↓ 20.7 12,046 1

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

  • Hash Cond: (referenced_reference_value.workflow_status_uuid = referenced_workflow_status.uuid)
16. 10.115 9,495.688 ↓ 20.7 12,046 1

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

  • Hash Cond: (referenced_reference_value.document_uuid = referenced_document.uuid)
17. 17.711 9,472.425 ↓ 20.7 12,046 1

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

18. 11.645 9,454.714 ↓ 20.7 12,046 1

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

19. 14.495 9,431.023 ↓ 20.7 12,046 1

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

20. 14.935 8,886.504 ↓ 20.7 12,046 1

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

21. 123.778 8,763.155 ↓ 20.7 12,046 1

Hash Left Join (cost=250.07..913.24 rows=582 width=750) (actual time=604.963..8,763.155 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. 38.773 8,507.581 ↓ 13.2 12,046 1

Hash Right Join (cost=61.34..721.06 rows=916 width=496) (actual time=473.144..8,507.581 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.064 8,007.280 ↓ 10,224.2 81,794 1

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

24. 9.074 7,700.250 ↓ 1,720.9 12,046 1

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

25. 16.961 7,606.854 ↓ 3,011.5 12,046 1

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

26. 7.786 7,589.893 ↓ 3,011.5 12,046 1

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

27. 14.712 6,052.265 ↓ 3,011.5 12,046 1

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

28. 15.525 5,965.277 ↓ 3,011.5 12,046 1

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

29. 1,312.042 1,312.042 ↓ 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=2.570..1,312.042 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. 4,637.710 4,637.710 ↑ 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.385..0.385 rows=1 loops=12,046)

  • Index Cond: (uuid = entity_value.entity_reference_value_uuid)
  • Filter: ((NOT deleted) AND (company_id = 467))
31. 72.276 72.276 ↓ 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.006..0.006 rows=0 loops=12,046)

  • Index Cond: (uuid = entity_reference_value.select_option_uuid)
  • Filter: ((NOT deleted) AND (company_id = 467))
32. 1,529.842 1,529.842 ↓ 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.127..0.127 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. 84.322 84.322 ↓ 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.007..0.007 rows=0 loops=12,046)

  • Index Cond: (item_uuid = select_option.uuid)
35. 252.966 252.966 ↓ 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.010..0.021 rows=6 loops=12,046)

  • Index Cond: (select_option_translation_unit.translation_key = translation_key)
36. 0.671 461.528 ↓ 1.4 840 1

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

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

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

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

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

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

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

40. 0.164 78.221 ↓ 14.1 239 1

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

41. 0.036 33.807 ↑ 1.0 15 1

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

42. 0.056 33.696 ↑ 1.0 15 1

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

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

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

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

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

  • Index Cond: (workflow_status_description_translation_unit.translation_key = translation_key)
47. 44.693 44.693 ↓ 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.096..0.187 rows=28 loops=239)

  • Index Cond: (workflow_status_name_translation_unit.translation_key = translation_key)
48. 108.414 108.414 ↓ 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.009..0.009 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. 530.024 530.024 ↓ 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.044..0.044 rows=0 loops=12,046)

  • Index Cond: (uuid = referenced_value.entity_reference_value_uuid)
  • Filter: (NOT deleted)
50. 12.046 12.046 ↓ 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.001..0.001 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.101 13.148 ↓ 1.0 4,126 1

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

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

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

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

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 459kB
55. 8.539 8.539 ↓ 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=3.128..8.539 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. 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 referenced_select_option_translation_unit (cost=0.42..1.49 rows=2 width=81) (actual time=0.001..0.001 rows=0 loops=12,046)

  • Index Cond: (item_uuid = referenced_select_option.uuid)
58. 24.092 24.092 ↑ 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.001..0.002 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.499 9,743.745 ↓ 29.0 7,991 1

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

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

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

  • Hash Cond: ("full".uuid = full_1.uuid)
64. 6.791 9,727.743 ↓ 29.0 7,991 1

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

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

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

66. 0.215 10.978 ↓ 607.0 607 1

Hash (cost=13.78..13.78 rows=1 width=16) (actual time=10.977..10.978 rows=607 loops=1)

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

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

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

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

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

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