explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jvpj : Deere List Fetch With Filter

Settings
# exclusive inclusive rows x rows loops node
1. 0.051 1,823,251.190 ↓ 10.0 10 1

Limit (cost=7,123.41..7,123.41 rows=1 width=64) (actual time=1,823,251.138..1,823,251.190 rows=10 loops=1)

2. 17.591 1,823,251.139 ↓ 10.0 10 1

Sort (cost=7,123.41..7,123.41 rows=1 width=64) (actual time=1,823,251.136..1,823,251.139 rows=10 loops=1)

  • Sort Key: (max(filter_query.row_number))
  • Sort Method: top-N heapsort Memory: 169kB
3. 1,293.517 1,823,233.548 ↓ 607.0 607 1

GroupAggregate (cost=7,123.37..7,123.40 rows=1 width=64) (actual time=1,821,927.138..1,823,233.548 rows=607 loops=1)

  • Group Key: filter_query.uuid
4. 47.421 1,821,940.031 ↓ 26,975.0 26,975 1

Sort (cost=7,123.37..7,123.37 rows=1 width=6,594) (actual time=1,821,926.623..1,821,940.031 rows=26,975 loops=1)

  • Sort Key: filter_query.uuid
  • Sort Method: external merge Disk: 17,320kB
5. 31.077 1,821,892.610 ↓ 26,975.0 26,975 1

Subquery Scan on filter_query (cost=7,123.33..7,123.36 rows=1 width=6,594) (actual time=1,821,815.182..1,821,892.610 rows=26,975 loops=1)

6. 34.403 1,821,861.533 ↓ 26,975.0 26,975 1

WindowAgg (cost=7,123.33..7,123.35 rows=1 width=6,554) (actual time=1,821,815.162..1,821,861.533 rows=26,975 loops=1)

7.          

CTE full

8. 6,908.469 238,894.802 ↓ 1,414.5 219,246 1

Sort (cost=7,112.02..7,112.41 rows=155 width=1,461) (actual time=238,720.340..238,894.802 rows=219,246 loops=1)

  • Sort Key: entity_value.created_at
  • Sort Method: external merge Disk: 168,384kB
9. 238.841 231,986.333 ↓ 1,414.5 219,246 1

Nested Loop Left Join (cost=334.14..7,106.39 rows=155 width=1,461) (actual time=18,916.201..231,986.333 rows=219,246 loops=1)

10. 48.040 229,657.008 ↓ 204.3 31,674 1

Nested Loop Left Join (cost=333.72..6,699.09 rows=155 width=1,421) (actual time=18,916.188..229,657.008 rows=31,674 loops=1)

11. 44.135 229,513.946 ↓ 204.3 31,674 1

Nested Loop Left Join (cost=333.30..6,340.46 rows=155 width=1,372) (actual time=18,916.179..229,513.946 rows=31,674 loops=1)

12. 42.826 229,394.193 ↓ 162.6 25,206 1

Nested Loop Left Join (cost=332.88..5,948.63 rows=155 width=1,396) (actual time=18,916.165..229,394.193 rows=25,206 loops=1)

13. 123.994 229,351.367 ↓ 162.6 25,206 1

Nested Loop Left Join (cost=332.46..5,590.00 rows=155 width=1,331) (actual time=18,916.155..229,351.367 rows=25,206 loops=1)

  • Join Filter: (referenced_workflow_status.uuid = referenced_reference_value.workflow_status_uuid)
  • Rows Removed by Join Filter: 376,489
14. 38.063 229,151.755 ↓ 162.6 25,206 1

Nested Loop Left Join (cost=331.93..5,482.62 rows=155 width=1,143) (actual time=18,915.972..229,151.755 rows=25,206 loops=1)

15. 36.267 229,113.692 ↓ 162.6 25,206 1

Nested Loop Left Join (cost=331.64..5,178.80 rows=155 width=1,013) (actual time=18,915.960..229,113.692 rows=25,206 loops=1)

16. 30.465 228,976.601 ↓ 162.6 25,206 1

Nested Loop Left Join (cost=320.43..3,125.30 rows=155 width=970) (actual time=18,915.951..228,976.601 rows=25,206 loops=1)

17. 16.252 228,524.526 ↓ 77.7 12,046 1

Nested Loop Left Join (cost=320.01..2,767.30 rows=155 width=994) (actual time=18,915.942..228,524.526 rows=12,046 loops=1)

18. 14.430 228,243.262 ↓ 77.7 12,046 1

Nested Loop Left Join (cost=319.59..2,191.30 rows=155 width=929) (actual time=18,915.933..228,243.262 rows=12,046 loops=1)

19. 14.154 227,927.682 ↓ 77.7 12,046 1

Nested Loop Left Join (cost=319.17..1,854.12 rows=155 width=906) (actual time=18,915.924..227,927.682 rows=12,046 loops=1)

20. 23.873 225,504.328 ↓ 77.7 12,046 1

Nested Loop Left Join (cost=318.74..1,430.28 rows=155 width=834) (actual time=18,915.914..225,504.328 rows=12,046 loops=1)

21. 127.269 224,721.557 ↓ 77.7 12,046 1

Hash Left Join (cost=318.32..1,020.52 rows=155 width=750) (actual time=18,915.902..224,721.557 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. 60.057 217,310.889 ↓ 37.5 12,046 1

Hash Right Join (cost=81.21..782.19 rows=321 width=496) (actual time=11,632.482..217,310.889 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. 119.067 207,504.639 ↓ 20,448.5 81,794 1

Nested Loop Left Join (cost=13.61..714.57 rows=4 width=496) (actual time=1,646.496..207,504.639 rows=81,794 loops=1)

24. 110.038 206,485.838 ↓ 20,448.5 81,794 1

Nested Loop Left Join (cost=13.32..707.74 rows=4 width=366) (actual time=1,646.466..206,485.838 rows=81,794 loops=1)

25. 64.433 58,655.836 ↓ 20,448.5 81,794 1

Nested Loop Left Join (cost=2.10..654.74 rows=4 width=323) (actual time=1,646.448..58,655.836 rows=81,794 loops=1)

26. 14.399 54,736.683 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.68..645.50 rows=4 width=347) (actual time=1,212.503..54,736.683 rows=12,046 loops=1)

27. 15.440 52,072.164 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.26..630.63 rows=4 width=282) (actual time=910.737..52,072.164 rows=12,046 loops=1)

28. 18.229 50,382.330 ↓ 3,011.5 12,046 1

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

29. 8.979 17,129.187 ↓ 3,011.5 12,046 1

Result (cost=0.42..612.35 rows=4 width=155) (actual time=333.291..17,129.187 rows=12,046 loops=1)

  • One-Time Filter: (get_company_id(current_setting('gan.company_token'::text, true)) = 467)
30. 17,120.208 17,120.208 ↓ 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=333.210..17,120.208 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)
31. 192.736 33,234.914 ↑ 1.0 1 12,046

Result (cost=0.43..2.65 rows=1 width=120) (actual time=2.759..2.759 rows=1 loops=12,046)

  • One-Time Filter: (get_company_id(current_setting('gan.company_token'::text, true)) = 467)
32. 33,042.178 33,042.178 ↑ 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=2.743..2.743 rows=1 loops=12,046)

  • Index Cond: (uuid = entity_value.entity_reference_value_uuid)
  • Filter: ((NOT deleted) AND (company_id = 467))
33. 204.782 1,674.394 ↓ 0.0 0 12,046

Result (cost=0.41..1.92 rows=1 width=39) (actual time=0.139..0.139 rows=0 loops=12,046)

  • One-Time Filter: (get_company_id(current_setting('gan.company_token'::text, true)) = 467)
34. 1,469.612 1,469.612 ↓ 0.0 0 12,046

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

  • Index Cond: (uuid = entity_reference_value.select_option_uuid)
  • Filter: ((NOT deleted) AND (company_id = 467))
35. 2,650.120 2,650.120 ↓ 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.71 rows=1 width=81) (actual time=0.220..0.220 rows=0 loops=12,046)

  • Index Cond: (item_uuid = select_option.uuid)
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
36. 3,854.720 3,854.720 ↓ 6.0 6 12,046

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

  • Index Cond: (select_option_translation_unit.translation_key = translation_key)
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
37. 35,716.791 147,719.964 ↓ 0.0 0 81,794

Index Scan using employee_uuid_unique on employee user_picker_employee (cost=11.22..13.25 rows=1 width=59) (actual time=1.806..1.806 rows=0 loops=81,794)

  • Index Cond: (uuid = entity_reference_value.employee_uuid)
  • Filter: ((company_id = 467) AND ((hashed SubPlan 1) OR (hashed SubPlan 2)))
38.          

SubPlan (for Index Scan)

39. 112,003.171 112,003.173 ↓ 43.2 43,204 1

ProjectSet (cost=0.00..5.27 rows=1,000 width=16) (actual time=111,992.265..112,003.173 rows=43,204 loops=1)

40. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

41. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..2.77 rows=100 width=16) (never executed)

42. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

44. 899.734 899.734 ↓ 0.0 0 81,794

Result (cost=0.28..1.71 rows=1 width=146) (actual time=0.011..0.011 rows=0 loops=81,794)

  • One-Time Filter: (get_company_id(current_setting('gan.company_token'::text, true)) = 467)
45. 0.000 0.000 ↓ 0.0 0 81,794

Index Scan using document_uuid_unique on document (cost=0.28..1.71 rows=1 width=146) (actual time=0.000..0.000 rows=0 loops=81,794)

  • Index Cond: (uuid = entity_reference_value.document_uuid)
  • Filter: ((NOT deleted) AND ((uploaded IS TRUE) OR (uploaded IS NULL)) AND (company_id = 467))
46. 0.311 9,746.193 ↓ 1.8 840 1

Hash (cost=61.85..61.85 rows=461 width=16) (actual time=9,746.193..9,746.193 rows=840 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 48kB
47. 488.356 9,745.882 ↓ 1.8 840 1

Index Scan using ix_entity_config on entity (cost=11.20..61.85 rows=461 width=16) (actual time=9,674.532..9,745.882 rows=840 loops=1)

  • Index Cond: (entity_config_uuid = '917c328a-bcdd-4da9-9886-ba0b28a394ac'::uuid)
  • Filter: (actions_run AND (company_id = 467) AND ((hashed SubPlan 5) OR (hashed SubPlan 6)))
48.          

SubPlan (for Index Scan)

49. 9,257.524 9,257.526 ↓ 1.4 1,440 1

ProjectSet (cost=0.00..5.27 rows=1,000 width=16) (actual time=9,257.182..9,257.526 rows=1,440 loops=1)

50. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

51. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..2.77 rows=100 width=16) (never executed)

52. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

54. 7.133 7,283.399 ↓ 449.0 6,735 1

Hash (cost=236.92..236.92 rows=15 width=270) (actual time=7,283.398..7,283.399 rows=6,735 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 3,834kB
55. 4.382 7,276.266 ↓ 449.0 6,735 1

Nested Loop Left Join (cost=1.96..236.92 rows=15 width=270) (actual time=497.594..7,276.266 rows=6,735 loops=1)

56. 0.565 4,598.191 ↓ 15.9 239 1

Nested Loop Left Join (cost=1.54..197.58 rows=15 width=294) (actual time=334.270..4,598.191 rows=239 loops=1)

57. 0.239 4,593.802 ↓ 15.9 239 1

Nested Loop Left Join (cost=1.12..153.85 rows=15 width=229) (actual time=334.230..4,593.802 rows=239 loops=1)

58. 0.082 1,765.253 ↑ 1.0 15 1

Nested Loop Left Join (cost=0.70..115.93 rows=15 width=253) (actual time=154.497..1,765.253 rows=15 loops=1)

59. 0.041 428.746 ↑ 1.0 15 1

Result (cost=0.28..72.21 rows=15 width=188) (actual time=0.815..428.746 rows=15 loops=1)

  • One-Time Filter: (get_company_id(current_setting('gan.company_token'::text, true)) = 467)
60. 428.705 428.705 ↑ 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.792..428.705 rows=15 loops=1)

  • Index Cond: (company_id = 467)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 5
61. 1,336.425 1,336.425 ↑ 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.91 rows=1 width=81) (actual time=89.094..89.095 rows=1 loops=15)

  • Index Cond: ((item_uuid = workflow_status_value.uuid) AND (item_property_type = 'name'::text))
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
62. 2,828.310 2,828.310 ↓ 16.0 16 15

Index Scan using ux_translation_key_locale on translation workflow_status_name_translation (cost=0.42..2.52 rows=1 width=106) (actual time=153.866..188.554 rows=16 loops=15)

  • Index Cond: (workflow_status_name_translation_unit.translation_key = translation_key)
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
63. 3.824 3.824 ↑ 1.0 1 239

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.91 rows=1 width=81) (actual time=0.016..0.016 rows=1 loops=239)

  • Index Cond: ((item_uuid = workflow_status_value.uuid) AND (item_property_type = 'description'::text))
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
64. 2,673.693 2,673.693 ↓ 28.0 28 239

Index Scan using ux_translation_key_locale on translation workflow_status_description_translation (cost=0.42..2.61 rows=1 width=106) (actual time=8.712..11.187 rows=28 loops=239)

  • Index Cond: (workflow_status_description_translation_unit.translation_key = translation_key)
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
65. 758.898 758.898 ↓ 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.63 rows=1 width=132) (actual time=0.063..0.063 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))
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
66. 2,409.200 2,409.200 ↓ 0.0 0 12,046

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

  • Index Cond: (uuid = referenced_value.entity_reference_value_uuid)
  • Filter: ((NOT deleted) AND (company_id = get_company_id(current_setting('gan.company_token'::text, true))))
67. 301.150 301.150 ↓ 0.0 0 12,046

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

  • Index Cond: (uuid = referenced_reference_value.select_option_uuid)
  • Filter: ((NOT deleted) AND (company_id = get_company_id(current_setting('gan.company_token'::text, true))))
68. 265.012 265.012 ↓ 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..3.71 rows=1 width=81) (actual time=0.022..0.022 rows=0 loops=12,046)

  • Index Cond: (item_uuid = referenced_select_option.uuid)
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
69. 421.610 421.610 ↑ 1.0 1 12,046

Index Scan using ux_translation_key_locale on translation referenced_select_option_translation (cost=0.42..2.30 rows=1 width=106) (actual time=0.021..0.035 rows=1 loops=12,046)

  • Index Cond: (referenced_select_option_translation_unit.translation_key = translation_key)
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
70. 24.271 100.824 ↓ 0.0 0 25,206

Index Scan using employee_uuid_unique on employee referenced_user (cost=11.22..13.25 rows=1 width=59) (actual time=0.004..0.004 rows=0 loops=25,206)

  • Index Cond: (uuid = referenced_reference_value.employee_uuid)
  • Filter: ((hashed SubPlan 3) OR (hashed SubPlan 4))
71.          

SubPlan (for Index Scan)

72. 76.552 76.553 ↓ 43.2 43,204 1

ProjectSet (cost=0.00..5.27 rows=1,000 width=16) (actual time=65.883..76.553 rows=43,204 loops=1)

73. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

74. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..2.77 rows=100 width=16) (never executed)

75. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

77. 0.000 0.000 ↓ 0.0 0 25,206

Index Scan using document_uuid_unique on document referenced_document (cost=0.28..1.96 rows=1 width=146) (actual time=0.000..0.000 rows=0 loops=25,206)

  • Index Cond: (uuid = referenced_reference_value.document_uuid)
  • Filter: ((NOT deleted) AND ((uploaded IS TRUE) OR (uploaded IS NULL)) AND (company_id = get_company_id(current_setting('gan.company_token'::text, true))))
78. 75.464 75.618 ↑ 1.0 15 25,206

Materialize (cost=0.53..72.54 rows=15 width=188) (actual time=0.000..0.003 rows=15 loops=25,206)

79. 0.154 0.154 ↑ 1.0 15 1

Index Scan using workflow_status_uuid_company_id_unique on workflow_status referenced_workflow_status (cost=0.53..72.46 rows=15 width=188) (actual time=0.037..0.154 rows=15 loops=1)

  • Index Cond: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 5
80. 0.000 0.000 ↓ 0.0 0 25,206

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..2.30 rows=1 width=81) (actual time=0.000..0.000 rows=0 loops=25,206)

  • Index Cond: ((item_uuid = referenced_reference_value.workflow_status_uuid) AND (item_property_type = 'name'::text))
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
81. 75.618 75.618 ↓ 0.0 0 25,206

Index Scan using ux_translation_key_locale on translation referenced_workflow_status_name_translation (cost=0.42..2.52 rows=1 width=106) (actual time=0.000..0.003 rows=0 loops=25,206)

  • Index Cond: (referenced_workflow_status_name_translation_unit.translation_key = translation_key)
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
82. 95.022 95.022 ↓ 0.0 0 31,674

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..2.30 rows=1 width=81) (actual time=0.003..0.003 rows=0 loops=31,674)

  • Index Cond: ((item_uuid = referenced_reference_value.workflow_status_uuid) AND (item_property_type = 'description'::text))
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
83. 2,090.484 2,090.484 ↓ 6.0 6 31,674

Index Scan using ux_translation_key_locale on translation referenced_workflow_status_description_translation (cost=0.42..2.61 rows=1 width=106) (actual time=0.004..0.066 rows=6 loops=31,674)

  • Index Cond: (referenced_workflow_status_description_translation_unit.translation_key = translation_key)
  • Filter: (company_id = get_company_id(current_setting('gan.company_token'::text, true)))
84. 238.138 1,821,827.130 ↓ 26,975.0 26,975 1

Sort (cost=10.92..10.92 rows=1 width=6,546) (actual time=1,821,815.139..1,821,827.130 rows=26,975 loops=1)

  • Sort Key: full_1."entityValueDate" DESC NULLS LAST
  • Sort Method: external merge Disk: 16,064kB
85. 5,559.715 1,821,588.992 ↓ 26,975.0 26,975 1

Nested Loop Left Join (cost=3.89..10.91 rows=1 width=6,546) (actual time=240,201.359..1,821,588.992 rows=26,975 loops=1)

  • Join Filter: (full_1.uuid = "full".uuid)
  • Rows Removed by Join Filter: 22,632,025
86. 138.399 240,635.327 ↓ 26,975.0 26,975 1

Hash Semi Join (cost=3.89..7.41 rows=1 width=6,538) (actual time=240,201.334..240,635.327 rows=26,975 loops=1)

  • Hash Cond: ("full".uuid = full_2.uuid)
87. 239,015.963 239,015.963 ↓ 1,414.5 219,246 1

CTE Scan on "full" (cost=0.00..3.10 rows=155 width=6,538) (actual time=238,720.350..239,015.963 rows=219,246 loops=1)

88. 0.289 1,480.965 ↓ 607.0 607 1

Hash (cost=3.88..3.88 rows=1 width=16) (actual time=1,480.964..1,480.965 rows=607 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
89. 1,480.676 1,480.676 ↓ 607.0 607 1

CTE Scan on "full" full_2 (cost=0.00..3.88 rows=1 width=16) (actual time=0.014..1,480.676 rows=607 loops=1)

  • Filter: (("workflowStatusValueUuid" = '7650becf-f98e-4212-8b1a-c2f1d60d1819'::uuid) AND ("entityFieldUuid" = '7d92b04d-a18e-4c41-af05-b1b2f6368f2f'::uuid))
  • Rows Removed by Filter: 218,639
90. 1,575,393.950 1,575,393.950 ↓ 840.0 840 26,975

CTE Scan on "full" full_1 (cost=0.00..3.49 rows=1 width=24) (actual time=0.003..58.402 rows=840 loops=26,975)

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