explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I5YY

Settings
# exclusive inclusive rows x rows loops node
1. 226.519 3,570.106 ↑ 4.6 13,703 1

HashAggregate (cost=1,680,307.79..1,680,941.27 rows=63,348 width=8) (actual time=3,567.704..3,570.106 rows=13,703 loops=1)

  • Group Key: a.storeid, a.terminalid
2. 388.477 3,343.587 ↓ 1.0 780,844 1

Hash Join (cost=81,306.05..1,674,716.45 rows=745,512 width=8) (actual time=774.620..3,343.587 rows=780,844 loops=1)

  • Hash Cond: (b.sid = a.sid)
3. 48.816 2,185.434 ↓ 1.1 784,430 1

Append (cost=0.00..1,583,159.62 rows=745,512 width=12) (actual time=0.018..2,185.434 rows=784,430 loops=1)

4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on nvusertimingtable_kohls b (cost=0.00..0.00 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint) AND (type = 3) AND (actionname = 'SaleTransaction'::text))
5. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on nvusertimingtable_2019_kohls b_1 (cost=0.00..0.00 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint) AND (type = 3) AND (actionname = 'SaleTransaction'::text))
6. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nvusertimingtable_08_2019_kohls b_2 (cost=0.00..0.00 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint) AND (type = 3) AND (actionname = 'SaleTransaction'::text))
7. 0.003 0.003 ↓ 0.0 0 1

Index Scan using nvusertimingtable_20190806160000_2_kohls_timestamp_idx on nvusertimingtable_20190806160000_2_kohls b_3 (cost=0.42..8.45 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint))
  • Filter: ((type = 3) AND (actionname = 'SaleTransaction'::text))
8. 0.056 0.056 ↓ 2.0 2 1

Index Scan using nvusertimingtable_20190806160000_kohls_timestamp_idx on nvusertimingtable_20190806160000_kohls b_4 (cost=0.43..10.70 rows=1 width=13) (actual time=0.013..0.056 rows=2 loops=1)

  • Index Cond: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint))
  • Filter: ((type = 3) AND (actionname = 'SaleTransaction'::text))
  • Rows Removed by Filter: 9
9. 0.125 0.566 ↑ 1.9 35 1

Bitmap Heap Scan on nvusertimingtable_20190807000000_2_kohls b_5 (cost=69.95..316.36 rows=66 width=13) (actual time=0.460..0.566 rows=35 loops=1)

  • Recheck Cond: ((actionname = 'SaleTransaction'::text) AND ("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint))
  • Filter: (type = 3)
  • Heap Blocks: exact=35
10. 0.046 0.441 ↓ 0.0 0 1

BitmapAnd (cost=69.95..69.95 rows=70 width=0) (actual time=0.441..0.441 rows=0 loops=1)

11. 0.117 0.117 ↑ 1.0 620 1

Bitmap Index Scan on nvusertimingtable_20190807000000_2_kohls_actionname_idx (cost=0.00..17.16 rows=649 width=0) (actual time=0.117..0.117 rows=620 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
12. 0.278 0.278 ↓ 1.1 2,702 1

Bitmap Index Scan on nvusertimingtable_20190807000000_2_kohls_timestamp_idx (cost=0.00..52.51 rows=2,422 width=0) (actual time=0.278..0.278 rows=2,702 loops=1)

  • Index Cond: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint))
13. 0.938 0.978 ↑ 1.2 266 1

Bitmap Heap Scan on nvusertimingtable_20190807000001_kohls b_6 (cost=10.77..844.83 rows=306 width=13) (actual time=0.087..0.978 rows=266 loops=1)

  • Recheck Cond: (actionname = 'SaleTransaction'::text)
  • Filter: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint) AND (type = 3))
  • Heap Blocks: exact=261
14. 0.040 0.040 ↑ 1.2 266 1

Bitmap Index Scan on nvusertimingtable_20190807000001_kohls_actionname_idx (cost=0.00..10.69 rows=321 width=0) (actual time=0.040..0.040 rows=266 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
15. 295.531 314.866 ↓ 1.0 111,705 1

Bitmap Heap Scan on nvusertimingtable_20190807070641_2_kohls b_7 (cost=2,810.64..226,723.54 rows=109,376 width=12) (actual time=39.992..314.866 rows=111,705 loops=1)

  • Recheck Cond: (actionname = 'SaleTransaction'::text)
  • Filter: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint) AND (type = 3))
  • Heap Blocks: exact=102430
16. 19.335 19.335 ↑ 1.0 111,705 1

Bitmap Index Scan on nvusertimingtable_20190807070641_2_kohls_actionname_idx (cost=0.00..2,783.29 rows=116,115 width=0) (actual time=19.335..19.335 rows=111,705 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
17. 1,042.426 1,107.902 ↓ 1.1 349,860 1

Bitmap Heap Scan on nvusertimingtable_20190807080001_kohls b_8 (cost=8,367.88..691,159.26 rows=326,400 width=12) (actual time=140.471..1,107.902 rows=349,860 loops=1)

  • Recheck Cond: (actionname = 'SaleTransaction'::text)
  • Filter: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint) AND (type = 3))
  • Heap Blocks: exact=321669
18. 65.476 65.476 ↓ 1.0 349,860 1

Bitmap Index Scan on nvusertimingtable_20190807080001_kohls_actionname_idx (cost=0.00..8,286.27 rows=346,362 width=0) (actual time=65.476..65.476 rows=349,860 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
19. 231.091 252.244 ↓ 1.0 121,357 1

Bitmap Heap Scan on nvusertimingtable_20190807150641_2_kohls b_9 (cost=2,964.71..247,891.32 rows=115,643 width=12) (actual time=43.401..252.244 rows=121,357 loops=1)

  • Recheck Cond: (actionname = 'SaleTransaction'::text)
  • Filter: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint) AND (type = 3))
  • Heap Blocks: exact=112315
20. 21.153 21.153 ↑ 1.0 121,357 1

Bitmap Index Scan on nvusertimingtable_20190807150641_2_kohls_actionname_idx (cost=0.00..2,935.79 rows=122,582 width=0) (actual time=21.153..21.153 rows=121,357 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
21. 415.386 456.304 ↓ 1.0 199,670 1

Bitmap Heap Scan on nvusertimingtable_20190807160001_kohls b_10 (cost=4,923.46..412,314.61 rows=192,365 width=13) (actual time=82.014..456.304 rows=199,670 loops=1)

  • Recheck Cond: (actionname = 'SaleTransaction'::text)
  • Filter: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint) AND (type = 3))
  • Heap Blocks: exact=184964
22. 40.918 40.918 ↑ 1.0 199,670 1

Bitmap Index Scan on nvusertimingtable_20190807160001_kohls_actionname_idx (cost=0.00..4,875.37 rows=204,125 width=0) (actual time=40.918..40.918 rows=199,670 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
23. 3.375 3.684 ↓ 1.1 1,535 1

Bitmap Heap Scan on nvusertimingtable_20190807230641_2_kohls b_11 (cost=45.62..3,882.24 rows=1,350 width=13) (actual time=0.529..3.684 rows=1,535 loops=1)

  • Recheck Cond: (actionname = 'SaleTransaction'::text)
  • Filter: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint) AND (type = 3))
  • Rows Removed by Filter: 219
  • Heap Blocks: exact=1672
24. 0.309 0.309 ↓ 1.0 1,754 1

Bitmap Index Scan on nvusertimingtable_20190807230641_2_kohls_actionname_idx (cost=0.00..45.28 rows=1,716 width=0) (actual time=0.309..0.309 rows=1,754 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
25. 0.013 0.013 ↓ 0.0 0 1

Index Scan using nvusertimingtable_20190808000001_kohls_timestamp_idx on nvusertimingtable_20190808000001_kohls b_12 (cost=0.29..8.31 rows=1 width=13) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint))
  • Filter: ((type = 3) AND (actionname = 'SaleTransaction'::text))
26. 192.568 769.676 ↓ 1.0 644,102 1

Hash (cost=73,387.60..73,387.60 rows=633,476 width=20) (actual time=769.676..769.676 rows=644,102 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 41530kB
27. 37.202 577.108 ↓ 1.0 644,102 1

Append (cost=0.00..73,387.60 rows=633,476 width=20) (actual time=0.037..577.108 rows=644,102 loops=1)

28. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
29. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
30. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
31. 0.030 0.030 ↓ 0.0 0 1

Index Scan using rumsessiontable_20190806160000_2_kohls_sessionstarttime_idx on rumsessiontable_20190806160000_2_kohls a_3 (cost=0.28..8.30 rows=1 width=20) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
32. 0.030 0.030 ↓ 3.0 3 1

Index Scan using rumsessiontable_20190806160000_kohls_sessionstarttime_idx on rumsessiontable_20190806160000_kohls a_4 (cost=0.42..8.44 rows=1 width=21) (actual time=0.007..0.030 rows=3 loops=1)

  • Index Cond: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
33. 60.375 60.375 ↓ 1.0 54,804 1

Seq Scan on rumsessiontable_20190807000000_2_kohls a_5 (cost=0.00..8,590.86 rows=54,708 width=20) (actual time=3.421..60.375 rows=54,804 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
  • Rows Removed by Filter: 2387
34. 136.002 136.002 ↑ 1.0 169,885 1

Seq Scan on rumsessiontable_20190807000001_kohls a_6 (cost=0.00..20,057.28 rows=169,885 width=20) (actual time=0.012..136.002 rows=169,885 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
35. 62.441 62.441 ↑ 1.0 73,305 1

Seq Scan on rumsessiontable_20190807070641_2_kohls a_7 (cost=0.00..8,183.57 rows=73,305 width=20) (actual time=0.027..62.441 rows=73,305 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
36. 105.211 105.211 ↑ 1.0 125,511 1

Seq Scan on rumsessiontable_20190807080001_kohls a_8 (cost=0.00..13,816.67 rows=125,511 width=20) (actual time=0.019..105.211 rows=125,511 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
37. 55.099 55.099 ↑ 1.0 69,659 1

Seq Scan on rumsessiontable_20190807150641_2_kohls a_9 (cost=0.00..7,251.89 rows=69,659 width=20) (actual time=0.028..55.099 rows=69,659 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
38. 109.497 109.497 ↑ 1.0 140,222 1

Seq Scan on rumsessiontable_20190807160001_kohls a_10 (cost=0.00..14,887.48 rows=140,231 width=20) (actual time=0.019..109.497 rows=140,222 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
  • Rows Removed by Filter: 10
39. 9.931 11.210 ↓ 62.6 10,713 1

Bitmap Heap Scan on rumsessiontable_20190807230641_2_kohls a_11 (cost=6.04..574.80 rows=171 width=28) (actual time=1.444..11.210 rows=10,713 loops=1)

  • Recheck Cond: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
  • Heap Blocks: exact=1290
40. 1.279 1.279 ↓ 62.6 10,713 1

Bitmap Index Scan on rumsessiontable_20190807230641_2_kohls_sessionstarttime_idx (cost=0.00..6.00 rows=171 width=0) (actual time=1.279..1.279 rows=10,713 loops=1)

  • Index Cond: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
41. 0.011 0.011 ↓ 0.0 0 1

Index Scan using rumsessiontable_20190808000001_kohls_sessionstarttime_idx on rumsessiontable_20190808000001_kohls a_12 (cost=0.29..8.31 rows=1 width=21) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
Planning time : 2,742.214 ms
Execution time : 3,575.258 ms