explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZKPE

Settings
# exclusive inclusive rows x rows loops node
1. 237.787 3,833.284 ↑ 4.7 13,703 1

HashAggregate (cost=1,681,875.29..1,682,519.37 rows=64,408 width=8) (actual time=3,830.712..3,833.284 rows=13,703 loops=1)

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

Hash Join (cost=82,838.59..1,676,283.76 rows=745,537 width=8) (actual time=843.143..3,595.497 rows=780,844 loops=1)

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

Append (cost=0.00..1,583,194.04 rows=745,537 width=12) (actual time=0.019..2,344.567 rows=784,430 loops=1)

4. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nvusertimingtable_kohls b (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))
5. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nvusertimingtable_2019_kohls b_1 (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))
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.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint))
  • Filter: ((type = 3) AND (actionname = 'SaleTransaction'::text))
8. 0.063 0.063 ↓ 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.063 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.163 0.661 ↑ 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.540..0.661 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.051 0.498 ↓ 0.0 0 1

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

11. 0.138 0.138 ↑ 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.138..0.138 rows=620 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
12. 0.309 0.309 ↓ 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.309..0.309 rows=2,702 loops=1)

  • Index Cond: (("timestamp" >= '176619600000'::bigint) AND ("timestamp" < '176705999000'::bigint))
13. 1.084 1.131 ↑ 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.104..1.131 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.047 0.047 ↑ 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.047..0.047 rows=266 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
15. 324.807 347.476 ↓ 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=46.825..347.476 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. 22.669 22.669 ↑ 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=22.669..22.669 rows=111,705 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
17. 1,121.902 1,206.148 ↓ 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=181.105..1,206.148 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. 84.246 84.246 ↓ 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=84.246..84.246 rows=349,860 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
19. 244.435 267.586 ↓ 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=47.131..267.586 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. 23.151 23.151 ↑ 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=23.151..23.151 rows=121,357 loops=1)

  • Index Cond: (actionname = 'SaleTransaction'::text)
21. 428.107 466.575 ↓ 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=80.150..466.575 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. 38.468 38.468 ↑ 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=38.468..38.468 rows=199,670 loops=1)

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

Bitmap Heap Scan on nvusertimingtable_20190807230641_2_kohls b_11 (cost=45.82..3,916.66 rows=1,375 width=13) (actual time=0.593..3.872 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.349 0.349 ↓ 1.0 1,754 1

Bitmap Index Scan on nvusertimingtable_20190807230641_2_kohls_actionname_idx (cost=0.00..45.47 rows=1,741 width=0) (actual time=0.349..0.349 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. 206.655 837.995 ↓ 1.0 644,102 1

Hash (cost=74,787.68..74,787.68 rows=644,073 width=20) (actual time=837.995..837.995 rows=644,102 loops=1)

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

Append (cost=0.00..74,787.68 rows=644,073 width=20) (actual time=0.027..631.340 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.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
32. 0.037 0.037 ↓ 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.012..0.037 rows=3 loops=1)

  • Index Cond: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
33. 64.193 64.193 ↓ 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.980..64.193 rows=54,804 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
  • Rows Removed by Filter: 2387
34. 144.684 144.684 ↑ 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.013..144.684 rows=169,885 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
35. 68.950 68.950 ↑ 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.019..68.950 rows=73,305 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
36. 111.604 111.604 ↑ 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.029..111.604 rows=125,511 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
37. 61.397 61.397 ↑ 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.025..61.397 rows=69,659 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
38. 125.342 125.342 ↑ 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.028..125.342 rows=140,222 loops=1)

  • Filter: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
  • Rows Removed by Filter: 10
39. 15.976 15.976 ↑ 1.0 10,713 1

Index Scan using rumsessiontable_20190807230641_2_kohls_sessionstarttime_idx on rumsessiontable_20190807230641_2_kohls a_11 (cost=0.29..1,974.88 rows=10,768 width=20) (actual time=0.048..15.976 rows=10,713 loops=1)

  • Index Cond: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
40. 0.012 0.012 ↓ 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=20) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 176619600) AND (sessionstarttime < 176705999))
Planning time : 678.413 ms
Execution time : 3,840.031 ms