explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XM9D

Settings
# exclusive inclusive rows x rows loops node
1. 21.307 16,803.306 ↑ 1.0 1 1

Aggregate (cost=60,003,350,439.52..60,003,350,439.53 rows=1 width=56) (actual time=16,803.306..16,803.306 rows=1 loops=1)

  • Buffers: shared hit=27270511
2. 54.687 16,781.999 ↑ 1.3 92,142 1

Nested Loop Left Join (cost=60,000,006,248.95..60,003,348,326.94 rows=120,719 width=28) (actual time=90.849..16,781.999 rows=92,142 loops=1)

  • Buffers: shared hit=27270511
3. 17.449 16,266.602 ↑ 1.3 92,142 1

Nested Loop Left Join (cost=50,000,006,244.81..50,002,845,532.30 rows=120,719 width=48) (actual time=90.841..16,266.602 rows=92,142 loops=1)

  • Buffers: shared hit=27039187
4. 29.031 14,774.881 ↑ 1.3 92,142 1

Nested Loop Left Join (cost=40,000,006,240.13..40,002,278,153.00 rows=120,719 width=44) (actual time=90.833..14,774.881 rows=92,142 loops=1)

  • Buffers: shared hit=24043853
5. 13.053 12,626.584 ↑ 1.3 92,142 1

Nested Loop Left Join (cost=30,000,006,235.46..30,001,710,773.70 rows=120,719 width=40) (actual time=90.782..12,626.584 rows=92,142 loops=1)

  • Buffers: shared hit=19334158
6. 21.230 10,125.697 ↑ 1.3 92,142 1

Nested Loop Left Join (cost=20,000,006,230.78..20,001,143,394.40 rows=120,719 width=36) (actual time=90.721..10,125.697 rows=92,142 loops=1)

  • Buffers: shared hit=13771535
7. 23.026 7,155.923 ↑ 1.3 92,142 1

Nested Loop Left Join (cost=10,000,006,226.10..10,000,576,015.10 rows=120,719 width=32) (actual time=90.650..7,155.923 rows=92,142 loops=1)

  • Buffers: shared hit=7241465
8. 78.099 130.105 ↑ 1.3 92,142 1

HashAggregate (cost=6,221.42..7,428.61 rows=120,719 width=28) (actual time=90.466..130.105 rows=92,142 loops=1)

  • Group Key: o.person_id
  • Buffers: shared hit=1998
9. 12.437 52.006 ↓ 1.4 165,764 1

Append (cost=0.00..5,617.83 rows=120,719 width=24) (actual time=0.042..52.006 rows=165,764 loops=1)

  • Buffers: shared hit=1998
10. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND ((location_fragment)::text = '/welcome'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
11. 39.565 39.565 ↓ 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_1 (cost=0.69..5,617.83 rows=120,718 width=24) (actual time=0.037..39.565 rows=165,764 loops=1)

  • Index Cond: ((location_fragment = '/welcome'::text) AND (page_title = 'H&R Block 2018'::text) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone))
  • Heap Fetches: 10
  • Buffers: shared hit=1998
12. 92.142 7,002.792 ↑ 1.0 1 92,142

Limit (cost=4.68..4.68 rows=1 width=28) (actual time=0.075..0.076 rows=1 loops=92,142)

  • Buffers: shared hit=7239467
13. 92.142 6,910.650 ↑ 2.0 1 92,142

Sort (cost=4.68..4.68 rows=2 width=28) (actual time=0.075..0.075 rows=1 loops=92,142)

  • Sort Key: o_2.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7239467
14. 0.000 6,818.508 ↑ 1.0 2 92,142

Result (cost=0.00..4.67 rows=2 width=28) (actual time=0.015..0.074 rows=2 loops=92,142)

  • Buffers: shared hit=7239464
15. 92.142 6,818.508 ↑ 1.0 2 92,142

Append (cost=0.00..4.65 rows=2 width=24) (actual time=0.015..0.074 rows=2 loops=92,142)

  • Buffers: shared hit=7239464
16. 0.000 0.000 ↓ 0.0 0 92,142

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_2 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=92,142)

  • Filter: ((timestamp_ >= (min(o.timestamp_))) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (person_id = o.person_id) AND ((location_fragment)::text = '/home/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
17. 6,726.366 6,726.366 ↓ 2.0 2 92,142

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_3 (cost=0.56..4.65 rows=1 width=24) (actual time=0.014..0.073 rows=2 loops=92,142)

  • Index Cond: ((person_id = o.person_id) AND (timestamp_ >= (min(o.timestamp_))) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/home/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 77
  • Buffers: shared hit=7239464
18. 92.142 2,948.544 ↑ 1.0 1 92,142

Limit (cost=4.68..4.68 rows=1 width=28) (actual time=0.031..0.032 rows=1 loops=92,142)

  • Buffers: shared hit=6530070
19. 92.142 2,856.402 ↑ 2.0 1 92,142

Sort (cost=4.68..4.68 rows=2 width=28) (actual time=0.031..0.031 rows=1 loops=92,142)

  • Sort Key: o_4.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6530070
20. 0.000 2,764.260 ↑ 1.0 2 92,142

Result (cost=0.00..4.67 rows=2 width=28) (actual time=0.009..0.030 rows=2 loops=92,142)

  • Buffers: shared hit=6530070
21. 92.142 2,764.260 ↑ 1.0 2 92,142

Append (cost=0.00..4.65 rows=2 width=24) (actual time=0.008..0.030 rows=2 loops=92,142)

  • Buffers: shared hit=6530070
22. 0.000 0.000 ↓ 0.0 0 92,142

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_4 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=92,142)

  • Filter: ((timestamp_ >= o_2.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (person_id = o_2.person_id) AND ((location_fragment)::text = '/quick-entry/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
23. 2,672.118 2,672.118 ↓ 2.0 2 92,142

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_5 (cost=0.56..4.65 rows=1 width=24) (actual time=0.008..0.029 rows=2 loops=92,142)

  • Index Cond: ((person_id = o_2.person_id) AND (timestamp_ >= o_2.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/quick-entry/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 68
  • Buffers: shared hit=6530070
24. 92.142 2,487.834 ↑ 1.0 1 92,142

Limit (cost=4.68..4.68 rows=1 width=28) (actual time=0.026..0.027 rows=1 loops=92,142)

  • Buffers: shared hit=5562623
25. 92.142 2,395.692 ↑ 2.0 1 92,142

Sort (cost=4.68..4.68 rows=2 width=28) (actual time=0.026..0.026 rows=1 loops=92,142)

  • Sort Key: o_6.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5562623
26. 0.000 2,303.550 ↑ 1.0 2 92,142

Result (cost=0.00..4.67 rows=2 width=28) (actual time=0.008..0.025 rows=2 loops=92,142)

  • Buffers: shared hit=5562623
27. 92.142 2,303.550 ↑ 1.0 2 92,142

Append (cost=0.00..4.65 rows=2 width=24) (actual time=0.007..0.025 rows=2 loops=92,142)

  • Buffers: shared hit=5562623
28. 0.000 0.000 ↓ 0.0 0 92,142

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=92,142)

  • Filter: ((timestamp_ >= o_4.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (person_id = o_4.person_id) AND ((location_fragment)::text = '/prepare/your-year/introduction'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
29. 2,211.408 2,211.408 ↓ 2.0 2 92,142

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_7 (cost=0.56..4.65 rows=1 width=24) (actual time=0.007..0.024 rows=2 loops=92,142)

  • Index Cond: ((person_id = o_4.person_id) AND (timestamp_ >= o_4.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/prepare/your-year/introduction'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 57
  • Buffers: shared hit=5562623
30. 92.142 2,119.266 ↑ 1.0 1 92,142

Limit (cost=4.68..4.68 rows=1 width=28) (actual time=0.023..0.023 rows=1 loops=92,142)

  • Buffers: shared hit=4709695
31. 92.142 2,027.124 ↑ 2.0 1 92,142

Sort (cost=4.68..4.68 rows=2 width=28) (actual time=0.022..0.022 rows=1 loops=92,142)

  • Sort Key: o_8.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4709695
32. 0.000 1,934.982 ↑ 2.0 1 92,142

Result (cost=0.00..4.67 rows=2 width=28) (actual time=0.011..0.021 rows=1 loops=92,142)

  • Buffers: shared hit=4709695
33. 92.142 1,934.982 ↑ 2.0 1 92,142

Append (cost=0.00..4.65 rows=2 width=24) (actual time=0.010..0.021 rows=1 loops=92,142)

  • Buffers: shared hit=4709695
34. 0.000 0.000 ↓ 0.0 0 92,142

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_8 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=92,142)

  • Filter: ((timestamp_ >= o_6.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (person_id = o_6.person_id) AND ((location_fragment)::text = '/wrap-up/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
35. 1,842.840 1,842.840 ↑ 1.0 1 92,142

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_9 (cost=0.56..4.65 rows=1 width=24) (actual time=0.010..0.020 rows=1 loops=92,142)

  • Index Cond: ((person_id = o_6.person_id) AND (timestamp_ >= o_6.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/wrap-up/section'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 49
  • Buffers: shared hit=4709695
36. 92.142 1,474.272 ↓ 0.0 0 92,142

Limit (cost=4.68..4.68 rows=1 width=28) (actual time=0.016..0.016 rows=0 loops=92,142)

  • Buffers: shared hit=2995334
37. 92.142 1,382.130 ↓ 0.0 0 92,142

Sort (cost=4.68..4.68 rows=2 width=28) (actual time=0.015..0.015 rows=0 loops=92,142)

  • Sort Key: o_10.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2995334
38. 0.000 1,289.988 ↑ 2.0 1 92,142

Result (cost=0.00..4.67 rows=2 width=28) (actual time=0.010..0.014 rows=1 loops=92,142)

  • Buffers: shared hit=2995334
39. 92.142 1,289.988 ↑ 2.0 1 92,142

Append (cost=0.00..4.65 rows=2 width=24) (actual time=0.010..0.014 rows=1 loops=92,142)

  • Buffers: shared hit=2995334
40. 0.000 0.000 ↓ 0.0 0 92,142

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_10 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=92,142)

  • Filter: ((timestamp_ >= o_8.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (person_id = o_8.person_id) AND ((location_fragment)::text = '/file/file-return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
41. 1,197.846 1,197.846 ↑ 1.0 1 92,142

Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_11 (cost=0.56..4.65 rows=1 width=24) (actual time=0.009..0.013 rows=1 loops=92,142)

  • Index Cond: ((person_id = o_8.person_id) AND (timestamp_ >= o_8.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone))
  • Filter: (((location_fragment)::text = '/file/file-return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 30
  • Buffers: shared hit=2995334
42. 0.000 460.710 ↓ 0.0 0 92,142

Limit (cost=4.14..4.14 rows=1 width=28) (actual time=0.005..0.005 rows=0 loops=92,142)

  • Buffers: shared hit=231324
43. 92.142 460.710 ↓ 0.0 0 92,142

Sort (cost=4.14..4.15 rows=2 width=28) (actual time=0.005..0.005 rows=0 loops=92,142)

  • Sort Key: o_12.timestamp_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=231324
44. 0.000 368.568 ↓ 0.0 0 92,142

Result (cost=0.00..4.13 rows=2 width=28) (actual time=0.003..0.004 rows=0 loops=92,142)

  • Buffers: shared hit=231324
45. 92.142 368.568 ↓ 0.0 0 92,142

Append (cost=0.00..4.11 rows=2 width=8) (actual time=0.003..0.004 rows=0 loops=92,142)

  • Buffers: shared hit=231324
46. 0.000 0.000 ↓ 0.0 0 92,142

Seq Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc o_12 (cost=0.00..0.00 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=92,142)

  • Filter: ((timestamp_ >= o_10.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (person_id = o_10.person_id) AND ((event_name)::text = 'Filed Return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
47. 276.426 276.426 ↓ 0.0 0 92,142

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_pid_ses_ts on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_13 (cost=0.43..4.11 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=92,142)

  • Index Cond: ((person_id = o_10.person_id) AND (timestamp_ >= o_10.timestamp_) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-02-01 00:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-02-28 23:59:59.999'::timestamp without time zone))
  • Filter: (((event_name)::text = 'Filed Return'::text) AND ((page_title)::text = 'H&R Block 2018'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=231324