explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3I9I

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 2,756,460.255 ↑ 42.0 6 1

GroupAggregate (cost=3,854,645.64..3,854,650.68 rows=252 width=60) (actual time=2,756,460.252..2,756,460.255 rows=6 loops=1)

  • Group Key: o.person_id, 'ALL'::text
  • Buffers: shared hit=635179 read=1924416
2. 0.031 2,756,460.246 ↑ 31.5 8 1

Sort (cost=3,854,645.64..3,854,646.27 rows=252 width=56) (actual time=2,756,460.245..2,756,460.246 rows=8 loops=1)

  • Sort Key: o.person_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=635179 read=1924416
3. 0.004 2,756,460.215 ↑ 31.5 8 1

Result (cost=0.00..3,854,635.59 rows=252 width=56) (actual time=67,219.324..2,756,460.215 rows=8 loops=1)

  • Buffers: shared hit=635176 read=1924416
4. 0.007 2,756,460.211 ↑ 31.5 8 1

Append (cost=0.00..3,854,633.07 rows=252 width=24) (actual time=67,219.322..2,756,460.211 rows=8 loops=1)

  • Buffers: shared hit=635176 read=1924416
5. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone) AND ((location_path)::text = '/tax-calculator'::text))
6. 71,211.910 71,211.910 ↑ 1.4 8 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_1_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 o_1 (cost=0.55..82,937.20 rows=11 width=24) (actual time=67,219.320..71,211.910 rows=8 loops=1)

  • Index Cond: ((location_path = '/tax-calculator'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared read=41031
7. 463,213.411 463,213.411 ↓ 0.0 0 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_2_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_2 o_2 (cost=0.68..635,310.72 rows=44 width=24) (actual time=463,213.411..463,213.411 rows=0 loops=1)

  • Index Cond: ((location_path = '/tax-calculator'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared read=320885
8. 1,003,405.833 1,003,405.833 ↓ 0.0 0 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_3_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_3 o_3 (cost=0.81..1,437,011.64 rows=88 width=24) (actual time=1,003,405.833..1,003,405.833 rows=0 loops=1)

  • Index Cond: ((location_path = '/tax-calculator'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared read=728943
9. 1,131,909.691 1,131,909.691 ↓ 0.0 0 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_4_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_4 o_4 (cost=0.81..1,514,990.48 rows=102 width=24) (actual time=1,131,909.691..1,131,909.691 rows=0 loops=1)

  • Index Cond: ((location_path = '/tax-calculator'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared read=769067
10. 86,719.357 86,719.357 ↓ 0.0 0 1

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_5_ts_pid_ses on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_5 o_5 (cost=0.56..184,383.03 rows=6 width=24) (actual time=86,719.357..86,719.357 rows=0 loops=1)

  • Index Cond: ((timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Filter: ((location_path)::text = '/tax-calculator'::text)
  • Rows Removed by Filter: 832683
  • Buffers: shared hit=635176 read=64490
Planning time : 3.710 ms
Execution time : 2,756,460.336 ms