explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7VbW : Deere List fetch without filters

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 23,837.682 ↑ 1.0 10 1

Limit (cost=21,262.52..21,262.54 rows=10 width=64) (actual time=23,837.628..23,837.682 rows=10 loops=1)

2. 5,427.434 23,837.634 ↑ 20.0 10 1

Sort (cost=21,262.52..21,263.02 rows=200 width=64) (actual time=23,837.626..23,837.634 rows=10 loops=1)

  • Sort Key: (max(filter_query.row_number))
  • Sort Method: external merge Disk: 384,880kB
3. 11,301.812 18,410.200 ↓ 4.2 840 1

GroupAggregate (cost=21,244.94..21,258.19 rows=200 width=64) (actual time=6,987.051..18,410.200 rows=840 loops=1)

  • Group Key: filter_query.uuid
4. 2,441.893 7,108.388 ↓ 267.4 219,246 1

Sort (cost=21,244.94..21,246.99 rows=820 width=6,594) (actual time=6,986.495..7,108.388 rows=219,246 loops=1)

  • Sort Key: filter_query.uuid
  • Sort Method: external merge Disk: 177,944kB
5. 276.119 4,666.495 ↓ 267.4 219,246 1

Subquery Scan on filter_query (cost=19,821.51..19,844.06 rows=820 width=6,594) (actual time=3,959.501..4,666.495 rows=219,246 loops=1)

6. 311.238 4,390.376 ↓ 267.4 219,246 1

WindowAgg (cost=19,821.51..19,835.86 rows=820 width=6,554) (actual time=3,959.479..4,390.376 rows=219,246 loops=1)

7.          

CTE full

8. 915.257 2,450.519 ↓ 133.7 219,246 1

Sort (cost=18,298.74..18,302.84 rows=1,640 width=1,461) (actual time=2,283.167..2,450.519 rows=219,246 loops=1)

  • Sort Key: entity_value.created_at
  • Sort Method: external merge Disk: 168,400kB
9. 202.568 1,535.262 ↓ 133.7 219,246 1

Nested Loop Left Join (cost=671.39..18,211.17 rows=1,640 width=1,461) (actual time=605.983..1,535.262 rows=219,246 loops=1)

10. 41.051 1,237.672 ↓ 22.1 31,674 1

Nested Loop Left Join (cost=670.97..15,503.07 rows=1,430 width=1,421) (actual time=605.967..1,237.672 rows=31,674 loops=1)

11. 32.799 1,196.621 ↓ 20.2 25,206 1

Nested Loop Left Join (cost=670.55..13,144.16 rows=1,247 width=1,445) (actual time=605.955..1,196.621 rows=25,206 loops=1)

12. 20.511 1,163.822 ↓ 20.2 25,206 1

Nested Loop Left Join (cost=670.13..10,783.38 rows=1,247 width=1,396) (actual time=605.947..1,163.822 rows=25,206 loops=1)

13. 17.019 1,131.265 ↓ 11.1 12,046 1

Nested Loop Left Join (cost=669.71..8,734.66 rows=1,088 width=1,420) (actual time=605.936..1,131.265 rows=12,046 loops=1)

14. 17.136 1,114.246 ↓ 20.7 12,046 1

Nested Loop Left Join (cost=669.29..7,200.26 rows=582 width=1,355) (actual time=605.927..1,114.246 rows=12,046 loops=1)

15. 9.819 1,097.110 ↓ 20.7 12,046 1

Hash Left Join (cost=668.87..6,098.43 rows=582 width=1,290) (actual time=605.910..1,097.110 rows=12,046 loops=1)

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

Hash Left Join (cost=499.54..5,927.58 rows=582 width=1,102) (actual time=413.756..895.168 rows=12,046 loops=1)

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

Nested Loop Left Join (cost=275.75..5,702.26 rows=582 width=972) (actual time=27.684..499.574 rows=12,046 loops=1)

18. 16.764 482.739 ↓ 20.7 12,046 1

Nested Loop Left Join (cost=275.32..4,523.34 rows=582 width=929) (actual time=27.673..482.739 rows=12,046 loops=1)

19. 7.212 465.975 ↓ 20.7 12,046 1

Nested Loop Left Join (cost=274.91..3,439.58 rows=582 width=906) (actual time=27.664..465.975 rows=12,046 loops=1)

20. 8.055 446.717 ↓ 20.7 12,046 1

Nested Loop Left Join (cost=274.48..2,338.22 rows=582 width=834) (actual time=27.655..446.717 rows=12,046 loops=1)

21. 129.853 426.616 ↓ 20.7 12,046 1

Hash Left Join (cost=274.06..948.05 rows=582 width=750) (actual time=27.644..426.616 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. 35.239 270.507 ↓ 13.2 12,046 1

Hash Right Join (cost=61.34..731.88 rows=916 width=496) (actual time=1.368..270.507 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. 49.623 234.023 ↓ 10,224.2 81,794 1

Nested Loop Left Join (cost=2.81..673.34 rows=8 width=496) (actual time=0.088..234.023 rows=81,794 loops=1)

24. 8.990 136.216 ↓ 1,720.9 12,046 1

Nested Loop Left Join (cost=2.40..660.16 rows=7 width=520) (actual time=0.072..136.216 rows=12,046 loops=1)

25. 14.578 115.180 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.97..647.29 rows=4 width=455) (actual time=0.061..115.180 rows=12,046 loops=1)

26. 10.280 100.602 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.69..640.46 rows=4 width=325) (actual time=0.055..100.602 rows=12,046 loops=1)

27. 7.808 78.276 ↓ 3,011.5 12,046 1

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

28. 20.365 58.422 ↓ 3,011.5 12,046 1

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

29. 13.965 13.965 ↓ 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.028..13.965 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.92 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..1.71 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. 48.184 48.184 ↓ 6.0 6 12,046

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

  • Index Cond: (select_option_translation_unit.translation_key = translation_key)
36. 0.259 1.245 ↓ 1.4 840 1

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

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

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

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

Hash (cost=212.48..212.48 rows=19 width=270) (actual time=26.256..26.256 rows=6,735 loops=1)

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

Nested Loop Left Join (cost=1.96..212.48 rows=19 width=270) (actual time=0.065..8.176 rows=6,735 loops=1)

40. 0.131 0.663 ↓ 14.1 239 1

Nested Loop Left Join (cost=1.54..180.39 rows=17 width=294) (actual time=0.049..0.663 rows=239 loops=1)

41. 0.015 0.292 ↑ 1.0 15 1

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

42. 0.020 0.232 ↑ 1.0 15 1

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

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

  • Index Cond: (company_id = 467)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 5
44. 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_name_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 = 'name'::text))
45. 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))
46. 0.240 0.240 ↓ 16.0 16 15

Index Scan using ux_translation_key_locale on translation workflow_status_description_translation (cost=0.42..1.88 rows=1 width=106) (actual time=0.008..0.016 rows=16 loops=15)

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

Index Scan using ux_translation_key_locale on translation workflow_status_name_translation (cost=0.42..1.88 rows=1 width=106) (actual time=0.005..0.015 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.38 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.89 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.86 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..2.03 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.353 386.030 ↓ 1.0 4,126 1

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

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

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

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

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 459kB
55. 190.719 190.719 ↓ 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.608..190.719 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.88 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..2.62 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.87 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. 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_description_translation_unit (cost=0.42..1.88 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 = 'description'::text))
60. 0.000 0.000 ↓ 0.0 0 25,206

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

  • Index Cond: (referenced_workflow_status_description_translation_unit.translation_key = translation_key)
61. 95.022 95.022 ↓ 6.0 6 31,674

Index Scan using ux_translation_key_locale on translation referenced_workflow_status_name_translation (cost=0.42..1.88 rows=1 width=106) (actual time=0.001..0.003 rows=6 loops=31,674)

  • Index Cond: (referenced_workflow_status_name_translation_unit.translation_key = translation_key)
62. 646.255 4,079.138 ↓ 267.4 219,246 1

Sort (cost=1,518.67..1,520.72 rows=820 width=6,546) (actual time=3,959.450..4,079.138 rows=219,246 loops=1)

  • Sort Key: full_1."entityValueDate" DESC NULLS LAST
  • Sort Method: external merge Disk: 167,664kB
63. 161.750 3,432.883 ↓ 267.4 219,246 1

Hash Left Join (cost=78.40..128.03 rows=820 width=6,546) (actual time=2,887.370..3,432.883 rows=219,246 loops=1)

  • Hash Cond: ("full".uuid = full_1.uuid)
64. 167.687 3,211.554 ↓ 267.4 219,246 1

Hash Join (cost=41.40..87.63 rows=820 width=6,538) (actual time=2,827.772..3,211.554 rows=219,246 loops=1)

  • Hash Cond: ("full".uuid = full_2.uuid)
65. 2,499.285 2,499.285 ↓ 133.7 219,246 1

CTE Scan on "full" (cost=0.00..32.80 rows=1,640 width=6,538) (actual time=2,283.175..2,499.285 rows=219,246 loops=1)

66. 0.244 544.582 ↓ 4.2 840 1

Hash (cost=38.90..38.90 rows=200 width=16) (actual time=544.581..544.582 rows=840 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 48kB
67. 68.662 544.338 ↓ 4.2 840 1

HashAggregate (cost=36.90..38.90 rows=200 width=16) (actual time=544.091..544.338 rows=840 loops=1)

  • Group Key: full_2.uuid
68. 475.676 475.676 ↓ 133.7 219,246 1

CTE Scan on "full" full_2 (cost=0.00..32.80 rows=1,640 width=16) (actual time=0.001..475.676 rows=219,246 loops=1)

69. 0.313 59.579 ↓ 105.0 840 1

Hash (cost=36.90..36.90 rows=8 width=24) (actual time=59.579..59.579 rows=840 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 54kB
70. 59.266 59.266 ↓ 105.0 840 1

CTE Scan on "full" full_1 (cost=0.00..36.90 rows=8 width=24) (actual time=0.017..59.266 rows=840 loops=1)

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