explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iuaVU

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 2.381 ↑ 41.6 24 1

Subquery Scan on call_driver_counts (cost=3,171.58..3,204.05 rows=999 width=49) (actual time=2.373..2.381 rows=24 loops=1)

2.          

CTE cte_percent

3. 0.004 2.048 ↓ 0.0 0 1

Subquery Scan on t (cost=2,261.97..2,271.46 rows=199 width=64) (actual time=2.048..2.048 rows=0 loops=1)

  • Filter: (t.ninety <> '0'::numeric)
  • Rows Removed by Filter: 3
4. 0.005 2.044 ↑ 66.7 3 1

Unique (cost=2,261.97..2,266.97 rows=200 width=104) (actual time=2.037..2.044 rows=3 loops=1)

5. 0.072 2.039 ↑ 11.1 90 1

Sort (cost=2,261.97..2,264.47 rows=999 width=104) (actual time=2.037..2.039 rows=90 loops=1)

  • Sort Key: cdc_1.label, date_1.date DESC
  • Sort Method: quicksort Memory: 32kB
6. 0.942 1.967 ↑ 11.1 90 1

WindowAgg (cost=2,189.72..2,212.20 rows=999 width=104) (actual time=1.060..1.967 rows=90 loops=1)

7. 0.040 1.025 ↑ 11.1 90 1

Sort (cost=2,189.72..2,192.22 rows=999 width=112) (actual time=1.017..1.025 rows=90 loops=1)

  • Sort Key: cdc_1.label, date_1.date
  • Sort Method: quicksort Memory: 32kB
8. 0.016 0.985 ↑ 11.1 90 1

Hash Join (cost=2,107.30..2,139.95 rows=999 width=112) (actual time=0.953..0.985 rows=90 loops=1)

  • Hash Cond: ((cdc_1.label)::text = (means.label)::text)
9. 0.012 0.345 ↑ 11.1 90 1

GroupAggregate (cost=889.36..909.34 rows=999 width=48) (actual time=0.327..0.345 rows=90 loops=1)

  • Group Key: date_1.date, cdc_1.label
10.          

Initplan (for GroupAggregate)

11. 0.000 0.000 ↓ 0.0 0

Limit (cost=21.48..21.48 rows=1 width=24) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Sort (cost=21.48..22.15 rows=270 width=24) (never executed)

  • Sort Key: call_driver_model.generation_ended DESC
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_driver_model (cost=0.00..20.12 rows=270 width=24) (never executed)

  • Filter: (generation_ended <= '2020-09-16 14:00:00+00'::timestamp with time zone)
14. 0.000 0.005 ↑ 1.0 1 1

Limit (cost=21.48..21.48 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=1)

15. 0.001 0.005 ↑ 270.0 1 1

Sort (cost=21.48..22.15 rows=270 width=24) (actual time=0.005..0.005 rows=1 loops=1)

  • Sort Key: call_driver_model_1.generation_ended DESC
  • Sort Method: quicksort Memory: 25kB
16. 0.004 0.004 ↑ 270.0 1 1

Seq Scan on call_driver_model call_driver_model_1 (cost=0.00..20.12 rows=270 width=24) (actual time=0.004..0.004 rows=1 loops=1)

  • Filter: (generation_ended <= '2020-09-16 14:00:00+00'::timestamp with time zone)
17. 0.023 0.328 ↑ 11.1 90 1

Sort (cost=846.40..848.90 rows=999 width=72) (actual time=0.325..0.328 rows=90 loops=1)

  • Sort Key: date_1.date, cdc_1.label
  • Sort Method: quicksort Memory: 30kB
18. 0.011 0.305 ↑ 11.1 90 1

Hash Left Join (cost=737.86..796.63 rows=999 width=72) (actual time=0.275..0.305 rows=90 loops=1)

  • Hash Cond: ((cdc_1.label)::text = (t4_1.label)::text)
  • Join Filter: "overlaps"(t0_3.began, (t0_3.began + '00:00:00'::interval), date_1.date, (date_1.date + '1 day'::interval))
19. 0.000 0.054 ↑ 11.1 90 1

Nested Loop (cost=4.34..59.31 rows=999 width=40) (actual time=0.033..0.054 rows=90 loops=1)

20. 0.027 0.027 ↑ 11.1 30 1

Function Scan on generate_series date_1 (cost=0.01..15.01 rows=333 width=8) (actual time=0.022..0.027 rows=30 loops=1)

  • Filter: (date >= ('2020-09-16 14:00:00+00'::timestamp with time zone - '30 days'::interval))
  • Rows Removed by Filter: 60
21. 0.016 0.030 ↑ 1.0 3 30

Materialize (cost=4.33..31.82 rows=3 width=32) (actual time=0.000..0.001 rows=3 loops=30)

22. 0.002 0.014 ↑ 1.0 3 1

Nested Loop (cost=4.33..31.80 rows=3 width=32) (actual time=0.010..0.014 rows=3 loops=1)

23. 0.001 0.009 ↑ 1.0 3 1

Bitmap Heap Scan on call_driver_model_bigram cdmb_1 (cost=4.17..11.28 rows=3 width=16) (actual time=0.008..0.009 rows=3 loops=1)

  • Recheck Cond: (model_id = $1)
  • Heap Blocks: exact=1
24. 0.008 0.008 ↑ 1.0 3 1

Bitmap Index Scan on call_driver_model_bigram_pkey (cost=0.00..4.17 rows=3 width=0) (actual time=0.008..0.008 rows=3 loops=1)

  • Index Cond: (model_id = $1)
25. 0.003 0.003 ↑ 1.0 1 3

Index Scan using call_driver_category_pkey on call_driver_category cdc_1 (cost=0.15..6.84 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=3)

  • Index Cond: (id = cdmb_1.category_id)
26. 0.000 0.240 ↓ 0.0 0 1

Hash (cost=733.49..733.49 rows=3 width=40) (actual time=0.240..0.240 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
27. 0.001 0.240 ↓ 0.0 0 1

Nested Loop (cost=672.23..733.49 rows=3 width=40) (actual time=0.240..0.240 rows=0 loops=1)

28. 0.000 0.239 ↓ 0.0 0 1

Nested Loop (cost=672.08..718.57 rows=3 width=24) (actual time=0.239..0.239 rows=0 loops=1)

  • Join Filter: (t1_3.call_id = t0_3.id)
29. 0.237 0.239 ↓ 0.0 0 1

Seq Scan on call t0_3 (cost=649.74..670.12 rows=47 width=24) (actual time=0.239..0.239 rows=0 loops=1)

  • Filter: (lisa_super_user() OR ((hashed SubPlan 3) IS TRUE))
  • Rows Removed by Filter: 40
30.          

SubPlan (for Seq Scan)

31. 0.000 0.002 ↓ 0.0 0 1

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (actual time=0.002..0.002 rows=0 loops=1)

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

Result (cost=0.01..202.01 rows=10,000 width=32) (actual time=0.002..0.002 rows=0 loops=1)

33. 0.000 0.001 ↓ 0.0 0 1

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (actual time=0.001..0.001 rows=0 loops=1)

34. 0.001 0.001 ↓ 0.0 0 1

Function Scan on json_array_elements_text t1_1 (cost=0.01..1.01 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=1)

35. 0.000 0.000 ↓ 0.0 0

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

36. 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)
37. 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)

38. 0.000 0.000 ↓ 0.0 0

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

39. 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)

40. 0.000 0.000 ↓ 0.0 0

Materialize (cost=22.34..44.94 rows=5 width=32) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=22.34..44.91 rows=5 width=32) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=22.19..43.81 rows=5 width=32) (never executed)

  • Hash Cond: (t2_3.id = t3_1.enriched_transcript_id)
43. 0.000 0.000 ↓ 0.0 0

Seq Scan on enriched_transcript t2_3 (cost=0.00..19.20 rows=920 width=32) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Hash (cost=22.12..22.12 rows=5 width=32) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_driver_tag t3_1 (cost=0.00..22.12 rows=5 width=32) (never executed)

  • Filter: (model_id = $0)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using transcript_pkey on transcript t1_3 (cost=0.15..0.22 rows=1 width=32) (never executed)

  • Index Cond: (id = t2_3.transcript_id)
47. 0.000 0.000 ↓ 0.0 0

Index Scan using call_driver_category_pkey on call_driver_category t4_1 (cost=0.15..4.97 rows=1 width=48) (never executed)

  • Index Cond: (id = t3_1.category_id)
48. 0.004 0.624 ↑ 66.7 3 1

Hash (cost=1,215.44..1,215.44 rows=200 width=96) (actual time=0.624..0.624 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
49. 0.001 0.620 ↑ 66.7 3 1

Subquery Scan on means (cost=1,210.44..1,215.44 rows=200 width=96) (actual time=0.618..0.620 rows=3 loops=1)

50. 0.122 0.619 ↑ 66.7 3 1

HashAggregate (cost=1,210.44..1,213.44 rows=200 width=96) (actual time=0.618..0.619 rows=3 loops=1)

  • Group Key: cdc_2.label
51. 0.045 0.497 ↑ 11.1 270 1

GroupAggregate (cost=1,052.94..1,112.94 rows=3,000 width=48) (actual time=0.441..0.497 rows=270 loops=1)

  • Group Key: date_2.date, cdc_2.label
52.          

Initplan (for GroupAggregate)

53. 0.000 0.000 ↓ 0.0 0

Limit (cost=21.48..21.48 rows=1 width=24) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Sort (cost=21.48..22.15 rows=270 width=24) (never executed)

  • Sort Key: call_driver_model_2.generation_ended DESC
55. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_driver_model call_driver_model_2 (cost=0.00..20.12 rows=270 width=24) (never executed)

  • Filter: (generation_ended <= '2020-09-16 14:00:00+00'::timestamp with time zone)
56. 0.000 0.004 ↑ 1.0 1 1

Limit (cost=21.48..21.48 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=1)

57. 0.001 0.004 ↑ 270.0 1 1

Sort (cost=21.48..22.15 rows=270 width=24) (actual time=0.004..0.004 rows=1 loops=1)

  • Sort Key: call_driver_model_3.generation_ended DESC
  • Sort Method: quicksort Memory: 25kB
58. 0.003 0.003 ↑ 270.0 1 1

Seq Scan on call_driver_model call_driver_model_3 (cost=0.00..20.12 rows=270 width=24) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (generation_ended <= '2020-09-16 14:00:00+00'::timestamp with time zone)
59. 0.063 0.448 ↑ 11.1 270 1

Sort (cost=1,009.99..1,017.49 rows=3,000 width=72) (actual time=0.440..0.448 rows=270 loops=1)

  • Sort Key: date_2.date, cdc_2.label
  • Sort Method: quicksort Memory: 40kB
60. 0.024 0.385 ↑ 11.1 270 1

Hash Left Join (cost=737.86..836.73 rows=3,000 width=72) (actual time=0.335..0.385 rows=270 loops=1)

  • Hash Cond: ((cdc_2.label)::text = (t4_2.label)::text)
  • Join Filter: "overlaps"(t0_4.began, (t0_4.began + '00:00:00'::interval), date_2.date, (date_2.date + '1 day'::interval))
61. 0.015 0.051 ↑ 11.1 270 1

Nested Loop Left Join (cost=4.34..91.81 rows=3,000 width=40) (actual time=0.022..0.051 rows=270 loops=1)

62. 0.001 0.012 ↑ 1.0 3 1

Nested Loop (cost=4.33..31.80 rows=3 width=32) (actual time=0.008..0.012 rows=3 loops=1)

63. 0.002 0.008 ↑ 1.0 3 1

Bitmap Heap Scan on call_driver_model_bigram cdmb_2 (cost=4.17..11.28 rows=3 width=16) (actual time=0.007..0.008 rows=3 loops=1)

  • Recheck Cond: (model_id = $4)
  • Heap Blocks: exact=1
64. 0.006 0.006 ↑ 1.0 3 1

Bitmap Index Scan on call_driver_model_bigram_pkey (cost=0.00..4.17 rows=3 width=0) (actual time=0.006..0.006 rows=3 loops=1)

  • Index Cond: (model_id = $4)
65. 0.003 0.003 ↑ 1.0 1 3

Index Scan using call_driver_category_pkey on call_driver_category cdc_2 (cost=0.15..6.84 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=3)

  • Index Cond: (id = cdmb_2.category_id)
66. 0.024 0.024 ↑ 11.1 90 3

Function Scan on generate_series date_2 (cost=0.01..10.01 rows=1,000 width=8) (actual time=0.004..0.008 rows=90 loops=3)

67. 0.000 0.310 ↓ 0.0 0 1

Hash (cost=733.49..733.49 rows=3 width=40) (actual time=0.310..0.310 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
68. 0.000 0.310 ↓ 0.0 0 1

Nested Loop (cost=672.23..733.49 rows=3 width=40) (actual time=0.310..0.310 rows=0 loops=1)

69. 0.000 0.310 ↓ 0.0 0 1

Nested Loop (cost=672.08..718.57 rows=3 width=24) (actual time=0.310..0.310 rows=0 loops=1)

  • Join Filter: (t1_4.call_id = t0_4.id)
70. 0.307 0.310 ↓ 0.0 0 1

Seq Scan on call t0_4 (cost=649.74..670.12 rows=47 width=24) (actual time=0.310..0.310 rows=0 loops=1)

  • Filter: (lisa_super_user() OR ((hashed SubPlan 6) IS TRUE))
  • Rows Removed by Filter: 40
71.          

SubPlan (for Seq Scan)

72. 0.000 0.003 ↓ 0.0 0 1

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (actual time=0.003..0.003 rows=0 loops=1)

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

Result (cost=0.01..202.01 rows=10,000 width=32) (actual time=0.003..0.003 rows=0 loops=1)

74. 0.000 0.003 ↓ 0.0 0 1

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (actual time=0.003..0.003 rows=0 loops=1)

75. 0.003 0.003 ↓ 0.0 0 1

Function Scan on json_array_elements_text t1_2 (cost=0.01..1.01 rows=100 width=32) (actual time=0.003..0.003 rows=0 loops=1)

76. 0.000 0.000 ↓ 0.0 0

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

77. 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)
78. 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)

79. 0.000 0.000 ↓ 0.0 0

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

80. 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)

81. 0.000 0.000 ↓ 0.0 0

Materialize (cost=22.34..44.94 rows=5 width=32) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=22.34..44.91 rows=5 width=32) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=22.19..43.81 rows=5 width=32) (never executed)

  • Hash Cond: (t2_4.id = t3_2.enriched_transcript_id)
84. 0.000 0.000 ↓ 0.0 0

Seq Scan on enriched_transcript t2_4 (cost=0.00..19.20 rows=920 width=32) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Hash (cost=22.12..22.12 rows=5 width=32) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_driver_tag t3_2 (cost=0.00..22.12 rows=5 width=32) (never executed)

  • Filter: (model_id = $3)
87. 0.000 0.000 ↓ 0.0 0

Index Scan using transcript_pkey on transcript t1_4 (cost=0.15..0.22 rows=1 width=32) (never executed)

  • Index Cond: (id = t2_4.transcript_id)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using call_driver_category_pkey on call_driver_category t4_2 (cost=0.15..4.97 rows=1 width=48) (never executed)

  • Index Cond: (id = t3_2.category_id)
89. 0.000 0.322 ↑ 41.6 24 1

GroupAggregate (cost=886.86..906.84 rows=999 width=48) (actual time=0.316..0.322 rows=24 loops=1)

  • Group Key: date.date, cdc.label
90.          

Initplan (for GroupAggregate)

91. 0.000 0.000 ↓ 0.0 0

Limit (cost=21.48..21.48 rows=1 width=24) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Sort (cost=21.48..22.15 rows=270 width=24) (never executed)

  • Sort Key: call_driver_model_4.generation_ended DESC
93. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_driver_model call_driver_model_4 (cost=0.00..20.12 rows=270 width=24) (never executed)

  • Filter: (generation_ended <= '2020-09-16 14:00:00+00'::timestamp with time zone)
94. 0.000 0.008 ↑ 1.0 1 1

Limit (cost=21.48..21.48 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=1)

95. 0.002 0.008 ↑ 270.0 1 1

Sort (cost=21.48..22.15 rows=270 width=24) (actual time=0.008..0.008 rows=1 loops=1)

  • Sort Key: call_driver_model_5.generation_ended DESC
  • Sort Method: quicksort Memory: 25kB
96. 0.006 0.006 ↑ 270.0 1 1

Seq Scan on call_driver_model call_driver_model_5 (cost=0.00..20.12 rows=270 width=24) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: (generation_ended <= '2020-09-16 14:00:00+00'::timestamp with time zone)
97. 0.012 0.316 ↑ 41.6 24 1

Sort (cost=843.90..846.40 rows=999 width=72) (actual time=0.314..0.316 rows=24 loops=1)

  • Sort Key: date.date, cdc.label
  • Sort Method: quicksort Memory: 26kB
98. 0.006 0.304 ↑ 41.6 24 1

Hash Left Join (cost=737.86..794.13 rows=999 width=72) (actual time=0.291..0.304 rows=24 loops=1)

  • Hash Cond: ((cdc.label)::text = (t4.label)::text)
  • Join Filter: "overlaps"(t0.began, (t0.began + '00:00:00'::interval), date.date, (date.date + '1 day'::interval))
99. 0.004 0.049 ↑ 41.6 24 1

Nested Loop (cost=4.34..56.81 rows=999 width=40) (actual time=0.039..0.049 rows=24 loops=1)

100. 0.021 0.021 ↑ 41.6 8 1

Function Scan on generate_series date (cost=0.01..12.51 rows=333 width=8) (actual time=0.020..0.021 rows=8 loops=1)

  • Filter: (date >= '2020-09-08 14:00:00+00'::timestamp with time zone)
  • Rows Removed by Filter: 82
101. 0.001 0.024 ↑ 1.0 3 8

Materialize (cost=4.33..31.82 rows=3 width=32) (actual time=0.002..0.003 rows=3 loops=8)

102. 0.001 0.023 ↑ 1.0 3 1

Nested Loop (cost=4.33..31.80 rows=3 width=32) (actual time=0.018..0.023 rows=3 loops=1)

103. 0.003 0.016 ↑ 1.0 3 1

Bitmap Heap Scan on call_driver_model_bigram cdmb (cost=4.17..11.28 rows=3 width=16) (actual time=0.015..0.016 rows=3 loops=1)

  • Recheck Cond: (model_id = $15)
  • Heap Blocks: exact=1
104. 0.013 0.013 ↑ 1.0 3 1

Bitmap Index Scan on call_driver_model_bigram_pkey (cost=0.00..4.17 rows=3 width=0) (actual time=0.013..0.013 rows=3 loops=1)

  • Index Cond: (model_id = $15)
105. 0.006 0.006 ↑ 1.0 1 3

Index Scan using call_driver_category_pkey on call_driver_category cdc (cost=0.15..6.84 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (id = cdmb.category_id)
106. 0.000 0.249 ↓ 0.0 0 1

Hash (cost=733.49..733.49 rows=3 width=40) (actual time=0.249..0.249 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
107. 0.000 0.249 ↓ 0.0 0 1

Nested Loop (cost=672.23..733.49 rows=3 width=40) (actual time=0.249..0.249 rows=0 loops=1)

108. 0.000 0.249 ↓ 0.0 0 1

Nested Loop (cost=672.08..718.57 rows=3 width=24) (actual time=0.249..0.249 rows=0 loops=1)

  • Join Filter: (t1.call_id = t0.id)
109. 0.247 0.249 ↓ 0.0 0 1

Seq Scan on call t0 (cost=649.74..670.12 rows=47 width=24) (actual time=0.249..0.249 rows=0 loops=1)

  • Filter: (lisa_super_user() OR ((hashed SubPlan 11) IS TRUE))
  • Rows Removed by Filter: 40
110.          

SubPlan (for Seq Scan)

111. 0.000 0.002 ↓ 0.0 0 1

Hash Join (cost=71.08..604.41 rows=18,133 width=16) (actual time=0.002..0.002 rows=0 loops=1)

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

Result (cost=0.01..202.01 rows=10,000 width=32) (actual time=0.002..0.002 rows=0 loops=1)

113. 0.000 0.002 ↓ 0.0 0 1

ProjectSet (cost=0.01..52.01 rows=10,000 width=32) (actual time=0.002..0.002 rows=0 loops=1)

114. 0.002 0.002 ↓ 0.0 0 1

Function Scan on json_array_elements_text t1_5 (cost=0.01..1.01 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=1)

115. 0.000 0.000 ↓ 0.0 0

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

116. 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)
117. 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)

118. 0.000 0.000 ↓ 0.0 0

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

119. 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)

120. 0.000 0.000 ↓ 0.0 0

Materialize (cost=22.34..44.94 rows=5 width=32) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=22.34..44.91 rows=5 width=32) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=22.19..43.81 rows=5 width=32) (never executed)

  • Hash Cond: (t2.id = t3.enriched_transcript_id)
123. 0.000 0.000 ↓ 0.0 0

Seq Scan on enriched_transcript t2 (cost=0.00..19.20 rows=920 width=32) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Hash (cost=22.12..22.12 rows=5 width=32) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_driver_tag t3 (cost=0.00..22.12 rows=5 width=32) (never executed)

  • Filter: (model_id = $14)
126. 0.000 0.000 ↓ 0.0 0

Index Scan using transcript_pkey on transcript t1 (cost=0.15..0.22 rows=1 width=32) (never executed)

  • Index Cond: (id = t2.transcript_id)
127. 0.000 0.000 ↓ 0.0 0

Index Scan using call_driver_category_pkey on call_driver_category t4 (cost=0.15..4.97 rows=1 width=48) (never executed)

  • Index Cond: (id = t3.category_id)
128.          

SubPlan (for Subquery Scan)

129. 0.000 2.055 ↓ 0.0 0 1

HashAggregate (cost=13.19..13.25 rows=6 width=32) (actual time=2.055..2.055 rows=0 loops=1)

  • Group Key: "*SELECT* 1".label
130. 0.000 2.055 ↓ 0.0 0 1

Append (cost=6.55..13.18 rows=6 width=32) (actual time=2.055..2.055 rows=0 loops=1)

131. 0.000 2.051 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=6.55..6.59 rows=3 width=32) (actual time=2.051..2.051 rows=0 loops=1)

132. 0.001 2.051 ↓ 0.0 0 1

Limit (cost=6.55..6.56 rows=3 width=64) (actual time=2.050..2.051 rows=0 loops=1)

133. 0.002 2.050 ↓ 0.0 0 1

Sort (cost=6.55..7.05 rows=199 width=64) (actual time=2.050..2.050 rows=0 loops=1)

  • Sort Key: a.percent DESC
  • Sort Method: quicksort Memory: 25kB
134. 2.048 2.048 ↓ 0.0 0 1

CTE Scan on cte_percent a (cost=0.00..3.98 rows=199 width=64) (actual time=2.048..2.048 rows=0 loops=1)

135. 0.001 0.004 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=6.55..6.59 rows=3 width=32) (actual time=0.004..0.004 rows=0 loops=1)

136. 0.000 0.003 ↓ 0.0 0 1

Limit (cost=6.55..6.56 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

137. 0.003 0.003 ↓ 0.0 0 1

Sort (cost=6.55..7.05 rows=199 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Sort Key: b.percent
  • Sort Method: quicksort Memory: 25kB
138. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on cte_percent b (cost=0.00..3.98 rows=199 width=64) (actual time=0.000..0.000 rows=0 loops=1)

Planning time : 11.365 ms
Execution time : 2.646 ms