explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uRUg

Settings
# exclusive inclusive rows x rows loops node
1. 36.198 2,542,263.395 ↓ 3.1 107,564 1

Finalize GroupAggregate (cost=4,133,833.19..4,138,802.56 rows=35,093 width=60) (actual time=2,542,139.373..2,542,263.395 rows=107,564 loops=1)

  • Group Key: o.person_id, ('ALL'::text)
  • Buffers: shared hit=1173012 read=368581
2. 0.000 2,542,227.197 ↓ 3.9 136,565 1

Gather Merge (cost=4,133,833.19..4,138,188.44 rows=35,092 width=56) (actual time=2,542,139.369..2,542,227.197 rows=136,565 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=5922198 read=1874627
3. 77.705 12,710,745.760 ↓ 3.1 27,313 5

Partial GroupAggregate (cost=4,132,833.13..4,133,008.59 rows=8,773 width=56) (actual time=2,542,126.924..2,542,149.152 rows=27,313 loops=5)

  • Group Key: o.person_id, 'ALL'::text
  • Buffers: shared hit=5922198 read=1874627
4. 171.730 12,710,668.055 ↓ 6.1 53,293 5

Sort (cost=4,132,833.13..4,132,855.06 rows=8,773 width=56) (actual time=2,542,126.917..2,542,133.611 rows=53,293 loops=5)

  • Sort Key: o.person_id
  • Sort Method: quicksort Memory: 5679kB
  • Buffers: shared hit=5922198 read=1874627
5. 32.715 12,710,496.325 ↓ 6.1 53,293 5

Result (cost=0.00..4,132,258.55 rows=8,773 width=56) (actual time=34.845..2,542,099.265 rows=53,293 loops=5)

  • Buffers: shared hit=5922170 read=1874627
6. 24.245 12,710,463.610 ↓ 6.1 53,293 5

Append (cost=0.00..4,132,170.82 rows=8,773 width=24) (actual time=34.841..2,542,092.722 rows=53,293 loops=5)

  • Buffers: shared hit=5922170 read=1874627
7. 0.000 0.000 ↓ 0.0 0 5

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=5)

  • 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. 6,363.725 6,363.725 ↓ 2.7 1,656 5

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=34.838..1,272.745 rows=1,656 loops=5)

  • 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: 241670
  • Buffers: shared hit=29291 read=44869
9. 2,239,780.520 2,239,780.520 ↓ 4.9 17,448 5

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=364,046.397..447,956.104 rows=17,448 loops=5)

  • 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: 1605911
  • Heap Fetches: 21
  • Buffers: shared hit=897079 read=320885
10. 5,240,292.525 5,240,292.525 ↓ 7.4 15,894 5

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=893,633.779..1,048,058.505 rows=15,894 loops=5)

  • 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: 3544890
  • Heap Fetches: 125
  • Buffers: shared hit=1966092 read=728996
11. 5,155,653.455 5,155,653.455 ↓ 8.2 18,075 5

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=918,847.354..1,031,130.691 rows=18,075 loops=5)

  • 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: 3700026
  • Heap Fetches: 163
  • Buffers: shared hit=2338613 read=769067
12. 68,349.140 68,349.140 ↑ 1.1 221 5

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=58.629..13,669.828 rows=221 loops=5)

  • 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: 166316
  • Buffers: shared hit=691095 read=10810
Planning time : 60.604 ms
Execution time : 2,542,271.053 ms