explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1E9v

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 5,351.885 ↑ 4.6 15 1

Sort (cost=190,333.99..190,334.16 rows=69 width=593) (actual time=5,351.883..5,351.885 rows=15 loops=1)

  • Sort Key: a.navigationstarttime DESC
  • Sort Method: quicksort Memory: 34kB
2. 140.061 5,351.839 ↑ 4.6 15 1

Merge Right Join (cost=168,999.46..190,331.88 rows=69 width=593) (actual time=5,346.980..5,351.839 rows=15 loops=1)

  • Merge Cond: ((nveventsrecordtable_kohls.sid = a.sid) AND (nveventsrecordtable_kohls.pageinstance = a.pageinstance))
3. 559.782 4,708.246 ↓ 3.9 726,709 1

GroupAggregate (cost=168,992.32..187,551.71 rows=184,788 width=20) (actual time=3,992.497..4,708.246 rows=726,709 loops=1)

  • Group Key: nveventsrecordtable_kohls.sid, nveventsrecordtable_kohls.pageinstance
4. 1,794.438 4,148.464 ↑ 1.0 1,081,475 1

Sort (cost=168,992.32..171,700.57 rows=1,083,303 width=20) (actual time=3,992.468..4,148.464 rows=1,081,475 loops=1)

  • Sort Key: nveventsrecordtable_kohls.sid, nveventsrecordtable_kohls.pageinstance
  • Sort Method: external sort Disk: 35952kB
5. 90.748 2,354.026 ↑ 1.0 1,081,476 1

Append (cost=0.00..38,189.41 rows=1,083,303 width=20) (actual time=12.530..2,354.026 rows=1,081,476 loops=1)

6. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on nveventsrecordtable_kohls (cost=0.00..0.00 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
7. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nveventsrecordtable_2019_kohls (cost=0.00..0.00 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
8. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nveventsrecordtable_09_2019_kohls (cost=0.00..0.00 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
9. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nveventsrecordtable_10_2019_kohls (cost=0.00..0.00 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
10. 72.814 72.814 ↓ 6.4 386 1

Index Scan using nveventsrecordtable_20190929200123_kohls_timestamp_idx on nveventsrecordtable_20190929200123_kohls (cost=0.42..35.02 rows=60 width=21) (actual time=12.526..72.814 rows=386 loops=1)

  • Index Cond: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
11. 101.630 101.630 ↓ 6.6 159 1

Index Scan using nveventsrecordtable_20190929200030_1_kohls_timestamp_idx on nveventsrecordtable_20190929200030_1_kohls (cost=0.42..17.66 rows=24 width=21) (actual time=18.495..101.630 rows=159 loops=1)

  • Index Cond: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
12. 59.843 59.843 ↓ 1.0 18,575 1

Seq Scan on nveventsrecordtable_20190930000128_kohls (cost=0.00..639.46 rows=18,564 width=20) (actual time=4.182..59.843 rows=18,575 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
13. 89.037 89.037 ↓ 1.0 20,887 1

Seq Scan on nveventsrecordtable_20190930000033_1_kohls (cost=0.00..726.18 rows=20,879 width=20) (actual time=13.239..89.037 rows=20,887 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
14. 149.915 149.915 ↑ 1.0 41,110 1

Seq Scan on nveventsrecordtable_20190930040128_kohls (cost=0.00..1,429.99 rows=41,133 width=20) (actual time=10.150..149.915 rows=41,110 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
15. 145.819 145.819 ↑ 1.0 41,579 1

Seq Scan on nveventsrecordtable_20190930040033_1_kohls (cost=0.00..1,481.73 rows=41,582 width=20) (actual time=0.018..145.819 rows=41,579 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
16. 204.113 204.113 ↑ 1.0 135,490 1

Seq Scan on nveventsrecordtable_20190930080129_kohls (cost=0.00..4,758.81 rows=135,521 width=20) (actual time=12.338..204.113 rows=135,490 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
17. 210.968 210.968 ↑ 1.0 136,700 1

Seq Scan on nveventsrecordtable_20190930080033_1_kohls (cost=0.00..4,848.76 rows=137,317 width=20) (actual time=10.136..210.968 rows=136,700 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
18. 142.981 142.981 ↓ 1.0 130,065 1

Seq Scan on nveventsrecordtable_20190930120129_kohls (cost=0.00..4,561.48 rows=129,965 width=20) (actual time=6.969..142.981 rows=130,065 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
19. 189.023 189.023 ↑ 1.0 134,222 1

Seq Scan on nveventsrecordtable_20190930120033_1_kohls (cost=0.00..4,722.89 rows=134,259 width=20) (actual time=16.495..189.023 rows=134,222 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
20. 125.640 125.640 ↑ 1.0 116,417 1

Seq Scan on nveventsrecordtable_20190930160130_kohls (cost=0.00..4,091.98 rows=116,532 width=20) (actual time=13.394..125.640 rows=116,417 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
21. 288.606 288.606 ↑ 1.0 118,115 1

Seq Scan on nveventsrecordtable_20190930160033_1_kohls (cost=0.00..4,191.73 rows=118,115 width=20) (actual time=15.129..288.606 rows=118,115 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
22. 186.217 186.217 ↑ 1.0 94,435 1

Seq Scan on nveventsrecordtable_20190930200130_kohls (cost=0.00..3,326.50 rows=94,459 width=21) (actual time=10.991..186.217 rows=94,435 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
  • Rows Removed by Filter: 134
23. 296.602 296.602 ↑ 1.0 93,336 1

Seq Scan on nveventsrecordtable_20190930200034_1_kohls (cost=0.00..3,340.62 rows=94,887 width=20) (actual time=13.382..296.602 rows=93,336 loops=1)

  • Filter: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
  • Rows Removed by Filter: 131
24. 0.056 0.056 ↓ 0.0 0 1

Index Scan using nveventsrecordtable_20191001000130_kohls_timestamp_idx on nveventsrecordtable_20191001000130_kohls (cost=0.29..8.30 rows=1 width=20) (actual time=0.056..0.056 rows=0 loops=1)

  • Index Cond: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
25. 0.013 0.013 ↓ 0.0 0 1

Index Scan using nveventsrecordtable_20191001000044_1_kohls_timestamp_idx on nveventsrecordtable_20191001000044_1_kohls (cost=0.29..8.30 rows=1 width=21) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (("timestamp" >= 181285200) AND ("timestamp" <= 181371600))
26. 0.122 503.532 ↑ 1.0 15 1

Sort (cost=7.14..7.18 rows=15 width=561) (actual time=503.524..503.532 rows=15 loops=1)

  • Sort Key: a.sid, a.pageinstance
  • Sort Method: quicksort Memory: 34kB
27. 0.010 503.410 ↑ 1.0 15 1

Limit (cost=6.36..6.70 rows=15 width=561) (actual time=417.499..503.410 rows=15 loops=1)

28. 0.147 503.400 ↑ 4,569,280,475.1 15 1

Nested Loop (cost=6.36..1,566,131,129.21 rows=68,539,207,127 width=561) (actual time=417.496..503.400 rows=15 loops=1)

29. 0.039 8.133 ↑ 470,322.6 15 1

Merge Append (cost=6.36..2,619,855.43 rows=7,054,839 width=519) (actual time=7.835..8.133 rows=15 loops=1)

  • Sort Key: a.navigationstarttime DESC
30. 0.022 0.022 ↓ 0.0 0 1

Index Scan Backward using rumpagetable_09_2019_kohls_navigationstarttime_idx on rumpagetable_09_2019_kohls a (cost=0.12..8.14 rows=1 width=254) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
31. 0.033 0.033 ↑ 512.0 1 1

Index Scan Backward using rumpagetable_20190929200123_kohls_navigationstarttime_idx on rumpagetable_20190929200123_kohls a_1 (cost=0.43..340.98 rows=512 width=521) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
32. 0.031 0.031 ↑ 206.0 1 1

Index Scan Backward using rumpagetable_20190929200030_1_kohls_navigationstarttime_idx on rumpagetable_20190929200030_1_kohls a_2 (cost=0.43..132.90 rows=206 width=520) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
33. 0.032 0.032 ↑ 185,804.0 1 1

Index Scan Backward using rumpagetable_20190930000128_kohls_navigationstarttime_idx on rumpagetable_20190930000128_kohls a_3 (cost=0.42..64,877.14 rows=185,804 width=506) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
34. 0.036 0.036 ↑ 195,056.0 1 1

Index Scan Backward using rumpagetable_20190930000033_1_kohls_navigationstarttime_idx on rumpagetable_20190930000033_1_kohls a_4 (cost=0.42..71,950.91 rows=195,056 width=509) (actual time=0.036..0.036 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
35. 0.029 0.029 ↑ 298,704.0 1 1

Index Scan Backward using rumpagetable_20190930040128_kohls_navigationstarttime_idx on rumpagetable_20190930040128_kohls a_5 (cost=0.42..93,405.33 rows=298,704 width=527) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
36. 0.029 0.029 ↑ 290,714.0 1 1

Index Scan Backward using rumpagetable_20190930040033_1_kohls_navigationstarttime_idx on rumpagetable_20190930040033_1_kohls a_6 (cost=0.42..93,478.74 rows=290,714 width=530) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
37. 0.052 0.052 ↑ 827,970.0 1 1

Index Scan Backward using rumpagetable_20190930080129_kohls_navigationstarttime_idx on rumpagetable_20190930080129_kohls a_7 (cost=0.42..263,486.55 rows=827,970 width=517) (actual time=0.052..0.052 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
38. 0.043 0.043 ↑ 826,906.0 1 1

Index Scan Backward using rumpagetable_20190930080033_1_kohls_navigationstarttime_idx on rumpagetable_20190930080033_1_kohls a_8 (cost=0.42..262,130.84 rows=826,906 width=517) (actual time=0.043..0.043 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
39. 0.053 0.053 ↑ 811,982.0 1 1

Index Scan Backward using rumpagetable_20190930120129_kohls_navigationstarttime_idx on rumpagetable_20190930120129_kohls a_9 (cost=0.42..254,267.88 rows=811,982 width=518) (actual time=0.053..0.053 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
40. 0.023 0.023 ↑ 832,033.0 1 1

Index Scan Backward using rumpagetable_20190930120033_1_kohls_navigationstarttime_idx on rumpagetable_20190930120033_1_kohls a_10 (cost=0.42..260,599.33 rows=832,033 width=518) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
41. 0.036 0.036 ↑ 753,234.0 1 1

Index Scan Backward using rumpagetable_20190930160130_kohls_navigationstarttime_idx on rumpagetable_20190930160130_kohls a_11 (cost=0.42..239,008.18 rows=753,234 width=520) (actual time=0.036..0.036 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
42. 0.028 0.028 ↑ 768,961.0 1 1

Index Scan Backward using rumpagetable_20190930160033_1_kohls_navigationstarttime_idx on rumpagetable_20190930160033_1_kohls a_12 (cost=0.42..246,551.50 rows=768,961 width=521) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
43. 3.571 3.571 ↑ 42,564.9 15 1

Index Scan Backward using rumpagetable_20190930200130_kohls_navigationstarttime_idx on rumpagetable_20190930200130_kohls a_13 (cost=0.42..240,593.76 rows=638,473 width=519) (actual time=3.288..3.571 rows=15 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
44. 4.076 4.076 ↑ 624,283.0 1 1

Index Scan Backward using rumpagetable_20190930200034_1_kohls_navigationstarttime_idx on rumpagetable_20190930200034_1_kohls a_14 (cost=0.42..235,761.03 rows=624,283 width=518) (actual time=4.076..4.076 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 181285200) AND (navigationstarttime < 181371600))
45. 0.593 495.120 ↑ 15.0 1 15

Append (cost=0.00..51.46 rows=15 width=79) (actual time=28.684..33.008 rows=1 loops=15)

46. 0.000 0.000 ↓ 0.0 0 15

Seq Scan on rumsessiontable_09_2019_kohls b (cost=0.00..0.00 rows=1 width=416) (actual time=0.000..0.000 rows=0 loops=15)

  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600) AND (a.sid = sid))
47. 30.360 30.360 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190929200123_kohls_sid_idx on rumsessiontable_20190929200123_kohls b_1 (cost=0.42..3.68 rows=1 width=55) (actual time=2.024..2.024 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
48. 38.595 38.595 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190929200030_1_kohls_sid_idx on rumsessiontable_20190929200030_1_kohls b_2 (cost=0.42..3.68 rows=1 width=54) (actual time=2.573..2.573 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
49. 42.135 42.135 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930000128_kohls_sid_idx on rumsessiontable_20190930000128_kohls b_3 (cost=0.42..3.67 rows=1 width=53) (actual time=2.809..2.809 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
50. 64.485 64.485 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930000033_1_kohls_sid_idx on rumsessiontable_20190930000033_1_kohls b_4 (cost=0.42..3.67 rows=1 width=53) (actual time=4.299..4.299 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
51. 25.185 25.185 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930040128_kohls_sid_idx on rumsessiontable_20190930040128_kohls b_5 (cost=0.42..3.67 rows=1 width=54) (actual time=1.679..1.679 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
52. 27.075 27.075 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930040033_1_kohls_sid_idx on rumsessiontable_20190930040033_1_kohls b_6 (cost=0.42..3.67 rows=1 width=54) (actual time=1.805..1.805 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
53. 32.985 32.985 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930080129_kohls_sid_idx on rumsessiontable_20190930080129_kohls b_7 (cost=0.42..3.68 rows=1 width=55) (actual time=2.199..2.199 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
54. 30.795 30.795 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930080033_1_kohls_sid_idx on rumsessiontable_20190930080033_1_kohls b_8 (cost=0.42..3.68 rows=1 width=55) (actual time=2.053..2.053 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
55. 19.425 19.425 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930120129_kohls_sid_idx on rumsessiontable_20190930120129_kohls b_9 (cost=0.42..3.68 rows=1 width=55) (actual time=1.295..1.295 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
56. 23.160 23.160 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930120033_1_kohls_sid_idx on rumsessiontable_20190930120033_1_kohls b_10 (cost=0.42..3.68 rows=1 width=55) (actual time=1.544..1.544 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
57. 10.275 10.275 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930160130_kohls_sid_idx on rumsessiontable_20190930160130_kohls b_11 (cost=0.42..3.68 rows=1 width=55) (actual time=0.685..0.685 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
58. 36.135 36.135 ↓ 0.0 0 15

Index Scan using rumsessiontable_20190930160033_1_kohls_sid_idx on rumsessiontable_20190930160033_1_kohls b_12 (cost=0.42..3.68 rows=1 width=55) (actual time=2.409..2.409 rows=0 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
59. 49.125 49.125 ↑ 1.0 1 15

Index Scan using rumsessiontable_20190930200130_kohls_sid_idx on rumsessiontable_20190930200130_kohls b_13 (cost=0.42..3.68 rows=1 width=55) (actual time=3.274..3.275 rows=1 loops=15)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
60. 64.792 64.792 ↓ 0.0 0 14

Index Scan using rumsessiontable_20190930200034_1_kohls_sid_idx on rumsessiontable_20190930200034_1_kohls b_14 (cost=0.42..3.68 rows=1 width=55) (actual time=4.628..4.628 rows=0 loops=14)

  • Index Cond: (sid = a.sid)
  • Filter: ((sessionstarttime >= 181285200) AND (sessionstarttime <= 181371600))
Planning time : 7,845.122 ms
Execution time : 5,364.538 ms