explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lOC6

Settings
# exclusive inclusive rows x rows loops node
1. 21.058 486,358.538 ↑ 200.0 1 1

GroupAggregate (cost=4,887,693.16..4,888,574.49 rows=200 width=72) (actual time=486,358.538..486,358.538 rows=1 loops=1)

  • Group Key: ('ALL'::text)
  • Buffers: shared hit=4363568 read=348102
2. 50.388 486,337.480 ↓ 3.1 107,564 1

Sort (cost=4,887,693.16..4,887,780.89 rows=35,093 width=56) (actual time=486,332.595..486,337.480 rows=107,564 loops=1)

  • Sort Key: ('ALL'::text)
  • Sort Method: quicksort Memory: 8343kB
  • Buffers: shared hit=4363568 read=348102
3. 10.740 486,287.092 ↓ 3.1 107,564 1

Nested Loop Left Join (cost=4,133,843.04..4,885,043.83 rows=35,093 width=56) (actual time=5,551.147..486,287.092 rows=107,564 loops=1)

  • Buffers: shared hit=4363568 read=348102
4. 78.632 5,787.964 ↓ 3.1 107,564 1

Finalize GroupAggregate (cost=4,133,821.81..4,138,791.19 rows=35,093 width=60) (actual time=5,551.066..5,787.964 rows=107,564 loops=1)

  • Group Key: o.person_id, ('ALL'::text)
  • Buffers: shared hit=1604375
5. 0.000 5,709.332 ↓ 3.9 136,574 1

Gather Merge (cost=4,133,821.81..4,138,177.07 rows=35,092 width=56) (actual time=5,551.062..5,709.332 rows=136,574 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=7966527
6. 106.630 27,874.680 ↓ 3.1 27,315 5

Partial GroupAggregate (cost=4,132,821.75..4,132,997.21 rows=8,773 width=56) (actual time=5,544.176..5,574.936 rows=27,315 loops=5)

  • Group Key: o.person_id, 'ALL'::text
  • Buffers: shared hit=7966527
7. 162.795 27,768.050 ↓ 6.1 53,293 5

Sort (cost=4,132,821.75..4,132,843.69 rows=8,773 width=56) (actual time=5,544.169..5,553.610 rows=53,293 loops=5)

  • Sort Key: o.person_id
  • Sort Method: quicksort Memory: 5774kB
  • Buffers: shared hit=7966527
8. 26.560 27,605.255 ↓ 6.1 53,293 5

Result (cost=0.00..4,132,247.17 rows=8,773 width=56) (actual time=0.155..5,521.051 rows=53,293 loops=5)

  • Buffers: shared hit=7966499
9. 21.170 27,578.695 ↓ 6.1 53,293 5

Append (cost=0.00..4,132,159.44 rows=8,773 width=24) (actual time=0.154..5,515.739 rows=53,293 loops=5)

  • Buffers: shared hit=7966499
10. 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))
11. 326.215 326.215 ↓ 2.7 1,656 5

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 o_1 (cost=0.00..89,420.94 rows=606 width=24) (actual time=0.154..65.243 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=118919
12. 4,815.260 4,815.260 ↓ 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,048.09 rows=3,572 width=24) (actual time=759.091..963.052 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: 15
  • Buffers: shared hit=1241041
13. 10,841.740 10,841.740 ↓ 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.67 rows=2,158 width=24) (actual time=1,841.179..2,168.348 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: 115
  • Buffers: shared hit=2740933
14. 10,993.875 10,993.875 ↓ 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,247.66 rows=2,192 width=24) (actual time=1,910.375..2,198.775 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: 131
  • Buffers: shared hit=3163689
15. 580.435 580.435 ↑ 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=0.476..116.087 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=701917
16. 107.564 480,488.388 ↓ 0.0 0 107,564

Limit (cost=21.23..21.23 rows=1 width=94) (actual time=4.466..4.467 rows=0 loops=107,564)

  • Buffers: shared hit=2759193 read=348102
17. 107.564 480,380.824 ↓ 0.0 0 107,564

Sort (cost=21.23..21.25 rows=6 width=94) (actual time=4.466..4.466 rows=0 loops=107,564)

  • Sort Key: o_6.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2759193 read=348102
18. 107.564 480,273.260 ↓ 0.0 0 107,564

Result (cost=0.00..21.20 rows=6 width=94) (actual time=4.041..4.465 rows=0 loops=107,564)

  • Buffers: shared hit=2759193 read=348102
19. 215.128 480,165.696 ↓ 0.0 0 107,564

Append (cost=0.00..21.14 rows=6 width=8) (actual time=4.041..4.464 rows=0 loops=107,564)

  • Buffers: shared hit=2759193 read=348102
20. 0.000 0.000 ↓ 0.0 0 107,564

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_6 (cost=0.00..0.00 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=107,564)

  • 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 (timestamp_ > (min(o.timestamp_))) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone) AND ((location_host)::text ~~ '%hrblock.ca'::text) AND (person_id = o.person_id) AND (((location_path)::text ~~ '/office-locator%'::text) OR ((location_path)::text ~~ '/stores%'::text) OR ((location_path)::text ~~ '/fr/localisateur-de-bureau%'::text) OR ((location_path)::text ~~ '/fr/quarter%'::text)))
21. 215.128 215.128 ↓ 0.0 0 107,564

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_1_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 o_7 (cost=0.55..3.92 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=107,564)

  • Index Cond: ((person_id = o.person_id) 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) AND (timestamp_ > (min(o.timestamp_))) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '%hrblock.ca'::text) AND (((location_path)::text ~~ '/office-locator%'::text) OR ((location_path)::text ~~ '/stores%'::text) OR ((location_path)::text ~~ '/fr/localisateur-de-bureau%'::text) OR ((location_path)::text ~~ '/fr/quarter%'::text)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=454090
22. 94,979.012 94,979.012 ↓ 0.0 0 107,564

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_2 o_8 (cost=0.56..4.15 rows=1 width=8) (actual time=0.828..0.883 rows=0 loops=107,564)

  • Index Cond: ((person_id = o.person_id) 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) AND (timestamp_ > (min(o.timestamp_))) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '%hrblock.ca'::text) AND (((location_path)::text ~~ '/office-locator%'::text) OR ((location_path)::text ~~ '/stores%'::text) OR ((location_path)::text ~~ '/fr/localisateur-de-bureau%'::text) OR ((location_path)::text ~~ '/fr/quarter%'::text)))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=559634 read=71534
23. 153,816.520 153,816.520 ↓ 0.0 0 107,564

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_3_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_3 o_9 (cost=0.56..4.50 rows=1 width=8) (actual time=1.336..1.430 rows=0 loops=107,564)

  • Index Cond: ((person_id = o.person_id) 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) AND (timestamp_ > (min(o.timestamp_))) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '%hrblock.ca'::text) AND (((location_path)::text ~~ '/office-locator%'::text) OR ((location_path)::text ~~ '/stores%'::text) OR ((location_path)::text ~~ '/fr/localisateur-de-bureau%'::text) OR ((location_path)::text ~~ '/fr/quarter%'::text)))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=591083 read=108969
24. 230,724.780 230,724.780 ↓ 0.0 0 107,564

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_4_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_4 o_10 (cost=0.56..4.57 rows=1 width=8) (actual time=1.926..2.145 rows=0 loops=107,564)

  • Index Cond: ((person_id = o.person_id) 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) AND (timestamp_ > (min(o.timestamp_))) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '%hrblock.ca'::text) AND (((location_path)::text ~~ '/office-locator%'::text) OR ((location_path)::text ~~ '/stores%'::text) OR ((location_path)::text ~~ '/fr/localisateur-de-bureau%'::text) OR ((location_path)::text ~~ '/fr/quarter%'::text)))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=707075 read=167599
25. 215.128 215.128 ↓ 0.0 0 107,564

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_5_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_5 o_11 (cost=0.56..4.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=107,564)

  • Index Cond: ((person_id = o.person_id) 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) AND (timestamp_ > (min(o.timestamp_))) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '%hrblock.ca'::text) AND (((location_path)::text ~~ '/office-locator%'::text) OR ((location_path)::text ~~ '/stores%'::text) OR ((location_path)::text ~~ '/fr/localisateur-de-bureau%'::text) OR ((location_path)::text ~~ '/fr/quarter%'::text)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=447311
Planning time : 38.868 ms
Execution time : 486,359.896 ms