explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KMww : 2h

Settings
# exclusive inclusive rows x rows loops node
1. 483.487 7,196,991.758 ↑ 1.0 1 1

Aggregate (cost=61,535,348.52..61,535,348.53 rows=1 width=56) (actual time=7,196,991.758..7,196,991.758 rows=1 loops=1)

  • Buffers: shared hit=746987619 read=290235 dirtied=2
2. 750.821 7,196,508.271 ↑ 1.2 376,141 1

Nested Loop Left Join (cost=24,433.02..61,527,126.04 rows=469,856 width=28) (actual time=438.637..7,196,508.271 rows=376,141 loops=1)

  • Buffers: shared hit=746987619 read=290235 dirtied=2
3. 638.142 7,038,906.653 ↑ 1.2 376,141 1

Nested Loop Left Join (cost=24,412.11..51,691,865.32 rows=469,856 width=48) (actual time=438.548..7,038,906.653 rows=376,141 loops=1)

  • Buffers: shared hit=741631588 read=177464 dirtied=2
4. 596.890 378,315.965 ↑ 1.2 376,141 1

Nested Loop Left Join (cost=24,408.48..41,997,730.38 rows=469,856 width=44) (actual time=379.723..378,315.965 rows=376,141 loops=1)

  • Buffers: shared hit=173412467 read=177464 dirtied=2
5. 662.653 352,517.628 ↑ 1.2 376,141 1

Nested Loop Left Join (cost=24,386.43..31,625,659.18 rows=469,856 width=40) (actual time=379.633..352,517.628 rows=376,141 loops=1)

  • Buffers: shared hit=137142293 read=177464 dirtied=2
6. 395.766 319,882.990 ↑ 1.2 376,141 1

Nested Loop Left Join (cost=24,364.31..21,221,872.70 rows=469,856 width=36) (actual time=379.539..319,882.990 rows=376,141 loops=1)

  • Buffers: shared hit=96130023 read=177464 dirtied=2
7. 496.350 276,607.150 ↑ 1.2 376,141 1

Nested Loop Left Join (cost=24,341.90..10,680,653.34 rows=469,856 width=32) (actual time=379.425..276,607.150 rows=376,141 loops=1)

  • Buffers: shared hit=50099209 read=177464 dirtied=2
8. 2,076.745 2,280.152 ↑ 1.2 376,141 1

HashAggregate (cost=24,319.26..29,017.82 rows=469,856 width=28) (actual time=379.210..2,280.152 rows=376,141 loops=1)

  • Group Key: o.person_id
  • Buffers: shared hit=9444
9. 49.576 203.407 ↓ 1.4 639,098 1

Append (cost=0.00..21,969.98 rows=469,856 width=24) (actual time=0.045..203.407 rows=639,098 loops=1)

  • Buffers: shared hit=9444
10. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o (cost=0.00..0.00 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND ((location_fragment)::text = '/welcome'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
11. 9.371 9.371 ↓ 2.1 39,004 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_1 (cost=0.55..888.30 rows=18,518 width=24) (actual time=0.041..9.371 rows=39,004 loops=1)

  • Index Cond: ((location_fragment = '/welcome'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared hit=332
12. 39.397 39.397 ↓ 1.4 165,764 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_2 (cost=0.69..5,617.83 rows=120,718 width=24) (actual time=0.041..39.397 rows=165,764 loops=1)

  • Index Cond: ((location_fragment = '/welcome'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 2
  • Buffers: shared hit=1990
13. 53.296 53.296 ↓ 1.3 221,143 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_3 (cost=0.81..7,936.46 rows=171,338 width=24) (actual time=0.046..53.296 rows=221,143 loops=1)

  • Index Cond: ((location_fragment = '/welcome'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 3
  • Buffers: shared hit=3283
14. 47.407 47.407 ↓ 1.3 196,229 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 o_4 (cost=0.81..6,759.19 rows=146,711 width=24) (actual time=0.063..47.407 rows=196,229 loops=1)

  • Index Cond: ((location_fragment = '/welcome'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared hit=3194
15. 4.357 4.357 ↓ 1.3 16,958 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_5_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_5 o_5 (cost=0.68..768.20 rows=12,570 width=24) (actual time=0.036..4.357 rows=16,958 loops=1)

  • Index Cond: ((location_fragment = '/welcome'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 366
  • Buffers: shared hit=645
16. 1,128.423 273,830.648 ↑ 1.0 1 376,141

Limit (cost=22.64..22.64 rows=1 width=28) (actual time=0.726..0.728 rows=1 loops=376,141)

  • Buffers: shared hit=50089765 read=177464 dirtied=2
17. 752.282 272,702.225 ↑ 6.0 1 376,141

Sort (cost=22.64..22.65 rows=6 width=28) (actual time=0.725..0.725 rows=1 loops=376,141)

  • Sort Key: o_6.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=50089765 read=177464 dirtied=2
18. 752.282 271,949.943 ↑ 3.0 2 376,141

Result (cost=0.00..22.61 rows=6 width=28) (actual time=0.252..0.723 rows=2 loops=376,141)

  • Buffers: shared hit=50089765 read=177464 dirtied=2
19. 1,880.705 271,197.661 ↑ 3.0 2 376,141

Append (cost=0.00..22.55 rows=6 width=24) (actual time=0.251..0.721 rows=2 loops=376,141)

  • Buffers: shared hit=50089765 read=177464 dirtied=2
20. 0.000 0.000 ↓ 0.0 0 376,141

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_6 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=376,141)

  • Filter: ((timestamp_ >= (min(o.timestamp_))) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o.person_id) AND ((location_fragment)::text = '/home/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
21. 23,320.742 23,320.742 ↓ 0.0 0 376,141

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_7 (cost=0.55..3.49 rows=1 width=24) (actual time=0.026..0.062 rows=0 loops=376,141)

  • Index Cond: ((location_fragment = '/home/section'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= (min(o.timestamp_))) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o.person_id))
  • Heap Fetches: 0
  • Buffers: shared hit=2950268
22. 62,815.547 62,815.547 ↓ 0.0 0 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_8 (cost=0.56..4.65 rows=1 width=24) (actual time=0.082..0.167 rows=0 loops=376,141)

  • Index Cond: ((person_id = o.person_id) AND (timestamp_ >= (min(o.timestamp_))) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/home/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 21
  • Buffers: shared hit=9082484 read=44970
23. 130,897.068 130,897.068 ↑ 1.0 1 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_9 (cost=0.56..4.93 rows=1 width=24) (actual time=0.152..0.348 rows=1 loops=376,141)

  • Index Cond: ((person_id = o.person_id) AND (timestamp_ >= (min(o.timestamp_))) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/home/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 43
  • Buffers: shared hit=17654019 read=100442
24. 39,118.664 39,118.664 ↑ 1.0 1 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 o_10 (cost=0.56..5.04 rows=1 width=24) (actual time=0.044..0.104 rows=1 loops=376,141)

  • Index Cond: ((person_id = o.person_id) AND (timestamp_ >= (min(o.timestamp_))) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/home/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 45
  • Buffers: shared hit=17637250 read=24204
25. 13,164.935 13,164.935 ↓ 0.0 0 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_5_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_5 o_11 (cost=0.55..4.45 rows=1 width=24) (actual time=0.024..0.035 rows=0 loops=376,141)

  • Index Cond: ((person_id = o.person_id) AND (timestamp_ >= (min(o.timestamp_))) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/home/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=2765744 read=7848 dirtied=2
26. 1,128.423 42,880.074 ↑ 1.0 1 376,141

Limit (cost=22.41..22.41 rows=1 width=28) (actual time=0.112..0.114 rows=1 loops=376,141)

  • Buffers: shared hit=46030814
27. 1,128.423 41,751.651 ↑ 6.0 1 376,141

Sort (cost=22.41..22.43 rows=6 width=28) (actual time=0.111..0.111 rows=1 loops=376,141)

  • Sort Key: o_12.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=46030814
28. 376.141 40,623.228 ↑ 3.0 2 376,141

Result (cost=0.00..22.38 rows=6 width=28) (actual time=0.037..0.108 rows=2 loops=376,141)

  • Buffers: shared hit=46030814
29. 1,504.564 40,247.087 ↑ 3.0 2 376,141

Append (cost=0.00..22.32 rows=6 width=24) (actual time=0.036..0.107 rows=2 loops=376,141)

  • Buffers: shared hit=46030814
30. 0.000 0.000 ↓ 0.0 0 376,141

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_12 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=376,141)

  • Filter: ((timestamp_ >= o_6.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_6.person_id) AND ((location_fragment)::text = '/quick-entry/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
31. 15,797.922 15,797.922 ↓ 0.0 0 376,141

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_13 (cost=0.55..3.26 rows=1 width=24) (actual time=0.019..0.042 rows=0 loops=376,141)

  • Index Cond: ((location_fragment = '/quick-entry/section'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= o_6.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_6.person_id))
  • Heap Fetches: 0
  • Buffers: shared hit=2363407
32. 4,889.833 4,889.833 ↓ 0.0 0 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_14 (cost=0.56..4.65 rows=1 width=24) (actual time=0.005..0.013 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ >= o_6.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/quick-entry/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 19
  • Buffers: shared hit=8333136
33. 8,651.243 8,651.243 ↑ 1.0 1 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_15 (cost=0.56..4.93 rows=1 width=24) (actual time=0.007..0.023 rows=1 loops=376,141)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ >= o_6.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/quick-entry/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 40
  • Buffers: shared hit=16490168
34. 8,275.102 8,275.102 ↑ 1.0 1 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 o_16 (cost=0.56..5.04 rows=1 width=24) (actual time=0.007..0.022 rows=1 loops=376,141)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ >= o_6.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/quick-entry/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 40
  • Buffers: shared hit=16294424
35. 1,128.423 1,128.423 ↓ 0.0 0 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_5_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_5 o_17 (cost=0.55..4.45 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ >= o_6.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/quick-entry/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=2549679
36. 752.282 31,971.985 ↑ 1.0 1 376,141

Limit (cost=22.12..22.12 rows=1 width=28) (actual time=0.083..0.085 rows=1 loops=376,141)

  • Buffers: shared hit=41012270
37. 752.282 31,219.703 ↑ 6.0 1 376,141

Sort (cost=22.12..22.14 rows=6 width=28) (actual time=0.082..0.083 rows=1 loops=376,141)

  • Sort Key: o_18.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=41012270
38. 376.141 30,467.421 ↑ 2.0 3 376,141

Result (cost=0.00..22.09 rows=6 width=28) (actual time=0.031..0.081 rows=3 loops=376,141)

  • Buffers: shared hit=41012270
39. 1,880.705 30,091.280 ↑ 2.0 3 376,141

Append (cost=0.00..22.03 rows=6 width=24) (actual time=0.030..0.080 rows=3 loops=376,141)

  • Buffers: shared hit=41012270
40. 0.000 0.000 ↓ 0.0 0 376,141

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_18 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=376,141)

  • Filter: ((timestamp_ >= o_12.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_12.person_id) AND ((location_fragment)::text = '/prepare/your-year/introduction'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
41. 10,155.807 10,155.807 ↓ 0.0 0 376,141

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_19 (cost=0.55..2.97 rows=1 width=24) (actual time=0.015..0.027 rows=0 loops=376,141)

  • Index Cond: ((location_fragment = '/prepare/your-year/introduction'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= o_12.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_12.person_id))
  • Heap Fetches: 0
  • Buffers: shared hit=1914014
42. 3,385.269 3,385.269 ↓ 0.0 0 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_20 (cost=0.56..4.65 rows=1 width=24) (actual time=0.004..0.009 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_12.person_id) AND (timestamp_ >= o_12.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/prepare/your-year/introduction'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 16
  • Buffers: shared hit=7270951
43. 6,770.538 6,770.538 ↑ 1.0 1 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_21 (cost=0.56..4.93 rows=1 width=24) (actual time=0.006..0.018 rows=1 loops=376,141)

  • Index Cond: ((person_id = o_12.person_id) AND (timestamp_ >= o_12.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/prepare/your-year/introduction'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 35
  • Buffers: shared hit=14779732
44. 6,770.538 6,770.538 ↑ 1.0 1 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 o_22 (cost=0.56..5.04 rows=1 width=24) (actual time=0.006..0.018 rows=1 loops=376,141)

  • Index Cond: ((person_id = o_12.person_id) AND (timestamp_ >= o_12.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/prepare/your-year/introduction'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 36
  • Buffers: shared hit=14716491
45. 1,128.423 1,128.423 ↓ 0.0 0 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_5_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_5 o_23 (cost=0.55..4.45 rows=1 width=24) (actual time=0.002..0.003 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_12.person_id) AND (timestamp_ >= o_12.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/prepare/your-year/introduction'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=2331082
46. 1,128.423 25,201.447 ↑ 1.0 1 376,141

Limit (cost=22.05..22.05 rows=1 width=28) (actual time=0.065..0.067 rows=1 loops=376,141)

  • Buffers: shared hit=36270174
47. 376.141 24,073.024 ↑ 6.0 1 376,141

Sort (cost=22.05..22.07 rows=6 width=28) (actual time=0.064..0.064 rows=1 loops=376,141)

  • Sort Key: o_24.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=36270174
48. 376.141 23,696.883 ↑ 3.0 2 376,141

Result (cost=0.00..22.02 rows=6 width=28) (actual time=0.032..0.063 rows=2 loops=376,141)

  • Buffers: shared hit=36270174
49. 1,128.423 23,320.742 ↑ 3.0 2 376,141

Append (cost=0.00..21.96 rows=6 width=24) (actual time=0.032..0.062 rows=2 loops=376,141)

  • Buffers: shared hit=36270174
50. 0.000 0.000 ↓ 0.0 0 376,141

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_24 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=376,141)

  • Filter: ((timestamp_ >= o_18.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_18.person_id) AND ((location_fragment)::text = '/wrap-up/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
51. 6,018.256 6,018.256 ↓ 0.0 0 376,141

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_25 (cost=0.55..2.90 rows=1 width=24) (actual time=0.011..0.016 rows=0 loops=376,141)

  • Index Cond: ((location_fragment = '/wrap-up/section'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= o_18.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_18.person_id))
  • Heap Fetches: 0
  • Buffers: shared hit=1733011
52. 3,009.128 3,009.128 ↓ 0.0 0 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_26 (cost=0.56..4.65 rows=1 width=24) (actual time=0.004..0.008 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_18.person_id) AND (timestamp_ >= o_18.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/wrap-up/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 14
  • Buffers: shared hit=6333150
53. 6,018.256 6,018.256 ↑ 1.0 1 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_27 (cost=0.56..4.93 rows=1 width=24) (actual time=0.008..0.016 rows=1 loops=376,141)

  • Index Cond: ((person_id = o_18.person_id) AND (timestamp_ >= o_18.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/wrap-up/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 31
  • Buffers: shared hit=12988322
54. 6,018.256 6,018.256 ↑ 1.0 1 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 o_28 (cost=0.56..5.04 rows=1 width=24) (actual time=0.008..0.016 rows=1 loops=376,141)

  • Index Cond: ((person_id = o_18.person_id) AND (timestamp_ >= o_18.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/wrap-up/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 32
  • Buffers: shared hit=13050695
55. 1,128.423 1,128.423 ↓ 0.0 0 376,141

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_5_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_5 o_29 (cost=0.55..4.45 rows=1 width=24) (actual time=0.002..0.003 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_18.person_id) AND (timestamp_ >= o_18.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/wrap-up/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=2164996
56. 752.282 6,659,952.546 ↑ 1.0 1 376,141

Limit (cost=3.63..20.61 rows=1 width=28) (actual time=17.705..17.706 rows=1 loops=376,141)

  • Buffers: shared hit=568219121
57. 376.141 6,659,200.264 ↑ 6.0 1 376,141

Result (cost=3.63..105.54 rows=6 width=28) (actual time=17.704..17.704 rows=1 loops=376,141)

  • Buffers: shared hit=568219121
58. 2,256.846 6,658,824.123 ↑ 6.0 1 376,141

Merge Append (cost=3.63..105.48 rows=6 width=24) (actual time=17.703..17.703 rows=1 loops=376,141)

  • Sort Key: o_30.timestamp_
  • Buffers: shared hit=568219121
59. 752.282 752.282 ↓ 0.0 0 376,141

Sort (cost=0.01..0.02 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=376,141)

  • Sort Key: o_30.timestamp_
  • Sort Method: quicksort Memory: 25kB
60. 0.000 0.000 ↓ 0.0 0 376,141

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_30 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=376,141)

  • Filter: ((timestamp_ >= o_24.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_24.person_id) AND ((location_fragment)::text = '/file/file-return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
61. 2,632.987 2,632.987 ↓ 0.0 0 376,141

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_31 (cost=0.55..2.61 rows=1 width=24) (actual time=0.007..0.007 rows=0 loops=376,141)

  • Index Cond: ((location_fragment = '/file/file-return'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= o_24.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_24.person_id))
  • Heap Fetches: 0
  • Buffers: shared hit=1140375
62. 137,291.465 137,291.465 ↓ 0.0 0 376,141

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_32 (cost=0.69..19.08 rows=1 width=24) (actual time=0.365..0.365 rows=0 loops=376,141)

  • Index Cond: ((location_fragment = '/file/file-return'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= o_24.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_24.person_id))
  • Heap Fetches: 0
  • Buffers: shared hit=12639898
63. 1,640,350.901 1,640,350.901 ↓ 0.0 0 376,141

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_33 (cost=0.81..39.48 rows=1 width=24) (actual time=4.361..4.361 rows=0 loops=376,141)

  • Index Cond: ((location_fragment = '/file/file-return'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= o_24.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_24.person_id))
  • Heap Fetches: 2
  • Buffers: shared hit=138768740
64. 4,193,596.009 4,193,596.009 ↓ 0.0 0 376,141

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 o_34 (cost=0.81..38.08 rows=1 width=24) (actual time=11.149..11.149 rows=0 loops=376,141)

  • Index Cond: ((location_fragment = '/file/file-return'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= o_24.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_24.person_id))
  • Heap Fetches: 11
  • Buffers: shared hit=355106986
65. 681,943.633 681,943.633 ↓ 0.0 0 376,141

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_5_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_5 o_35 (cost=0.68..6.04 rows=1 width=24) (actual time=1.813..1.813 rows=0 loops=376,141)

  • Index Cond: ((location_fragment = '/file/file-return'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= o_24.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_24.person_id))
  • Heap Fetches: 219
  • Buffers: shared hit=60563122
66. 1,128.423 156,850.797 ↑ 1.0 1 376,141

Limit (cost=20.91..20.91 rows=1 width=28) (actual time=0.416..0.417 rows=1 loops=376,141)

  • Buffers: shared hit=5356031 read=112771
67. 1,504.564 155,722.374 ↑ 6.0 1 376,141

Sort (cost=20.91..20.93 rows=6 width=28) (actual time=0.414..0.414 rows=1 loops=376,141)

  • Sort Key: o_36.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5356031 read=112771
68. 376.141 154,217.810 ↑ 6.0 1 376,141

Result (cost=0.00..20.88 rows=6 width=28) (actual time=0.189..0.410 rows=1 loops=376,141)

  • Buffers: shared hit=5356031 read=112771
69. 1,880.705 153,841.669 ↑ 6.0 1 376,141

Append (cost=0.00..20.82 rows=6 width=8) (actual time=0.188..0.409 rows=1 loops=376,141)

  • Buffers: shared hit=5356031 read=112771
70. 0.000 0.000 ↓ 0.0 0 376,141

Seq Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc o_36 (cost=0.00..0.00 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=376,141)

  • Filter: ((timestamp_ >= o_30.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (person_id = o_30.person_id) AND ((event_name)::text = 'Filed Return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
71. 3,385.269 3,385.269 ↓ 0.0 0 376,141

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_pid_ses_ts on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_37 (cost=0.42..4.07 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_30.person_id) AND (timestamp_ >= o_30.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((event_name)::text = 'Filed Return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=753131 read=1359
72. 31,595.844 31,595.844 ↓ 0.0 0 376,141

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_38 (cost=0.43..4.11 rows=1 width=8) (actual time=0.053..0.084 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_30.person_id) AND (timestamp_ >= o_30.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((event_name)::text = 'Filed Return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=876160 read=23375
73. 56,797.291 56,797.291 ↓ 0.0 0 376,141

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_pid_ses_ts on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_39 (cost=0.56..4.28 rows=1 width=8) (actual time=0.078..0.151 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_30.person_id) AND (timestamp_ >= o_30.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((event_name)::text = 'Filed Return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1424019 read=42811
74. 55,292.727 55,292.727 ↓ 0.0 0 376,141

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_pid_ses_ts on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 o_40 (cost=0.56..4.28 rows=1 width=8) (actual time=0.084..0.147 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_30.person_id) AND (timestamp_ >= o_30.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((event_name)::text = 'Filed Return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1487372 read=42518
75. 4,889.833 4,889.833 ↓ 0.0 0 376,141

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2019_5_pid_ses_ts on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_5 o_41 (cost=0.42..4.09 rows=1 width=8) (actual time=0.010..0.013 rows=0 loops=376,141)

  • Index Cond: ((person_id = o_30.person_id) AND (timestamp_ >= o_30.timestamp_) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-30 03:59:59.999'::timestamp without time zone))
  • Filter: (((event_name)::text = 'Filed Return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=815349 read=2708
Planning time : 41.873 ms
Execution time : 7,197,006.433 ms