explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xDiQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 11,312.734 ↓ 26.8 161 1

Subquery Scan on s1 (cost=3,724.51..3,724.76 rows=6 width=40) (actual time=11,306.183..11,312.734 rows=161 loops=1)

2.          

CTE filter

3. 1.704 16.352 ↑ 1.0 23,475 1

Append (cost=0..1,506.28 rows=23,581 width=351) (actual time=0.024..16.352 rows=23,475 loops=1)

4. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on session session (cost=0..0 rows=1 width=2,143) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone) AND ((tracking_id)::text = '5c2ed7472175c126645b4182'::text))
5. 2.803 2.803 ↑ 1.0 4,225 1

Seq Scan on _hyper_4_5704_chunk _hyper_4_5704_chunk (cost=0..251.32 rows=4,225 width=174) (actual time=0.011..2.803 rows=4,225 loops=1)

  • Filter: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone) AND ((tracking_id)::text = '5c2ed7472175c126645b4182'::text))
6. 2.825 2.825 ↑ 1.0 5,252 1

Seq Scan on _hyper_4_5668_chunk _hyper_4_5668_chunk (cost=0..255.29 rows=5,252 width=676) (actual time=0.024..2.825 rows=5,252 loops=1)

  • Filter: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone) AND ((tracking_id)::text = '5c2ed7472175c126645b4182'::text))
7. 2.756 2.756 ↑ 1.0 5,049 1

Seq Scan on _hyper_4_5692_chunk _hyper_4_5692_chunk (cost=0..267.02 rows=5,049 width=173) (actual time=0.016..2.756 rows=5,049 loops=1)

  • Filter: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone) AND ((tracking_id)::text = '5c2ed7472175c126645b4182'::text))
8. 2.218 2.218 ↓ 1.0 3,041 1

Index Scan using _hyper_4_5656_chunk_session_time_idx on _hyper_4_5656_chunk _hyper_4_5656_chunk (cost=0.28..166.44 rows=3,034 width=675) (actual time=0.019..2.218 rows=3,041 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
9. 4.033 4.033 ↑ 1.0 5,908 1

Index Scan using _hyper_4_5680_chunk_session_tracking_id_index on _hyper_4_5680_chunk _hyper_4_5680_chunk (cost=0.29..566.22 rows=6,020 width=177) (actual time=0.035..4.033 rows=5,908 loops=1)

  • Index Cond: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
  • Filter: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
10.          

CTE bucket_user

11. 3.966 74.623 ↓ 13.6 2,728 1

Aggregate (cost=694.86..697.36 rows=200 width=524) (actual time=73.657..74.623 rows=2,728 loops=1)

12. 5.931 70.657 ↓ 2.2 8,726 1

Hash Join (cost=76.45..675.41 rows=3,891 width=524) (actual time=29.787..70.657 rows=8,726 loops=1)

13. 34.996 34.996 ↑ 1.0 23,475 1

CTE Scan on filter filter (cost=0..471.62 rows=23,581 width=1,040) (actual time=0.032..34.996 rows=23,475 loops=1)

14. 2.316 29.730 ↓ 264.4 8,726 1

Hash (cost=76.04..76.04 rows=33 width=43) (actual time=29.73..29.73 rows=8,726 loops=1)

15. 0.761 27.414 ↓ 264.4 8,726 1

Append (cost=0..76.04 rows=33 width=43) (actual time=0.049..27.414 rows=8,726 loops=1)

16. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on event_session event_session (cost=0..0 rows=1 width=516) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone) AND ((tracking_id)::text = '5c2ed7472175c126645b4182'::text) AND ((data ->> 'css_selector'::text) ~~ '%div%send%div%ql-editor%ql-blank%'::text) AND ((data ->> 'category'::text) = 'auto_track'::text) AND ((data ->> 'action'::text) = 'click'::text))
17. 0.829 0.829 ↓ 321.0 321 1

Index Scan using _hyper_13_5664_chunk_event_session_2 on _hyper_13_5664_chunk _hyper_13_5664_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.042..0.829 rows=321 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
18. 1.052 1.052 ↓ 386.0 386 1

Index Scan using _hyper_13_5678_chunk_event_session_2 on _hyper_13_5678_chunk _hyper_13_5678_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.025..1.052 rows=386 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
19. 0.417 0.417 ↓ 119.0 119 1

Index Scan using _hyper_13_5708_chunk_event_session_2 on _hyper_13_5708_chunk _hyper_13_5708_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.017..0.417 rows=119 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
20. 0.930 0.930 ↓ 315.0 315 1

Index Scan using _hyper_13_5690_chunk_event_session_2 on _hyper_13_5690_chunk _hyper_13_5690_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.034..0.93 rows=315 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
21. 0.848 0.848 ↓ 365.0 365 1

Index Scan using _hyper_13_5675_chunk_event_session_2 on _hyper_13_5675_chunk _hyper_13_5675_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.022..0.848 rows=365 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
22. 0.038 0.038 ↓ 4.0 4 1

Index Scan using _hyper_13_5712_chunk_event_session_2 on _hyper_13_5712_chunk _hyper_13_5712_chunk (cost=0.13..2.35 rows=1 width=28) (actual time=0.014..0.038 rows=4 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
23. 1.432 1.432 ↓ 405.0 405 1

Index Scan using _hyper_13_5695_chunk_event_session_2 on _hyper_13_5695_chunk _hyper_13_5695_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.023..1.432 rows=405 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
24. 0.910 0.910 ↓ 289.0 289 1

Index Scan using _hyper_13_5698_chunk_event_session_2 on _hyper_13_5698_chunk _hyper_13_5698_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.036..0.91 rows=289 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
25. 0.920 0.920 ↓ 191.0 191 1

Index Scan using _hyper_13_5711_chunk_event_session_2 on _hyper_13_5711_chunk _hyper_13_5711_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.031..0.92 rows=191 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
26. 0.312 0.312 ↓ 138.0 138 1

Index Scan using _hyper_13_5661_chunk_event_session_2 on _hyper_13_5661_chunk _hyper_13_5661_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.014..0.312 rows=138 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
27. 0.893 0.893 ↓ 404.0 404 1

Index Scan using _hyper_13_5676_chunk_event_session_2 on _hyper_13_5676_chunk _hyper_13_5676_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.038..0.893 rows=404 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
28. 0.912 0.912 ↓ 273.0 273 1

Index Scan using _hyper_13_5710_chunk_event_session_2 on _hyper_13_5710_chunk _hyper_13_5710_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.02..0.912 rows=273 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
29. 1.453 1.453 ↓ 346.0 346 1

Index Scan using _hyper_13_5687_chunk_event_session_2 on _hyper_13_5687_chunk _hyper_13_5687_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.023..1.453 rows=346 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
30. 0.421 0.421 ↓ 128.0 128 1

Index Scan using _hyper_13_5709_chunk_event_session_2 on _hyper_13_5709_chunk _hyper_13_5709_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.015..0.421 rows=128 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
31. 0.559 0.559 ↓ 161.0 161 1

Index Scan using _hyper_13_5696_chunk_event_session_2 on _hyper_13_5696_chunk _hyper_13_5696_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.022..0.559 rows=161 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
32. 0.357 0.357 ↓ 118.0 118 1

Index Scan using _hyper_13_5674_chunk_event_session_2 on _hyper_13_5674_chunk _hyper_13_5674_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.014..0.357 rows=118 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
33. 1.612 1.612 ↓ 422.0 422 1

Index Scan using _hyper_13_5686_chunk_event_session_2 on _hyper_13_5686_chunk _hyper_13_5686_chunk (cost=0.27..2.5 rows=1 width=28) (actual time=0.025..1.612 rows=422 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
34. 1.534 1.534 ↓ 366.0 366 1

Index Scan using _hyper_13_5699_chunk_event_session_2 on _hyper_13_5699_chunk _hyper_13_5699_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.023..1.534 rows=366 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
35. 0.974 0.974 ↓ 320.0 320 1

Index Scan using _hyper_13_5707_chunk_event_session_2 on _hyper_13_5707_chunk _hyper_13_5707_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.03..0.974 rows=320 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
36. 0.631 0.631 ↓ 248.0 248 1

Index Scan using _hyper_13_5702_chunk_event_session_2 on _hyper_13_5702_chunk _hyper_13_5702_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.018..0.631 rows=248 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
37. 0.294 0.294 ↓ 118.0 118 1

Index Scan using _hyper_13_5673_chunk_event_session_2 on _hyper_13_5673_chunk _hyper_13_5673_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.018..0.294 rows=118 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
38. 0.642 0.642 ↓ 315.0 315 1

Index Scan using _hyper_13_5666_chunk_event_session_2 on _hyper_13_5666_chunk _hyper_13_5666_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.03..0.642 rows=315 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
39. 0.478 0.478 ↓ 164.0 164 1

Index Scan using _hyper_13_5697_chunk_event_session_2 on _hyper_13_5697_chunk _hyper_13_5697_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.014..0.478 rows=164 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
40. 1.184 1.184 ↓ 348.0 348 1

Index Scan using _hyper_13_5700_chunk_event_session_2 on _hyper_13_5700_chunk _hyper_13_5700_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.028..1.184 rows=348 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
41. 1.000 1.000 ↓ 407.0 407 1

Index Scan using _hyper_13_5671_chunk_event_session_2 on _hyper_13_5671_chunk _hyper_13_5671_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.035..1 rows=407 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
42. 0.380 0.380 ↓ 151.0 151 1

Index Scan using _hyper_13_5672_chunk_event_session_2 on _hyper_13_5672_chunk _hyper_13_5672_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.015..0.38 rows=151 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
43. 1.640 1.640 ↓ 537.0 537 1

Index Scan using _hyper_13_5683_chunk_event_session_2 on _hyper_13_5683_chunk _hyper_13_5683_chunk (cost=0.28..2.5 rows=1 width=28) (actual time=0.028..1.64 rows=537 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
44. 0.901 0.901 ↓ 385.0 385 1

Index Scan using _hyper_13_5662_chunk_event_session_2 on _hyper_13_5662_chunk _hyper_13_5662_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.035..0.901 rows=385 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
45. 0.896 0.896 ↓ 294.0 294 1

Index Scan using _hyper_13_5663_chunk_event_session_2 on _hyper_13_5663_chunk _hyper_13_5663_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.037..0.896 rows=294 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
46. 0.375 0.375 ↓ 172.0 172 1

Index Scan using _hyper_13_5684_chunk_event_session_2 on _hyper_13_5684_chunk _hyper_13_5684_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.022..0.375 rows=172 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
47. 1.367 1.367 ↓ 366.0 366 1

Index Scan using _hyper_13_5688_chunk_event_session_2 on _hyper_13_5688_chunk _hyper_13_5688_chunk (cost=0.15..2.37 rows=1 width=28) (actual time=0.05..1.367 rows=366 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
48. 0.455 0.455 ↓ 150.0 150 1

Index Scan using _hyper_13_5685_chunk_event_session_2 on _hyper_13_5685_chunk _hyper_13_5685_chunk (cost=0.14..2.37 rows=1 width=28) (actual time=0.041..0.455 rows=150 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
49.          

CTE new_users

50. 4.281 6.553 ↑ 6.5 31 1

Aggregate (cost=11.64..15.14 rows=200 width=16) (actual time=2.399..6.553 rows=31 loops=1)

51. 1.714 2.272 ↓ 13.6 2,728 1

Sort (cost=11.64..12.14 rows=200 width=524) (actual time=2.071..2.272 rows=2,728 loops=1)

  • Sort Key: bucket_user_1.first_hit
  • Sort Method: quicksort Memory: 310kB
52. 0.558 0.558 ↓ 13.6 2,728 1

CTE Scan on bucket_user bucket_user_1 (cost=0..4 rows=200 width=524) (actual time=0.001..0.558 rows=2,728 loops=1)

53.          

CTE visitor_log1

54. 6.074 20.938 ↓ 2.2 8,726 1

Hash Join (cost=76.45..675.41 rows=3,891 width=524) (actual time=11.926..20.938 rows=8,726 loops=1)

55. 2.953 2.953 ↑ 1.0 23,475 1

CTE Scan on filter filter_1 (cost=0..471.62 rows=23,581 width=1,040) (actual time=0.002..2.953 rows=23,475 loops=1)

56. 2.312 11.911 ↓ 264.4 8,726 1

Hash (cost=76.04..76.04 rows=33 width=43) (actual time=11.911..11.911 rows=8,726 loops=1)

57. 0.602 9.599 ↓ 264.4 8,726 1

Append (cost=0..76.04 rows=33 width=43) (actual time=0.012..9.599 rows=8,726 loops=1)

58. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on event_session event_session_1 (cost=0..0 rows=1 width=516) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone) AND ((tracking_id)::text = '5c2ed7472175c126645b4182'::text) AND ((data ->> 'css_selector'::text) ~~ '%div%send%div%ql-editor%ql-blank%'::text) AND ((data ->> 'category'::text) = 'auto_track'::text) AND ((data ->> 'action'::text) = 'click'::text))
59. 0.253 0.253 ↓ 321.0 321 1

Index Scan using _hyper_13_5664_chunk_event_session_2 on _hyper_13_5664_chunk _hyper_13_5664_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.01..0.253 rows=321 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
60. 0.323 0.323 ↓ 386.0 386 1

Index Scan using _hyper_13_5678_chunk_event_session_2 on _hyper_13_5678_chunk _hyper_13_5678_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.018..0.323 rows=386 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
61. 0.120 0.120 ↓ 119.0 119 1

Index Scan using _hyper_13_5708_chunk_event_session_2 on _hyper_13_5708_chunk _hyper_13_5708_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.012..0.12 rows=119 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
62. 0.284 0.284 ↓ 315.0 315 1

Index Scan using _hyper_13_5690_chunk_event_session_2 on _hyper_13_5690_chunk _hyper_13_5690_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.016..0.284 rows=315 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
63. 0.294 0.294 ↓ 365.0 365 1

Index Scan using _hyper_13_5675_chunk_event_session_2 on _hyper_13_5675_chunk _hyper_13_5675_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.018..0.294 rows=365 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
64. 0.008 0.008 ↓ 4.0 4 1

Index Scan using _hyper_13_5712_chunk_event_session_2 on _hyper_13_5712_chunk _hyper_13_5712_chunk_1 (cost=0.13..2.35 rows=1 width=28) (actual time=0.005..0.008 rows=4 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
65. 0.357 0.357 ↓ 405.0 405 1

Index Scan using _hyper_13_5695_chunk_event_session_2 on _hyper_13_5695_chunk _hyper_13_5695_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.018..0.357 rows=405 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
66. 0.278 0.278 ↓ 289.0 289 1

Index Scan using _hyper_13_5698_chunk_event_session_2 on _hyper_13_5698_chunk _hyper_13_5698_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.021..0.278 rows=289 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
67. 0.237 0.237 ↓ 191.0 191 1

Index Scan using _hyper_13_5711_chunk_event_session_2 on _hyper_13_5711_chunk _hyper_13_5711_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.04..0.237 rows=191 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
68. 0.116 0.116 ↓ 138.0 138 1

Index Scan using _hyper_13_5661_chunk_event_session_2 on _hyper_13_5661_chunk _hyper_13_5661_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.013..0.116 rows=138 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
69. 0.354 0.354 ↓ 404.0 404 1

Index Scan using _hyper_13_5676_chunk_event_session_2 on _hyper_13_5676_chunk _hyper_13_5676_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.022..0.354 rows=404 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
70. 0.305 0.305 ↓ 273.0 273 1

Index Scan using _hyper_13_5710_chunk_event_session_2 on _hyper_13_5710_chunk _hyper_13_5710_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.031..0.305 rows=273 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
71. 0.357 0.357 ↓ 346.0 346 1

Index Scan using _hyper_13_5687_chunk_event_session_2 on _hyper_13_5687_chunk _hyper_13_5687_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.021..0.357 rows=346 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
72. 0.133 0.133 ↓ 128.0 128 1

Index Scan using _hyper_13_5709_chunk_event_session_2 on _hyper_13_5709_chunk _hyper_13_5709_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.014..0.133 rows=128 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
73. 0.161 0.161 ↓ 161.0 161 1

Index Scan using _hyper_13_5696_chunk_event_session_2 on _hyper_13_5696_chunk _hyper_13_5696_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.016..0.161 rows=161 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
74. 0.107 0.107 ↓ 118.0 118 1

Index Scan using _hyper_13_5674_chunk_event_session_2 on _hyper_13_5674_chunk _hyper_13_5674_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.011..0.107 rows=118 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
75. 0.503 0.503 ↓ 422.0 422 1

Index Scan using _hyper_13_5686_chunk_event_session_2 on _hyper_13_5686_chunk _hyper_13_5686_chunk_1 (cost=0.27..2.5 rows=1 width=28) (actual time=0.112..0.503 rows=422 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
76. 0.414 0.414 ↓ 366.0 366 1

Index Scan using _hyper_13_5699_chunk_event_session_2 on _hyper_13_5699_chunk _hyper_13_5699_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.021..0.414 rows=366 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
77. 0.362 0.362 ↓ 320.0 320 1

Index Scan using _hyper_13_5707_chunk_event_session_2 on _hyper_13_5707_chunk _hyper_13_5707_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.023..0.362 rows=320 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
78. 0.346 0.346 ↓ 248.0 248 1

Index Scan using _hyper_13_5702_chunk_event_session_2 on _hyper_13_5702_chunk _hyper_13_5702_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.018..0.346 rows=248 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
79. 0.116 0.116 ↓ 118.0 118 1

Index Scan using _hyper_13_5673_chunk_event_session_2 on _hyper_13_5673_chunk _hyper_13_5673_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.013..0.116 rows=118 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
80. 0.303 0.303 ↓ 315.0 315 1

Index Scan using _hyper_13_5666_chunk_event_session_2 on _hyper_13_5666_chunk _hyper_13_5666_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.041..0.303 rows=315 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
81. 0.208 0.208 ↓ 164.0 164 1

Index Scan using _hyper_13_5697_chunk_event_session_2 on _hyper_13_5697_chunk _hyper_13_5697_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.014..0.208 rows=164 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
82. 0.330 0.330 ↓ 348.0 348 1

Index Scan using _hyper_13_5700_chunk_event_session_2 on _hyper_13_5700_chunk _hyper_13_5700_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.026..0.33 rows=348 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
83. 0.379 0.379 ↓ 407.0 407 1

Index Scan using _hyper_13_5671_chunk_event_session_2 on _hyper_13_5671_chunk _hyper_13_5671_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.039..0.379 rows=407 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
84. 0.129 0.129 ↓ 151.0 151 1

Index Scan using _hyper_13_5672_chunk_event_session_2 on _hyper_13_5672_chunk _hyper_13_5672_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.014..0.129 rows=151 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
85. 0.447 0.447 ↓ 537.0 537 1

Index Scan using _hyper_13_5683_chunk_event_session_2 on _hyper_13_5683_chunk _hyper_13_5683_chunk_1 (cost=0.28..2.5 rows=1 width=28) (actual time=0.021..0.447 rows=537 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
86. 0.358 0.358 ↓ 385.0 385 1

Index Scan using _hyper_13_5662_chunk_event_session_2 on _hyper_13_5662_chunk _hyper_13_5662_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.02..0.358 rows=385 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
87. 0.284 0.284 ↓ 294.0 294 1

Index Scan using _hyper_13_5663_chunk_event_session_2 on _hyper_13_5663_chunk _hyper_13_5663_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.024..0.284 rows=294 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
88. 0.159 0.159 ↓ 172.0 172 1

Index Scan using _hyper_13_5684_chunk_event_session_2 on _hyper_13_5684_chunk _hyper_13_5684_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.015..0.159 rows=172 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
89. 0.696 0.696 ↓ 366.0 366 1

Index Scan using _hyper_13_5688_chunk_event_session_2 on _hyper_13_5688_chunk _hyper_13_5688_chunk_1 (cost=0.15..2.37 rows=1 width=28) (actual time=0.173..0.696 rows=366 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
90. 0.275 0.275 ↓ 150.0 150 1

Index Scan using _hyper_13_5685_chunk_event_session_2 on _hyper_13_5685_chunk _hyper_13_5685_chunk_1 (cost=0.14..2.37 rows=1 width=28) (actual time=0.062..0.275 rows=150 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
91.          

CTE visit_tracker

92. 7,604.072 11,190.231 ↓ 3,109.3 18,656 1

Nested Loop (cost=648.49..820.35 rows=6 width=532) (actual time=75.326..11,190.231 rows=18,656 loops=1)

93. 1.159 17.225 ↓ 264.4 8,726 1

Append (cost=0..76.04 rows=33 width=43) (actual time=0.023..17.225 rows=8,726 loops=1)

94. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on event_session event_session_2 (cost=0..0 rows=1 width=516) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone) AND ((tracking_id)::text = '5c2ed7472175c126645b4182'::text) AND ((data ->> 'css_selector'::text) ~~ '%div%send%div%ql-editor%ql-blank%'::text) AND ((data ->> 'category'::text) = 'auto_track'::text) AND ((data ->> 'action'::text) = 'click'::text))
95. 0.489 0.489 ↓ 321.0 321 1

Index Scan using _hyper_13_5664_chunk_event_session_2 on _hyper_13_5664_chunk _hyper_13_5664_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.019..0.489 rows=321 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
96. 0.611 0.611 ↓ 386.0 386 1

Index Scan using _hyper_13_5678_chunk_event_session_2 on _hyper_13_5678_chunk _hyper_13_5678_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.031..0.611 rows=386 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
97. 0.233 0.233 ↓ 119.0 119 1

Index Scan using _hyper_13_5708_chunk_event_session_2 on _hyper_13_5708_chunk _hyper_13_5708_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.02..0.233 rows=119 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
98. 0.594 0.594 ↓ 315.0 315 1

Index Scan using _hyper_13_5690_chunk_event_session_2 on _hyper_13_5690_chunk _hyper_13_5690_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.027..0.594 rows=315 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
99. 0.753 0.753 ↓ 365.0 365 1

Index Scan using _hyper_13_5675_chunk_event_session_2 on _hyper_13_5675_chunk _hyper_13_5675_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.031..0.753 rows=365 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
100. 0.032 0.032 ↓ 4.0 4 1

Index Scan using _hyper_13_5712_chunk_event_session_2 on _hyper_13_5712_chunk _hyper_13_5712_chunk_2 (cost=0.13..2.35 rows=1 width=28) (actual time=0.026..0.032 rows=4 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
101. 0.733 0.733 ↓ 405.0 405 1

Index Scan using _hyper_13_5695_chunk_event_session_2 on _hyper_13_5695_chunk _hyper_13_5695_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.029..0.733 rows=405 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
102. 0.544 0.544 ↓ 289.0 289 1

Index Scan using _hyper_13_5698_chunk_event_session_2 on _hyper_13_5698_chunk _hyper_13_5698_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.026..0.544 rows=289 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
103. 0.370 0.370 ↓ 191.0 191 1

Index Scan using _hyper_13_5711_chunk_event_session_2 on _hyper_13_5711_chunk _hyper_13_5711_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.025..0.37 rows=191 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
104. 0.210 0.210 ↓ 138.0 138 1

Index Scan using _hyper_13_5661_chunk_event_session_2 on _hyper_13_5661_chunk _hyper_13_5661_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.018..0.21 rows=138 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
105. 0.640 0.640 ↓ 404.0 404 1

Index Scan using _hyper_13_5676_chunk_event_session_2 on _hyper_13_5676_chunk _hyper_13_5676_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.046..0.64 rows=404 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
106. 0.620 0.620 ↓ 273.0 273 1

Index Scan using _hyper_13_5710_chunk_event_session_2 on _hyper_13_5710_chunk _hyper_13_5710_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.09..0.62 rows=273 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
107. 0.744 0.744 ↓ 346.0 346 1

Index Scan using _hyper_13_5687_chunk_event_session_2 on _hyper_13_5687_chunk _hyper_13_5687_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.036..0.744 rows=346 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
108. 0.249 0.249 ↓ 128.0 128 1

Index Scan using _hyper_13_5709_chunk_event_session_2 on _hyper_13_5709_chunk _hyper_13_5709_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.019..0.249 rows=128 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
109. 0.357 0.357 ↓ 161.0 161 1

Index Scan using _hyper_13_5696_chunk_event_session_2 on _hyper_13_5696_chunk _hyper_13_5696_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.033..0.357 rows=161 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
110. 0.232 0.232 ↓ 118.0 118 1

Index Scan using _hyper_13_5674_chunk_event_session_2 on _hyper_13_5674_chunk _hyper_13_5674_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.027..0.232 rows=118 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
111. 0.833 0.833 ↓ 422.0 422 1

Index Scan using _hyper_13_5686_chunk_event_session_2 on _hyper_13_5686_chunk _hyper_13_5686_chunk_2 (cost=0.27..2.5 rows=1 width=28) (actual time=0.049..0.833 rows=422 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
112. 0.671 0.671 ↓ 366.0 366 1

Index Scan using _hyper_13_5699_chunk_event_session_2 on _hyper_13_5699_chunk _hyper_13_5699_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.032..0.671 rows=366 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
113. 0.567 0.567 ↓ 320.0 320 1

Index Scan using _hyper_13_5707_chunk_event_session_2 on _hyper_13_5707_chunk _hyper_13_5707_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.029..0.567 rows=320 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
114. 0.489 0.489 ↓ 248.0 248 1

Index Scan using _hyper_13_5702_chunk_event_session_2 on _hyper_13_5702_chunk _hyper_13_5702_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.026..0.489 rows=248 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
115. 0.249 0.249 ↓ 118.0 118 1

Index Scan using _hyper_13_5673_chunk_event_session_2 on _hyper_13_5673_chunk _hyper_13_5673_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.053..0.249 rows=118 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
116. 0.531 0.531 ↓ 315.0 315 1

Index Scan using _hyper_13_5666_chunk_event_session_2 on _hyper_13_5666_chunk _hyper_13_5666_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.041..0.531 rows=315 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
117. 0.299 0.299 ↓ 164.0 164 1

Index Scan using _hyper_13_5697_chunk_event_session_2 on _hyper_13_5697_chunk _hyper_13_5697_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.023..0.299 rows=164 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
118. 0.651 0.651 ↓ 348.0 348 1

Index Scan using _hyper_13_5700_chunk_event_session_2 on _hyper_13_5700_chunk _hyper_13_5700_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.052..0.651 rows=348 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
119. 0.688 0.688 ↓ 407.0 407 1

Index Scan using _hyper_13_5671_chunk_event_session_2 on _hyper_13_5671_chunk _hyper_13_5671_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.042..0.688 rows=407 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
120. 0.254 0.254 ↓ 151.0 151 1

Index Scan using _hyper_13_5672_chunk_event_session_2 on _hyper_13_5672_chunk _hyper_13_5672_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.026..0.254 rows=151 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
121. 0.958 0.958 ↓ 537.0 537 1

Index Scan using _hyper_13_5683_chunk_event_session_2 on _hyper_13_5683_chunk _hyper_13_5683_chunk_2 (cost=0.28..2.5 rows=1 width=28) (actual time=0.037..0.958 rows=537 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
122. 0.711 0.711 ↓ 385.0 385 1

Index Scan using _hyper_13_5662_chunk_event_session_2 on _hyper_13_5662_chunk _hyper_13_5662_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.048..0.711 rows=385 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
123. 0.429 0.429 ↓ 294.0 294 1

Index Scan using _hyper_13_5663_chunk_event_session_2 on _hyper_13_5663_chunk _hyper_13_5663_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.032..0.429 rows=294 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
124. 0.291 0.291 ↓ 172.0 172 1

Index Scan using _hyper_13_5684_chunk_event_session_2 on _hyper_13_5684_chunk _hyper_13_5684_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.025..0.291 rows=172 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
125. 0.702 0.702 ↓ 366.0 366 1

Index Scan using _hyper_13_5688_chunk_event_session_2 on _hyper_13_5688_chunk _hyper_13_5688_chunk_2 (cost=0.15..2.37 rows=1 width=28) (actual time=0.038..0.702 rows=366 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
126. 0.329 0.329 ↓ 150.0 150 1

Index Scan using _hyper_13_5685_chunk_event_session_2 on _hyper_13_5685_chunk _hyper_13_5685_chunk_2 (cost=0.14..2.37 rows=1 width=28) (actual time=0.087..0.329 rows=150 loops=1)

  • Index Cond: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone))
  • Filter: ((tracking_id)::text = '5c2ed7472175c126645b4182'::text)
127. 3,516.946 3,568.934 ↓ 1,361.7 8,170 8,726

Materialize (cost=648.49..741.31 rows=6 width=1,048) (actual time=0.004..0.409 rows=8,170 loops=8,726)

128. 9.413 51.988 ↓ 1,361.7 8,170 1

Hash Join (cost=648.49..741.28 rows=6 width=1,048) (actual time=30.828..51.988 rows=8,170 loops=1)

129. 23.759 23.759 ↓ 2.2 8,726 1

CTE Scan on visitor_log1 visitor_log1 (cost=0..77.82 rows=3,891 width=524) (actual time=11.928..23.759 rows=8,726 loops=1)

130. 10.299 18.816 ↓ 23,475.0 23,475 1

Hash (cost=648.48..648.48 rows=1 width=1,040) (actual time=18.816..18.816 rows=23,475 loops=1)

131. 8.517 8.517 ↓ 23,475.0 23,475 1

CTE Scan on filter filter_2 (cost=0..648.48 rows=1 width=1,040) (actual time=0.002..8.517 rows=23,475 loops=1)

  • Filter: (("time" >= '2019-08-04 00:00:00'::timestamp without time zone) AND ("time" <= '2019-09-04 23:59:59'::timestamp without time zone) AND ((tracking_id)::text = '5c2ed7472175c126645b4182'::text))
132. 5.581 11,312.700 ↓ 26.8 161 1

Aggregate (cost=9.97..10.16 rows=6 width=48) (actual time=11,306.181..11,312.7 rows=161 loops=1)

133. 9.502 11,307.119 ↓ 3,109.3 18,656 1

Sort (cost=9.97..9.98 rows=6 width=540) (actual time=11,306.171..11,307.119 rows=18,656 loops=1)

  • Sort Key: new_users.first_hit, new_users.new_users, visit_tracker.retention_index
  • Sort Method: quicksort Memory: 3392kB
134. 4.148 11,297.617 ↓ 3,109.3 18,656 1

Hash Join (cost=5.08..9.89 rows=6 width=540) (actual time=11,289.316..11,297.617 rows=18,656 loops=1)

135. 6.569 6.569 ↑ 6.5 31 1

CTE Scan on new_users new_users (cost=0..4 rows=200 width=16) (actual time=2.402..6.569 rows=31 loops=1)

136. 3.822 11,286.900 ↓ 3,109.3 18,656 1

Hash (cost=5..5 rows=6 width=532) (actual time=11,286.9..11,286.9 rows=18,656 loops=1)

137. 2.971 11,283.078 ↓ 3,109.3 18,656 1

Hash Join (cost=0.2..5 rows=6 width=532) (actual time=11,278.424..11,283.078 rows=18,656 loops=1)

138. 75.361 75.361 ↓ 13.6 2,728 1

CTE Scan on bucket_user bucket_user (cost=0..4 rows=200 width=524) (actual time=73.659..75.361 rows=2,728 loops=1)

139. 5.534 11,204.746 ↓ 3,109.3 18,656 1

Hash (cost=0.12..0.12 rows=6 width=524) (actual time=11,204.746..11,204.746 rows=18,656 loops=1)

140. 11,199.212 11,199.212 ↓ 3,109.3 18,656 1

CTE Scan on visit_tracker visit_tracker (cost=0..0.12 rows=6 width=524) (actual time=75.329..11,199.212 rows=18,656 loops=1)

  • Filter: (retention_index IS NOT NULL)