explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7aCp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=15,060,698.47..15,070,643.76 rows=3,978,116 width=308) (actual rows= loops=)

  • Sort Key: (CASE (timeline.sort)::text WHEN '[TOTAL]'::text THEN 0 ELSE 1 END), (COALESCE(lpad((timeline.sort)::text, 10, '0'::text), '[TOTAL]'::text)), (CASE (COALESCE(data_stats_session."Source", data_stats_page_view."Source", data_stats_event."Source")) WHEN '[TOTAL]'::text THEN 0 ELSE 1 END), (CASE ((COALESCE(data_stats_session."Source", data_stats_page_view."Source", data_stats_event."Source")) ~ '^([0-9]+[.]?[0-9]*|[.][0-9]+)$'::text) WHEN CASE_TEST_EXPR THEN lpad((COALESCE(data_stats_session."Source", data_stats_page_view."Source", data_stats_event."Source")), 50, '0'::text) ELSE (COALESCE(data_stats_session."Source", data_stats_page_view."Source", data_stats_event."Source")) END), (CASE (COALESCE(data_stats_session."Device Type", data_stats_page_view."Device Type", data_stats_event."Device Type")) WHEN '[TOTAL]'::text THEN 0 ELSE 1 END), (CASE ((COALESCE(data_stats_session."Device Type", data_stats_page_view."Device Type", data_stats_event."Device Type")) ~ '^([0-9]+[.]?[0-9]*|[.][0-9]+)$'::text) WHEN CASE_TEST_EXPR THEN lpad((COALESCE(data_stats_session."Device Type", data_stats_page_view."Device Type", data_stats_event."Device Type")), 50, '0'::text) ELSE (COALESCE(data_stats_session."Device Type", data_stats_page_view."Device Type", data_stats_event."Device Type")) END)
2. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=13,956,453.70..14,298,294.28 rows=3,978,116 width=308) (actual rows= loops=)

  • Hash Cond: (COALESCE(data_stats_session.day, data_stats_page_view.day, data_stats_event.day) = timeline.day)
3. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=13,956,317.73..14,029,635.48 rows=3,978,116 width=264) (actual rows= loops=)

  • Merge Cond: (((COALESCE(data_stats_session.day, data_stats_page_view.day)) = data_stats_event.day) AND ((COALESCE(data_stats_session."Source", data_stats_page_view."Source")) = data_stats_event."Source") AND ((COALESCE(data_stats_session."Device Type", data_stats_page_view."Device Type")) = data_stats_event."Device Type"))
4. 0.000 0.000 ↓ 0.0

Sort (cost=10,016,733.27..10,026,678.56 rows=3,978,116 width=232) (actual rows= loops=)

  • Sort Key: (COALESCE(data_stats_session.day, data_stats_page_view.day)), (COALESCE(data_stats_session."Source", data_stats_page_view."Source")), (COALESCE(data_stats_session."Device Type", data_stats_page_view."Device Type"))
5. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=9,288,714.95..9,332,025.08 rows=3,978,116 width=232) (actual rows= loops=)

  • Merge Cond: ((data_stats_page_view.day = (COALESCE(data_stats_session.day))) AND (data_stats_page_view."Source" = (COALESCE(data_stats_session."Source"))) AND (data_stats_page_view."Device Type" = (COALESCE(data_stats_session."Device Type"))))
6. 0.000 0.000 ↓ 0.0

Sort (cost=4,694,849.13..4,704,794.42 rows=3,978,116 width=104) (actual rows= loops=)

  • Sort Key: data_stats_page_view.day, data_stats_page_view."Source", data_stats_page_view."Device Type
7. 0.000 0.000 ↓ 0.0

Subquery Scan on data_stats_page_view (cost=4,033,483.66..4,134,456.94 rows=3,978,116 width=104) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4,033,483.66..4,094,675.78 rows=3,978,116 width=200) (actual rows= loops=)

  • Group Key: (COALESCE((((date_trunc('day'::text, _hyper_3_120_chunk.created_at))::timestamp without time zone)::date)::text, ''::text)), (COALESCE((_hyper_3_120_chunk.referer_host)::text, ''::text)), (COALESCE((_hyper_2_123_chunk.user_agent_type)::text, ''::text))
  • Group Key: (COALESCE((((date_trunc('day'::text, _hyper_3_120_chunk.created_at))::timestamp without time zone)::date)::text, ''::text)), (COALESCE((_hyper_3_120_chunk.referer_host)::text, ''::text))
  • Group Key: (COALESCE((((date_trunc('day'::text, _hyper_3_120_chunk.created_at))::timestamp without time zone)::date)::text, ''::text))
  • Group Key: ()
9. 0.000 0.000 ↓ 0.0

Sort (cost=4,033,483.66..4,037,765.85 rows=1,712,877 width=112) (actual rows= loops=)

  • Sort Key: (COALESCE((((date_trunc('day'::text, _hyper_3_120_chunk.created_at))::timestamp without time zone)::date)::text, ''::text)), (COALESCE((_hyper_3_120_chunk.referer_host)::text, ''::text)), (COALESCE((_hyper_2_123_chunk.user_agent_type)::text, ''::text))
10. 0.000 0.000 ↓ 0.0

Gather (cost=870,791.86..3,799,258.46 rows=1,712,877 width=112) (actual rows= loops=)

  • Workers Planned: 2
11. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=869,791.86..3,626,970.76 rows=713,699 width=112) (actual rows= loops=)

  • Hash Cond: (_hyper_3_120_chunk.session_id = _hyper_2_123_chunk.id)
12. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..2,660,713.93 rows=2,706,460 width=96) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_3_120_chunk_stats_page_view_created_at_idx on _hyper_3_120_chunk (cost=0.43..575,509.17 rows=466,475 width=96) (actual rows= loops=)

  • Index Cond: ((created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
  • Filter: (property_id = 56)
14. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_3_134_chunk (cost=0.00..813,491.31 rows=761,716 width=96) (actual rows= loops=)

  • Filter: ((created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone) AND (property_id = 56))
15. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_3_128_chunk (cost=0.00..699,558.26 rows=878,571 width=96) (actual rows= loops=)

  • Filter: ((created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone) AND (property_id = 56))
16. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_3_139_chunk (cost=0.00..558,622.89 rows=599,698 width=96) (actual rows= loops=)

  • Filter: ((created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone) AND (property_id = 56))
17. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=859,982.07..859,982.07 rows=460,783 width=48) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.43..859,982.07 rows=460,783 width=48) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_123_chunk_tmp_session_property_id_and_created_at on _hyper_2_123_chunk (cost=0.56..197,787.53 rows=98,975 width=48) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
20. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_133_chunk_tmp_session_property_id_and_created_at on _hyper_2_133_chunk (cost=0.43..255,316.50 rows=129,492 width=48) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
21. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_127_chunk_tmp_session_property_id_and_created_at on _hyper_2_127_chunk (cost=0.43..255,892.28 rows=145,466 width=48) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
22. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_138_chunk_tmp_session_property_id_and_created_at on _hyper_2_138_chunk (cost=0.43..148,681.84 rows=86,850 width=48) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
23. 0.000 0.000 ↓ 0.0

Materialize (cost=4,593,865.82..4,594,875.68 rows=201,971 width=128) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Sort (cost=4,593,865.82..4,594,370.75 rows=201,971 width=128) (actual rows= loops=)

  • Sort Key: (COALESCE(data_stats_session.day)), (COALESCE(data_stats_session."Source")), (COALESCE(data_stats_session."Device Type"))
25. 0.000 0.000 ↓ 0.0

Subquery Scan on data_stats_session (cost=4,429,053.38..4,568,572.35 rows=201,971 width=128) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4,429,053.38..4,566,552.64 rows=201,971 width=224) (actual rows= loops=)

  • Group Key: (COALESCE((((date_trunc('day'::text, _hyper_2_123_chunk_1.created_at))::timestamp without time zone)::date)::text, ''::text)), (COALESCE((_hyper_3_120_chunk_1.referer_host)::text, ''::text)), (COALESCE((_hyper_2_123_chunk_1.user_agent_type)::text, ''::text))
  • Group Key: (COALESCE((((date_trunc('day'::text, _hyper_2_123_chunk_1.created_at))::timestamp without time zone)::date)::text, ''::text)), (COALESCE((_hyper_3_120_chunk_1.referer_host)::text, ''::text))
  • Group Key: (COALESCE((((date_trunc('day'::text, _hyper_2_123_chunk_1.created_at))::timestamp without time zone)::date)::text, ''::text))
  • Group Key: ()
27. 0.000 0.000 ↓ 0.0

WindowAgg (cost=4,429,053.38..4,489,716.94 rows=1,617,695 width=144) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Sort (cost=4,429,053.38..4,433,097.62 rows=1,617,695 width=136) (actual rows= loops=)

  • Sort Key: (COALESCE((((date_trunc('day'::text, _hyper_2_123_chunk_1.created_at))::timestamp without time zone)::date)::text, ''::text)), (COALESCE((_hyper_3_120_chunk_1.referer_host)::text, ''::text)), (COALESCE((_hyper_2_123_chunk_1.user_agent_type)::text, ''::text)), _hyper_2_123_chunk_1.id
29. 0.000 0.000 ↓ 0.0

Gather (cost=1,334,707.24..4,199,032.47 rows=1,617,695 width=136) (actual rows= loops=)

  • Workers Planned: 2
30. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=1,333,707.24..4,036,262.97 rows=674,040 width=136) (actual rows= loops=)

  • Hash Cond: (_hyper_3_120_chunk_1.session_id = _hyper_2_123_chunk_1.id)
31. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..2,634,632.51 rows=2,706,460 width=33) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_3_120_chunk_stats_page_view_created_at_idx on _hyper_3_120_chunk _hyper_3_120_chunk_1 (cost=0.43..577,427.56 rows=466,475 width=34) (actual rows= loops=)

  • Index Cond: ((created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
  • Filter: (property_id = 56)
33. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_3_134_chunk _hyper_3_134_chunk_1 (cost=0.00..803,969.85 rows=761,716 width=33) (actual rows= loops=)

  • Filter: ((created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone) AND (property_id = 56))
34. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_3_128_chunk _hyper_3_128_chunk_1 (cost=0.00..688,576.13 rows=878,571 width=33) (actual rows= loops=)

  • Filter: ((created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone) AND (property_id = 56))
35. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_3_139_chunk _hyper_3_139_chunk_1 (cost=0.00..551,126.67 rows=599,698 width=33) (actual rows= loops=)

  • Filter: ((created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone) AND (property_id = 56))
36. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=1,324,017.52..1,324,017.52 rows=435,177 width=55) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=852,688.93..1,324,017.52 rows=435,177 width=55) (actual rows= loops=)

  • Hash Cond: (_hyper_4_112_chunk.id = _hyper_2_123_chunk_1.user_id)
38. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..350,324.73 rows=8,493,232 width=16) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using "112_158_stats_user_pkey" on _hyper_4_112_chunk (cost=0.43..32,248.74 rows=843,469 width=16) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_136_chunk (cost=0.00..46,440.17 rows=1,322,717 width=16) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_124_chunk (cost=0.00..36,879.59 rows=1,006,059 width=16) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_106_chunk (cost=0.00..32,209.88 rows=731,888 width=16) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_130_chunk (cost=0.00..30,796.59 rows=855,059 width=16) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_142_chunk (cost=0.00..28,360.20 rows=854,420 width=16) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_102_chunk (cost=0.00..22,632.04 rows=611,104 width=16) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_118_chunk (cost=0.00..21,498.78 rows=476,278 width=16) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_96_chunk (cost=0.00..17,041.55 rows=504,555 width=16) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_91_chunk (cost=0.00..15,503.73 rows=474,073 width=16) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_54_chunk (cost=0.00..8,482.28 rows=277,828 width=16) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_17_chunk (cost=0.00..7,807.67 rows=269,367 width=16) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_12_chunk (cost=0.00..6,614.98 rows=226,298 width=16) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_8_chunk (cost=0.00..1,241.59 rows=52,459 width=16) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on _hyper_4_1_chunk (cost=0.00..100.78 rows=4,178 width=16) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=842,659.52..842,659.52 rows=450,433 width=55) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.43..842,659.52 rows=450,433 width=55) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_123_chunk_tmp_session_property_id_and_created_at on _hyper_2_123_chunk _hyper_2_123_chunk_1 (cost=0.56..180,408.86 rows=88,625 width=55) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
57. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_133_chunk_tmp_session_property_id_and_created_at on _hyper_2_133_chunk _hyper_2_133_chunk_1 (cost=0.43..255,316.50 rows=129,492 width=55) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
58. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_127_chunk_tmp_session_property_id_and_created_at on _hyper_2_127_chunk _hyper_2_127_chunk_1 (cost=0.43..256,000.16 rows=145,466 width=55) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
59. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_138_chunk_tmp_session_property_id_and_created_at on _hyper_2_138_chunk _hyper_2_138_chunk_1 (cost=0.43..148,681.84 rows=86,850 width=55) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
60. 0.000 0.000 ↓ 0.0

Materialize (cost=3,939,584.45..3,949,181.34 rows=1,919,377 width=160) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Sort (cost=3,939,584.45..3,944,382.89 rows=1,919,377 width=160) (actual rows= loops=)

  • Sort Key: data_stats_event.day, data_stats_event."Source", data_stats_event."Device Type
62. 0.000 0.000 ↓ 0.0

Subquery Scan on data_stats_event (cost=3,582,675.14..3,653,052.28 rows=1,919,377 width=160) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=3,582,675.14..3,633,858.51 rows=1,919,377 width=256) (actual rows= loops=)

  • Group Key: (COALESCE((((date_trunc('day'::text, _hyper_5_121_chunk.created_at))::timestamp without time zone)::date)::text, ''::text)), (COALESCE((_hyper_3_120_chunk_2.referer_host)::text, ''::text)), (COALESCE((_hyper_2_127_chunk_2.user_agent_type)::text, ''::text))
  • Group Key: (COALESCE((((date_trunc('day'::text, _hyper_5_121_chunk.created_at))::timestamp without time zone)::date)::text, ''::text)), (COALESCE((_hyper_3_120_chunk_2.referer_host)::text, ''::text))
  • Group Key: (COALESCE((((date_trunc('day'::text, _hyper_5_121_chunk.created_at))::timestamp without time zone)::date)::text, ''::text))
  • Group Key: ()
64. 0.000 0.000 ↓ 0.0

Sort (cost=3,582,675.14..3,584,274.62 rows=639,792 width=116) (actual rows= loops=)

  • Sort Key: (COALESCE((((date_trunc('day'::text, _hyper_5_121_chunk.created_at))::timestamp without time zone)::date)::text, ''::text)), (COALESCE((_hyper_3_120_chunk_2.referer_host)::text, ''::text)), (COALESCE((_hyper_2_127_chunk_2.user_agent_type)::text, ''::text))
65. 0.000 0.000 ↓ 0.0

Gather (cost=873,856.68..3,498,482.02 rows=639,792 width=116) (actual rows= loops=)

  • Workers Planned: 2
66. 0.000 0.000 ↓ 0.0

Nested Loop (cost=872,856.68..3,433,502.82 rows=266,580 width=116) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=872,856.12..1,374,923.82 rows=272,402 width=100) (actual rows= loops=)

  • Hash Cond: (_hyper_5_121_chunk.session_id = _hyper_2_127_chunk_2.id)
68. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.56..487,629.40 rows=297,561 width=84) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on _hyper_5_121_chunk (cost=12,566.49..357,193.60 rows=237,378 width=84) (actual rows= loops=)

  • Recheck Cond: ((event_id = ANY ('{3108,4066,4064,4065,3977,3978,3979,3980}'::integer[])) AND (property_id = 56) AND (created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
70. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on _hyper_5_121_chunk_tmp_event_event_id (cost=0.00..12,424.06 rows=569,707 width=0) (actual rows= loops=)

  • Index Cond: ((event_id = ANY ('{3108,4066,4064,4065,3977,3978,3979,3980}'::integer[])) AND (property_id = 56) AND (created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
71. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_5_129_chunk_tmp_event_event_id on _hyper_5_129_chunk (cost=0.56..97,450.01 rows=66,059 width=84) (actual rows= loops=)

  • Index Cond: ((event_id = ANY ('{3108,4066,4064,4065,3977,3978,3979,3980}'::integer[])) AND (property_id = 56) AND (created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
72. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_5_135_chunk_tmp_event_event_id on _hyper_5_135_chunk (cost=0.56..17,882.54 rows=10,418 width=84) (actual rows= loops=)

  • Index Cond: ((event_id = ANY ('{3108,4066,4064,4065,3977,3978,3979,3980}'::integer[])) AND (property_id = 56) AND (created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
73. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_5_140_chunk_tmp_event_event_id on _hyper_5_140_chunk (cost=0.56..13,615.45 rows=8,488 width=84) (actual rows= loops=)

  • Index Cond: ((event_id = ANY ('{3108,4066,4064,4065,3977,3978,3979,3980}'::integer[])) AND (property_id = 56) AND (created_at >= '2020-05-24 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
74. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=863,045.77..863,045.77 rows=460,783 width=48) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.56..863,045.77 rows=460,783 width=48) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on _hyper_2_127_chunk _hyper_2_127_chunk_2 (cost=7,871.70..259,411.36 rows=145,466 width=48) (actual rows= loops=)

  • Recheck Cond: ((property_id = 56) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
77. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on _hyper_2_127_chunk_tmp_session_property_id_and_created_at (cost=0.00..7,784.42 rows=349,119 width=0) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
78. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_123_chunk_tmp_session_property_id_and_created_at on _hyper_2_123_chunk _hyper_2_123_chunk_2 (cost=0.56..197,787.53 rows=98,975 width=48) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
79. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_133_chunk_tmp_session_property_id_and_created_at on _hyper_2_133_chunk _hyper_2_133_chunk_2 (cost=0.43..255,316.50 rows=129,492 width=48) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
80. 0.000 0.000 ↓ 0.0

Parallel Index Scan using _hyper_2_138_chunk_tmp_session_property_id_and_created_at on _hyper_2_138_chunk _hyper_2_138_chunk_2 (cost=0.43..148,226.46 rows=86,850 width=48) (actual rows= loops=)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
81. 0.000 0.000 ↓ 0.0

Append (cost=0.56..7.52 rows=4 width=48) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Index Scan using "120_172_stats_page_view_pkey" on _hyper_3_120_chunk _hyper_3_120_chunk_2 (cost=0.56..1.88 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ((id = _hyper_5_121_chunk.page_view_id) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
  • Filter: (property_id = 56)
83. 0.000 0.000 ↓ 0.0

Index Scan using "128_187_stats_page_view_pkey" on _hyper_3_128_chunk _hyper_3_128_chunk_2 (cost=0.56..1.87 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ((id = _hyper_5_121_chunk.page_view_id) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
  • Filter: (property_id = 56)
84. 0.000 0.000 ↓ 0.0

Index Scan using "134_197_stats_page_view_id" on _hyper_3_134_chunk _hyper_3_134_chunk_2 (cost=0.56..1.89 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ((id = _hyper_5_121_chunk.page_view_id) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
  • Filter: (property_id = 56)
85. 0.000 0.000 ↓ 0.0

Index Scan using "139_207_stats_page_view_pkey" on _hyper_3_139_chunk _hyper_3_139_chunk_2 (cost=0.56..1.85 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ((id = _hyper_5_121_chunk.page_view_id) AND (created_at >= '2020-05-23 06:02:00+00'::timestamp with time zone) AND (created_at <= '2020-09-01 06:02:59+00'::timestamp with time zone))
  • Filter: (property_id = 56)
86. 0.000 0.000 ↓ 0.0

Hash (cost=133.48..133.48 rows=200 width=40) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Subquery Scan on timeline (cost=125.98..133.48 rows=200 width=40) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

WindowAgg (cost=125.98..131.48 rows=200 width=48) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Subquery Scan on timeline_inner (cost=125.98..128.48 rows=200 width=40) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Sort (cost=125.98..126.48 rows=200 width=52) (actual rows= loops=)

  • Sort Key: (first_value(tl.dt) OVER (?))
91. 0.000 0.000 ↓ 0.0

HashAggregate (cost=112.33..118.33 rows=200 width=52) (actual rows= loops=)

  • Group Key: first_value(tl.dt) OVER (?), ((((date_trunc('day'::text, tl.dt))::timestamp without time zone)::date))::text
92. 0.000 0.000 ↓ 0.0

WindowAgg (cost=67.33..107.33 rows=1,000 width=52) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Sort (cost=67.33..69.83 rows=1,000 width=12) (actual rows= loops=)

  • Sort Key: (((date_trunc('day'::text, tl.dt))::timestamp without time zone)::date), tl.dt
94. 0.000 0.000 ↓ 0.0

Function Scan on generate_series tl (cost=0.00..17.50 rows=1,000 width=12) (actual rows= loops=)