explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w8le

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 3,838.962 ↑ 1.0 15 1

Limit (cost=42,574.51..85,136.13 rows=15 width=701) (actual time=2,887.870..3,838.962 rows=15 loops=1)

2. 1,653.459 3,838.928 ↑ 43,039.1 30 1

Nested Loop Left Join (cost=12.89..3,663,630,335.91 rows=1,291,174 width=701) (actual time=1,834.147..3,838.928 rows=30 loops=1)

  • Join Filter: (rumsessiontable_kohls.sid = inq2.sid)
  • Rows Removed by Join Filter: 9085132
3. 0.082 1.079 ↑ 43,039.1 30 1

Merge Append (cost=6.21..217,601.52 rows=1,291,174 width=669) (actual time=0.428..1.079 rows=30 loops=1)

  • Sort Key: rumsessiontable_kohls.sessionstarttime DESC
4. 0.029 0.029 ↓ 0.0 0 1

Index Scan Backward using session_sessionstarttime_kohls on rumsessiontable_kohls (cost=0.12..8.14 rows=1 width=1,722) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
5. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using rumsessiontable_2019_kohls_sessionstarttime_idx on rumsessiontable_2019_kohls (cost=0.12..8.14 rows=1 width=1,722) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
6. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using rumsessiontable_10_2019_kohls_sessionstarttime_idx on rumsessiontable_10_2019_kohls (cost=0.12..8.14 rows=1 width=1,722) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
7. 0.039 0.039 ↑ 73.0 1 1

Index Scan Backward using rumsessiontable_20191002200200_kohls_sessionstarttime_idx on rumsessiontable_20191002200200_kohls (cost=0.29..29.29 rows=73 width=673) (actual time=0.039..0.039 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
8. 0.032 0.032 ↑ 27.0 1 1

Index Scan Backward using rumsessiontable_20191002200048_1_kohls_sessionstarttime_idx on rumsessiontable_20191002200048_1_kohls (cost=0.29..15.94 rows=27 width=672) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
9. 0.024 0.024 ↑ 31,830.0 1 1

Index Scan Backward using rumsessiontable_20191003000201_kohls_sessionstarttime_idx on rumsessiontable_20191003000201_kohls (cost=0.29..3,911.59 rows=31,830 width=660) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
10. 0.016 0.016 ↑ 32,725.0 1 1

Index Scan Backward using rumsessiontable_20191003000050_1_kohls_sessionstarttime_idx on rumsessiontable_20191003000050_1_kohls (cost=0.29..4,024.00 rows=32,725 width=660) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
11. 0.013 0.013 ↑ 67,404.0 1 1

Index Scan Backward using rumsessiontable_20191003040205_kohls_sessionstarttime_idx on rumsessiontable_20191003040205_kohls (cost=0.29..8,254.03 rows=67,404 width=667) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
12. 0.022 0.022 ↑ 66,653.0 1 1

Index Scan Backward using rumsessiontable_20191003040050_1_kohls_sessionstarttime_idx on rumsessiontable_20191003040050_1_kohls (cost=0.29..8,161.88 rows=66,653 width=666) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
13. 0.031 0.031 ↑ 141,649.0 1 1

Index Scan Backward using rumsessiontable_20191003080208_kohls_sessionstarttime_idx on rumsessiontable_20191003080208_kohls (cost=0.42..17,478.91 rows=141,649 width=669) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
14. 0.016 0.016 ↑ 154,517.0 1 1

Index Scan Backward using rumsessiontable_20191003080050_1_kohls_sessionstarttime_idx on rumsessiontable_20191003080050_1_kohls (cost=0.42..19,144.06 rows=154,517 width=669) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
15. 0.052 0.052 ↑ 159,644.0 1 1

Index Scan Backward using rumsessiontable_20191003120213_kohls_sessionstarttime_idx on rumsessiontable_20191003120213_kohls (cost=0.42..19,540.71 rows=159,644 width=668) (actual time=0.052..0.052 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
16. 0.020 0.020 ↑ 166,088.0 1 1

Index Scan Backward using rumsessiontable_20191003120050_1_kohls_sessionstarttime_idx on rumsessiontable_20191003120050_1_kohls (cost=0.42..20,402.62 rows=166,088 width=669) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
17. 0.017 0.017 ↑ 125,375.0 1 1

Index Scan Backward using rumsessiontable_20191003160221_kohls_sessionstarttime_idx on rumsessiontable_20191003160221_kohls (cost=0.42..15,390.02 rows=125,375 width=670) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
18. 0.018 0.018 ↑ 142,595.0 1 1

Index Scan Backward using rumsessiontable_20191003160058_1_kohls_sessionstarttime_idx on rumsessiontable_20191003160058_1_kohls (cost=0.42..17,537.56 rows=142,595 width=670) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
19. 0.247 0.247 ↑ 8,437.8 12 1

Index Scan Backward using rumsessiontable_20191003200223_kohls_sessionstarttime_idx on rumsessiontable_20191003200223_kohls (cost=0.29..12,757.77 rows=101,253 width=672) (actual time=0.040..0.247 rows=12 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
20. 0.401 0.401 ↑ 5,333.5 19 1

Index Scan Backward using rumsessiontable_20191003200058_1_kohls_sessionstarttime_idx on rumsessiontable_20191003200058_1_kohls (cost=0.29..12,835.62 rows=101,336 width=672) (actual time=0.031..0.401 rows=19 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
21. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using rumsessiontable_20191004000228_kohls_sessionstarttime_idx on rumsessiontable_20191004000228_kohls (cost=0.29..8.31 rows=1 width=662) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
22. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using rumsessiontable_20191004000058_1_kohls_sessionstarttime_idx on rumsessiontable_20191004000058_1_kohls (cost=0.29..8.31 rows=1 width=661) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 181544400) AND (sessionstarttime <= 181630740))
23. 488.728 2,184.390 ↓ 1.6 302,838 30

Materialize (cost=6.69..145,981.42 rows=189,144 width=44) (actual time=2.773..72.813 rows=302,838 loops=30)

24. 34.422 1,695.662 ↓ 1.6 302,838 1

Subquery Scan on inq2 (cost=6.69..145,035.70 rows=189,144 width=44) (actual time=83.160..1,695.662 rows=302,838 loops=1)

25. 458.761 1,661.240 ↓ 1.6 302,838 1

GroupAggregate (cost=6.69..143,144.26 rows=189,144 width=16) (actual time=83.159..1,661.240 rows=302,838 loops=1)

  • Group Key: nveventsrecordtable_kohls.sid
26. 327.436 1,202.479 ↑ 1.0 1,034,082 1

Merge Append (cost=6.69..130,408.36 rows=1,037,160 width=16) (actual time=83.123..1,202.479 rows=1,034,082 loops=1)

  • Sort Key: nveventsrecordtable_kohls.sid
27. 0.007 0.007 ↓ 0.0 0 1

Index Scan using event_sid_kohls on nveventsrecordtable_kohls (cost=0.12..8.14 rows=1 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
28. 0.002 0.002 ↓ 0.0 0 1

Index Scan using nveventsrecordtable_2019_kohls_sid_idx on nveventsrecordtable_2019_kohls (cost=0.12..8.14 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
29. 0.003 0.003 ↓ 0.0 0 1

Index Scan using nveventsrecordtable_10_2019_kohls_sid_idx on nveventsrecordtable_10_2019_kohls (cost=0.12..8.14 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
30. 50.577 50.577 ↓ 4.9 228 1

Index Scan using nveventsrecordtable_20191002200200_kohls_sid_idx on nveventsrecordtable_20191002200200_kohls (cost=0.42..5,550.11 rows=47 width=16) (actual time=36.470..50.577 rows=228 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
  • Rows Removed by Filter: 76451
31. 58.943 58.943 ↓ 5.6 106 1

Index Scan using nveventsrecordtable_20191002200048_1_kohls_sid_idx on nveventsrecordtable_20191002200048_1_kohls (cost=0.42..5,707.80 rows=19 width=16) (actual time=45.963..58.943 rows=106 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
  • Rows Removed by Filter: 77981
32. 16.019 16.019 ↓ 1.0 15,505 1

Index Scan using nveventsrecordtable_20191003000201_kohls_sid_idx on nveventsrecordtable_20191003000201_kohls (cost=0.29..1,138.72 rows=15,442 width=17) (actual time=0.038..16.019 rows=15,505 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
33. 16.493 16.493 ↑ 1.0 15,961 1

Index Scan using nveventsrecordtable_20191003000050_1_kohls_sid_idx on nveventsrecordtable_20191003000050_1_kohls (cost=0.29..1,137.81 rows=15,989 width=17) (actual time=0.028..16.493 rows=15,961 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
34. 38.826 38.826 ↓ 1.0 43,715 1

Index Scan using nveventsrecordtable_20191003040205_kohls_sid_idx on nveventsrecordtable_20191003040205_kohls (cost=0.29..3,023.53 rows=43,685 width=16) (actual time=0.042..38.826 rows=43,715 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
35. 39.219 39.219 ↑ 1.0 43,899 1

Index Scan using nveventsrecordtable_20191003040050_1_kohls_sid_idx on nveventsrecordtable_20191003040050_1_kohls (cost=0.29..3,103.06 rows=43,899 width=16) (actual time=0.031..39.219 rows=43,899 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
36. 96.445 96.445 ↓ 1.0 133,328 1

Index Scan using nveventsrecordtable_20191003080208_kohls_sid_idx on nveventsrecordtable_20191003080208_kohls (cost=0.42..9,054.24 rows=133,300 width=16) (actual time=0.036..96.445 rows=133,328 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
37. 107.034 107.034 ↑ 1.0 148,866 1

Index Scan using nveventsrecordtable_20191003080050_1_kohls_sid_idx on nveventsrecordtable_20191003080050_1_kohls (cost=0.42..10,300.66 rows=150,349 width=16) (actual time=0.029..107.034 rows=148,866 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
38. 95.906 95.906 ↓ 1.0 132,661 1

Index Scan using nveventsrecordtable_20191003120213_kohls_sid_idx on nveventsrecordtable_20191003120213_kohls (cost=0.42..8,949.58 rows=132,626 width=16) (actual time=0.056..95.906 rows=132,661 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
39. 99.655 99.655 ↑ 1.0 137,565 1

Index Scan using nveventsrecordtable_20191003120050_1_kohls_sid_idx on nveventsrecordtable_20191003120050_1_kohls (cost=0.42..9,392.27 rows=137,842 width=17) (actual time=0.051..99.655 rows=137,565 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
40. 65.707 65.707 ↓ 1.0 92,192 1

Index Scan using nveventsrecordtable_20191003160221_kohls_sid_idx on nveventsrecordtable_20191003160221_kohls (cost=0.42..6,220.51 rows=92,118 width=17) (actual time=0.046..65.707 rows=92,192 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
41. 74.341 74.341 ↑ 1.0 104,446 1

Index Scan using nveventsrecordtable_20191003160058_1_kohls_sid_idx on nveventsrecordtable_20191003160058_1_kohls (cost=0.42..7,163.54 rows=104,678 width=16) (actual time=0.094..74.341 rows=104,446 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
42. 45.805 45.805 ↓ 1.0 68,587 1

Index Scan using nveventsrecordtable_20191003200223_kohls_sid_idx on nveventsrecordtable_20191003200223_kohls (cost=0.42..4,976.79 rows=68,519 width=16) (actual time=0.061..45.805 rows=68,587 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
43. 47.078 47.078 ↑ 1.0 71,407 1

Index Scan using nveventsrecordtable_20191003200058_1_kohls_sid_idx on nveventsrecordtable_20191003200058_1_kohls (cost=0.42..5,274.96 rows=72,616 width=16) (actual time=0.095..47.078 rows=71,407 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
44. 11.518 11.518 ↑ 1.0 13,115 1

Index Scan using nveventsrecordtable_20191004000228_kohls_sid_idx on nveventsrecordtable_20191004000228_kohls (cost=0.29..1,391.79 rows=13,476 width=16) (actual time=0.024..11.518 rows=13,115 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
  • Rows Removed by Filter: 6254
45. 11.465 11.465 ↑ 1.0 12,501 1

Index Scan using nveventsrecordtable_20191004000058_1_kohls_sid_idx on nveventsrecordtable_20191004000058_1_kohls (cost=0.29..1,347.46 rows=12,552 width=16) (actual time=0.029..11.465 rows=12,501 loops=1)

  • Filter: (("timestamp" >= 181544400) AND ("timestamp" <= 181637940))
  • Rows Removed by Filter: 6926
Planning time : 13,877.746 ms
Execution time : 3,846.909 ms