explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uilf

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 80,174.152 ↑ 10.4 84 1

Nested Loop Left Join (cost=111,205.44..111,249.23 rows=875 width=652) (actual time=80,174.092..80,174.152 rows=84 loops=1)

  • Join Filter: (qualifying_mission_responses2.place_id = filtered_places.place_id)
  • Functions: 219
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 22.259 ms, Inlining 0.000 ms, Optimization 8.954 ms, Emission 146.230 ms, Total 177.443 ms
2.          

CTE places_agg

3. 100.048 105.936 ↑ 1.0 36,659 1

Bitmap Heap Scan on places (cost=776.22..93,773.84 rows=37,358 width=370) (actual time=12.076..105.936 rows=36,659 loops=1)

  • Recheck Cond: (company_id = 3,437)
  • Filter: (disabled_at IS NULL)
  • Rows Removed by Filter: 10,947
  • Heap Blocks: exact=34,936
4. 5.888 5.888 ↑ 1.0 47,606 1

Bitmap Index Scan on index_places_on_company_id_id_status (cost=0.00..766.88 rows=48,043 width=0) (actual time=5.888..5.888 rows=47,606 loops=1)

  • Index Cond: (company_id = 3,437)
5.          

CTE filtered_places

6. 12.375 747.165 ↓ 196.0 36,659 1

Unique (cost=10,049.64..10,053.38 rows=187 width=656) (actual time=730.960..747.165 rows=36,659 loops=1)

7. 30.849 734.790 ↓ 196.0 36,659 1

Sort (cost=10,049.64..10,050.11 rows=187 width=656) (actual time=730.958..734.790 rows=36,659 loops=1)

  • Sort Key: places_agg_1.id, places_agg_1.name, ((places_agg_1.metadata -> 'component_id'::text)), (upper((places_agg_1.metadata -> 'schedule_id'::text))), (CASE WHEN (char_length(regexp_replace((places_agg_1.custom_place_id)::text, '\d'::text, ''::text, 'g'::text)) < char_length((places_agg_1.custom_place_id)::text)) THEN regexp_replace((places_agg_1.custom_place_id)::text, '[^0-9]'::text, ''::text, 'g'::text) ELSE NULL::text END), (CASE WHEN ((catalog_items.metadata -> 'time_zone'::text) IS NULL) THEN CASE WHEN ((companies.time_zone)::text = 'Eastern Time (US & Canada)'::text) THEN 'US/Eastern'::text WHEN ((companies.time_zone)::text = 'Central Time (US & Canada)'::text) THEN 'US/Central'::text WHEN ((companies.time_zone)::text = 'Mountain Time (US & Canada)'::text) THEN 'US/Mountain'::text WHEN ((companies.time_zone)::text = 'Pacific Time (US & Canada)'::text) THEN 'US/Pacific'::text ELSE NULL::text END ELSE (catalog_items.metadata -> 'time_zone'::text) END), (CASE WHEN ((catalog_items.metadata -> 'time_zone'::text) IS NULL) THEN CASE WHEN (date_part('hour'::text, timezone(CASE WHEN ((companies.time_zone)::text = 'Eastern Time (US & Canada)'::text) THEN 'US/Eastern'::text WHEN ((companies.time_zone)::text = 'Central Time (US & Canada)'::text) THEN 'US/Central'::text WHEN ((companies.time_zone)::text = 'Mountain Time (US & Canada)'::text) THEN 'US/Mountain'::text WHEN ((companies.time_zone)::text = 'Pacific Time (US & Canada)'::text) THEN 'US/Pacific'::text ELSE NULL::text END, now())) < '4'::double precision) THEN (((timezone(CASE WHEN ((companies.time_zone)::text = 'Eastern Time (US & Canada)'::text) THEN 'US/Eastern'::text WHEN ((companies.time_zone)::text = 'Central Time (US & Canada)'::text) THEN 'US/Central'::text WHEN ((companies.time_zone)::text = 'Mountain Time (US & Canada)'::text) THEN 'US/Mountain'::text WHEN ((companies.time_zone)::text = 'Pacific Time (US & Canada)'::text) THEN 'US/Pacific'::text ELSE NULL::text END, now()))::date - '1 day'::interval) + '04:00:00'::interval) ELSE ((timezone(CASE WHEN ((companies.time_zone)::text = 'Eastern Time (US & Canada)'::text) THEN 'US/Eastern'::text WHEN ((companies.time_zone)::text = 'Central Time (US & Canada)'::text) THEN 'US/Central'::text WHEN ((companies.time_zone)::text = 'Mountain Time (US & Canada)'::text) THEN 'US/Mountain'::text WHEN ((companies.time_zone)::text = 'Pacific Time (US & Canada)'::text) THEN 'US/Pacific'::text ELSE NULL::text END, now()))::date + '04:00:00'::interval) END ELSE CASE WHEN (date_part('hour'::text, timezone((catalog_items.metadata -> 'time_zone'::text), now())) < '4'::double precision) THEN (((timezone((catalog_items.metadata -> 'time_zone'::text), now()))::date - '1 day'::interval) + '04:00:00'::interval) ELSE ((timezone((catalog_items.metadata -> 'time_zone'::text), now()))::date + '04:00:00'::interval) END END)
  • Sort Method: quicksort Memory: 6,693kB
8. 308.310 703.941 ↓ 196.0 36,659 1

Nested Loop (cost=867.12..10,042.59 rows=187 width=656) (actual time=387.686..703.941 rows=36,659 loops=1)

9. 157.064 157.064 ↑ 1.0 1 1

Index Scan using companies_pkey on companies (cost=0.28..4.30 rows=1 width=29) (actual time=157.055..157.064 rows=1 loops=1)

  • Index Cond: (id = 3,437)
10. 8.255 238.567 ↓ 196.0 36,659 1

Hash Right Join (cost=866.84..10,010.24 rows=187 width=1,252) (actual time=230.578..238.567 rows=36,659 loops=1)

  • Hash Cond: ((lower((catalog_items.name)::text) = places_agg_1.component_id) AND (lower((catalog_items.metadata -> 'component_name'::text)) = places_agg_1.component_name))
11. 0.109 55.529 ↑ 1.8 214 1

Hash Join (cost=23.48..9,119.21 rows=385 width=212) (actual time=55.283..55.529 rows=214 loops=1)

  • Hash Cond: ((catalog_items.metadata -> 'time_zone'::text) = pg_timezone_names.name)
12. 0.028 1.564 ↓ 2.8 214 1

Nested Loop (cost=0.98..9,073.42 rows=77 width=212) (actual time=1.406..1.564 rows=214 loops=1)

13. 1.417 1.417 ↑ 1.0 1 1

Index Scan using index_catalogs_on_company_id_and_name on catalogs (cost=0.42..1,714.35 rows=1 width=4) (actual time=1.378..1.417 rows=1 loops=1)

  • Index Cond: ((name)::text = 'account_time_zones'::text)
  • Filter: (disabled_at IS NULL)
14. 0.119 0.119 ↑ 6.6 214 1

Index Scan using catalog_items_catalog_id_name_idx on catalog_items (cost=0.56..7,344.96 rows=1,411 width=216) (actual time=0.021..0.119 rows=214 loops=1)

  • Index Cond: (catalog_id = catalogs.id)
  • Filter: (disabled_at IS NULL)
15. 0.246 53.856 ↓ 1.2 1,218 1

Hash (cost=10.00..10.00 rows=1,000 width=32) (actual time=53.856..53.856 rows=1,218 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 76kB
16. 53.610 53.610 ↓ 1.2 1,218 1

Function Scan on pg_timezone_names (cost=0.00..10.00 rows=1,000 width=32) (actual time=53.427..53.610 rows=1,218 loops=1)

17. 31.284 174.783 ↓ 196.0 36,659 1

Hash (cost=840.55..840.55 rows=187 width=1,136) (actual time=174.783..174.783 rows=36,659 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 18,381kB
18. 143.499 143.499 ↓ 196.0 36,659 1

CTE Scan on places_agg places_agg_1 (cost=0.00..840.55 rows=187 width=1,136) (actual time=12.085..143.499 rows=36,659 loops=1)

  • Filter: (company_id = 3,437)
19.          

CTE campaigns_agg

20. 0.819 0.819 ↓ 102.8 1,131 1

Index Scan using index_campaigns_on_company_id on campaigns (cost=0.43..520.28 rows=11 width=36) (actual time=0.105..0.819 rows=1,131 loops=1)

  • Index Cond: (company_id = 3,437)
  • Filter: ((metadata -> 'category'::text) = ANY ('{virtual_guide,employee_name}'::text[]))
  • Rows Removed by Filter: 4
21.          

CTE employee_names_temp1

22. 0.002 376.072 ↓ 0.0 0 1

ProjectSet (cost=1.71..1,710.34 rows=10 width=48) (actual time=376.071..376.072 rows=0 loops=1)

23. 0.001 376.070 ↓ 0.0 0 1

Nested Loop (cost=1.71..1,710.28 rows=1 width=119) (actual time=376.070..376.070 rows=0 loops=1)

24. 0.001 376.069 ↓ 0.0 0 1

Nested Loop (cost=1.14..1,702.67 rows=2 width=123) (actual time=376.069..376.069 rows=0 loops=1)

25. 0.017 376.068 ↓ 0.0 0 1

Nested Loop (cost=0.57..867.46 rows=1 width=20) (actual time=376.067..376.068 rows=0 loops=1)

26. 1.226 1.226 ↓ 5.0 5 1

CTE Scan on campaigns_agg campaigns_agg_1 (cost=0.00..0.25 rows=1 width=4) (actual time=0.125..1.226 rows=5 loops=1)

  • Filter: (category = 'employee_name'::text)
  • Rows Removed by Filter: 1,126
27. 0.000 374.825 ↓ 0.0 0 5

Nested Loop (cost=0.57..865.34 rows=187 width=24) (actual time=74.965..74.965 rows=0 loops=5)

28. 41.060 41.060 ↓ 196.0 36,659 5

CTE Scan on filtered_places filtered_places_3 (cost=0.00..3.74 rows=187 width=44) (actual time=0.000..8.212 rows=36,659 loops=5)

29. 366.590 366.590 ↓ 0.0 0 183,295

Index Scan using index_mission_responses_on_place_id_and_campaign_id_and_state on mission_responses mission_responses_1 (cost=0.57..4.60 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=183,295)

  • Index Cond: ((place_id = filtered_places_3.place_id) AND (campaign_id = campaigns_agg_1.id) AND ((state)::text = 'completed'::text))
  • Filter: (timezone(filtered_places_3.place_time_zone, timezone('UTC'::text, completed_at)) >= filtered_places_3.converted_cutoff_time)
  • Rows Removed by Filter: 0
30. 0.000 0.000 ↓ 0.0 0

Index Scan using index_task_responses_on_mission_response_id on task_responses (cost=0.57..744.56 rows=9,065 width=111) (never executed)

  • Index Cond: (mission_response_id = mission_responses_1.id)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using tasks_pkey on tasks (cost=0.56..3.81 rows=1 width=4) (never executed)

  • Index Cond: (id = task_responses.task_id)
  • Filter: (lower((metadata -> 'task_category'::text)) = 'employee_name'::text)
32.          

CTE company_memberships_agg

33. 1.046 1.135 ↑ 1.8 603 1

Bitmap Heap Scan on company_memberships (cost=78.90..2,034.52 rows=1,094 width=132) (actual time=0.159..1.135 rows=603 loops=1)

  • Recheck Cond: ((company_id = 3,437) AND (disabled_at IS NULL))
  • Heap Blocks: exact=426
34. 0.089 0.089 ↑ 1.8 603 1

Bitmap Index Scan on index_memberships_on_company_id_role (cost=0.00..78.62 rows=1,094 width=0) (actual time=0.088..0.089 rows=603 loops=1)

  • Index Cond: (company_id = 3,437)
35.          

CTE employee_list

36. 40.200 48.808 ↓ 196.0 36,659 1

Hash Join (cost=29.07..1,011.59 rows=187 width=85) (actual time=4.053..48.808 rows=36,659 loops=1)

  • Hash Cond: (upper(places_agg_2.schedule_id) = upper(company_memberships_agg_4.schedule_id))
37. 4.596 4.596 ↑ 1.0 36,659 1

CTE Scan on places_agg places_agg_2 (cost=0.00..747.16 rows=37,358 width=36) (actual time=0.002..4.596 rows=36,659 loops=1)

38. 0.492 4.012 ↓ 591.0 591 1

Hash (cost=29.06..29.06 rows=1 width=113) (actual time=4.012..4.012 rows=591 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 77kB
39. 0.449 3.520 ↓ 591.0 591 1

Nested Loop (cost=0.42..29.06 rows=1 width=113) (actual time=0.198..3.520 rows=591 loops=1)

40. 1.889 1.889 ↓ 591.0 591 1

CTE Scan on company_memberships_agg company_memberships_agg_4 (cost=0.00..24.61 rows=1 width=100) (actual time=0.175..1.889 rows=591 loops=1)

  • Filter: (user_type ~~* 'FLA SCHEDULE'::text)
  • Rows Removed by Filter: 12
41. 1.182 1.182 ↑ 1.0 1 591

Index Scan using users_pkey on users users_2 (cost=0.42..4.44 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=591)

  • Index Cond: (id = company_memberships_agg_4.user_id)
42. 0.033 1,229.906 ↑ 10.4 84 1

Group (cost=1,227.96..1,247.64 rows=875 width=620) (actual time=1,229.865..1,229.906 rows=84 loops=1)

  • Group Key: ((filtered_places.schedule_id)::character varying), ((filtered_places.route_order)::integer), filtered_places.place_id, ((COALESCE(employee_names_temp1.employee_name, 'N/A'::text))::character varying), filtered_places.place_room, ((filtered_places.component_id)::character varying)
43. 0.108 1,229.873 ↑ 10.4 84 1

Sort (cost=1,227.96..1,230.14 rows=875 width=620) (actual time=1,229.862..1,229.873 rows=84 loops=1)

  • Sort Key: ((filtered_places.schedule_id)::character varying), ((filtered_places.route_order)::integer), filtered_places.place_id, ((COALESCE(employee_names_temp1.employee_name, 'N/A'::text))::character varying), filtered_places.place_room, ((filtered_places.component_id)::character varying)
  • Sort Method: quicksort Memory: 32kB
44. 0.077 1,229.765 ↑ 10.4 84 1

Hash Join (cost=1,149.84..1,185.20 rows=875 width=620) (actual time=1,229.682..1,229.765 rows=84 loops=1)

  • Hash Cond: (employee_list.place_id = filtered_places.place_id)
45. 0.059 86.179 ↑ 11.1 84 1

HashAggregate (cost=1,116.28..1,125.64 rows=936 width=8) (actual time=86.156..86.179 rows=84 loops=1)

  • Group Key: users.id, employee_list.place_id
46. 0.013 86.120 ↑ 11.1 84 1

Append (cost=4.45..1,111.60 rows=936 width=8) (actual time=83.308..86.120 rows=84 loops=1)

47. 0.001 83.154 ↓ 0.0 0 1

Nested Loop (cost=4.45..36.13 rows=1 width=8) (actual time=83.154..83.154 rows=0 loops=1)

48. 17.489 83.153 ↓ 0.0 0 1

Hash Join (cost=4.45..8.77 rows=1 width=8) (actual time=83.152..83.153 rows=0 loops=1)

  • Hash Cond: (lower(employee_list.supervisor) = lower(concat(users.first_name, ' ', users.last_name)))
49. 65.640 65.640 ↓ 196.0 36,659 1

CTE Scan on employee_list (cost=0.00..3.74 rows=187 width=36) (actual time=4.055..65.640 rows=36,659 loops=1)

50. 0.012 0.024 ↑ 1.0 1 1

Hash (cost=4.44..4.44 rows=1 width=17) (actual time=0.024..0.024 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
51. 0.012 0.012 ↑ 1.0 1 1

Index Scan using users_pkey on users (cost=0.42..4.44 rows=1 width=17) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (id = 308,071)
52. 0.000 0.000 ↓ 0.0 0

CTE Scan on company_memberships_agg company_memberships_agg_1 (cost=0.00..27.35 rows=1 width=4) (never executed)

  • Filter: ((user_type ~~* 'SUPERVISOR'::text) AND (user_id = 308,071))
53. 2.478 2.478 ↓ 84.0 84 1

CTE Scan on employee_list employee_list_1 (cost=0.00..4.21 rows=1 width=8) (actual time=0.150..2.478 rows=84 loops=1)

  • Filter: (user_id = 308,071)
  • Rows Removed by Filter: 36,575
54. 0.004 0.475 ↓ 0.0 0 1

Nested Loop (cost=53.88..1,057.22 rows=934 width=8) (actual time=0.475..0.475 rows=0 loops=1)

55. 0.032 0.032 ↑ 1.0 1 1

Index Only Scan using users_pkey on users users_1 (cost=0.42..4.44 rows=1 width=4) (actual time=0.030..0.032 rows=1 loops=1)

  • Index Cond: (id = 308,071)
  • Heap Fetches: 0
56. 0.015 0.439 ↓ 0.0 0 1

Hash Join (cost=53.46..1,043.44 rows=934 width=8) (actual time=0.439..0.439 rows=0 loops=1)

  • Hash Cond: (upper(places_agg.schedule_id) = upper(company_memberships_agg_3.schedule_id))
57. 0.001 0.001 ↑ 37,358.0 1 1

CTE Scan on places_agg (cost=0.00..747.16 rows=37,358 width=36) (actual time=0.001..0.001 rows=1 loops=1)

58. 0.000 0.423 ↓ 0.0 0 1

Hash (cost=53.39..53.39 rows=5 width=36) (actual time=0.423..0.423 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
59. 0.009 0.423 ↓ 0.0 0 1

Hash Join (cost=27.36..53.39 rows=5 width=36) (actual time=0.422..0.423 rows=0 loops=1)

  • Hash Cond: (company_memberships_agg_3.component_id = company_memberships_agg_2.component_id)
60. 0.002 0.002 ↑ 1,094.0 1 1

CTE Scan on company_memberships_agg company_memberships_agg_3 (cost=0.00..21.88 rows=1,094 width=64) (actual time=0.001..0.002 rows=1 loops=1)

61. 0.001 0.412 ↓ 0.0 0 1

Hash (cost=27.35..27.35 rows=1 width=36) (actual time=0.412..0.412 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
62. 0.411 0.411 ↓ 0.0 0 1

CTE Scan on company_memberships_agg company_memberships_agg_2 (cost=0.00..27.35 rows=1 width=36) (actual time=0.411..0.411 rows=0 loops=1)

  • Filter: ((user_type ~~* 'MANAGER'::text) AND (user_id = 308,071))
  • Rows Removed by Filter: 603
63. 11.331 1,143.509 ↓ 196.0 36,659 1

Hash (cost=31.23..31.23 rows=187 width=648) (actual time=1,143.509..1,143.509 rows=36,659 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 3,414kB
64. 20.397 1,132.178 ↓ 196.0 36,659 1

Hash Left Join (cost=26.27..31.23 rows=187 width=648) (actual time=1,107.103..1,132.178 rows=36,659 loops=1)

  • Hash Cond: (lower(filtered_places.schedule_id) = lower(company_memberships_agg.schedule_id))
65. 735.689 735.689 ↓ 196.0 36,659 1

CTE Scan on filtered_places (cost=0.00..3.74 rows=187 width=616) (actual time=730.963..735.689 rows=36,659 loops=1)

66. 0.001 376.092 ↓ 0.0 0 1

Hash (cost=26.20..26.20 rows=5 width=64) (actual time=376.091..376.092 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
67. 0.016 376.091 ↓ 0.0 0 1

Hash Join (cost=0.92..26.20 rows=5 width=64) (actual time=376.090..376.091 rows=0 loops=1)

  • Hash Cond: ((employee_names_temp1_1.user_id = employee_names_temp1.user_id) AND ((max(employee_names_temp1_1.completed_at)) = employee_names_temp1.completed_at))
68. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.57..25.38 rows=55 width=48) (never executed)

  • Hash Cond: (company_memberships_agg.user_id = employee_names_temp1_1.user_id)
69. 0.000 0.000 ↓ 0.0 0

CTE Scan on company_memberships_agg (cost=0.00..21.88 rows=1,094 width=36) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.45..0.45 rows=10 width=12) (never executed)

71. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=0.25..0.35 rows=10 width=12) (never executed)

  • Group Key: employee_names_temp1_1.user_id
72. 0.000 0.000 ↓ 0.0 0

CTE Scan on employee_names_temp1 employee_names_temp1_1 (cost=0.00..0.20 rows=10 width=12) (never executed)

73. 0.001 376.075 ↓ 0.0 0 1

Hash (cost=0.20..0.20 rows=10 width=44) (actual time=376.075..376.075 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
74. 376.074 376.074 ↓ 0.0 0 1

CTE Scan on employee_names_temp1 (cost=0.00..0.20 rows=10 width=44) (actual time=376.074..376.074 rows=0 loops=1)

75. 0.016 78,944.208 ↓ 0.0 0 84

Materialize (cost=873.55..873.58 rows=1 width=12) (actual time=939.812..939.812 rows=0 loops=84)

76. 0.001 78,944.192 ↓ 0.0 0 1

Subquery Scan on qualifying_mission_responses2 (cost=873.55..873.58 rows=1 width=12) (actual time=78,944.192..78,944.192 rows=0 loops=1)

77. 0.003 78,944.191 ↓ 0.0 0 1

GroupAggregate (cost=873.55..873.57 rows=1 width=12) (actual time=78,944.191..78,944.191 rows=0 loops=1)

  • Group Key: mission_responses.place_id
78. 0.014 78,944.188 ↓ 0.0 0 1

Sort (cost=873.55..873.55 rows=1 width=8) (actual time=78,944.188..78,944.188 rows=0 loops=1)

  • Sort Key: mission_responses.place_id
  • Sort Method: quicksort Memory: 25kB
79. 0.001 78,944.174 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.57..873.54 rows=1 width=8) (actual time=78,944.174..78,944.174 rows=0 loops=1)

  • Join Filter: (mission_responses.place_id = filtered_places_2.place_id)
80. 3.057 78,944.173 ↓ 0.0 0 1

Nested Loop (cost=0.57..867.46 rows=1 width=12) (actual time=78,944.173..78,944.173 rows=0 loops=1)

81. 4.012 4.012 ↓ 1,126.0 1,126 1

CTE Scan on campaigns_agg (cost=0.00..0.25 rows=1 width=4) (actual time=0.005..4.012 rows=1,126 loops=1)

  • Filter: (category = 'virtual_guide'::text)
  • Rows Removed by Filter: 5
82. 0.000 78,937.104 ↓ 0.0 0 1,126

Nested Loop (cost=0.57..865.34 rows=187 width=16) (actual time=70.104..70.104 rows=0 loops=1,126)

83. 4,067.112 4,067.112 ↓ 196.0 36,659 1,126

CTE Scan on filtered_places filtered_places_1 (cost=0.00..3.74 rows=187 width=44) (actual time=0.001..3.612 rows=36,659 loops=1,126)

84. 82,556.068 82,556.068 ↓ 0.0 0 41,278,034

Index Scan using index_mission_responses_on_place_id_and_campaign_id_and_state on mission_responses (cost=0.57..4.60 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=41,278,034)

  • Index Cond: ((place_id = filtered_places_1.place_id) AND (campaign_id = campaigns_agg.id) AND ((state)::text = 'completed'::text))
  • Filter: (timezone(filtered_places_1.place_time_zone, timezone('UTC'::text, completed_at)) >= filtered_places_1.converted_cutoff_time)
  • Rows Removed by Filter: 0
85. 0.000 0.000 ↓ 0.0 0

CTE Scan on filtered_places filtered_places_2 (cost=0.00..3.74 rows=187 width=4) (never executed)

Execution time : 80,203.488 ms