explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FUEx

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 4,859.461 ↑ 42.0 6 1

GroupAggregate (cost=3,854,645.64..3,854,650.68 rows=252 width=60) (actual time=4,859.458..4,859.461 rows=6 loops=1)

  • Group Key: o.person_id, 'ALL'::text
  • Buffers: shared hit=2559592
2. 0.016 4,859.451 ↑ 31.5 8 1

Sort (cost=3,854,645.64..3,854,646.27 rows=252 width=56) (actual time=4,859.451..4,859.451 rows=8 loops=1)

  • Sort Key: o.person_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2559592
3. 0.004 4,859.435 ↑ 31.5 8 1

Result (cost=0.00..3,854,635.59 rows=252 width=56) (actual time=102.394..4,859.435 rows=8 loops=1)

  • Buffers: shared hit=2559592
4. 0.008 4,859.431 ↑ 31.5 8 1

Append (cost=0.00..3,854,633.07 rows=252 width=24) (actual time=102.393..4,859.431 rows=8 loops=1)

  • Buffers: shared hit=2559592
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. 108.551 108.551 ↑ 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=102.390..108.551 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 hit=41031
7. 799.303 799.303 ↓ 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=799.303..799.303 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 hit=320885
8. 1,756.668 1,756.668 ↓ 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,756.668..1,756.668 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 hit=728943
9. 1,798.299 1,798.299 ↓ 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,798.299..1,798.299 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 hit=769067
10. 396.600 396.600 ↓ 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=396.600..396.600 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=699666
Planning time : 3.327 ms
Execution time : 4,859.526 ms