explain.depesz.com

PostgreSQL's explain analyze made readable

Result: quDU

Settings
# exclusive inclusive rows x rows loops node
1. 41.595 178,810.691 ↑ 200.0 1 1

GroupAggregate (cost=4,885,499.85..4,886,381.17 rows=200 width=72) (actual time=178,810.691..178,810.691 rows=1 loops=1)

  • Group Key: ('ALL'::text)
  • Buffers: shared hit=3730800 read=110890
2. 46.989 178,769.096 ↓ 3.1 107,564 1

Sort (cost=4,885,499.85..4,885,587.58 rows=35,093 width=56) (actual time=178,763.968..178,769.096 rows=107,564 loops=1)

  • Sort Key: ('ALL'::text)
  • Sort Method: quicksort Memory: 10916kB
  • Buffers: shared hit=3730800 read=110890
3. 13.894 178,722.107 ↓ 3.1 107,564 1

Nested Loop Left Join (cost=4,133,842.98..4,882,850.52 rows=35,093 width=56) (actual time=5,636.212..178,722.107 rows=107,564 loops=1)

  • Buffers: shared hit=3730797 read=110890
4. 71.009 5,852.865 ↓ 3.1 107,564 1

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

  • Group Key: o.person_id, ('ALL'::text)
  • Buffers: shared hit=1590962
5. 0.000 5,781.856 ↓ 3.9 136,631 1

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

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=7965505
6. 108.785 28,286.940 ↓ 3.1 27,326 5

Partial GroupAggregate (cost=4,132,821.75..4,132,997.21 rows=8,773 width=56) (actual time=5,625.976..5,657.388 rows=27,326 loops=5)

  • Group Key: o.person_id, 'ALL'::text
  • Buffers: shared hit=7965505
7. 164.135 28,178.155 ↓ 6.1 53,293 5

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

  • Sort Key: o.person_id
  • Sort Method: quicksort Memory: 5697kB
  • Buffers: shared hit=7965505
8. 26.630 28,014.020 ↓ 6.1 53,293 5

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

  • Buffers: shared hit=7965477
9. 21.580 27,987.390 ↓ 6.1 53,293 5

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

  • Buffers: shared hit=7965477
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. 324.385 324.385 ↓ 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.156..64.877 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,923.075 4,923.075 ↓ 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=767.009..984.615 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: 17
  • Buffers: shared hit=1241021
13. 11,024.590 11,024.590 ↓ 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,853.095..2,204.918 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: 128
  • Buffers: shared hit=2740007
14. 11,106.485 11,106.485 ↓ 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,926.072..2,221.297 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: 130
  • Buffers: shared hit=3163625
15. 587.275 587.275 ↑ 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.589..117.455 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=701905
16. 215.128 172,855.348 ↑ 1.0 1 107,564

Limit (cost=21.17..21.17 rows=1 width=94) (actual time=1.606..1.607 rows=1 loops=107,564)

  • Buffers: shared hit=2139835 read=110890
17. 215.128 172,640.220 ↑ 6.0 1 107,564

Sort (cost=21.17..21.19 rows=6 width=94) (actual time=1.605..1.605 rows=1 loops=107,564)

  • Sort Key: o_6.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2139835 read=110890
18. 107.564 172,425.092 ↓ 1.5 9 107,564

Result (cost=0.00..21.14 rows=6 width=94) (actual time=1.071..1.603 rows=9 loops=107,564)

  • Buffers: shared hit=2139832 read=110890
19. 215.128 172,317.528 ↓ 1.5 9 107,564

Append (cost=0.00..21.08 rows=6 width=8) (actual time=1.070..1.602 rows=9 loops=107,564)

  • Buffers: shared hit=2139832 read=110890
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 (person_id = o.person_id))
21. 12,907.680 12,907.680 ↓ 0.0 0 107,564

Index Only 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.90 rows=1 width=8) (actual time=0.112..0.120 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))
  • Heap Fetches: 0
  • Buffers: shared hit=427893 read=6763
22. 33,452.404 33,452.404 ↓ 2.0 2 107,564

Index Only 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.13 rows=1 width=8) (actual time=0.289..0.311 rows=2 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))
  • Heap Fetches: 0
  • Buffers: shared hit=429479 read=23629
23. 51,092.900 51,092.900 ↓ 3.0 3 107,564

Index Only 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.49 rows=1 width=8) (actual time=0.440..0.475 rows=3 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))
  • Heap Fetches: 21
  • Buffers: shared hit=426072 read=33094
24. 58,729.944 58,729.944 ↓ 4.0 4 107,564

Index Only 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.56 rows=1 width=8) (actual time=0.485..0.546 rows=4 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))
  • Heap Fetches: 15
  • Buffers: shared hit=433553 read=37490
25. 15,919.472 15,919.472 ↓ 0.0 0 107,564

Index Only 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..3.99 rows=1 width=8) (actual time=0.145..0.148 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))
  • Heap Fetches: 1
  • Buffers: shared hit=422835 read=9914
Planning time : 26.132 ms
Execution time : 178,812.499 ms