explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bygT

Settings
# exclusive inclusive rows x rows loops node
1. 26.976 701,384.957 ↑ 200.0 1 1

GroupAggregate (cost=6,339,367.86..6,340,249.18 rows=200 width=72) (actual time=701,384.956..701,384.957 rows=1 loops=1)

  • Group Key: ('ALL'::text)
  • Buffers: shared hit=4212379 read=485143
2. 74.610 701,357.981 ↓ 3.4 120,998 1

Sort (cost=6,339,367.86..6,339,455.59 rows=35,093 width=56) (actual time=701,352.391..701,357.981 rows=120,998 loops=1)

  • Sort Key: ('ALL'::text)
  • Sort Method: quicksort Memory: 9393kB
  • Buffers: shared hit=4212379 read=485143
3. 70.167 701,283.371 ↓ 3.4 120,998 1

Nested Loop Left Join (cost=4,133,833.34..6,336,718.53 rows=35,093 width=56) (actual time=5,434.718..701,283.371 rows=120,998 loops=1)

  • Buffers: shared hit=4212379 read=485143
4. 93.083 5,704.380 ↓ 3.1 107,564 1

Finalize GroupAggregate (cost=4,133,833.34..4,138,802.71 rows=35,093 width=60) (actual time=5,434.647..5,704.380 rows=107,564 loops=1)

  • Group Key: o_6.person_id, ('ALL'::text)
  • Buffers: shared hit=1590227
5. 0.000 5,611.297 ↓ 3.9 136,558 1

Gather Merge (cost=4,133,833.34..4,138,188.59 rows=35,092 width=56) (actual time=5,434.643..5,611.297 rows=136,558 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=7968292
6. 112.205 27,301.100 ↓ 3.1 27,312 5

Partial GroupAggregate (cost=4,132,833.28..4,133,008.74 rows=8,773 width=56) (actual time=5,427.716..5,460.220 rows=27,312 loops=5)

  • Group Key: o_6.person_id, 'ALL'::text
  • Buffers: shared hit=7968292
7. 164.755 27,188.895 ↓ 6.1 53,293 5

Sort (cost=4,132,833.28..4,132,855.21 rows=8,773 width=56) (actual time=5,427.708..5,437.779 rows=53,293 loops=5)

  • Sort Key: o_6.person_id
  • Sort Method: quicksort Memory: 5746kB
  • Buffers: shared hit=7968292
8. 26.505 27,024.140 ↓ 6.1 53,293 5

Result (cost=0.00..4,132,258.70 rows=8,773 width=56) (actual time=0.170..5,404.828 rows=53,293 loops=5)

  • Buffers: shared hit=7968264
9. 21.420 26,997.635 ↓ 6.1 53,293 5

Append (cost=0.00..4,132,170.97 rows=8,773 width=24) (actual time=0.170..5,399.527 rows=53,293 loops=5)

  • Buffers: shared hit=7968264
10. 0.000 0.000 ↓ 0.0 0 5

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_6 (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. 324.345 324.345 ↓ 2.7 1,656 5

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 o_7 (cost=0.00..89,421.21 rows=606 width=24) (actual time=0.169..64.869 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,721.210 4,721.210 ↓ 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_8 (cost=0.68..686,049.73 rows=3,572 width=24) (actual time=726.593..944.242 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: 18
  • Buffers: shared hit=1241293
13. 10,408.505 10,408.505 ↓ 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_9 (cost=0.81..1,548,345.85 rows=2,158 width=24) (actual time=1,743.945..2,081.701 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: 120
  • Buffers: shared hit=2742064
14. 10,936.930 10,936.930 ↓ 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_10 (cost=0.81..1,631,257.09 rows=2,192 width=24) (actual time=1,899.372..2,187.386 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: 172
  • Buffers: shared hit=3164080
15. 585.225 585.225 ↑ 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_11 (cost=0.56..177,097.08 rows=244 width=24) (actual time=0.672..117.045 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=701908
16. 107.564 695,508.824 ↓ 0.0 0 107,564

Append (cost=0.00..62.56 rows=6 width=28) (actual time=5.911..6.466 rows=0 loops=107,564)

  • Buffers: shared hit=2622152 read=485143
17. 0.000 0.000 ↓ 0.0 0 107,564

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o (cost=0.00..0.00 rows=1 width=28) (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 ((location_host)::text ~~ '%hrblock.ca'::text) AND (timestamp_ > (min(o_6.timestamp_))) AND (person_id = o_6.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)))
18. 7,744.608 7,744.608 ↓ 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_1 (cost=0.55..3.97 rows=1 width=28) (actual time=0.071..0.072 rows=0 loops=107,564)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ > (min(o_6.timestamp_))) 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 ~~ '/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=448703 read=5387
19. 142,844.992 142,844.992 ↓ 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_2 (cost=0.56..11.31 rows=1 width=28) (actual time=1.258..1.328 rows=0 loops=107,564)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ > (min(o_6.timestamp_))) 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 ~~ '/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=530183 read=100985
20. 213,514.540 213,514.540 ↓ 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_3 (cost=0.56..21.32 rows=1 width=28) (actual time=1.870..1.985 rows=0 loops=107,564)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ > (min(o_6.timestamp_))) 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 ~~ '/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=550042 read=150010
21. 320,540.720 320,540.720 ↓ 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_4 (cost=0.56..22.68 rows=1 width=28) (actual time=2.694..2.980 rows=0 loops=107,564)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ > (min(o_6.timestamp_))) 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 ~~ '/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=653947 read=220727
22. 10,756.400 10,756.400 ↓ 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_5 (cost=0.56..3.28 rows=1 width=28) (actual time=0.100..0.100 rows=0 loops=107,564)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ > (min(o_6.timestamp_))) 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 ~~ '/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=439277 read=8034
Planning time : 38.741 ms
Execution time : 701,386.413 ms