explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 90MO

Settings
# exclusive inclusive rows x rows loops node
1. 894.135 3,715.356 ↑ 1.0 1 1

Aggregate (cost=130,250.38..130,250.39 rows=1 width=24) (actual time=3,715.356..3,715.356 rows=1 loops=1)

  • Buffers: shared hit=18585 read=669
2. 411.763 2,821.221 ↓ 4.8 1,396,756 1

Merge Left Join (cost=120,159.97..128,056.60 rows=292,505 width=48) (actual time=2,173.753..2,821.221 rows=1,396,756 loops=1)

  • Merge Cond: (o.person_id = o_4.person_id)
  • Join Filter: (o_4.timestamp_ > o.timestamp_)
  • Rows Removed by Join Filter: 802376
  • Buffers: shared hit=18585 read=669
3. 301.089 1,611.890 ↓ 1.6 470,834 1

Sort (cost=66,433.03..67,164.29 rows=292,505 width=40) (actual time=1,537.642..1,611.890 rows=470,834 loops=1)

  • Sort Key: o.person_id
  • Sort Method: quicksort Memory: 48394kB
  • Buffers: shared hit=11772 read=507
4. 170.226 1,310.801 ↓ 1.6 470,834 1

Hash Right Join (cost=23,925.05..39,876.35 rows=292,505 width=40) (actual time=775.507..1,310.801 rows=470,834 loops=1)

  • Hash Cond: (o.person_id = o_8.person_id)
  • Join Filter: (o.timestamp_ > (min(o_8.timestamp_)))
  • Rows Removed by Join Filter: 1708
  • Buffers: shared hit=11772 read=507
5. 34.860 370.983 ↓ 1.4 460,198 1

Append (cost=0.00..15,057.27 rows=340,582 width=24) (actual time=3.982..370.983 rows=460,198 loops=1)

  • Buffers: shared hit=6756 read=181
6. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o (cost=0.00..0.00 rows=1 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone) AND ((location_fragment)::text = '/home/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
7. 225.553 225.553 ↓ 1.9 18,961 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_1 (cost=0.55..455.09 rows=9,926 width=24) (actual time=3.976..225.553 rows=18,961 loops=1)

  • Index Cond: ((location_fragment = '/home/section'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared hit=3 read=180
8. 41.736 41.736 ↓ 1.4 168,820 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_2 (cost=0.69..5,411.62 rows=121,849 width=24) (actual time=0.052..41.736 rows=168,820 loops=1)

  • Index Cond: ((location_fragment = '/home/section'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 29
  • Buffers: shared hit=2164
9. 68.829 68.829 ↓ 1.3 272,417 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_3 (cost=0.81..9,190.56 rows=208,806 width=24) (actual time=0.062..68.829 rows=272,417 loops=1)

  • Index Cond: ((location_fragment = '/home/section'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 19
  • Buffers: shared hit=4589 read=1
10. 56.013 769.592 ↑ 1.3 231,372 1

Hash (cost=20,268.74..20,268.74 rows=292,505 width=24) (actual time=769.592..769.592 rows=231,372 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 16750kB
  • Buffers: shared hit=5016 read=326
11. 164.803 713.579 ↑ 1.3 231,372 1

HashAggregate (cost=14,418.64..17,343.69 rows=292,505 width=24) (actual time=659.685..713.579 rows=231,372 loops=1)

  • Group Key: o_8.person_id
  • Buffers: shared hit=5016 read=326
12. 35.175 548.776 ↓ 1.4 403,812 1

Append (cost=0.00..12,956.12 rows=292,505 width=24) (actual time=7.589..548.776 rows=403,812 loops=1)

  • Buffers: shared hit=5016 read=326
13. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_8 (cost=0.00..0.00 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone) AND ((location_fragment)::text = '/welcome'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
14. 426.433 426.433 ↓ 2.1 39,004 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_9 (cost=0.55..846.76 rows=18,490 width=24) (actual time=7.586..426.433 rows=39,004 loops=1)

  • Index Cond: ((location_fragment = '/welcome'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared hit=6 read=326
15. 39.397 39.397 ↓ 1.4 165,764 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_10 (cost=0.69..5,360.69 rows=120,708 width=24) (actual time=0.067..39.397 rows=165,764 loops=1)

  • Index Cond: ((location_fragment = '/welcome'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 34
  • Buffers: shared hit=2021
16. 47.769 47.769 ↓ 1.3 199,044 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_11 (cost=0.81..6,748.66 rows=153,306 width=24) (actual time=0.067..47.769 rows=199,044 loops=1)

  • Index Cond: ((location_fragment = '/welcome'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 22
  • Buffers: shared hit=2989
17. 423.977 797.568 ↓ 5.5 2,139,967 1

Sort (cost=53,726.94..54,706.72 rows=391,911 width=24) (actual time=636.100..797.568 rows=2,139,967 loops=1)

  • Sort Key: o_4.person_id
  • Sort Method: quicksort Memory: 65952kB
  • Buffers: shared hit=6813 read=162
18. 45.271 373.591 ↓ 1.4 529,602 1

Append (cost=0.00..17,318.08 rows=391,911 width=24) (actual time=2.113..373.591 rows=529,602 loops=1)

  • Buffers: shared hit=6813 read=162
19. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_4 (cost=0.00..0.00 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone) AND ((location_fragment)::text = '/quick-entry/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
20. 204.958 204.958 ↓ 1.9 15,301 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_5 (cost=0.55..362.29 rows=7,878 width=24) (actual time=2.108..204.958 rows=15,301 loops=1)

  • Index Cond: ((location_fragment = '/quick-entry/section'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared hit=4 read=162
21. 44.347 44.347 ↓ 1.4 186,762 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_6 (cost=0.69..6,009.51 rows=135,333 width=24) (actual time=0.048..44.347 rows=186,762 loops=1)

  • Index Cond: ((location_fragment = '/quick-entry/section'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 33
  • Buffers: shared hit=2282
22. 79.011 79.011 ↓ 1.3 327,539 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_locfragtit_ts_pi on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_7 (cost=0.81..10,946.28 rows=248,699 width=24) (actual time=0.043..79.011 rows=327,539 loops=1)

  • Index Cond: ((location_fragment = '/quick-entry/section'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-03-28 03:59:59.999'::timestamp without time zone))
  • Heap Fetches: 30
  • Buffers: shared hit=4527
Planning time : 102.775 ms
Execution time : 3,729.843 ms