explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ouXT : Deere Filter Without Translations

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 520.089 ↑ 1.0 10 1

Limit (cost=4,743.15..4,743.18 rows=10 width=64) (actual time=520.058..520.089 rows=10 loops=1)

2. 0.831 520.059 ↑ 20.0 10 1

Sort (cost=4,743.15..4,743.65 rows=200 width=64) (actual time=520.057..520.059 rows=10 loops=1)

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

GroupAggregate (cost=4,731.98..4,738.83 rows=200 width=64) (actual time=290.382..519.228 rows=607 loops=1)

  • Group Key: filter_query.uuid
4. 6.986 292.013 ↓ 25.9 7,991 1

Sort (cost=4,731.98..4,732.75 rows=308 width=6,210) (actual time=289.930..292.013 rows=7,991 loops=1)

  • Sort Key: filter_query.uuid
  • Sort Method: quicksort Memory: 2,894kB
5. 8.237 285.027 ↓ 25.9 7,991 1

Subquery Scan on filter_query (cost=4,710.78..4,719.25 rows=308 width=6,210) (actual time=265.839..285.027 rows=7,991 loops=1)

6. 9.303 276.790 ↓ 25.9 7,991 1

WindowAgg (cost=4,710.78..4,716.17 rows=308 width=6,170) (actual time=265.811..276.790 rows=7,991 loops=1)

7.          

CTE full

8. 16.714 230.504 ↓ 19.6 12,046 1

Sort (cost=4,648.70..4,650.24 rows=615 width=1,215) (actual time=227.456..230.504 rows=12,046 loops=1)

  • Sort Key: entity_value.created_at
  • Sort Method: quicksort Memory: 3,339kB
9. 12.196 213.790 ↓ 19.6 12,046 1

Hash Left Join (cost=455.59..4,620.21 rows=615 width=1,215) (actual time=7.450..213.790 rows=12,046 loops=1)

  • Hash Cond: (referenced_reference_value.workflow_status_uuid = referenced_workflow_status.uuid)
10. 7.867 199.094 ↓ 19.6 12,046 1

Hash Left Join (cost=286.26..4,446.20 rows=615 width=979) (actual time=4.939..199.094 rows=12,046 loops=1)

  • Hash Cond: (referenced_reference_value.document_uuid = referenced_document.uuid)
11. 15.154 187.631 ↓ 19.6 12,046 1

Nested Loop Left Join (cost=62.47..4,220.79 rows=615 width=849) (actual time=1.332..187.631 rows=12,046 loops=1)

12. 14.845 172.477 ↓ 19.6 12,046 1

Nested Loop Left Join (cost=62.04..2,987.51 rows=615 width=806) (actual time=1.328..172.477 rows=12,046 loops=1)

13. 16.941 157.632 ↓ 19.6 12,046 1

Nested Loop Left Join (cost=61.63..1,864.42 rows=615 width=783) (actual time=1.325..157.632 rows=12,046 loops=1)

14. 8.956 140.691 ↓ 19.6 12,046 1

Hash Right Join (cost=61.20..721.92 rows=615 width=711) (actual time=1.321..140.691 rows=12,046 loops=1)

  • Hash Cond: (entity_value.entity_uuid = entity.uuid)
15. 17.714 130.465 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=2.68..663.39 rows=4 width=711) (actual time=0.044..130.465 rows=12,046 loops=1)

16. 14.877 112.751 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=2.25..653.85 rows=4 width=627) (actual time=0.040..112.751 rows=12,046 loops=1)

17. 13.320 97.874 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.97..647.07 rows=4 width=455) (actual time=0.037..97.874 rows=12,046 loops=1)

18. 8.229 84.554 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.69..640.34 rows=4 width=325) (actual time=0.033..84.554 rows=12,046 loops=1)

19. 5.733 64.279 ↓ 3,011.5 12,046 1

Nested Loop Left Join (cost=1.26..630.51 rows=4 width=282) (actual time=0.030..64.279 rows=12,046 loops=1)

20. 11.570 46.500 ↓ 3,011.5 12,046 1

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

21. 10.838 10.838 ↓ 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..10.838 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)
22. 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))
23. 12.046 12.046 ↓ 0.0 0 12,046

Index Scan using select_option_uuid_unique on select_option (cost=0.41..1.89 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))
24. 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)
25. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using document_uuid_unique on document (cost=0.28..1.68 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))
26. 0.000 0.000 ↓ 0.0 0 12,046

Index Scan using workflow_status_uuid_unique on workflow_status workflow_status_value (cost=0.28..1.65 rows=1 width=188) (actual time=0.000..0.000 rows=0 loops=12,046)

  • Index Cond: (uuid = entity_reference_value.workflow_status_uuid)
  • Filter: ((NOT deleted) AND (company_id = 467))
27. 0.000 0.000 ↓ 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.000..0.000 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))
28. 0.287 1.270 ↓ 1.4 840 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 48kB
29. 0.983 0.983 ↓ 1.4 840 1

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

  • Index Cond: (entity_config_uuid = '917c328a-bcdd-4da9-9886-ba0b28a394ac'::uuid)
  • Filter: (actions_run AND (company_id = 467))
30. 0.000 0.000 ↓ 0.0 0 12,046

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

  • Index Cond: (uuid = referenced_value.entity_reference_value_uuid)
  • Filter: (NOT deleted)
31. 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.83 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)
32. 0.000 0.000 ↓ 0.0 0 12,046

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

  • Index Cond: (uuid = referenced_reference_value.employee_uuid)
33. 1.827 3.596 ↓ 1.0 4,126 1

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

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

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

  • Filter: ((NOT deleted) AND ((uploaded IS TRUE) OR (uploaded IS NULL)))
35. 1.220 2.500 ↓ 1.0 2,506 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 459kB
36. 1.280 1.280 ↓ 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.003..1.280 rows=2,506 loops=1)

  • Filter: (NOT deleted)
  • Rows Removed by Filter: 911
37. 7.873 267.487 ↓ 25.9 7,991 1

Sort (cost=60.54..61.31 rows=308 width=6,162) (actual time=265.789..267.487 rows=7,991 loops=1)

  • Sort Key: full_1."entityValueDate" DESC NULLS LAST
  • Sort Method: quicksort Memory: 2,073kB
38. 5.693 259.614 ↓ 25.9 7,991 1

Hash Left Join (cost=29.26..47.81 rows=308 width=6,162) (actual time=239.496..259.614 rows=7,991 loops=1)

  • Hash Cond: ("full".uuid = full_1.uuid)
39. 6.511 252.309 ↓ 25.9 7,991 1

Hash Semi Join (cost=15.39..32.73 rows=308 width=6,154) (actual time=237.873..252.309 rows=7,991 loops=1)

  • Hash Cond: ("full".uuid = full_2.uuid)
40. 235.400 235.400 ↓ 19.6 12,046 1

CTE Scan on "full" (cost=0.00..12.30 rows=615 width=6,154) (actual time=227.463..235.400 rows=12,046 loops=1)

41. 0.218 10.398 ↓ 607.0 607 1

Hash (cost=15.38..15.38 rows=1 width=16) (actual time=10.397..10.398 rows=607 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
42. 10.180 10.180 ↓ 607.0 607 1

CTE Scan on "full" full_2 (cost=0.00..15.38 rows=1 width=16) (actual time=0.006..10.180 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
43. 0.245 1.612 ↓ 280.0 840 1

Hash (cost=13.84..13.84 rows=3 width=24) (actual time=1.612..1.612 rows=840 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 54kB
44. 1.367 1.367 ↓ 280.0 840 1

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

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