explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KEI9

Settings
# exclusive inclusive rows x rows loops node
1. 29.935 2,311,022.119 ↓ 3.1 107,564 1

Finalize GroupAggregate (cost=4,133,833.19..4,138,802.56 rows=35,093 width=60) (actual time=2,310,893.808..2,311,022.119 rows=107,564 loops=1)

  • Group Key: o.person_id, ('ALL'::text)
  • Buffers: shared hit=5865377 read=968796
2. 12.786 2,310,992.184 ↓ 3.1 107,564 1

Gather Merge (cost=4,133,833.19..4,138,188.44 rows=35,092 width=56) (actual time=2,310,893.805..2,310,992.184 rows=107,564 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
  • Buffers: shared hit=5865377 read=968796
3. 58.092 2,310,979.398 ↓ 12.3 107,564 1

Partial GroupAggregate (cost=4,132,833.13..4,133,008.59 rows=8,773 width=56) (actual time=2,310,893.070..2,310,979.398 rows=107,564 loops=1)

  • Group Key: o.person_id, 'ALL'::text
  • Buffers: shared hit=5865377 read=968796
4. 165.374 2,310,921.306 ↓ 30.4 266,467 1

Sort (cost=4,132,833.13..4,132,855.06 rows=8,773 width=56) (actual time=2,310,893.061..2,310,921.306 rows=266,467 loops=1)

  • Sort Key: o.person_id
  • Sort Method: quicksort Memory: 33106kB
  • Buffers: shared hit=5865377 read=968796
5. 30.345 2,310,755.932 ↓ 30.4 266,467 1

Result (cost=0.00..4,132,258.55 rows=8,773 width=56) (actual time=0.172..2,310,755.932 rows=266,467 loops=1)

  • Buffers: shared hit=5865377 read=968796
6. 23.334 2,310,725.587 ↓ 30.4 266,467 1

Append (cost=0.00..4,132,170.82 rows=8,773 width=24) (actual time=0.171..2,310,725.587 rows=266,467 loops=1)

  • Buffers: shared hit=5865377 read=968796
7. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 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_host)::text ~~ '%hrblock.ca'::text) AND ((location_path)::text ~~ '/%tax-calculator%'::text))
8. 336.428 336.428 ↓ 13.7 8,279 1

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 o_1 (cost=0.00..89,421.06 rows=606 width=24) (actual time=0.171..336.428 rows=8,279 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_host)::text ~~ '%hrblock.ca'::text) AND ((location_path)::text ~~ '/%tax-calculator%'::text))
  • Rows Removed by Filter: 1208349
  • Buffers: shared hit=118919
9. 3,984.959 3,984.959 ↓ 24.4 87,239 1

Parallel 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..686,049.73 rows=3,572 width=24) (actual time=3,022.307..3,984.959 rows=87,239 loops=1)

  • Index Cond: ((location_path ~>=~ '/'::text) AND (location_path ~<~ '0'::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))
  • Filter: (((location_host)::text ~~ '%hrblock.ca'::text) AND ((location_path)::text ~~ '/%tax-calculator%'::text))
  • Rows Removed by Filter: 8029556
  • Heap Fetches: 110
  • Buffers: shared hit=1046355
10. 1,073,473.761 1,073,473.761 ↓ 36.8 79,471 1

Parallel 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,548,345.85 rows=2,158 width=24) (actual time=923,113.800..1,073,473.761 rows=79,471 loops=1)

  • Index Cond: ((location_path ~>=~ '/'::text) AND (location_path ~<~ '0'::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))
  • Filter: (((location_host)::text ~~ '%hrblock.ca'::text) AND ((location_path)::text ~~ '/%tax-calculator%'::text))
  • Rows Removed by Filter: 17724450
  • Heap Fetches: 636
  • Buffers: shared hit=2155998 read=135199
11. 1,136,844.875 1,136,844.875 ↓ 41.2 90,374 1

Parallel 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,631,257.09 rows=2,192 width=24) (actual time=955,357.365..1,136,844.875 rows=90,374 loops=1)

  • Index Cond: ((location_path ~>=~ '/'::text) AND (location_path ~<~ '0'::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))
  • Filter: (((location_host)::text ~~ '%hrblock.ca'::text) AND ((location_path)::text ~~ '/%tax-calculator%'::text))
  • Rows Removed by Filter: 18500128
  • Heap Fetches: 804
  • Buffers: shared hit=1908929 read=769107
12. 96,062.230 96,062.230 ↓ 4.5 1,104 1

Parallel 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..177,097.08 rows=244 width=24) (actual time=244.367..96,062.230 rows=1,104 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_host)::text ~~ '%hrblock.ca'::text) AND ((location_path)::text ~~ '/%tax-calculator%'::text))
  • Rows Removed by Filter: 831579
  • Buffers: shared hit=635176 read=64490
Planning time : 22.701 ms
Execution time : 2,311,028.785 ms