explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oQr8

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.006 3,658.499 ↑ 1.0 1 1

Aggregate (cost=278,947.84..278,947.85 rows=1 width=8) (actual time=3,658.499..3,658.499 rows=1 loops=1)

2. 0.000 3,658.493 ↓ 34.0 34 1

Unique (cost=278,844.72..278,947.83 rows=1 width=614) (actual time=3,658.243..3,658.493 rows=34 loops=1)

3.          

Initplan (for Unique)

4. 0.004 0.057 ↑ 1.0 1 1

Nested Loop (cost=12.50..17.93 rows=1 width=0) (actual time=0.057..0.057 rows=1 loops=1)

5. 0.002 0.039 ↑ 1.5 2 1

HashAggregate (cost=11.95..11.98 rows=3 width=16) (actual time=0.039..0.039 rows=2 loops=1)

  • Group Key: attribute_values.id
6. 0.003 0.037 ↑ 1.0 3 1

Nested Loop (cost=0.70..11.94 rows=3 width=16) (actual time=0.034..0.037 rows=3 loops=1)

7. 0.017 0.017 ↑ 1.0 1 1

Index Scan using index_attributes_on_team_id_and_archived_at on attributes (cost=0.29..2.31 rows=1 width=16) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid)
  • Filter: ((label)::text = 'Role'::text)
  • Rows Removed by Filter: 1
8. 0.017 0.017 ↑ 1.0 3 1

Index Scan using index_attribute_values_on_attribute_id_and_archived_at on attribute_values (cost=0.42..9.61 rows=3 width=32) (actual time=0.015..0.017 rows=3 loops=1)

  • Index Cond: ((attribute_id = attributes.id) AND (archived_at = 0))
  • Filter: (label = ANY ('{JOBCREATOR,EXECUTOR,WORKFLOW_PLANNER}'::text[]))
  • Rows Removed by Filter: 5
9. 0.014 0.014 ↓ 0.0 0 2

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values actor_attribute_values_1 (cost=0.56..1.97 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=2)

  • Index Cond: ((attribute_value_id = attribute_values.id) AND (actor_id = '78ed74a1-58aa-47a6-bf29-223482b2149b'::uuid))
  • Filter: (archived_at = 0)
10. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.47..14.26 rows=1 width=0) (never executed)

11. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.91..11.92 rows=1 width=16) (never executed)

  • Group Key: attribute_values_1.id
12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..11.91 rows=1 width=16) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using index_attributes_on_team_id_and_archived_at on attributes attributes_1 (cost=0.29..2.31 rows=1 width=16) (never executed)

  • Index Cond: (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid)
  • Filter: ((label)::text = 'Role'::text)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using index_attribute_values_on_attribute_id_and_archived_at on attribute_values attribute_values_1 (cost=0.42..9.60 rows=1 width=32) (never executed)

  • Index Cond: ((attribute_id = attributes_1.id) AND (archived_at = 0))
  • Filter: (label = 'PARSABLE_ADMIN'::text)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values actor_attribute_values_2 (cost=0.56..2.32 rows=1 width=16) (never executed)

  • Index Cond: ((attribute_value_id = attribute_values_1.id) AND (actor_id = '78ed74a1-58aa-47a6-bf29-223482b2149b'::uuid))
  • Filter: (archived_at = 0)
16. 0.001 0.058 ↑ 1.0 1 1

Nested Loop (cost=12.50..17.93 rows=1 width=0) (actual time=0.058..0.058 rows=1 loops=1)

17. 0.005 0.041 ↑ 1.5 2 1

HashAggregate (cost=11.95..11.98 rows=3 width=16) (actual time=0.040..0.041 rows=2 loops=1)

  • Group Key: attribute_values_2.id
18. 0.002 0.036 ↑ 1.0 3 1

Nested Loop (cost=0.70..11.94 rows=3 width=16) (actual time=0.034..0.036 rows=3 loops=1)

19. 0.018 0.018 ↑ 1.0 1 1

Index Scan using index_attributes_on_team_id_and_archived_at on attributes attributes_2 (cost=0.29..2.31 rows=1 width=16) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid)
  • Filter: ((label)::text = 'Role'::text)
  • Rows Removed by Filter: 1
20. 0.016 0.016 ↑ 1.0 3 1

Index Scan using index_attribute_values_on_attribute_id_and_archived_at on attribute_values attribute_values_2 (cost=0.42..9.61 rows=3 width=32) (actual time=0.014..0.016 rows=3 loops=1)

  • Index Cond: ((attribute_id = attributes_2.id) AND (archived_at = 0))
  • Filter: (label = ANY ('{JOBCREATOR,EXECUTOR,WORKFLOW_PLANNER}'::text[]))
  • Rows Removed by Filter: 5
21. 0.016 0.016 ↓ 0.0 0 2

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values actor_attribute_values_4 (cost=0.56..1.97 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=2)

  • Index Cond: ((attribute_value_id = attribute_values_2.id) AND (actor_id = '78ed74a1-58aa-47a6-bf29-223482b2149b'::uuid))
  • Filter: (archived_at = 0)
22. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.47..14.26 rows=1 width=0) (never executed)

23. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.91..11.92 rows=1 width=16) (never executed)

  • Group Key: attribute_values_3.id
24. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..11.91 rows=1 width=16) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Index Scan using index_attributes_on_team_id_and_archived_at on attributes attributes_3 (cost=0.29..2.31 rows=1 width=16) (never executed)

  • Index Cond: (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid)
  • Filter: ((label)::text = 'Role'::text)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using index_attribute_values_on_attribute_id_and_archived_at on attribute_values attribute_values_3 (cost=0.42..9.60 rows=1 width=32) (never executed)

  • Index Cond: ((attribute_id = attributes_3.id) AND (archived_at = 0))
  • Filter: (label = 'PARSABLE_ADMIN'::text)
27. 0.000 0.000 ↓ 0.0 0

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values actor_attribute_values_5 (cost=0.56..2.32 rows=1 width=16) (never executed)

  • Index Cond: ((attribute_value_id = attribute_values_3.id) AND (actor_id = '78ed74a1-58aa-47a6-bf29-223482b2149b'::uuid))
  • Filter: (archived_at = 0)
28. 0.002 0.022 ↓ 0.0 0 1

Nested Loop (cost=12.47..14.26 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=1)

29. 0.003 0.015 ↑ 1.0 1 1

HashAggregate (cost=11.91..11.92 rows=1 width=16) (actual time=0.015..0.015 rows=1 loops=1)

  • Group Key: attribute_values_4.id
30. 0.001 0.012 ↑ 1.0 1 1

Nested Loop (cost=0.70..11.91 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=1)

31. 0.005 0.005 ↑ 1.0 1 1

Index Scan using index_attributes_on_team_id_and_archived_at on attributes attributes_4 (cost=0.29..2.31 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid)
  • Filter: ((label)::text = 'Role'::text)
  • Rows Removed by Filter: 1
32. 0.006 0.006 ↑ 1.0 1 1

Index Scan using index_attribute_values_on_attribute_id_and_archived_at on attribute_values attribute_values_4 (cost=0.42..9.60 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: ((attribute_id = attributes_4.id) AND (archived_at = 0))
  • Filter: (label = 'PARSABLE_ADMIN'::text)
  • Rows Removed by Filter: 7
33. 0.005 0.005 ↓ 0.0 0 1

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values actor_attribute_values_6 (cost=0.56..2.32 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((attribute_value_id = attribute_values_4.id) AND (actor_id = '78ed74a1-58aa-47a6-bf29-223482b2149b'::uuid))
  • Filter: (archived_at = 0)
34. 0.002 0.059 ↑ 1.0 1 1

Nested Loop (cost=12.50..17.93 rows=1 width=0) (actual time=0.059..0.059 rows=1 loops=1)

35. 0.002 0.041 ↑ 1.5 2 1

HashAggregate (cost=11.95..11.98 rows=3 width=16) (actual time=0.040..0.041 rows=2 loops=1)

  • Group Key: attribute_values_5.id
36. 0.005 0.039 ↑ 1.0 3 1

Nested Loop (cost=0.70..11.94 rows=3 width=16) (actual time=0.036..0.039 rows=3 loops=1)

37. 0.017 0.017 ↑ 1.0 1 1

Index Scan using index_attributes_on_team_id_and_archived_at on attributes attributes_5 (cost=0.29..2.31 rows=1 width=16) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid)
  • Filter: ((label)::text = 'Role'::text)
  • Rows Removed by Filter: 1
38. 0.017 0.017 ↑ 1.0 3 1

Index Scan using index_attribute_values_on_attribute_id_and_archived_at on attribute_values attribute_values_5 (cost=0.42..9.61 rows=3 width=32) (actual time=0.015..0.017 rows=3 loops=1)

  • Index Cond: ((attribute_id = attributes_5.id) AND (archived_at = 0))
  • Filter: (label = ANY ('{JOBCREATOR,EXECUTOR,WORKFLOW_PLANNER}'::text[]))
  • Rows Removed by Filter: 5
39. 0.016 0.016 ↓ 0.0 0 2

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values actor_attribute_values_8 (cost=0.56..1.97 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=2)

  • Index Cond: ((attribute_value_id = attribute_values_5.id) AND (actor_id = '78ed74a1-58aa-47a6-bf29-223482b2149b'::uuid))
  • Filter: (archived_at = 0)
40. 24.355 3,658.483 ↓ 34.0 34 1

Index Scan using index_jobs_on_id on jobs j (cost=278,748.17..278,851.27 rows=1 width=614) (actual time=3,658.241..3,658.483 rows=34 loops=1)

  • Index Cond: (id = ANY ('{a3321db9-d742-43e2-876a-e200d57dba19,7fd099f6-a8f4-491c-a441-6c51b6ac9c68,7fd099f6-a8f4-491c-a441-6c51b6ac9c68,1454877e-3990-4947-95e8-8fd15e653af1,1454877e-3990-4947-95e8-8fd15e653af1,c5df8469-4661-4077-b4fe-57eafaa56a71,c5df8469-4661-4077-b4fe-57eafaa56a71,f0224203-107d-4177-ba9c-0f8510ba3208,f0224203-107d-4177-ba9c-0f8510ba3208,dbda305a-5853-4339-8e33-60f2bf63eb68,dbda305a-5853-4339-8e33-60f2bf63eb68,149fd075-d1bf-483c-9e5a-496a4d2093fd,149fd075-d1bf-483c-9e5a-496a4d2093fd,4cd26f4a-dfe1-40e4-a017-03d3f267632f,4cd26f4a-dfe1-40e4-a017-03d3f267632f,dbe55bf2-5446-40c2-af84-3a13ecb59c8c,dbe55bf2-5446-40c2-af84-3a13ecb59c8c,3d838744-eaf0-4a6c-b254-4a7a8e0ec50e,961b213e-5099-4763-bbe0-007e9289d2ac,6f483af9-b918-42b8-b2e2-ee121ea922d3,a7f72457-172f-43d0-ac10-608fb8bd2104,a89a966d-a4a6-4a23-91c6-b41093d0cc68,3677dcb7-80ae-4dc6-b75f-bea87ba744f1,eae9960d-bb61-4467-94c5-de5809f4528a,9843d355-30ac-40fa-961c-fe248838551e,62a5ea3f-d63f-4c28-a86a-0122c6660279,fb9dea09-50e1-4c68-a2b5-61f0e2f8efa2,312c6fdb-57c9-4b14-a756-279180bec308,12b248ad-cc80-41b9-b75c-5f351a774d1b,52b938d2-7380-4e01-9ebf-4733bf949892,89429a27-49c3-44d9-afb6-706798e0342a,f2f76368-7567-424a-9e5a-e6673ce77554,89181beb-6ba0-49e8-8c89-7f0454cef14c,c6fda160-80c2-4b80-b488-cc994d8674ec,07f2a3d1-930e-480f-9843-b5d93c65c2f6,a69fb62a-0665-4bf9-bed7-4b7420ba9eff,a9640385-5742-4f5a-8f25-a29a7578c56a,98a38803-b236-4ae4-bc37-103d900e1d87,aa22ca4b-81bf-4d31-9a25-6fd1df84aab5,abd977e8-5cee-4ab4-aefc-758b92eea51a,60079c7c-7550-4b03-80d5-09a2bcc83644,94e67d8a-0d72-4673-9e9e-c603bec89985}'::uuid[]))
  • Filter: ((NOT is_preview) AND (team_id = ANY ('{73ec9125-648d-4642-9422-f731ef234fc2}'::uuid[])) AND (completed_at <> 0) AND (started_at <> 0) AND (archived_at = 0) AND (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid) AND (((((hashed SubPlan 1) AND $6) OR $9) AND (job_type = ANY ('{2}'::integer[]))) OR ((((hashed SubPlan 4) AND $16) OR $19) AND (job_type = ANY ('{1}'::integer[]))) OR (($22 OR ((hashed SubPlan 8) AND $29)) AND (job_type = ANY ('{0}'::integer[])))))
41.          

SubPlan (for Index Scan)

42. 16.068 1,200.983 ↓ 1.8 38,748 1

HashAggregate (cost=92,649.35..92,862.60 rows=21,325 width=16) (actual time=1,194.482..1,200.983 rows=38,748 loops=1)

  • Group Key: actor_attribute_values.actor_id
43. 3.431 1,184.915 ↓ 1.8 38,748 1

Nested Loop (cost=1.27..92,596.04 rows=21,325 width=16) (actual time=1,151.641..1,184.915 rows=38,748 loops=1)

44. 0.001 1,151.623 ↑ 19.0 1 1

Subquery Scan on "ANY_subquery" (cost=0.72..71,436.74 rows=19 width=16) (actual time=1,151.621..1,151.623 rows=1 loops=1)

45. 68.041 1,151.622 ↑ 19.0 1 1

HashSetOp Intersect (cost=0.72..71,436.55 rows=19 width=20) (actual time=1,151.621..1,151.622 rows=1 loops=1)

46. 66.433 1,083.581 ↓ 17.5 972,908 1

Append (cost=0.72..71,297.35 rows=55,680 width=20) (actual time=0.016..1,083.581 rows=972,908 loops=1)

47. 0.001 0.019 ↑ 9.5 2 1

Subquery Scan on "*SELECT* 1" (cost=0.72..23.49 rows=19 width=20) (actual time=0.016..0.019 rows=2 loops=1)

48. 0.002 0.018 ↑ 9.5 2 1

Nested Loop (cost=0.72..23.30 rows=19 width=16) (actual time=0.015..0.018 rows=2 loops=1)

49. 0.008 0.008 ↑ 1.0 1 1

Index Scan using index_attributes_on_team_id_and_archived_at on attributes a_subj (cost=0.29..2.31 rows=1 width=0) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid)
  • Filter: ((label)::text = 'Location'::text)
  • Rows Removed by Filter: 1
50. 0.008 0.008 ↑ 9.5 2 1

Index Scan using index_actor_attribute_values_on_actor_id_and_archived_at on actor_attribute_values aav_subj (cost=0.43..20.81 rows=19 width=16) (actual time=0.007..0.008 rows=2 loops=1)

  • Index Cond: ((actor_id = '78ed74a1-58aa-47a6-bf29-223482b2149b'::uuid) AND (archived_at = 0))
51. 90.166 1,017.129 ↓ 17.5 972,906 1

Subquery Scan on "*SELECT* 2" (cost=0.97..71,273.85 rows=55,661 width=20) (actual time=0.499..1,017.129 rows=972,906 loops=1)

52. 85.843 926.963 ↓ 17.5 972,906 1

Nested Loop (cost=0.97..70,717.24 rows=55,661 width=16) (actual time=0.498..926.963 rows=972,906 loops=1)

53. 0.212 2.608 ↓ 1.1 1,941 1

Nested Loop (cost=0.42..1,535.66 rows=1,690 width=16) (actual time=0.488..2.608 rows=1,941 loops=1)

54. 0.992 0.992 ↓ 1.1 234 1

Seq Scan on attributes a_obj (cost=0.00..269.61 rows=215 width=16) (actual time=0.477..0.992 rows=234 loops=1)

  • Filter: ((label)::text = 'Location'::text)
  • Rows Removed by Filter: 9,654
55. 1.404 1.404 ↑ 1.0 8 234

Index Scan using index_attribute_values_on_attribute_id_and_archived_at on attribute_values av_obj (cost=0.42..5.81 rows=8 width=32) (actual time=0.003..0.006 rows=8 loops=234)

  • Index Cond: (attribute_id = a_obj.id)
56. 838.512 838.512 ↑ 2.2 501 1,941

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values aav_obj (cost=0.56..29.72 rows=1,122 width=16) (actual time=0.007..0.432 rows=501 loops=1,941)

  • Index Cond: (attribute_value_id = av_obj.id)
  • Filter: (archived_at = 0)
  • Rows Removed by Filter: 204
57. 29.861 29.861 ↓ 34.5 38,748 1

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values (cost=0.56..1,102.43 rows=1,122 width=32) (actual time=0.018..29.861 rows=38,748 loops=1)

  • Index Cond: (attribute_value_id = ""ANY_subquery"".attribute_value_id)
  • Filter: (archived_at = 0)
  • Rows Removed by Filter: 3,218
58. 14.942 1,225.127 ↓ 1.8 38,748 1

HashAggregate (cost=92,649.35..92,862.60 rows=21,325 width=16) (actual time=1,219.302..1,225.127 rows=38,748 loops=1)

  • Group Key: actor_attribute_values_3.actor_id
59. 3.568 1,210.185 ↓ 1.8 38,748 1

Nested Loop (cost=1.27..92,596.04 rows=21,325 width=16) (actual time=1,177.597..1,210.185 rows=38,748 loops=1)

60. 0.002 1,177.578 ↑ 19.0 1 1

Subquery Scan on "ANY_subquery_1" (cost=0.72..71,436.74 rows=19 width=16) (actual time=1,177.576..1,177.578 rows=1 loops=1)

61. 68.795 1,177.576 ↑ 19.0 1 1

HashSetOp Intersect (cost=0.72..71,436.55 rows=19 width=20) (actual time=1,177.575..1,177.576 rows=1 loops=1)

62. 66.072 1,108.781 ↓ 17.5 972,908 1

Append (cost=0.72..71,297.35 rows=55,680 width=20) (actual time=0.014..1,108.781 rows=972,908 loops=1)

63. 0.001 0.015 ↑ 9.5 2 1

Subquery Scan on "*SELECT* 1_1" (cost=0.72..23.49 rows=19 width=20) (actual time=0.013..0.015 rows=2 loops=1)

64. 0.001 0.014 ↑ 9.5 2 1

Nested Loop (cost=0.72..23.30 rows=19 width=16) (actual time=0.012..0.014 rows=2 loops=1)

65. 0.006 0.006 ↑ 1.0 1 1

Index Scan using index_attributes_on_team_id_and_archived_at on attributes a_subj_1 (cost=0.29..2.31 rows=1 width=0) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid)
  • Filter: ((label)::text = 'Location'::text)
  • Rows Removed by Filter: 1
66. 0.007 0.007 ↑ 9.5 2 1

Index Scan using index_actor_attribute_values_on_actor_id_and_archived_at on actor_attribute_values aav_subj_1 (cost=0.43..20.81 rows=19 width=16) (actual time=0.006..0.007 rows=2 loops=1)

  • Index Cond: ((actor_id = '78ed74a1-58aa-47a6-bf29-223482b2149b'::uuid) AND (archived_at = 0))
67. 92.791 1,042.694 ↓ 17.5 972,906 1

Subquery Scan on "*SELECT* 2_1" (cost=0.97..71,273.85 rows=55,661 width=20) (actual time=0.510..1,042.694 rows=972,906 loops=1)

68. 87.369 949.903 ↓ 17.5 972,906 1

Nested Loop (cost=0.97..70,717.24 rows=55,661 width=16) (actual time=0.510..949.903 rows=972,906 loops=1)

69. 0.279 2.671 ↓ 1.1 1,941 1

Nested Loop (cost=0.42..1,535.66 rows=1,690 width=16) (actual time=0.499..2.671 rows=1,941 loops=1)

70. 0.988 0.988 ↓ 1.1 234 1

Seq Scan on attributes a_obj_1 (cost=0.00..269.61 rows=215 width=16) (actual time=0.489..0.988 rows=234 loops=1)

  • Filter: ((label)::text = 'Location'::text)
  • Rows Removed by Filter: 9,654
71. 1.404 1.404 ↑ 1.0 8 234

Index Scan using index_attribute_values_on_attribute_id_and_archived_at on attribute_values av_obj_1 (cost=0.42..5.81 rows=8 width=32) (actual time=0.003..0.006 rows=8 loops=234)

  • Index Cond: (attribute_id = a_obj_1.id)
72. 859.863 859.863 ↑ 2.2 501 1,941

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values aav_obj_1 (cost=0.56..29.72 rows=1,122 width=16) (actual time=0.007..0.443 rows=501 loops=1,941)

  • Index Cond: (attribute_value_id = av_obj_1.id)
  • Filter: (archived_at = 0)
  • Rows Removed by Filter: 204
73. 29.039 29.039 ↓ 34.5 38,748 1

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values actor_attribute_values_3 (cost=0.56..1,102.43 rows=1,122 width=32) (actual time=0.020..29.039 rows=38,748 loops=1)

  • Index Cond: (attribute_value_id = ""ANY_subquery_1"".attribute_value_id)
  • Filter: (archived_at = 0)
  • Rows Removed by Filter: 3,218
74. 14.397 1,208.018 ↓ 1.8 38,748 1

HashAggregate (cost=92,649.35..92,862.60 rows=21,325 width=16) (actual time=1,202.622..1,208.018 rows=38,748 loops=1)

  • Group Key: actor_attribute_values_7.actor_id
75. 3.388 1,193.621 ↓ 1.8 38,748 1

Nested Loop (cost=1.27..92,596.04 rows=21,325 width=16) (actual time=1,161.396..1,193.621 rows=38,748 loops=1)

76. 0.001 1,161.378 ↑ 19.0 1 1

Subquery Scan on "ANY_subquery_2" (cost=0.72..71,436.74 rows=19 width=16) (actual time=1,161.376..1,161.378 rows=1 loops=1)

77. 67.474 1,161.377 ↑ 19.0 1 1

HashSetOp Intersect (cost=0.72..71,436.55 rows=19 width=20) (actual time=1,161.376..1,161.377 rows=1 loops=1)

78. 66.280 1,093.903 ↓ 17.5 972,908 1

Append (cost=0.72..71,297.35 rows=55,680 width=20) (actual time=0.012..1,093.903 rows=972,908 loops=1)

79. 0.000 0.012 ↑ 9.5 2 1

Subquery Scan on "*SELECT* 1_2" (cost=0.72..23.49 rows=19 width=20) (actual time=0.012..0.012 rows=2 loops=1)

80. 0.002 0.012 ↑ 9.5 2 1

Nested Loop (cost=0.72..23.30 rows=19 width=16) (actual time=0.012..0.012 rows=2 loops=1)

81. 0.005 0.005 ↑ 1.0 1 1

Index Scan using index_attributes_on_team_id_and_archived_at on attributes a_subj_2 (cost=0.29..2.31 rows=1 width=0) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (team_id = '73ec9125-648d-4642-9422-f731ef234fc2'::uuid)
  • Filter: ((label)::text = 'Location'::text)
  • Rows Removed by Filter: 1
82. 0.005 0.005 ↑ 9.5 2 1

Index Scan using index_actor_attribute_values_on_actor_id_and_archived_at on actor_attribute_values aav_subj_2 (cost=0.43..20.81 rows=19 width=16) (actual time=0.005..0.005 rows=2 loops=1)

  • Index Cond: ((actor_id = '78ed74a1-58aa-47a6-bf29-223482b2149b'::uuid) AND (archived_at = 0))
83. 90.740 1,027.611 ↓ 17.5 972,906 1

Subquery Scan on "*SELECT* 2_2" (cost=0.97..71,273.85 rows=55,661 width=20) (actual time=0.497..1,027.611 rows=972,906 loops=1)

84. 86.103 936.871 ↓ 17.5 972,906 1

Nested Loop (cost=0.97..70,717.24 rows=55,661 width=16) (actual time=0.496..936.871 rows=972,906 loops=1)

85. 0.181 2.551 ↓ 1.1 1,941 1

Nested Loop (cost=0.42..1,535.66 rows=1,690 width=16) (actual time=0.486..2.551 rows=1,941 loops=1)

86. 0.966 0.966 ↓ 1.1 234 1

Seq Scan on attributes a_obj_2 (cost=0.00..269.61 rows=215 width=16) (actual time=0.478..0.966 rows=234 loops=1)

  • Filter: ((label)::text = 'Location'::text)
  • Rows Removed by Filter: 9,654
87. 1.404 1.404 ↑ 1.0 8 234

Index Scan using index_attribute_values_on_attribute_id_and_archived_at on attribute_values av_obj_2 (cost=0.42..5.81 rows=8 width=32) (actual time=0.003..0.006 rows=8 loops=234)

  • Index Cond: (attribute_id = a_obj_2.id)
88. 848.217 848.217 ↑ 2.2 501 1,941

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values aav_obj_2 (cost=0.56..29.72 rows=1,122 width=16) (actual time=0.007..0.437 rows=501 loops=1,941)

  • Index Cond: (attribute_value_id = av_obj_2.id)
  • Filter: (archived_at = 0)
  • Rows Removed by Filter: 204
89. 28.855 28.855 ↓ 34.5 38,748 1

Index Scan using index_actor_attribute_values_on_attribute_value_id_and_actor_id on actor_attribute_values actor_attribute_values_7 (cost=0.56..1,102.43 rows=1,122 width=32) (actual time=0.019..28.855 rows=38,748 loops=1)

  • Index Cond: (attribute_value_id = ""ANY_subquery_2"".attribute_value_id)
  • Filter: (archived_at = 0)
  • Rows Removed by Filter: 3,218
Planning time : 3.266 ms
Execution time : 3,659.581 ms