explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OM9oU

Settings
# exclusive inclusive rows x rows loops node
1. 215.296 483,836.964 ↑ 134.4 29,603 1

Sort (cost=14,592,296.69..14,602,241.49 rows=3,977,919 width=308) (actual time=483,835.411..483,836.964 rows=29,603 loops=1)

  • 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)
  • Sort Method: quicksort Memory: 8,762kB
2. 45.820 483,621.668 ↑ 134.4 29,603 1

Hash Full Join (cost=13,488,105.36..13,829,931.51 rows=3,977,919 width=308) (actual time=483,536.129..483,621.668 rows=29,603 loops=1)

  • Hash Cond: (COALESCE(data_stats_session.day, data_stats_page_view.day, data_stats_event.day) = timeline.day)
3. 32.752 483,572.040 ↑ 134.4 29,603 1

Merge Full Join (cost=13,487,969.38..13,561,286.00 rows=3,977,919 width=264) (actual time=483,532.156..483,572.040 rows=29,603 loops=1)

  • 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. 27.691 288,052.539 ↑ 134.4 29,592 1

Sort (cost=9,548,206.99..9,558,151.78 rows=3,977,919 width=232) (actual time=288,050.115..288,052.539 rows=29,592 loops=1)

  • 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"))
  • Sort Method: quicksort Memory: 8,751kB
5. 30.999 288,024.848 ↑ 134.4 29,592 1

Merge Full Join (cost=8,820,128.72..8,863,535.81 rows=3,977,919 width=232) (actual time=287,986.568..288,024.848 rows=29,592 loops=1)

  • 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. 83.223 130,586.652 ↑ 134.9 29,496 1

Sort (cost=4,694,829.10..4,704,773.90 rows=3,977,919 width=104) (actual time=130,584.729..130,586.652 rows=29,496 loops=1)

  • Sort Key: data_stats_page_view.day, data_stats_page_view."Source", data_stats_page_view."Device Type
  • Sort Method: quicksort Memory: 3,605kB
7. 3.016 130,503.429 ↑ 134.9 29,496 1

Subquery Scan on data_stats_page_view (cost=4,033,499.27..4,134,467.93 rows=3,977,919 width=104) (actual time=125,900.819..130,503.429 rows=29,496 loops=1)

8. 1,556.763 130,500.413 ↑ 134.9 29,496 1

GroupAggregate (cost=4,033,499.27..4,094,688.74 rows=3,977,919 width=200) (actual time=125,900.818..130,500.413 rows=29,496 loops=1)

  • 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. 14,646.253 128,943.650 ↓ 3.9 6,750,077 1

Sort (cost=4,033,499.27..4,037,781.33 rows=1,712,822 width=112) (actual time=125,900.755..128,943.650 rows=6,750,077 loops=1)

  • 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))
  • Sort Method: external merge Disk: 429,608kB
10. 1,229.072 114,297.397 ↓ 3.9 6,750,077 1

Gather (cost=870,825.08..3,799,282.16 rows=1,712,822 width=112) (actual time=111,200.901..114,297.397 rows=6,750,077 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
11. 3,601.398 113,068.325 ↓ 3.2 2,250,026 3 / 3

Parallel Hash Join (cost=869,825.08..3,626,999.96 rows=713,676 width=112) (actual time=111,242.923..113,068.325 rows=2,250,026 loops=3)

  • Hash Cond: (_hyper_3_120_chunk.session_id = _hyper_2_123_chunk.id)
12. 432.437 67,846.817 ↑ 1.2 2,194,604 3 / 3

Parallel Append (cost=0.00..2,660,716.65 rows=2,706,290 width=96) (actual time=0.574..67,846.817 rows=2,194,604 loops=3)

13. 41,117.716 41,117.716 ↑ 1.1 414,892 3 / 3

Parallel Index Scan using _hyper_3_120_chunk_stats_page_view_created_at_idx on _hyper_3_120_chunk (cost=0.43..575,514.86 rows=466,475 width=96) (actual time=0.681..41,117.716 rows=414,892 loops=3)

  • 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)
  • Rows Removed by Filter: 1,027,244
14. 10,833.622 10,833.622 ↓ 2.4 1,818,897 1 / 3

Parallel Seq Scan on _hyper_3_134_chunk (cost=0.00..813,491.31 rows=761,716 width=96) (actual time=0.483..32,500.865 rows=1,818,897 loops=1)

  • 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))
  • Rows Removed by Filter: 9,478,767
15. 9,677.707 9,677.707 ↓ 1.2 1,038,126 2 / 3

Parallel Seq Scan on _hyper_3_128_chunk (cost=0.00..699,558.26 rows=878,571 width=96) (actual time=0.310..14,516.561 rows=1,038,126 loops=2)

  • 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))
  • Rows Removed by Filter: 3,246,932
16. 5,785.335 5,785.335 ↓ 2.4 1,443,987 1 / 3

Parallel Seq Scan on _hyper_3_139_chunk (cost=0.00..558,620.77 rows=599,528 width=96) (actual time=0.047..17,356.006 rows=1,443,987 loops=1)

  • 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))
  • Rows Removed by Filter: 6,394,550
17. 340.392 41,620.110 ↑ 1.2 372,877 3 / 3

Parallel Hash (cost=860,015.11..860,015.11 rows=460,797 width=48) (actual time=41,620.109..41,620.110 rows=372,877 loops=3)

  • Buckets: 524,288 Batches: 8 Memory Usage: 11,808kB
18. 82.487 41,279.718 ↑ 1.2 372,877 3 / 3

Parallel Append (cost=0.43..860,015.11 rows=460,797 width=48) (actual time=0.614..41,279.718 rows=372,877 loops=3)

19. 11,502.947 11,502.947 ↓ 2.3 228,000 1 / 3

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 time=1.423..34,508.842 rows=228,000 loops=1)

  • 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. 12,964.474 12,964.474 ↓ 2.5 321,832 1 / 3

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 time=0.339..38,893.422 rows=321,832 loops=1)

  • 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. 15,903.633 15,903.633 ↑ 1.2 117,749 3 / 3

Parallel Index Scan using _hyper_2_127_chunk_tmp_session_property_id_and_created_at on _hyper_2_127_chunk (cost=0.43..255,891.28 rows=145,466 width=48) (actual time=0.717..15,903.633 rows=117,749 loops=3)

  • 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. 826.176 826.176 ↓ 2.5 215,552 1 / 3

Parallel Index Scan using _hyper_2_138_chunk_tmp_session_property_id_and_created_at on _hyper_2_138_chunk (cost=0.43..148,715.82 rows=86,864 width=48) (actual time=0.078..2,478.529 rows=215,552 loops=1)

  • 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. 3.554 157,407.197 ↑ 7.0 29,462 1

Materialize (cost=4,125,299.62..4,126,337.80 rows=207,636 width=128) (actual time=157,401.827..157,407.197 rows=29,462 loops=1)

24. 141.387 157,403.643 ↑ 7.0 29,462 1

Sort (cost=4,125,299.62..4,125,818.71 rows=207,636 width=128) (actual time=157,401.820..157,403.643 rows=29,462 loops=1)

  • Sort Key: (COALESCE(data_stats_session.day)), (COALESCE(data_stats_session."Source")), (COALESCE(data_stats_session."Device Type"))
  • Sort Method: quicksort Memory: 5,976kB
25. 7.550 157,262.256 ↑ 7.0 29,462 1

Subquery Scan on data_stats_session (cost=3,954,892.32..4,099,255.52 rows=207,636 width=128) (actual time=124,643.773..157,262.256 rows=29,462 loops=1)

26. 19,671.828 157,254.706 ↑ 7.0 29,462 1

GroupAggregate (cost=3,954,892.32..4,097,179.16 rows=207,636 width=224) (actual time=124,643.770..157,254.706 rows=29,462 loops=1)

  • 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. 5,152.634 137,582.878 ↓ 4.0 6,748,575 1

WindowAgg (cost=3,954,892.32..4,017,680.55 rows=1,674,353 width=144) (actual time=124,643.572..137,582.878 rows=6,748,575 loops=1)

28. 36,045.884 132,430.244 ↓ 4.0 6,748,575 1

Sort (cost=3,954,892.32..3,959,078.20 rows=1,674,353 width=136) (actual time=124,643.547..132,430.244 rows=6,748,575 loops=1)

  • 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
  • Sort Method: external merge Disk: 625,728kB
29. 806.510 96,384.360 ↓ 4.0 6,748,575 1

Gather (cost=853,614.28..3,716,398.63 rows=1,674,353 width=136) (actual time=92,357.835..96,384.360 rows=6,748,575 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
30. 4,426.168 95,577.850 ↓ 3.2 2,249,525 3 / 3

Parallel Hash Join (cost=852,614.28..3,547,963.33 rows=697,647 width=136) (actual time=92,334.507..95,577.850 rows=2,249,525 loops=3)

  • Hash Cond: (_hyper_3_120_chunk_1.session_id = _hyper_2_123_chunk_1.id)
31. 339.149 49,273.360 ↑ 1.2 2,194,604 3 / 3

Parallel Append (cost=0.00..2,626,888.02 rows=2,706,290 width=33) (actual time=0.183..49,273.360 rows=2,194,604 loops=3)

32. 29,091.180 29,091.180 ↑ 1.1 414,892 3 / 3

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..569,683.92 rows=466,475 width=34) (actual time=0.562..29,091.180 rows=414,892 loops=3)

  • 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)
  • Rows Removed by Filter: 1,027,244
33. 8,115.115 8,115.115 ↓ 2.4 1,818,897 1 / 3

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 time=0.034..24,345.344 rows=1,818,897 loops=1)

  • 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))
  • Rows Removed by Filter: 9,478,767
34. 7,326.397 7,326.397 ↓ 1.2 1,038,126 2 / 3

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 time=0.096..10,989.595 rows=1,038,126 loops=2)

  • 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))
  • Rows Removed by Filter: 3,246,932
35. 4,401.520 4,401.520 ↓ 2.4 1,443,987 1 / 3

Parallel Seq Scan on _hyper_3_139_chunk _hyper_3_139_chunk_1 (cost=0.00..551,126.67 rows=599,528 width=33) (actual time=0.024..13,204.559 rows=1,443,987 loops=1)

  • 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))
  • Rows Removed by Filter: 6,394,550
36. 389.474 41,878.322 ↑ 1.2 368,905 3 / 3

Parallel Hash (cost=842,584.69..842,584.69 rows=450,447 width=55) (actual time=41,878.322..41,878.322 rows=368,905 loops=3)

  • Buckets: 262,144 Batches: 8 Memory Usage: 14,048kB
37. 84.778 41,488.848 ↑ 1.2 368,905 3 / 3

Parallel Append (cost=0.43..842,584.69 rows=450,447 width=55) (actual time=0.463..41,488.848 rows=368,905 loops=3)

38. 10,748.461 10,748.461 ↓ 2.4 216,082 1 / 3

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 time=0.953..32,245.382 rows=216,082 loops=1)

  • 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))
39. 11,722.172 11,722.172 ↓ 2.5 321,832 1 / 3

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 time=0.386..35,166.517 rows=321,832 loops=1)

  • 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))
40. 16,043.046 16,043.046 ↑ 1.2 117,749 3 / 3

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..255,891.28 rows=145,466 width=55) (actual time=0.498..16,043.046 rows=117,749 loops=3)

  • 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))
41. 2,890.391 2,890.391 ↓ 2.5 215,552 1 / 3

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,715.82 rows=86,864 width=55) (actual time=0.048..8,671.173 rows=215,552 loops=1)

  • 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))
42. 3.159 195,486.749 ↑ 81.2 23,642 1

Materialize (cost=3,939,762.40..3,949,359.66 rows=1,919,452 width=160) (actual time=195,482.031..195,486.749 rows=23,642 loops=1)

43. 77.990 195,483.590 ↑ 81.2 23,642 1

Sort (cost=3,939,762.40..3,944,561.03 rows=1,919,452 width=160) (actual time=195,482.026..195,483.590 rows=23,642 loops=1)

  • Sort Key: data_stats_event.day, data_stats_event."Source", data_stats_event."Device Type
  • Sort Method: quicksort Memory: 4,445kB
44. 3.663 195,405.600 ↑ 81.2 23,642 1

Subquery Scan on data_stats_event (cost=3,582,839.97..3,653,219.86 rows=1,919,452 width=160) (actual time=191,186.543..195,405.600 rows=23,642 loops=1)

45. 1,716.513 195,401.937 ↑ 81.2 23,642 1

GroupAggregate (cost=3,582,839.97..3,634,025.34 rows=1,919,452 width=256) (actual time=191,186.541..195,401.937 rows=23,642 loops=1)

  • 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: ()
46. 11,480.689 193,685.424 ↓ 7.1 4,534,075 1

Sort (cost=3,582,839.97..3,584,439.52 rows=639,817 width=116) (actual time=191,186.425..193,685.424 rows=4,534,075 loops=1)

  • 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))
  • Sort Method: external merge Disk: 304,776kB
47. 0.000 182,204.735 ↓ 7.1 4,534,075 1

Gather (cost=873,890.90..3,498,644.26 rows=639,817 width=116) (actual time=67,076.911..182,204.735 rows=4,534,075 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
48. 1,245.290 183,144.529 ↓ 5.7 1,511,358 3 / 3

Nested Loop (cost=872,890.90..3,433,662.56 rows=266,590 width=116) (actual time=67,080.910..183,144.529 rows=1,511,358 loops=3)

49. 2,690.639 68,604.289 ↓ 5.5 1,510,599 3 / 3

Parallel Hash Join (cost=872,890.34..1,374,963.80 rows=272,413 width=100) (actual time=67,078.684..68,604.289 rows=1,510,599 loops=3)

  • Hash Cond: (_hyper_5_121_chunk.session_id = _hyper_2_127_chunk_2.id)
50. 273.475 40,322.166 ↓ 4.8 1,418,230 3 / 3

Parallel Append (cost=0.56..487,635.11 rows=297,564 width=84) (actual time=1,397.371..40,322.166 rows=1,418,230 loops=3)

51. 3,168.988 4,537.511 ↓ 9.7 2,292,454 1 / 3

Parallel Bitmap Heap Scan on _hyper_5_121_chunk (cost=12,566.49..357,193.60 rows=237,378 width=84) (actual time=4,189.415..13,612.532 rows=2,292,454 loops=1)

  • 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))
52. 1,368.522 1,368.522 ↓ 4.0 2,292,454 1 / 3

Bitmap Index Scan on _hyper_5_121_chunk_tmp_event_event_id (cost=0.00..12,424.06 rows=569,707 width=0) (actual time=4,105.567..4,105.567 rows=2,292,454 loops=1)

  • 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))
53. 13,378.450 13,378.450 ↓ 6.0 395,208 3 / 3

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 time=0.762..13,378.450 rows=395,208 loops=3)

  • 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))
54. 13,008.851 13,008.851 ↓ 21.1 219,872 2 / 3

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 time=2.968..19,513.277 rows=219,872 loops=2)

  • 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))
55. 9,123.879 9,123.879 ↓ 39.7 336,869 1 / 3

Parallel Index Scan using _hyper_5_140_chunk_tmp_event_event_id on _hyper_5_140_chunk (cost=0.56..13,621.14 rows=8,492 width=84) (actual time=0.914..27,371.636 rows=336,869 loops=1)

  • 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))
56. 291.675 25,591.484 ↑ 1.2 372,877 3 / 3

Parallel Hash (cost=863,079.81..863,079.81 rows=460,797 width=48) (actual time=25,591.484..25,591.484 rows=372,877 loops=3)

  • Buckets: 524,288 Batches: 8 Memory Usage: 11,808kB
57. 79.923 25,299.809 ↑ 1.2 372,877 3 / 3

Parallel Append (cost=0.56..863,079.81 rows=460,797 width=48) (actual time=326.413..25,299.809 rows=372,877 loops=3)

58. 2,975.147 3,270.367 ↓ 2.4 353,248 1 / 3

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 time=978.110..9,811.102 rows=353,248 loops=1)

  • 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))
59. 295.220 295.220 ↓ 1.0 353,248 1 / 3

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 time=885.660..885.660 rows=353,248 loops=1)

  • 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))
60. 11,976.302 11,976.302 ↑ 1.3 76,000 3 / 3

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 time=0.555..11,976.302 rows=76,000 loops=3)

  • 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))
61. 9,843.685 9,843.685 ↓ 1.2 160,916 2 / 3

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 time=0.329..14,765.528 rows=160,916 loops=2)

  • 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))
62. 129.531 129.531 ↓ 2.5 215,552 1 / 3

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,260.44 rows=86,864 width=48) (actual time=0.024..388.593 rows=215,552 loops=1)

  • 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))
63. 3,021.199 113,294.950 ↑ 4.0 1 4,531,798 / 3

Append (cost=0.56..7.52 rows=4 width=48) (actual time=0.059..0.075 rows=1 loops=4,531,798)

64. 28,701.387 28,701.387 ↑ 1.0 1 4,531,798 / 3

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 time=0.019..0.019 rows=1 loops=4,531,798)

  • 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)
  • Rows Removed by Filter: 0
65. 37,764.983 37,764.983 ↓ 0.0 0 4,531,798 / 3

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 time=0.025..0.025 rows=0 loops=4,531,798)

  • 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)
  • Rows Removed by Filter: 0
66. 28,701.387 28,701.387 ↓ 0.0 0 4,531,798 / 3

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 time=0.018..0.019 rows=0 loops=4,531,798)

  • 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)
  • Rows Removed by Filter: 0
67. 15,105.993 15,105.993 ↓ 0.0 0 4,531,798 / 3

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 time=0.010..0.010 rows=0 loops=4,531,798)

  • 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)
68. 0.018 3.808 ↑ 2.0 101 1

Hash (cost=133.48..133.48 rows=200 width=40) (actual time=3.808..3.808 rows=101 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
69. 0.009 3.790 ↑ 2.0 101 1

Subquery Scan on timeline (cost=125.98..133.48 rows=200 width=40) (actual time=3.726..3.790 rows=101 loops=1)

70. 0.044 3.781 ↑ 2.0 101 1

WindowAgg (cost=125.98..131.48 rows=200 width=48) (actual time=3.725..3.781 rows=101 loops=1)

71. 0.011 3.737 ↑ 2.0 101 1

Subquery Scan on timeline_inner (cost=125.98..128.48 rows=200 width=40) (actual time=3.721..3.737 rows=101 loops=1)

72. 0.057 3.726 ↑ 2.0 101 1

Sort (cost=125.98..126.48 rows=200 width=52) (actual time=3.720..3.726 rows=101 loops=1)

  • Sort Key: (first_value(tl.dt) OVER (?))
  • Sort Method: quicksort Memory: 32kB
73. 0.507 3.669 ↑ 2.0 101 1

HashAggregate (cost=112.33..118.33 rows=200 width=52) (actual time=3.653..3.669 rows=101 loops=1)

  • Group Key: first_value(tl.dt) OVER (?), ((((date_trunc('day'::text, tl.dt))::timestamp without time zone)::date))::text
74. 1.456 3.162 ↓ 2.4 2,401 1

WindowAgg (cost=67.33..107.33 rows=1,000 width=52) (actual time=1.593..3.162 rows=2,401 loops=1)

75. 0.551 1.706 ↓ 2.4 2,401 1

Sort (cost=67.33..69.83 rows=1,000 width=12) (actual time=1.585..1.706 rows=2,401 loops=1)

  • Sort Key: (((date_trunc('day'::text, tl.dt))::timestamp without time zone)::date), tl.dt
  • Sort Method: quicksort Memory: 209kB
76. 1.155 1.155 ↓ 2.4 2,401 1

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

Planning time : 12.311 ms
Execution time : 484,834.693 ms