explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dfCn

Settings
# exclusive inclusive rows x rows loops node
1. 119,865.606 119,865.606 ↓ 3,996.9 799,386 1

CTE Scan on visitor_aggregated_visitor_ids_in_array (cost=506,349,769.09..506,349,773.09 rows=200 width=186) (actual time=69,362.344..119,865.606 rows=799,386 loops=1)

2.          

CTE visitor_aggregated_visitor_ids_in_array

3. 43,598.469 119,262.479 ↓ 3,996.9 799,386 1

GroupAggregate (cost=490,470,873.80..506,349,769.09 rows=200 width=131) (actual time=69,362.339..119,262.479 rows=799,386 loops=1)

  • Group Key: us_49.domain_userid
4. 47,773.055 75,664.010 ↑ 47.3 26,877,839 1

Sort (cost=490,470,873.80..493,646,652.16 rows=1,270,311,343 width=104) (actual time=69,362.271..75,664.010 rows=26,877,839 loops=1)

  • Sort Key: us_49.domain_userid
  • Sort Method: external merge Disk: 2126280kB
5. 4,970.819 27,890.955 ↑ 47.3 26,877,839 1

Merge Left Join (cost=1,435,270.30..20,503,087.62 rows=1,270,311,343 width=104) (actual time=18,415.192..27,890.955 rows=26,877,839 loops=1)

  • Merge Cond: (us_49.root_event_id = co.root_event_id)
6. 12,157.722 15,439.088 ↓ 196.8 9,687,508 1

Sort (cost=384,668.37..384,791.45 rows=49,233 width=93) (actual time=13,398.979..15,439.088 rows=9,687,508 loops=1)

  • Sort Key: us_49.root_event_id
  • Sort Method: external merge Disk: 711288kB
7. 324.844 3,281.366 ↓ 196.8 9,687,508 1

Gather (cost=1,000.00..378,304.31 rows=49,233 width=93) (actual time=75.019..3,281.366 rows=9,687,508 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 0.000 2,956.522 ↓ 157.3 3,229,169 3

Parallel Append (cost=0.00..372,381.01 rows=20,530 width=93) (actual time=24.686..2,956.522 rows=3,229,169 loops=3)

9. 1,339.295 1,339.295 ↓ 160.5 1,610,296 3

Parallel Seq Scan on contexts_com_globeandmail_user_3_2019_01_03 us_49 (cost=0.00..184,488.72 rows=10,035 width=93) (actual time=0.053..1,339.295 rows=1,610,296 loops=3)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
10. 1,927.249 1,927.249 ↓ 238.9 2,419,186 2

Parallel Seq Scan on contexts_com_globeandmail_user_3_2019_01_02 us_48 (cost=0.00..180,952.44 rows=10,125 width=93) (actual time=0.064..1,927.249 rows=2,419,186 loops=2)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
11. 29.796 29.796 ↓ 172.2 18,248 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2019_01_01 us_47 (cost=0.00..1,441.46 rows=106 width=96) (actual time=0.007..29.796 rows=18,248 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 17909
12. 17.643 17.643 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_31 us_46 (cost=0.00..1,300.94 rows=96 width=95) (actual time=17.643..17.643 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 32719
13. 5.892 5.892 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_28 us_43 (cost=0.00..417.37 rows=31 width=96) (actual time=5.892..5.892 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 10468
14. 4.644 4.644 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_30 us_45 (cost=0.00..326.82 rows=24 width=96) (actual time=4.644..4.644 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 8244
15. 4.506 4.506 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_29 us_44 (cost=0.00..325.97 rows=24 width=96) (actual time=4.506..4.506 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 8222
16. 4.446 4.446 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_27 us_42 (cost=0.00..289.66 rows=22 width=96) (actual time=4.446..4.446 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 7336
17. 3.764 3.764 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_21 us_36 (cost=0.00..279.24 rows=21 width=96) (actual time=3.764..3.764 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 7038
18. 3.061 3.061 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_20 us_35 (cost=0.00..218.06 rows=16 width=96) (actual time=3.061..3.061 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 5493
19. 3.137 3.137 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_19 us_34 (cost=0.00..212.25 rows=16 width=96) (actual time=3.137..3.137 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 5368
20. 2.095 2.095 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_18 us_33 (cost=0.00..152.94 rows=11 width=96) (actual time=2.095..2.095 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 3875
21. 2.077 2.077 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_13 us_28 (cost=0.00..151.47 rows=11 width=96) (actual time=2.077..2.077 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 3849
22. 1.954 1.954 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_22 us_37 (cost=0.00..145.29 rows=11 width=96) (actual time=1.954..1.954 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 3700
23. 1.977 1.977 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_24 us_39 (cost=0.00..144.49 rows=11 width=96) (actual time=1.977..1.977 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 3665
24. 1.937 1.937 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_17 us_32 (cost=0.00..143.40 rows=11 width=96) (actual time=1.937..1.937 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 3644
25. 1.859 1.859 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_14 us_29 (cost=0.00..138.29 rows=10 width=96) (actual time=1.859..1.859 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 3485
26. 1.563 1.563 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_26 us_41 (cost=0.00..118.60 rows=9 width=96) (actual time=1.563..1.563 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 2961
27. 1.421 1.421 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_23 us_38 (cost=0.00..105.24 rows=8 width=96) (actual time=1.421..1.421 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 2678
28. 1.460 1.460 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_10 us_25 (cost=0.00..105.16 rows=8 width=96) (actual time=1.460..1.460 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 2686
29. 1.209 1.209 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_11 us_26 (cost=0.00..91.00 rows=7 width=96) (actual time=1.209..1.209 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 2289
30. 1.220 1.220 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_12 us_27 (cost=0.00..87.99 rows=6 width=96) (actual time=1.220..1.220 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 2226
31. 1.099 1.099 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_07 us_22 (cost=0.00..73.66 rows=5 width=96) (actual time=1.099..1.099 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1871
32. 1.640 1.640 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_25 us_40 (cost=0.00..73.22 rows=5 width=96) (actual time=1.640..1.640 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1863
33. 1.240 1.240 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_15 us_30 (cost=0.00..62.09 rows=5 width=96) (actual time=1.240..1.240 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1578
34. 1.227 1.227 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_08 us_23 (cost=0.00..56.10 rows=4 width=96) (actual time=1.227..1.227 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1403
35. 1.140 1.140 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_06 us_21 (cost=0.00..55.81 rows=4 width=96) (actual time=1.140..1.140 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1411
36. 0.798 0.798 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_16 us_31 (cost=0.00..46.01 rows=4 width=96) (actual time=0.798..0.798 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1164
37. 0.616 0.616 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_09 us_24 (cost=0.00..43.06 rows=3 width=96) (actual time=0.616..0.616 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1098
38. 0.004 0.004 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_06_10 us (cost=0.00..11.03 rows=1 width=740) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 4
39. 0.006 0.006 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_02 us_1 (cost=0.00..11.03 rows=1 width=740) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1
40. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_06 us_2 (cost=0.00..11.03 rows=1 width=740) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 3
41. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_08 us_3 (cost=0.00..11.03 rows=1 width=740) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 2
42. 0.006 0.006 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_14 us_4 (cost=0.00..11.03 rows=1 width=740) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1
43. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_15 us_5 (cost=0.00..11.03 rows=1 width=740) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 4
44. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_18 us_6 (cost=0.00..11.03 rows=1 width=740) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 6
45. 0.006 0.006 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_19 us_7 (cost=0.00..11.03 rows=1 width=740) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1
46. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_20 us_8 (cost=0.00..11.03 rows=1 width=740) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 6
47. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_21 us_9 (cost=0.00..11.03 rows=1 width=740) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 8
48. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_22 us_10 (cost=0.00..11.03 rows=1 width=740) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1
49. 0.006 0.006 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_24 us_11 (cost=0.00..11.03 rows=1 width=740) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 4
50. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_25 us_12 (cost=0.00..11.03 rows=1 width=740) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 7
51. 0.006 0.006 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_26 us_13 (cost=0.00..11.03 rows=1 width=740) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 1
52. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_28 us_14 (cost=0.00..11.03 rows=1 width=740) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 5
53. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_11_29 us_15 (cost=0.00..11.03 rows=1 width=740) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 3
54. 0.016 0.016 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_01 us_16 (cost=0.00..11.03 rows=1 width=740) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 32
55. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_02 us_17 (cost=0.00..11.03 rows=1 width=740) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 8
56. 0.012 0.012 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_03 us_18 (cost=0.00..11.03 rows=1 width=740) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 18
57. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_04 us_19 (cost=0.00..11.03 rows=1 width=740) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 5
58. 0.013 0.013 ↓ 0.0 0 1

Parallel Seq Scan on contexts_com_globeandmail_user_3_2018_12_05 us_20 (cost=0.00..11.03 rows=1 width=740) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (root_derived_tstamp <@ tsrange((LOCALTIMESTAMP - '48:00:00'::interval), (LOCALTIMESTAMP - '00:00:00'::interval)))
  • Rows Removed by Filter: 4
59. 1,374.720 7,481.048 ↓ 4.4 22,515,307 1

Materialize (cost=1,050,601.93..1,076,403.96 rows=5,160,406 width=43) (actual time=5,016.203..7,481.048 rows=22,515,307 loops=1)

60. 4,915.239 6,106.328 ↓ 1.0 5,183,814 1

Sort (cost=1,050,601.93..1,063,502.94 rows=5,160,406 width=43) (actual time=5,016.200..6,106.328 rows=5,183,814 loops=1)

  • Sort Key: co.root_event_id
  • Sort Method: external merge Disk: 271672kB
61. 356.305 1,191.089 ↓ 1.0 5,183,814 1

Append (cost=0.00..157,749.09 rows=5,160,406 width=43) (actual time=0.010..1,191.089 rows=5,183,814 loops=1)

62. 0.010 0.010 ↑ 5.0 4 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_06_10 co (cost=0.00..10.20 rows=20 width=532) (actual time=0.009..0.010 rows=4 loops=1)

63. 0.010 0.010 ↑ 20.0 1 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_02 co_1 (cost=0.00..10.20 rows=20 width=532) (actual time=0.010..0.010 rows=1 loops=1)

64. 0.008 0.008 ↑ 6.7 3 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_06 co_2 (cost=0.00..10.20 rows=20 width=532) (actual time=0.008..0.008 rows=3 loops=1)

65. 0.008 0.008 ↑ 10.0 2 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_08 co_3 (cost=0.00..10.20 rows=20 width=532) (actual time=0.007..0.008 rows=2 loops=1)

66. 0.009 0.009 ↑ 20.0 1 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_14 co_4 (cost=0.00..10.20 rows=20 width=532) (actual time=0.009..0.009 rows=1 loops=1)

67. 0.008 0.008 ↑ 5.0 4 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_15 co_5 (cost=0.00..10.20 rows=20 width=532) (actual time=0.007..0.008 rows=4 loops=1)

68. 0.008 0.008 ↑ 3.3 6 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_18 co_6 (cost=0.00..10.20 rows=20 width=532) (actual time=0.008..0.008 rows=6 loops=1)

69. 0.008 0.008 ↑ 20.0 1 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_19 co_7 (cost=0.00..10.20 rows=20 width=532) (actual time=0.008..0.008 rows=1 loops=1)

70. 0.009 0.009 ↑ 3.3 6 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_20 co_8 (cost=0.00..10.20 rows=20 width=532) (actual time=0.008..0.009 rows=6 loops=1)

71. 0.008 0.008 ↑ 2.5 8 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_21 co_9 (cost=0.00..10.20 rows=20 width=532) (actual time=0.007..0.008 rows=8 loops=1)

72. 0.007 0.007 ↑ 20.0 1 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_22 co_10 (cost=0.00..10.20 rows=20 width=532) (actual time=0.006..0.007 rows=1 loops=1)

73. 0.008 0.008 ↑ 5.0 4 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_24 co_11 (cost=0.00..10.20 rows=20 width=532) (actual time=0.007..0.008 rows=4 loops=1)

74. 0.008 0.008 ↑ 2.9 7 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_25 co_12 (cost=0.00..10.20 rows=20 width=532) (actual time=0.007..0.008 rows=7 loops=1)

75. 0.008 0.008 ↑ 20.0 1 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_26 co_13 (cost=0.00..10.20 rows=20 width=532) (actual time=0.008..0.008 rows=1 loops=1)

76. 0.010 0.010 ↑ 4.0 5 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_28 co_14 (cost=0.00..10.20 rows=20 width=532) (actual time=0.010..0.010 rows=5 loops=1)

77. 0.010 0.010 ↑ 6.7 3 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_11_29 co_15 (cost=0.00..10.20 rows=20 width=532) (actual time=0.009..0.010 rows=3 loops=1)

78. 0.014 0.014 ↓ 1.6 32 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_01 co_16 (cost=0.00..10.20 rows=20 width=532) (actual time=0.009..0.014 rows=32 loops=1)

79. 0.010 0.010 ↑ 2.5 8 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_02 co_17 (cost=0.00..10.20 rows=20 width=532) (actual time=0.009..0.010 rows=8 loops=1)

80. 0.012 0.012 ↑ 1.1 18 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_03 co_18 (cost=0.00..10.20 rows=20 width=532) (actual time=0.009..0.012 rows=18 loops=1)

81. 0.008 0.008 ↑ 5.0 4 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_04 co_19 (cost=0.00..10.20 rows=20 width=532) (actual time=0.007..0.008 rows=4 loops=1)

82. 0.008 0.008 ↑ 5.0 4 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_05 co_20 (cost=0.00..10.20 rows=20 width=532) (actual time=0.007..0.008 rows=4 loops=1)

83. 0.310 0.310 ↓ 1.0 1,324 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_06 co_21 (cost=0.00..26.69 rows=1,269 width=43) (actual time=0.016..0.310 rows=1,324 loops=1)

84. 0.416 0.416 ↓ 1.0 1,765 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_07 co_22 (cost=0.00..36.54 rows=1,754 width=43) (actual time=0.017..0.416 rows=1,765 loops=1)

85. 0.248 0.248 ↑ 1.0 1,336 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_08 co_23 (cost=0.00..27.39 rows=1,339 width=43) (actual time=0.017..0.248 rows=1,336 loops=1)

86. 0.147 0.147 ↑ 1.0 1,033 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_09 co_24 (cost=0.00..21.55 rows=1,055 width=43) (actual time=0.013..0.147 rows=1,033 loops=1)

87. 0.427 0.427 ↓ 1.0 2,568 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_10 co_25 (cost=0.00..52.36 rows=2,536 width=43) (actual time=0.010..0.427 rows=2,568 loops=1)

88. 0.461 0.461 ↓ 1.0 2,191 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_11 co_26 (cost=0.00..44.85 rows=2,185 width=43) (actual time=0.008..0.461 rows=2,191 loops=1)

89. 0.462 0.462 ↓ 1.0 2,117 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_12 co_27 (cost=0.00..42.97 rows=2,097 width=43) (actual time=0.018..0.462 rows=2,117 loops=1)

90. 0.799 0.799 ↑ 1.0 3,726 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_13 co_28 (cost=0.00..76.28 rows=3,728 width=43) (actual time=0.017..0.799 rows=3,726 loops=1)

91. 0.610 0.610 ↓ 1.0 3,329 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_14 co_29 (cost=0.00..68.15 rows=3,315 width=43) (actual time=0.016..0.610 rows=3,329 loops=1)

92. 0.282 0.282 ↓ 1.0 1,529 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_15 co_30 (cost=0.00..31.13 rows=1,513 width=43) (actual time=0.014..0.282 rows=1,529 loops=1)

93. 0.189 0.189 ↓ 1.0 1,114 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_16 co_31 (cost=0.00..23.07 rows=1,107 width=43) (actual time=0.016..0.189 rows=1,114 loops=1)

94. 0.517 0.517 ↑ 1.0 3,525 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_17 co_32 (cost=0.00..72.37 rows=3,537 width=43) (actual time=0.011..0.517 rows=3,525 loops=1)

95. 0.544 0.544 ↓ 1.0 3,723 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_18 co_33 (cost=0.00..75.74 rows=3,674 width=43) (actual time=0.006..0.544 rows=3,723 loops=1)

96. 0.829 0.829 ↓ 1.0 5,231 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_19 co_34 (cost=0.00..107.27 rows=5,227 width=43) (actual time=0.026..0.829 rows=5,231 loops=1)

97. 0.954 0.954 ↓ 1.0 5,351 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_20 co_35 (cost=0.00..109.14 rows=5,314 width=43) (actual time=0.006..0.954 rows=5,351 loops=1)

98. 0.960 0.960 ↓ 1.0 6,914 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_21 co_36 (cost=0.00..140.71 rows=6,871 width=43) (actual time=0.006..0.960 rows=6,914 loops=1)

99. 0.537 0.537 ↑ 1.0 3,592 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_22 co_37 (cost=0.00..74.41 rows=3,641 width=43) (actual time=0.016..0.537 rows=3,592 loops=1)

100. 0.374 0.374 ↓ 1.0 2,591 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_23 co_38 (cost=0.00..52.23 rows=2,523 width=43) (actual time=0.012..0.374 rows=2,591 loops=1)

101. 0.544 0.544 ↑ 1.0 3,581 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_24 co_39 (cost=0.00..73.90 rows=3,590 width=43) (actual time=0.012..0.544 rows=3,581 loops=1)

102. 0.297 0.297 ↑ 1.0 1,799 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_25 co_40 (cost=0.00..36.99 rows=1,799 width=43) (actual time=0.005..0.297 rows=1,799 loops=1)

103. 0.403 0.403 ↓ 1.0 2,875 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_26 co_41 (cost=0.00..58.41 rows=2,841 width=43) (actual time=0.013..0.403 rows=2,875 loops=1)

104. 1.019 1.019 ↓ 1.0 7,113 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_27 co_42 (cost=0.00..144.41 rows=7,041 width=43) (actual time=0.012..1.019 rows=7,113 loops=1)

105. 1.503 1.503 ↓ 1.0 10,196 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_28 co_43 (cost=0.00..207.58 rows=10,158 width=43) (actual time=0.005..1.503 rows=10,196 loops=1)

106. 1.122 1.122 ↓ 1.0 8,062 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_29 co_44 (cost=0.00..164.28 rows=8,028 width=43) (actual time=0.007..1.122 rows=8,062 loops=1)

107. 1.168 1.168 ↓ 1.0 7,918 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_30 co_45 (cost=0.00..160.36 rows=7,836 width=43) (actual time=0.015..1.168 rows=7,918 loops=1)

108. 5.333 5.333 ↑ 1.0 32,172 1

Seq Scan on contexts_com_google_analytics_cookies_1_2018_12_31 co_46 (cost=0.00..655.09 rows=32,209 width=43) (actual time=0.006..5.333 rows=32,172 loops=1)

109. 6.046 6.046 ↓ 1.0 35,552 1

Seq Scan on contexts_com_google_analytics_cookies_1_2019_01_01 co_47 (cost=0.00..725.41 rows=35,441 width=43) (actual time=0.006..6.046 rows=35,552 loops=1)

110. 406.909 406.909 ↓ 1.0 2,588,366 1

Seq Scan on contexts_com_google_analytics_cookies_1_2019_01_02 co_48 (cost=0.00..67,737.33 rows=2,545,633 width=43) (actual time=0.008..406.909 rows=2,588,366 loops=1)

111. 401.185 401.185 ↑ 1.0 2,433,098 1

Seq Scan on contexts_com_google_analytics_cookies_1_2019_01_03 co_49 (cost=0.00..60,686.25 rows=2,452,725 width=43) (actual time=0.006..401.185 rows=2,433,098 loops=1)