explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ipTR

Settings
# exclusive inclusive rows x rows loops node
1. 117.329 4,049.033 ↓ 2.3 461 1

HashAggregate (cost=1,322,670.21..1,322,672.21 rows=200 width=62) (actual time=4,048.892..4,049.033 rows=461 loops=1)

  • Group Key: s.last_location_fragment
  • Buffers: shared hit=6601651 read=11 dirtied=106
2. 562.893 3,931.704 ↑ 1.2 297,073 1

HashAggregate (cost=1,313,574.63..1,317,212.86 rows=363,823 width=38) (actual time=3,816.349..3,931.704 rows=297,073 loops=1)

  • Group Key: s.last_location_fragment, o.person_id
  • Buffers: shared hit=6601651 read=11 dirtied=106
3. 0.000 3,368.811 ↓ 1.8 656,370 1

Gather (cost=1,000.56..1,311,755.52 rows=363,823 width=38) (actual time=0.904..3,368.811 rows=656,370 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=6601651 read=11 dirtied=106
4. 1,403.815 3,550.381 ↓ 1.4 131,274 5

Nested Loop Left Join (cost=0.56..1,274,373.22 rows=90,956 width=38) (actual time=0.082..3,550.381 rows=131,274 loops=5)

  • Buffers: shared hit=6601651 read=11 dirtied=106
5. 74.161 2,146.557 ↓ 1.4 131,274 5

Append (cost=0.00..1,100,153.15 rows=90,957 width=38) (actual time=0.050..2,146.557 rows=131,274 loops=5)

  • Buffers: shared hit=839112 read=11 dirtied=11
6. 0.002 0.002 ↓ 0.0 0 5

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o (cost=0.00..0.00 rows=1 width=82) (actual time=0.002..0.002 rows=0 loops=5)

  • Filter: ((timestamp_ >= '2019-02-06 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-04-08 05:59:59.999'::timestamp without time zone) AND ((location_host)::text ~~ '2018.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/prepare/your-year/introduction'::text))
7. 545.878 545.878 ↓ 1.6 36,596 5

Parallel Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_1 (cost=0.81..297,434.63 rows=23,323 width=38) (actual time=0.046..545.878 rows=36,596 loops=5)

  • Index Cond: ((location_host = '2018.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/prepare/your-year/introduction'::text) AND (timestamp_ >= '2019-02-06 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-04-08 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2018.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/prepare/your-year/introduction'::text))
  • Heap Fetches: 83
  • Buffers: shared hit=233147 read=9
8. 1,220.640 1,220.640 ↓ 1.4 79,831 5

Parallel Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_2 (cost=0.81..646,934.70 rows=57,122 width=38) (actual time=0.098..1,220.640 rows=79,831 loops=5)

  • Index Cond: ((location_host = '2018.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/prepare/your-year/introduction'::text) AND (timestamp_ >= '2019-02-06 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-04-08 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2018.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/prepare/your-year/introduction'::text))
  • Heap Fetches: 187
  • Buffers: shared hit=489429 read=2 dirtied=1
9. 305.876 305.876 ↓ 1.4 14,847 5

Parallel Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 o_3 (cost=0.81..155,783.83 rows=10,511 width=38) (actual time=0.129..305.876 rows=14,847 loops=5)

  • Index Cond: ((location_host = '2018.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/prepare/your-year/introduction'::text) AND (timestamp_ >= '2019-02-06 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-04-08 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2018.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/prepare/your-year/introduction'::text))
  • Heap Fetches: 13
  • Buffers: shared hit=116536 dirtied=10
10. 0.009 0.009 ↑ 1.0 1 656,370

Index Scan using session_ace8b421_634f_4060_9118_ffc36db704dc__pid_ts on session_ace8b421_634f_4060_9118_ffc36db704dc s (cost=0.56..1.91 rows=1 width=59) (actual time=0.007..0.009 rows=1 loops=656,370)

  • Index Cond: ((o.person_id = person_id) AND (first_seen >= '2019-02-06 07:00:00'::timestamp without time zone) AND (first_seen <= '2019-04-08 05:59:59.999'::timestamp without time zone))
  • Filter: ((o.session_id)::text = (session_id)::text)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=5762539 dirtied=95