explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9uC2

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 8,827.958 ↑ 55.5 2 1

GroupAggregate (cost=1,507.37..23,710,385.66 rows=111 width=52) (actual time=8,827.956..8,827.958 rows=2 loops=1)

  • Group Key: t0.agent_id, i.bucket
2. 0.006 3.402 ↑ 55.5 2 1

Sort (cost=1,507.37..1,507.65 rows=111 width=60) (actual time=3.401..3.402 rows=2 loops=1)

  • Sort Key: i.bucket
  • Sort Method: quicksort Memory: 25kB
3. 0.003 3.396 ↑ 55.5 2 1

Nested Loop (cost=1,404.86..1,503.60 rows=111 width=60) (actual time=3.335..3.396 rows=2 loops=1)

  • Join Filter: ((t0.began >= ('{""2020-06-08 14:00:00+00"",""2020-06-16 14:00:00+00"",""2020-06-24 14:00:00+00""}'::timestamp with time zone[])[i.bucket]) AND (t0.began < ('{""2020-06-08 14:00:00+00"",""2020-06-16 14:00:00+00"",""2020-06-24 14:00:00+00""}'::timestamp with time zone[])[(i.bucket + 1)]))
  • Rows Removed by Join Filter: 2
4. 0.002 3.389 ↓ 2.0 2 1

Nested Loop Left Join (cost=1,404.86..1,476.10 rows=1 width=64) (actual time=3.329..3.389 rows=2 loops=1)

5. 0.004 3.381 ↓ 2.0 2 1

Nested Loop (cost=1,404.30..1,465.15 rows=1 width=80) (actual time=3.325..3.381 rows=2 loops=1)

6. 0.006 0.006 ↑ 1.0 1 1

Index Scan using rule_category_pkey on rule_category t9 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (id = '2dd5c3bb-527c-4c51-b623-2a2cc1d29527'::uuid)
7. 0.002 3.371 ↓ 2.0 2 1

Nested Loop Left Join (cost=1,404.15..1,456.97 rows=1 width=72) (actual time=3.317..3.371 rows=2 loops=1)

8. 0.002 3.363 ↓ 2.0 2 1

Nested Loop Left Join (cost=1,403.59..1,446.02 rows=1 width=64) (actual time=3.312..3.363 rows=2 loops=1)

9. 0.004 3.347 ↓ 2.0 2 1

Nested Loop Left Join (cost=1,403.03..1,435.07 rows=1 width=64) (actual time=3.303..3.347 rows=2 loops=1)

10. 0.001 3.331 ↓ 2.0 2 1

Nested Loop Left Join (cost=1,402.47..1,427.96 rows=1 width=56) (actual time=3.294..3.331 rows=2 loops=1)

11. 0.001 3.320 ↓ 2.0 2 1

Nested Loop Left Join (cost=1,402.05..1,427.18 rows=1 width=56) (actual time=3.287..3.320 rows=2 loops=1)

12. 0.002 3.309 ↓ 2.0 2 1

Nested Loop Left Join (cost=1,401.63..1,426.41 rows=1 width=56) (actual time=3.280..3.309 rows=2 loops=1)

13. 0.003 3.297 ↓ 2.0 2 1

Nested Loop (cost=1,401.21..1,417.97 rows=1 width=40) (actual time=3.273..3.297 rows=2 loops=1)

14. 0.099 3.234 ↓ 2.0 2 1

Bitmap Heap Scan on call t0 (cost=751.19..759.67 rows=1 width=40) (actual time=3.221..3.234 rows=2 loops=1)

  • Recheck Cond: ((agent_id = 'e26f82dc-3bf2-4469-933a-1f6c1bb813a9'::uuid) AND (began >= ('{""2020-06-08 14:00:00+00"",""2020-06-16 14:00:00+00"",""2020-06-24 14:00:00+00""}'::timestamp with time zone[])[1]) AND (began < ('{""2020-06-08 14:00:00+00"",""2020-06-16 14:00:00+00"",""2020-06-24 14:00:00+00""}'::timestamp with time zone[])[3]))
  • Filter: (lisa_super_user() OR ((hashed SubPlan 13) IS TRUE))
  • Heap Blocks: exact=2
15. 0.014 3.135 ↓ 0.0 0 1

BitmapAnd (cost=101.45..101.45 rows=2 width=0) (actual time=3.135..3.135 rows=0 loops=1)

16. 0.017 0.017 ↑ 2.1 179 1

Bitmap Index Scan on call_idx_agent_id (cost=0.00..19.27 rows=379 width=0) (actual time=0.017..0.017 rows=179 loops=1)

  • Index Cond: (agent_id = 'e26f82dc-3bf2-4469-933a-1f6c1bb813a9'::uuid)
17. 3.104 3.104 ↓ 20.0 43,036 1

Bitmap Index Scan on call_idx_began (cost=0.00..81.93 rows=2,151 width=0) (actual time=3.104..3.104 rows=43,036 loops=1)

  • Index Cond: ((began >= ('{""2020-06-08 14:00:00+00"",""2020-06-16 14:00:00+00"",""2020-06-24 14:00:00+00""}'::timestamp with time zone[])[1]) AND (began < ('{""2020-06-08 14:00:00+00"",""2020-06-16 14:00:00+00"",""2020-06-24 14:00:00+00""}'::timestamp with time zone[])[3]))
18.          

SubPlan (for Bitmap Heap Scan)

19. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (never executed)

  • Hash Cond: (((((unnest(regexp_match(t1_9.c1, '^team_(.+)'::text))))::character varying))::text = (t0_9.access_control_name)::text)
20. 0.000 0.000 ↓ 0.0 0

Result (cost=0.01..202.01 rows=10,000 width=32) (never executed)

21. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Function Scan on json_array_elements_text t1_9 (cost=0.01..1.01 rows=100 width=32) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Hash (cost=54.07..54.07 rows=1,360 width=48) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26.88..54.07 rows=1,360 width=48) (never executed)

  • Hash Cond: (t2_9.ac_team_id = t0_9.id)
25. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team_membership t2_9 (cost=0.00..23.60 rows=1,360 width=32) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.50..17.50 rows=750 width=48) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team t0_9 (cost=0.00..17.50 rows=750 width=48) (never executed)

28. 0.060 0.060 ↑ 1.0 1 2

Index Only Scan using agent_pkey on agent t1 (cost=650.02..658.29 rows=1 width=16) (actual time=0.030..0.030 rows=1 loops=2)

  • Index Cond: (id = 'e26f82dc-3bf2-4469-933a-1f6c1bb813a9'::uuid)
  • Filter: (lisa_super_user() OR ((hashed SubPlan 14) IS TRUE))
  • Heap Fetches: 2
29.          

SubPlan (for Index Only Scan)

30. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (never executed)

  • Hash Cond: (((((unnest(regexp_match(t1_10.c1, '^team_(.+)'::text))))::character varying))::text = (t0_10.access_control_name)::text)
31. 0.000 0.000 ↓ 0.0 0

Result (cost=0.01..202.01 rows=10,000 width=32) (never executed)

32. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Function Scan on json_array_elements_text t1_10 (cost=0.01..1.01 rows=100 width=32) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Hash (cost=54.07..54.07 rows=1,360 width=48) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26.88..54.07 rows=1,360 width=48) (never executed)

  • Hash Cond: (t2_10.ac_team_id = t0_10.id)
36. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team_membership t2_10 (cost=0.00..23.60 rows=1,360 width=32) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.50..17.50 rows=750 width=48) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team t0_10 (cost=0.00..17.50 rows=750 width=48) (never executed)

39. 0.010 0.010 ↑ 1.0 1 2

Index Scan using transcript_unique_call_id on transcript t2 (cost=0.42..8.44 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: (call_id = t0.id)
40. 0.010 0.010 ↑ 1.0 1 2

Index Scan using enriched_transcript_unique_transcript_id on enriched_transcript t3 (cost=0.42..0.77 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: (transcript_id = t2.id)
41. 0.010 0.010 ↑ 1.0 1 2

Index Scan using scorecard_run_unique_enriched_transcript_id on scorecard_run t4 (cost=0.42..0.78 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: (enriched_transcript_id = t3.id)
42. 0.012 0.012 ↑ 7.0 1 2

Index Scan using scorecard_result_idx_scorecard_run_id_parent on scorecard_result t5 (cost=0.56..7.04 rows=7 width=40) (actual time=0.006..0.006 rows=1 loops=2)

  • Index Cond: ((scorecard_run_id = t4.id) AND (parent IS NULL))
43. 0.014 0.014 ↑ 1.0 1 2

Index Scan using scorecard_result_unique_position on scorecard_result t6 (cost=0.56..10.94 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=2)

  • Index Cond: (parent = t5.id)
  • Filter: ((question)::text = 'Communication'::text)
  • Rows Removed by Filter: 2
44. 0.006 0.006 ↑ 1.0 1 2

Index Scan using scorecard_result_unique_position on scorecard_result t7 (cost=0.56..10.94 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=2)

  • Index Cond: (parent = t5.id)
  • Filter: ((question)::text = 'Compliance'::text)
  • Rows Removed by Filter: 2
45. 0.006 0.006 ↑ 1.0 1 2

Index Scan using scorecard_result_unique_position on scorecard_result t8 (cost=0.56..10.94 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=2)

  • Index Cond: (parent = t5.id)
  • Filter: ((question)::text = 'Conduct'::text)
  • Rows Removed by Filter: 2
46. 0.004 0.004 ↑ 500.0 2 2

Function Scan on generate_series i (cost=0.00..10.00 rows=1,000 width=4) (actual time=0.001..0.002 rows=2 loops=2)

47.          

SubPlan (for GroupAggregate)

48. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=650.16..639,480.07 rows=3 width=0) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Index Scan using call_pkey on call t0_4 (cost=650.16..658.43 rows=1 width=16) (never executed)

  • Index Cond: (id = t0.id)
  • Filter: (lisa_super_user() OR ((hashed SubPlan 1) IS TRUE))
50.          

SubPlan (for Index Scan)

51. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (never executed)

  • Hash Cond: (((((unnest(regexp_match(t1_1.c1, '^team_(.+)'::text))))::character varying))::text = (t0_1.access_control_name)::text)
52. 0.000 0.000 ↓ 0.0 0

Result (cost=0.01..202.01 rows=10,000 width=32) (never executed)

53. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Function Scan on json_array_elements_text t1_1 (cost=0.01..1.01 rows=100 width=32) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Hash (cost=54.07..54.07 rows=1,360 width=48) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26.88..54.07 rows=1,360 width=48) (never executed)

  • Hash Cond: (t2_1.ac_team_id = t0_1.id)
57. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team_membership t2_1 (cost=0.00..23.60 rows=1,360 width=32) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.50..17.50 rows=750 width=48) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team t0_1 (cost=0.00..17.50 rows=750 width=48) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..638,821.60 rows=3 width=16) (never executed)

  • Join Filter: (t1_4.id = t3_1.interaction_id)
61. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_review t3_1 (cost=0.00..27.00 rows=1,692 width=16) (never executed)

  • Filter: (review_status IS NOT NULL)
62. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..638,743.85 rows=2 width=32) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..638,743.84 rows=2 width=32) (never executed)

  • Join Filter: (t1_4.user_id = t2_4.id)
64. 0.000 0.000 ↓ 0.0 0

Seq Scan on lisa_user t2_4 (cost=0.00..17.50 rows=750 width=16) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..638,703.84 rows=2 width=48) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_interaction t1_4 (cost=0.00..638,703.83 rows=2 width=48) (never executed)

  • Filter: ((call_id = t0.id) AND (alternatives: SubPlan 3 or hashed SubPlan 5))
67.          

SubPlan (for Seq Scan)

68. 0.000 0.000 ↓ 0.0 0

Index Scan using call_pkey on call call_interaction0 (cost=650.16..658.43 rows=1 width=0) (never executed)

  • Index Cond: (id = t1_4.call_id)
  • Filter: (lisa_super_user() OR ((hashed SubPlan 2) IS TRUE))
69.          

SubPlan (for Index Scan)

70. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (never executed)

  • Hash Cond: (((((unnest(regexp_match(t1_2.c1, '^team_(.+)'::text))))::character varying))::text = (t0_2.access_control_name)::text)
71. 0.000 0.000 ↓ 0.0 0

Result (cost=0.01..202.01 rows=10,000 width=32) (never executed)

72. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Function Scan on json_array_elements_text t1_2 (cost=0.01..1.01 rows=100 width=32) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Hash (cost=54.07..54.07 rows=1,360 width=48) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26.88..54.07 rows=1,360 width=48) (never executed)

  • Hash Cond: (t2_2.ac_team_id = t0_2.id)
76. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team_membership t2_2 (cost=0.00..23.60 rows=1,360 width=32) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.50..17.50 rows=750 width=48) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team t0_2 (cost=0.00..17.50 rows=750 width=48) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Seq Scan on call call_interaction0_1 (cost=649.74..132,594.18 rows=286,863 width=16) (never executed)

  • Filter: (lisa_super_user() OR ((hashed SubPlan 4) IS TRUE))
80.          

SubPlan (for Seq Scan)

81. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (never executed)

  • Hash Cond: (((((unnest(regexp_match(t1_3.c1, '^team_(.+)'::text))))::character varying))::text = (t0_3.access_control_name)::text)
82. 0.000 0.000 ↓ 0.0 0

Result (cost=0.01..202.01 rows=10,000 width=32) (never executed)

83. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Function Scan on json_array_elements_text t1_3 (cost=0.01..1.01 rows=100 width=32) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Hash (cost=54.07..54.07 rows=1,360 width=48) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26.88..54.07 rows=1,360 width=48) (never executed)

  • Hash Cond: (t2_3.ac_team_id = t0_3.id)
87. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team_membership t2_3 (cost=0.00..23.60 rows=1,360 width=32) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.50..17.50 rows=750 width=48) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team t0_3 (cost=0.00..17.50 rows=750 width=48) (never executed)

90. 0.017 8,824.536 ↑ 17.6 32 1

Hash Join (cost=136,254.99..774,959.37 rows=563 width=16) (actual time=8,824.482..8,824.536 rows=32 loops=1)

  • Hash Cond: (t1_8.id = t3_2.interaction_id)
91. 0.011 8,824.505 ↑ 8.1 40 1

Hash Join (cost=136,206.84..774,910.37 rows=323 width=32) (actual time=8,824.462..8,824.505 rows=40 loops=1)

  • Hash Cond: (t1_8.user_id = t2_8.id)
92. 0.446 8,824.487 ↑ 8.1 40 1

Hash Join (cost=136,179.97..774,882.65 rows=323 width=48) (actual time=8,824.452..8,824.487 rows=40 loops=1)

  • Hash Cond: (t1_8.call_id = t0_8.id)
93. 206.774 4,791.536 ↑ 12.1 40 1

Seq Scan on call_interaction t1_8 (cost=0.00..638,701.41 rows=485 width=48) (actual time=4,791.514..4,791.536 rows=40 loops=1)

  • Filter: (alternatives: SubPlan 9 or hashed SubPlan 11)
94.          

SubPlan (for Seq Scan)

95. 0.000 0.000 ↓ 0.0 0

Index Scan using call_pkey on call call_interaction0_2 (cost=650.16..658.43 rows=1 width=0) (never executed)

  • Index Cond: (id = t1_8.call_id)
  • Filter: (lisa_super_user() OR ((hashed SubPlan 8) IS TRUE))
96.          

SubPlan (for Index Scan)

97. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (never executed)

  • Hash Cond: (((((unnest(regexp_match(t1_6.c1, '^team_(.+)'::text))))::character varying))::text = (t0_6.access_control_name)::text)
98. 0.000 0.000 ↓ 0.0 0

Result (cost=0.01..202.01 rows=10,000 width=32) (never executed)

99. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Function Scan on json_array_elements_text t1_6 (cost=0.01..1.01 rows=100 width=32) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Hash (cost=54.07..54.07 rows=1,360 width=48) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26.88..54.07 rows=1,360 width=48) (never executed)

  • Hash Cond: (t2_6.ac_team_id = t0_6.id)
103. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team_membership t2_6 (cost=0.00..23.60 rows=1,360 width=32) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.50..17.50 rows=750 width=48) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team t0_6 (cost=0.00..17.50 rows=750 width=48) (never executed)

106. 4,584.762 4,584.762 ↓ 1.5 434,403 1

Seq Scan on call call_interaction0_3 (cost=649.74..132,594.18 rows=286,863 width=16) (actual time=0.076..4,584.762 rows=434,403 loops=1)

  • Filter: (lisa_super_user() OR ((hashed SubPlan 10) IS TRUE))
107.          

SubPlan (for Seq Scan)

108. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (never executed)

  • Hash Cond: (((((unnest(regexp_match(t1_7.c1, '^team_(.+)'::text))))::character varying))::text = (t0_7.access_control_name)::text)
109. 0.000 0.000 ↓ 0.0 0

Result (cost=0.01..202.01 rows=10,000 width=32) (never executed)

110. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Function Scan on json_array_elements_text t1_7 (cost=0.01..1.01 rows=100 width=32) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Hash (cost=54.07..54.07 rows=1,360 width=48) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26.88..54.07 rows=1,360 width=48) (never executed)

  • Hash Cond: (t2_7.ac_team_id = t0_7.id)
114. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team_membership t2_7 (cost=0.00..23.60 rows=1,360 width=32) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.50..17.50 rows=750 width=48) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team t0_7 (cost=0.00..17.50 rows=750 width=48) (never executed)

117. 130.491 4,032.505 ↓ 1.5 434,403 1

Hash (cost=132,594.18..132,594.18 rows=286,863 width=16) (actual time=4,032.505..4,032.505 rows=434,403 loops=1)

  • Buckets: 524,288 Batches: 1 Memory Usage: 24,459kB
118. 3,902.014 3,902.014 ↓ 1.5 434,403 1

Seq Scan on call t0_8 (cost=649.74..132,594.18 rows=286,863 width=16) (actual time=0.105..3,902.014 rows=434,403 loops=1)

  • Filter: (lisa_super_user() OR ((hashed SubPlan 7) IS TRUE))
119.          

SubPlan (for Seq Scan)

120. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (never executed)

  • Hash Cond: (((((unnest(regexp_match(t1_5.c1, '^team_(.+)'::text))))::character varying))::text = (t0_5.access_control_name)::text)
121. 0.000 0.000 ↓ 0.0 0

Result (cost=0.01..202.01 rows=10,000 width=32) (never executed)

122. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Function Scan on json_array_elements_text t1_5 (cost=0.01..1.01 rows=100 width=32) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Hash (cost=54.07..54.07 rows=1,360 width=48) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26.88..54.07 rows=1,360 width=48) (never executed)

  • Hash Cond: (t2_5.ac_team_id = t0_5.id)
126. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team_membership t2_5 (cost=0.00..23.60 rows=1,360 width=32) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.50..17.50 rows=750 width=48) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Seq Scan on ac_team t0_5 (cost=0.00..17.50 rows=750 width=48) (never executed)

129. 0.003 0.007 ↑ 62.5 12 1

Hash (cost=17.50..17.50 rows=750 width=16) (actual time=0.007..0.007 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
130. 0.004 0.004 ↑ 62.5 12 1

Seq Scan on lisa_user t2_8 (cost=0.00..17.50 rows=750 width=16) (actual time=0.003..0.004 rows=12 loops=1)

131. 0.005 0.014 ↑ 52.9 32 1

Hash (cost=27.00..27.00 rows=1,692 width=16) (actual time=0.014..0.014 rows=32 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 18kB
132. 0.009 0.009 ↑ 52.9 32 1

Seq Scan on call_review t3_2 (cost=0.00..27.00 rows=1,692 width=16) (actual time=0.006..0.009 rows=32 loops=1)

  • Filter: (review_status IS NOT NULL)
Planning time : 5.431 ms
Execution time : 8,828.514 ms