explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5l0r

Settings
# exclusive inclusive rows x rows loops node
1. 23.471 13,674.307 ↓ 2.0 80,768 1

Hash Full Join (cost=1,609,674.15..1,731,498.69 rows=40,000 width=141) (actual time=11,700.467..13,674.307 rows=80,768 loops=1)

  • Hash Cond: (((c_7.merchant_id)::text = (products_total_sold_lifetime.merchant_id)::text) AND ((c_7.product_id)::text = (products_total_sold_lifetime.product_id)::text))
2. 35.896 13,552.965 ↓ 2.0 79,047 1

Merge Full Join (cost=1,551,473.46..1,672,998.00 rows=40,000 width=164) (actual time=11,602.579..13,552.965 rows=79,047 loops=1)

  • Merge Cond: (((p_51.merchant_id)::text = (c_7.merchant_id)::text) AND ((p_51.product_id)::text = (c_7.product_id)::text))
3. 110.088 11,424.368 ↓ 1.9 75,311 1

Finalize GroupAggregate (cost=1,380,459.15..1,497,596.81 rows=40,000 width=82) (actual time=9,824.966..11,424.368 rows=75,311 loops=1)

  • Group Key: p_51.merchant_id, p_51.product_id
4. 1,032.937 11,314.280 ↓ 1.2 140,650 1

Gather Merge (cost=1,380,459.15..1,495,896.81 rows=120,000 width=82) (actual time=9,824.935..11,314.280 rows=140,650 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 123.947 10,281.343 ↑ 1.1 35,162 4 / 4

Partial GroupAggregate (cost=1,380,449.11..1,494,260.77 rows=40,000 width=82) (actual time=9,175.376..10,281.343 rows=35,162 loops=4)

  • Group Key: p_51.merchant_id, p_51.product_id
6. 595.797 10,157.396 ↑ 6.8 576,850 4 / 4

Merge Join (cost=1,380,449.11..1,464,341.95 rows=3,922,510 width=58) (actual time=9,175.352..10,157.396 rows=576,850 loops=4)

  • Merge Cond: (((p_51.merchant_id)::text = (products_total_views_2020_09_hash_0.merchant_id)::text) AND ((p_51.product_id)::text = (products_total_views_2020_09_hash_0.product_id)::text))
7. 7,009.531 8,964.559 ↑ 1.1 1,887,598 4 / 4

Sort (cost=1,313,247.36..1,318,330.36 rows=2,033,202 width=58) (actual time=8,624.153..8,964.559 rows=1,887,598 loops=4)

  • Sort Key: p_51.merchant_id, p_51.product_id
  • Sort Method: external merge Disk: 159,040kB
  • Worker 0: Sort Method: external merge Disk: 112,992kB
  • Worker 1: Sort Method: external merge Disk: 137,512kB
  • Worker 2: Sort Method: external merge Disk: 137,184kB
8. 149.881 1,955.028 ↑ 1.1 1,887,598 4 / 4

Parallel Append (cost=0.00..1,100,215.34 rows=2,033,202 width=58) (actual time=109.022..1,955.028 rows=1,887,598 loops=4)

9. 37.439 37.439 ↓ 4.0 147,400 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_51 p_51 (cost=0.00..26,483.37 rows=36,598 width=58) (actual time=124.500..149.756 rows=147,400 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,099,906
10. 38.715 38.715 ↓ 4.2 132,925 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_7 p_7 (cost=0.00..23,410.00 rows=31,514 width=58) (actual time=131.774..154.861 rows=132,925 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 969,628
11. 52.770 52.770 ↓ 4.0 127,617 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_22 p_22 (cost=0.00..23,013.60 rows=31,549 width=58) (actual time=179.799..211.081 rows=127,617 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 956,272
12. 32.916 32.916 ↓ 4.3 130,634 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_31 p_31 (cost=0.00..22,795.89 rows=30,563 width=58) (actual time=108.856..131.666 rows=130,634 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 942,987
13. 32.807 32.807 ↓ 3.8 118,582 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_38 p_38 (cost=0.00..22,701.54 rows=30,866 width=58) (actual time=110.189..131.227 rows=118,582 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 950,612
14. 43.510 43.510 ↓ 4.0 115,183 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_47 p_47 (cost=0.00..21,841.34 rows=28,900 width=58) (actual time=143.702..174.041 rows=115,183 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 913,468
15. 30.585 30.585 ↓ 4.0 118,980 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_8 p_8 (cost=0.00..21,499.45 rows=29,415 width=58) (actual time=101.662..122.342 rows=118,980 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 893,609
16. 38.348 38.348 ↓ 4.1 117,044 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_44 p_44 (cost=0.00..21,314.41 rows=28,820 width=58) (actual time=129.496..153.391 rows=117,044 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 886,781
17. 41.590 41.590 ↓ 3.4 100,235 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_24 p_24 (cost=0.00..21,256.11 rows=29,225 width=58) (actual time=146.681..166.358 rows=100,235 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 900,878
18. 30.076 30.076 ↓ 4.1 118,647 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_23 p_23 (cost=0.00..20,993.02 rows=28,909 width=58) (actual time=100.097..120.303 rows=118,647 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 870,101
19. 35.080 35.080 ↓ 4.5 121,682 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_49 p_49 (cost=0.00..20,126.81 rows=27,020 width=58) (actual time=118.726..140.319 rows=121,682 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 826,253
20. 28.543 28.543 ↓ 3.9 106,402 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_1 p_1 (cost=0.00..20,078.72 rows=27,224 width=58) (actual time=95.666..114.171 rows=106,402 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 839,230
21. 43.915 43.915 ↓ 4.4 116,581 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_10 p_10 (cost=0.00..19,984.31 rows=26,378 width=58) (actual time=145.186..175.661 rows=116,581 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 824,601
22. 28.649 28.649 ↓ 4.0 105,266 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_57 p_57 (cost=0.00..19,806.86 rows=26,646 width=58) (actual time=96.164..114.595 rows=105,266 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 827,574
23. 28.126 28.126 ↓ 3.9 108,848 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_54 p_54 (cost=0.00..19,770.42 rows=28,125 width=58) (actual time=93.717..112.503 rows=108,848 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 822,280
24. 30.813 30.813 ↓ 4.1 108,295 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_60 p_60 (cost=0.00..19,478.95 rows=26,479 width=58) (actual time=104.552..123.252 rows=108,295 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 809,124
25. 29.807 29.807 ↓ 4.1 110,657 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_19 p_19 (cost=0.00..19,466.03 rows=26,723 width=58) (actual time=98.419..119.228 rows=110,657 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 806,164
26. 29.218 29.218 ↓ 4.0 101,584 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_42 p_42 (cost=0.00..19,129.36 rows=25,407 width=58) (actual time=96.337..116.874 rows=101,584 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 799,341
27. 27.507 27.507 ↓ 4.2 105,592 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_55 p_55 (cost=0.00..19,078.97 rows=25,333 width=58) (actual time=90.946..110.028 rows=105,592 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 792,962
28. 43.556 43.556 ↓ 4.1 103,696 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_12 p_12 (cost=0.00..18,708.52 rows=25,070 width=58) (actual time=143.503..174.224 rows=103,696 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 777,437
29. 26.536 26.536 ↓ 4.5 109,183 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_20 p_20 (cost=0.00..18,561.95 rows=24,418 width=58) (actual time=87.143..106.143 rows=109,183 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 765,069
30. 26.319 26.319 ↓ 4.0 102,178 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_11 p_11 (cost=0.00..18,440.27 rows=25,537 width=58) (actual time=87.364..105.274 rows=102,178 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 766,308
31. 25.683 25.683 ↓ 3.9 96,553 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_35 p_35 (cost=0.00..17,970.24 rows=24,765 width=58) (actual time=85.950..102.731 rows=96,553 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 749,806
32. 32.972 32.972 ↓ 3.9 96,109 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_41 p_41 (cost=0.00..17,817.43 rows=24,672 width=58) (actual time=110.010..131.889 rows=96,109 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 743,037
33. 25.712 25.712 ↓ 4.1 99,210 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_52 p_52 (cost=0.00..17,767.99 rows=24,310 width=58) (actual time=85.099..102.850 rows=99,210 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 737,616
34. 24.078 24.078 ↓ 4.5 102,222 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_25 p_25 (cost=0.00..16,825.19 rows=22,504 width=58) (actual time=78.365..96.312 rows=102,222 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 690,183
35. 23.676 23.676 ↓ 4.1 90,733 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_21 p_21 (cost=0.00..16,506.71 rows=22,067 width=58) (actual time=78.977..94.703 rows=90,733 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 686,671
36. 28.904 28.904 ↓ 4.1 87,125 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_50 p_50 (cost=0.00..16,062.54 rows=21,163 width=58) (actual time=94.267..115.614 rows=87,125 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 669,357
37. 22.596 22.596 ↓ 3.5 78,003 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_58 p_58 (cost=0.00..15,865.62 rows=22,006 width=58) (actual time=76.863..90.382 rows=78,003 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 669,203
38. 22.970 22.970 ↓ 4.0 85,462 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_3 p_3 (cost=0.00..15,848.68 rows=21,205 width=58) (actual time=76.472..91.880 rows=85,462 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 660,981
39. 34.818 34.818 ↓ 4.0 82,878 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_53 p_53 (cost=0.00..15,556.13 rows=20,714 width=58) (actual time=119.714..139.270 rows=82,878 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 649,772
40. 22.281 22.281 ↓ 4.4 92,202 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_63 p_63 (cost=0.00..15,536.56 rows=21,153 width=58) (actual time=72.877..89.124 rows=92,202 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 639,511
41. 22.114 22.114 ↓ 3.7 77,649 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_6 p_6 (cost=0.00..15,473.17 rows=21,235 width=58) (actual time=74.773..88.457 rows=77,649 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 651,058
42. 22.040 22.040 ↓ 4.3 87,601 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_40 p_40 (cost=0.00..15,404.45 rows=20,602 width=58) (actual time=72.930..88.158 rows=87,601 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 637,916
43. 26.715 26.715 ↓ 3.9 80,062 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_18 p_18 (cost=0.00..15,361.65 rows=20,410 width=58) (actual time=89.345..106.859 rows=80,062 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 643,430
44. 21.632 21.632 ↓ 4.0 80,465 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_29 p_29 (cost=0.00..15,101.58 rows=20,249 width=58) (actual time=72.627..86.529 rows=80,465 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 630,781
45. 21.488 21.488 ↓ 3.6 74,511 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_37 p_37 (cost=0.00..15,067.84 rows=20,837 width=58) (actual time=73.129..85.951 rows=74,511 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 635,109
46. 26.186 26.186 ↓ 4.0 78,520 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_13 p_13 (cost=0.00..14,821.66 rows=19,510 width=58) (actual time=91.221..104.744 rows=78,520 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 619,532
47. 20.962 20.962 ↓ 4.1 81,886 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_61 p_61 (cost=0.00..14,777.69 rows=20,014 width=58) (actual time=69.796..83.847 rows=81,886 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 614,101
48. 20.364 20.364 ↓ 4.0 75,247 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_27 p_27 (cost=0.00..14,242.69 rows=18,788 width=58) (actual time=67.984..81.456 rows=75,247 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 595,524
49. 20.271 20.271 ↓ 4.2 77,865 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_5 p_5 (cost=0.00..14,193.61 rows=18,646 width=58) (actual time=67.607..81.083 rows=77,865 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 590,581
50. 20.292 20.292 ↓ 4.0 75,594 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_46 p_46 (cost=0.00..14,177.96 rows=19,058 width=58) (actual time=68.338..81.169 rows=75,594 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 592,122
51. 19.564 19.564 ↓ 4.2 75,235 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_26 p_26 (cost=0.00..13,830.87 rows=17,970 width=58) (actual time=65.250..78.256 rows=75,235 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 576,134
52. 19.450 19.450 ↓ 4.1 74,299 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_28 p_28 (cost=0.00..13,724.35 rows=18,314 width=58) (actual time=64.776..77.798 rows=74,299 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 572,117
53. 23.500 23.500 ↓ 4.2 73,651 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_33 p_33 (cost=0.00..13,020.21 rows=17,432 width=58) (actual time=72.708..93.999 rows=73,651 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 539,573
54. 27.971 27.971 ↓ 4.1 73,944 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_39 p_39 (cost=0.00..12,876.38 rows=17,850 width=58) (actual time=88.724..111.882 rows=73,944 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 532,464
55. 24.169 24.169 ↓ 3.9 66,640 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_17 p_17 (cost=0.00..12,779.08 rows=17,062 width=58) (actual time=75.682..96.674 rows=66,640 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 535,202
56. 32.216 32.216 ↓ 4.0 67,911 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_14 p_14 (cost=0.00..12,734.00 rows=17,012 width=58) (actual time=107.961..128.865 rows=67,911 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 531,815
57. 26.090 26.090 ↓ 3.8 65,431 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_59 p_59 (cost=0.00..12,710.55 rows=17,125 width=58) (actual time=89.880..104.359 rows=65,431 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 533,167
58. 30.184 30.184 ↓ 1.5 30,648 2 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_36 p_36 (cost=0.00..12,679.81 rows=20,920 width=58) (actual time=52.883..60.369 rows=30,648 loops=2)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 249,312
59. 16.699 16.699 ↓ 3.0 63,026 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_0 p (cost=0.00..12,643.79 rows=20,672 width=58) (actual time=55.903..66.796 rows=63,026 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 495,318
60. 17.570 17.570 ↓ 4.1 69,400 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_16 p_16 (cost=0.00..12,389.44 rows=16,929 width=58) (actual time=58.295..70.282 rows=69,400 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 514,091
61. 17.619 17.619 ↓ 4.2 69,016 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_15 p_15 (cost=0.00..12,337.64 rows=16,568 width=58) (actual time=58.252..70.478 rows=69,016 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 512,032
62. 17.557 17.557 ↓ 4.1 68,438 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_30 p_30 (cost=0.00..12,274.19 rows=16,742 width=58) (actual time=58.262..70.227 rows=68,438 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 509,621
63. 16.373 16.373 ↓ 3.1 61,224 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_43 p_43 (cost=0.00..12,248.86 rows=20,004 width=58) (actual time=54.865..65.493 rows=61,224 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 479,667
64. 16.839 16.839 ↓ 3.8 60,945 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_56 p_56 (cost=0.00..11,987.85 rows=15,995 width=58) (actual time=56.682..67.356 rows=60,945 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 503,667
65. 18.240 18.240 ↓ 3.0 58,152 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_45 p_45 (cost=0.00..11,932.33 rows=19,664 width=58) (actual time=62.751..72.961 rows=58,152 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 468,782
66. 15.783 15.783 ↓ 3.1 62,808 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_34 p_34 (cost=0.00..11,792.82 rows=20,172 width=58) (actual time=52.186..63.133 rows=62,808 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 457,950
67. 15.343 15.343 ↓ 1.0 19,389 3 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_48 p_48 (cost=0.00..11,400.67 rows=19,388 width=58) (actual time=17.065..20.458 rows=19,389 loops=3)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 148,433
68. 16.684 16.684 ↓ 1.5 28,724 2 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_9 p_9 (cost=0.00..11,327.61 rows=19,005 width=58) (actual time=28.233..33.368 rows=28,724 loops=2)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 221,406
69. 21.954 21.954 ↓ 3.0 55,610 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_4 p_4 (cost=0.00..11,182.39 rows=18,242 width=58) (actual time=75.519..87.816 rows=55,610 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 438,188
70. 21.631 21.631 ↓ 3.1 53,045 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_2 p_2 (cost=0.00..10,604.92 rows=17,012 width=58) (actual time=75.719..86.522 rows=53,045 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 415,273
71. 21.324 21.324 ↓ 3.0 48,253 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_32 p_32 (cost=0.00..9,960.09 rows=16,260 width=58) (actual time=70.421..85.297 rows=48,253 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 391,592
72. 18.713 18.713 ↓ 2.9 39,965 1 / 4

Parallel Seq Scan on products_total_views_2020_08_hash_62 p_62 (cost=0.00..8,440.59 rows=13,973 width=58) (actual time=62.573..74.853 rows=39,965 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 332,779
73. 3.595 3.595 ↓ 1.6 50,268 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_51 p_115 (cost=0.00..1,367.09 rows=31,005 width=58) (actual time=0.007..14.378 rows=50,268 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,909
74. 3.624 3.624 ↓ 1.6 45,991 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_7 p_71 (cost=0.00..1,248.91 rows=28,117 width=58) (actual time=0.006..14.497 rows=45,991 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,531
75. 3.358 3.358 ↓ 1.6 44,547 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_31 p_95 (cost=0.00..1,211.60 rows=27,450 width=58) (actual time=0.007..13.433 rows=44,547 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,490
76. 3.393 3.393 ↓ 1.7 42,076 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_23 p_87 (cost=0.00..1,156.53 rows=24,758 width=58) (actual time=0.006..13.572 rows=42,076 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,771
77. 2.982 2.982 ↓ 1.7 42,381 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_22 p_86 (cost=0.00..1,150.47 rows=24,924 width=58) (actual time=0.006..11.930 rows=42,381 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,232
78. 3.433 3.433 ↓ 1.6 42,199 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_38 p_102 (cost=0.00..1,145.56 rows=25,652 width=58) (actual time=0.007..13.734 rows=42,199 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,223
79. 3.236 3.236 ↓ 1.6 41,247 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_49 p_113 (cost=0.00..1,117.94 rows=25,389 width=58) (actual time=0.007..12.945 rows=41,247 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,068
80. 3.407 3.407 ↓ 1.7 40,836 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_8 p_72 (cost=0.00..1,116.62 rows=23,998 width=58) (actual time=0.008..13.628 rows=40,836 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,434
81. 2.469 2.469 ↓ 1.6 40,667 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_47 p_111 (cost=0.00..1,110.48 rows=25,136 width=58) (actual time=0.005..9.874 rows=40,667 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,334
82. 1.888 1.888 ↓ 1.7 40,302 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_19 p_83 (cost=0.00..1,099.60 rows=23,710 width=58) (actual time=0.005..7.553 rows=40,302 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,286
83. 1.859 1.859 ↓ 1.7 39,922 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_10 p_74 (cost=0.00..1,088.82 rows=23,448 width=58) (actual time=0.005..7.435 rows=39,922 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,238
84. 1.792 1.792 ↓ 1.6 38,570 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_44 p_108 (cost=0.00..1,048.56 rows=23,817 width=58) (actual time=0.006..7.167 rows=38,570 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,972
85. 1.663 1.663 ↓ 1.7 36,973 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_1 p_65 (cost=0.00..1,005.92 rows=21,724 width=58) (actual time=0.006..6.654 rows=36,973 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,911
86. 1.737 1.737 ↓ 1.7 36,357 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_11 p_75 (cost=0.00..990.35 rows=21,396 width=58) (actual time=0.005..6.949 rows=36,357 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,896
87. 1.725 1.725 ↓ 1.6 35,955 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_42 p_106 (cost=0.00..977.91 rows=21,905 width=58) (actual time=0.005..6.899 rows=35,955 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,809
88. 1.606 1.606 ↓ 1.6 35,898 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_55 p_119 (cost=0.00..976.53 rows=21,875 width=58) (actual time=0.006..6.425 rows=35,898 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,824
89. 1.731 1.731 ↓ 1.7 35,828 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_12 p_76 (cost=0.00..972.04 rows=21,079 width=58) (actual time=0.005..6.925 rows=35,828 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,710
90. 1.807 1.807 ↓ 1.7 35,872 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_24 p_88 (cost=0.00..971.87 rows=21,099 width=58) (actual time=0.007..7.227 rows=35,872 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,647
91. 2.510 2.510 ↓ 1.7 35,145 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_20 p_84 (cost=0.00..956.54 rows=20,684 width=58) (actual time=0.007..10.039 rows=35,145 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,769
92. 2.675 2.675 ↓ 1.6 34,320 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_57 p_121 (cost=0.00..939.53 rows=21,139 width=58) (actual time=0.008..10.701 rows=34,320 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,907
93. 2.354 2.354 ↓ 1.7 33,907 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_54 p_118 (cost=0.00..931.96 rows=19,926 width=58) (actual time=0.005..9.415 rows=33,907 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3,035
94. 1.649 1.649 ↓ 1.6 33,937 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_41 p_105 (cost=0.00..924.18 rows=20,982 width=58) (actual time=0.007..6.595 rows=33,937 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,687
95. 1.561 1.561 ↓ 1.7 33,050 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_35 p_99 (cost=0.00..905.81 rows=19,454 width=58) (actual time=0.005..6.243 rows=33,050 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,855
96. 1.488 1.488 ↓ 1.6 33,362 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_60 p_124 (cost=0.00..905.81 rows=20,567 width=58) (actual time=0.005..5.952 rows=33,362 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,528
97. 1.480 1.480 ↓ 1.6 32,726 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_52 p_116 (cost=0.00..893.71 rows=20,015 width=58) (actual time=0.005..5.918 rows=32,726 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,692
98. 1.456 1.456 ↓ 1.7 31,757 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_18 p_82 (cost=0.00..867.05 rows=18,671 width=58) (actual time=0.006..5.825 rows=31,757 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,589
99. 1.420 1.420 ↓ 1.7 31,676 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_21 p_85 (cost=0.00..865.54 rows=18,639 width=58) (actual time=0.005..5.681 rows=31,676 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,612
100. 1.433 1.433 ↓ 1.6 30,871 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_63 p_127 (cost=0.00..838.30 rows=18,888 width=58) (actual time=0.005..5.730 rows=30,871 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,358
101. 1.411 1.411 ↓ 1.7 30,492 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_25 p_89 (cost=0.00..836.57 rows=17,924 width=58) (actual time=0.005..5.643 rows=30,492 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,666
102. 1.453 1.453 ↓ 1.6 30,732 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_61 p_125 (cost=0.00..833.30 rows=18,842 width=58) (actual time=0.007..5.811 rows=30,732 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,322
103. 1.376 1.376 ↓ 1.7 29,956 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_40 p_104 (cost=0.00..816.32 rows=17,626 width=58) (actual time=0.005..5.503 rows=29,956 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,380
104. 1.365 1.365 ↓ 1.6 29,278 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_29 p_93 (cost=0.00..801.11 rows=17,951 width=58) (actual time=0.005..5.459 rows=29,278 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,473
105. 1.354 1.354 ↓ 1.6 29,206 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_3 p_67 (cost=0.00..792.16 rows=17,799 width=58) (actual time=0.005..5.415 rows=29,206 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,195
106. 1.323 1.323 ↓ 1.6 28,952 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_50 p_114 (cost=0.00..784.43 rows=17,799 width=58) (actual time=0.006..5.291 rows=28,952 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,108
107. 1.325 1.325 ↓ 1.7 28,422 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_6 p_70 (cost=0.00..773.26 rows=16,717 width=58) (actual time=0.005..5.302 rows=28,422 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,208
108. 1.270 1.270 ↓ 1.6 27,967 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_53 p_117 (cost=0.00..761.21 rows=17,216 width=58) (actual time=0.005..5.079 rows=27,967 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,171
109. 1.361 1.361 ↓ 1.6 27,786 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_58 p_122 (cost=0.00..755.04 rows=17,075 width=58) (actual time=0.005..5.444 rows=27,786 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,116
110. 1.405 1.405 ↓ 1.7 27,580 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_13 p_77 (cost=0.00..753.29 rows=16,224 width=58) (actual time=0.005..5.621 rows=27,580 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,260
111. 1.235 1.235 ↓ 1.6 27,511 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_26 p_90 (cost=0.00..750.45 rows=16,767 width=58) (actual time=0.005..4.939 rows=27,511 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,248
112. 1.239 1.239 ↓ 1.6 27,393 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_5 p_69 (cost=0.00..745.49 rows=16,916 width=58) (actual time=0.005..4.956 rows=27,393 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,183
113. 1.197 1.197 ↓ 1.6 26,348 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_27 p_91 (cost=0.00..720.93 rows=16,298 width=58) (actual time=0.005..4.789 rows=26,348 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,201
114. 1.254 1.254 ↓ 1.6 26,428 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_37 p_101 (cost=0.00..717.54 rows=16,278 width=58) (actual time=0.005..5.017 rows=26,428 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,034
115. 1.170 1.170 ↓ 1.6 26,235 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_33 p_97 (cost=0.00..713.14 rows=16,164 width=58) (actual time=0.005..4.681 rows=26,235 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,042
116. 1.220 1.220 ↓ 1.6 25,900 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_39 p_103 (cost=0.00..702.47 rows=15,788 width=58) (actual time=0.007..4.880 rows=25,900 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,946
117. 1.251 1.251 ↓ 1.7 25,507 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_14 p_78 (cost=0.00..699.40 rows=15,004 width=58) (actual time=0.005..5.005 rows=25,507 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,192
118. 1.176 1.176 ↓ 1.7 25,150 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_28 p_92 (cost=0.00..693.31 rows=14,794 width=58) (actual time=0.005..4.704 rows=25,150 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,312
119. 1.164 1.164 ↓ 1.7 24,604 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_46 p_110 (cost=0.00..673.53 rows=14,473 width=58) (actual time=0.008..4.655 rows=24,604 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,089
120. 1.148 1.148 ↓ 1.6 24,241 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_15 p_79 (cost=0.00..659.75 rows=14,994 width=58) (actual time=0.005..4.593 rows=24,241 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,882
121. 1.054 1.054 ↓ 1.6 23,576 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_17 p_81 (cost=0.00..640.97 rows=14,350 width=58) (actual time=0.006..4.218 rows=23,576 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,857
122. 1.118 1.118 ↓ 1.7 23,192 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_34 p_98 (cost=0.00..632.13 rows=13,642 width=58) (actual time=0.004..4.471 rows=23,192 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,869
123. 1.016 1.016 ↓ 1.7 22,814 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_43 p_107 (cost=0.00..624.14 rows=13,420 width=58) (actual time=0.005..4.064 rows=22,814 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,908
124. 1.009 1.009 ↓ 1.6 22,389 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_30 p_94 (cost=0.00..606.68 rows=13,799 width=58) (actual time=0.004..4.037 rows=22,389 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,681
125. 1.027 1.027 ↓ 1.6 22,054 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_59 p_123 (cost=0.00..599.65 rows=13,564 width=58) (actual time=0.005..4.107 rows=22,054 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,725
126. 0.978 0.978 ↓ 1.6 22,049 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_48 p_112 (cost=0.00..598.25 rows=13,562 width=58) (actual time=0.005..3.912 rows=22,049 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,648
127. 1.131 1.131 ↓ 1.6 21,893 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_0 p_64 (cost=0.00..596.40 rows=13,360 width=58) (actual time=0.005..4.525 rows=21,893 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,717
128. 1.003 1.003 ↓ 1.7 21,421 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_36 p_100 (cost=0.00..588.76 rows=12,601 width=58) (actual time=0.005..4.013 rows=21,421 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,898
129. 0.973 0.973 ↓ 1.7 21,489 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_16 p_80 (cost=0.00..585.91 rows=12,641 width=58) (actual time=0.004..3.890 rows=21,489 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,734
130. 0.947 0.947 ↓ 1.6 21,284 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_56 p_120 (cost=0.00..584.12 rows=13,143 width=58) (actual time=0.004..3.789 rows=21,284 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,882
131. 0.929 0.929 ↓ 1.7 20,671 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_9 p_73 (cost=0.00..564.29 rows=12,260 width=58) (actual time=0.005..3.715 rows=20,671 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,681
132. 1.252 1.252 ↓ 1.7 20,599 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_45 p_109 (cost=0.00..564.01 rows=12,117 width=58) (actual time=0.006..5.009 rows=20,599 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,729
133. 1.608 1.608 ↓ 1.7 19,947 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_4 p_68 (cost=0.00..542.74 rows=11,734 width=58) (actual time=0.007..6.431 rows=19,947 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,557
134. 1.602 1.602 ↓ 1.7 19,612 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_2 p_66 (cost=0.00..537.89 rows=11,536 width=58) (actual time=0.007..6.407 rows=19,612 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,682
135. 1.301 1.301 ↓ 1.6 16,197 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_32 p_96 (cost=0.00..441.12 rows=9,872 width=58) (actual time=0.007..5.205 rows=16,197 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,258
136. 1.121 1.121 ↓ 1.6 13,868 1 / 4

Parallel Seq Scan on products_total_views_2020_09_hash_62 p_126 (cost=0.00..376.65 rows=8,505 width=58) (actual time=0.009..4.484 rows=13,868 loops=1)

  • Filter: ((partition_time >= '2020-08-28 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,054
137. 273.446 597.040 ↓ 8.0 616,990 4 / 4

Sort (cost=67,201.76..67,394.68 rows=77,169 width=50) (actual time=551.149..597.040 rows=616,990 loops=4)

  • Sort Key: products_total_views_2020_09_hash_0.merchant_id, products_total_views_2020_09_hash_0.product_id
  • Sort Method: quicksort Memory: 13,663kB
  • Worker 0: Sort Method: quicksort Memory: 13,663kB
  • Worker 1: Sort Method: quicksort Memory: 13,663kB
  • Worker 2: Sort Method: quicksort Memory: 13,663kB
138. 6.888 323.594 ↑ 1.0 75,311 4 / 4

Append (cost=0.00..60,937.28 rows=77,169 width=50) (actual time=3.184..323.594 rows=75,311 loops=4)

139. 3.688 3.688 ↑ 1.0 843 4 / 4

Seq Scan on products_total_views_2020_09_hash_0 (cost=0.00..683.24 rows=875 width=50) (actual time=3.183..3.688 rows=843 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 22,767
140. 5.958 5.958 ↓ 1.0 1,438 4 / 4

Seq Scan on products_total_views_2020_09_hash_1 (cost=0.00..1,152.55 rows=1,429 width=50) (actual time=5.194..5.958 rows=1,438 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 38,446
141. 3.337 3.337 ↑ 1.0 722 4 / 4

Seq Scan on products_total_views_2020_09_hash_2 (cost=0.00..616.17 rows=722 width=50) (actual time=2.911..3.337 rows=722 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 20,572
142. 5.008 5.008 ↑ 1.0 1,044 4 / 4

Seq Scan on products_total_views_2020_09_hash_3 (cost=0.00..907.64 rows=1,081 width=50) (actual time=4.480..5.008 rows=1,044 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 30,357
143. 3.319 3.319 ↑ 1.0 800 4 / 4

Seq Scan on products_total_views_2020_09_hash_4 (cost=0.00..621.80 rows=800 width=50) (actual time=2.921..3.319 rows=800 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 20,704
144. 4.596 4.596 ↑ 1.1 979 4 / 4

Seq Scan on products_total_views_2020_09_hash_5 (cost=0.00..854.03 rows=1,028 width=50) (actual time=4.096..4.596 rows=979 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 28,597
145. 4.865 4.865 ↑ 1.0 992 4 / 4

Seq Scan on products_total_views_2020_09_hash_6 (cost=0.00..885.88 rows=996 width=50) (actual time=4.327..4.865 rows=992 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 29,638
146. 7.400 7.400 ↑ 1.0 1,638 4 / 4

Seq Scan on products_total_views_2020_09_hash_7 (cost=0.00..1,430.95 rows=1,674 width=50) (actual time=6.529..7.400 rows=1,638 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 47,884
147. 6.795 6.795 ↑ 1.0 1,614 4 / 4

Seq Scan on products_total_views_2020_09_hash_8 (cost=0.00..1,279.38 rows=1,628 width=50) (actual time=5.935..6.795 rows=1,614 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 42,656
148. 3.536 3.536 ↑ 1.0 890 4 / 4

Seq Scan on products_total_views_2020_09_hash_9 (cost=0.00..646.49 rows=897 width=50) (actual time=3.082..3.536 rows=890 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 21,462
149. 6.510 6.510 ↑ 1.0 1,592 4 / 4

Seq Scan on products_total_views_2020_09_hash_10 (cost=0.00..1,247.50 rows=1,608 width=50) (actual time=5.614..6.510 rows=1,592 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 41,568
150. 5.919 5.919 ↑ 1.0 1,392 4 / 4

Seq Scan on products_total_views_2020_09_hash_11 (cost=0.00..1,134.66 rows=1,412 width=50) (actual time=5.242..5.919 rows=1,392 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 37,861
151. 5.881 5.881 ↑ 1.0 1,277 4 / 4

Seq Scan on products_total_views_2020_09_hash_12 (cost=0.00..1,113.72 rows=1,292 width=50) (actual time=5.203..5.881 rows=1,277 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 37,261
152. 4.480 4.480 ↑ 1.0 987 4 / 4

Seq Scan on products_total_views_2020_09_hash_13 (cost=0.00..863.00 rows=987 width=50) (actual time=3.943..4.480 rows=987 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 28,853
153. 4.452 4.452 ↑ 1.0 1,011 4 / 4

Seq Scan on products_total_views_2020_09_hash_14 (cost=0.00..801.24 rows=1,011 width=50) (actual time=3.913..4.452 rows=1,011 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 26,688
154. 4.044 4.044 ↑ 1.1 1,007 4 / 4

Seq Scan on products_total_views_2020_09_hash_15 (cost=0.00..755.90 rows=1,059 width=50) (actual time=3.528..4.044 rows=1,007 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 25,116
155. 3.667 3.667 ↑ 1.0 829 4 / 4

Seq Scan on products_total_views_2020_09_hash_16 (cost=0.00..671.29 rows=829 width=50) (actual time=3.211..3.667 rows=829 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 22,394
156. 3.982 3.982 ↑ 1.0 1,034 4 / 4

Seq Scan on products_total_views_2020_09_hash_17 (cost=0.00..734.29 rows=1,070 width=50) (actual time=3.451..3.982 rows=1,034 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 24,399
157. 5.228 5.228 ↑ 1.0 1,272 4 / 4

Seq Scan on products_total_views_2020_09_hash_18 (cost=0.00..993.33 rows=1,272 width=50) (actual time=4.462..5.228 rows=1,272 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 33,074
158. 7.551 7.551 ↓ 1.0 1,398 4 / 4

Seq Scan on products_total_views_2020_09_hash_19 (cost=0.00..1,259.85 rows=1,379 width=50) (actual time=6.638..7.551 rows=1,398 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 42,190
159. 6.029 6.029 ↑ 1.0 1,437 4 / 4

Seq Scan on products_total_views_2020_09_hash_20 (cost=0.00..1,095.92 rows=1,445 width=50) (actual time=5.282..6.029 rows=1,437 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 36,477
160. 5.207 5.207 ↑ 1.0 1,275 4 / 4

Seq Scan on products_total_views_2020_09_hash_21 (cost=0.00..991.60 rows=1,292 width=50) (actual time=4.491..5.207 rows=1,275 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 33,013
161. 7.138 7.138 ↓ 1.0 1,632 4 / 4

Seq Scan on products_total_views_2020_09_hash_22 (cost=0.00..1,318.16 rows=1,622 width=50) (actual time=6.318..7.138 rows=1,632 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 43,981
162. 7.224 7.224 ↑ 1.0 1,859 4 / 4

Seq Scan on products_total_views_2020_09_hash_23 (cost=0.00..1,325.09 rows=1,861 width=50) (actual time=6.333..7.224 rows=1,859 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 43,988
163. 5.851 5.851 ↓ 1.0 1,438 4 / 4

Seq Scan on products_total_views_2020_09_hash_24 (cost=0.00..1,113.49 rows=1,410 width=50) (actual time=5.125..5.851 rows=1,438 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 37,081
164. 5.096 5.096 ↑ 1.0 1,424 4 / 4

Seq Scan on products_total_views_2020_09_hash_25 (cost=0.00..958.48 rows=1,428 width=50) (actual time=4.409..5.096 rows=1,424 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 31,734
165. 4.790 4.790 ↑ 1.0 1,075 4 / 4

Seq Scan on products_total_views_2020_09_hash_26 (cost=0.00..859.80 rows=1,114 width=50) (actual time=4.142..4.790 rows=1,075 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 28,684
166. 4.566 4.566 ↑ 1.1 1,033 4 / 4

Seq Scan on products_total_views_2020_09_hash_27 (cost=0.00..825.90 rows=1,086 width=50) (actual time=4.016..4.566 rows=1,033 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 27,516
167. 4.586 4.586 ↑ 1.0 1,008 4 / 4

Seq Scan on products_total_views_2020_09_hash_28 (cost=0.00..794.28 rows=1,008 width=50) (actual time=3.845..4.586 rows=1,008 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 26,454
168. 5.041 5.041 ↑ 1.0 1,002 4 / 4

Seq Scan on products_total_views_2020_09_hash_29 (cost=0.00..917.83 rows=1,052 width=50) (actual time=4.469..5.041 rows=1,002 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 30,749
169. 4.183 4.183 ↑ 1.0 956 4 / 4

Seq Scan on products_total_views_2020_09_hash_30 (cost=0.00..694.88 rows=1,002 width=50) (actual time=3.633..4.183 rows=956 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 23,114
170. 7.862 7.862 ↑ 1.0 1,717 4 / 4

Seq Scan on products_total_views_2020_09_hash_31 (cost=0.00..1,388.10 rows=1,791 width=50) (actual time=6.906..7.862 rows=1,717 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 46,320
171. 2.937 2.937 ↑ 1.0 684 4 / 4

Seq Scan on products_total_views_2020_09_hash_32 (cost=0.00..505.34 rows=709 width=50) (actual time=2.581..2.937 rows=684 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 16,771
172. 4.688 4.688 ↑ 1.0 986 4 / 4

Seq Scan on products_total_views_2020_09_hash_33 (cost=0.00..816.95 rows=1,033 width=50) (actual time=4.177..4.688 rows=986 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 27,291
173. 4.124 4.124 ↑ 1.0 957 4 / 4

Seq Scan on products_total_views_2020_09_hash_34 (cost=0.00..724.26 rows=957 width=50) (actual time=3.635..4.124 rows=957 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 24,104
174. 5.549 5.549 ↓ 1.0 1,373 4 / 4

Seq Scan on products_total_views_2020_09_hash_35 (cost=0.00..1,037.81 rows=1,363 width=50) (actual time=4.712..5.549 rows=1,373 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 34,532
175. 3.774 3.774 ↑ 1.0 834 4 / 4

Seq Scan on products_total_views_2020_09_hash_36 (cost=0.00..674.49 rows=834 width=50) (actual time=3.294..3.774 rows=834 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 22,485
176. 4.516 4.516 ↑ 1.0 1,027 4 / 4

Seq Scan on products_total_views_2020_09_hash_37 (cost=0.00..821.92 rows=1,075 width=50) (actual time=3.941..4.516 rows=1,027 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 27,435
177. 7.119 7.119 ↑ 1.0 1,498 4 / 4

Seq Scan on products_total_views_2020_09_hash_38 (cost=0.00..1,312.46 rows=1,557 width=50) (actual time=6.200..7.119 rows=1,498 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 43,924
178. 4.495 4.495 ↑ 1.0 900 4 / 4

Seq Scan on products_total_views_2020_09_hash_39 (cost=0.00..804.75 rows=933 width=50) (actual time=3.974..4.495 rows=900 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 26,946
179. 4.938 4.938 ↑ 1.0 1,183 4 / 4

Seq Scan on products_total_views_2020_09_hash_40 (cost=0.00..935.20 rows=1,187 width=50) (actual time=4.277..4.938 rows=1,183 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 31,153
180. 5.500 5.500 ↑ 1.1 1,240 4 / 4

Seq Scan on products_total_views_2020_09_hash_41 (cost=0.00..1,058.84 rows=1,305 width=50) (actual time=4.901..5.500 rows=1,240 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 35,384
181. 5.456 5.456 ↑ 1.1 1,416 4 / 4

Seq Scan on products_total_views_2020_09_hash_42 (cost=0.00..1,120.38 rows=1,489 width=50) (actual time=4.796..5.456 rows=1,416 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 37,348
182. 3.419 3.419 ↑ 1.0 1,012 4 / 4

Seq Scan on products_total_views_2020_09_hash_43 (cost=0.00..715.03 rows=1,012 width=50) (actual time=2.972..3.419 rows=1,012 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 23,710
183. 5.674 5.674 ↑ 1.1 1,458 4 / 4

Seq Scan on products_total_views_2020_09_hash_44 (cost=0.00..1,201.29 rows=1,532 width=50) (actual time=4.991..5.674 rows=1,458 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 40,084
184. 3.085 3.085 ↑ 1.0 851 4 / 4

Seq Scan on products_total_views_2020_09_hash_45 (cost=0.00..646.10 rows=851 width=50) (actual time=2.696..3.085 rows=851 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 21,477
185. 3.773 3.773 ↑ 1.0 981 4 / 4

Seq Scan on products_total_views_2020_09_hash_46 (cost=0.00..771.66 rows=981 width=50) (actual time=3.268..3.773 rows=981 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 25,712
186. 6.067 6.067 ↑ 1.1 1,519 4 / 4

Seq Scan on products_total_views_2020_09_hash_47 (cost=0.00..1,272.35 rows=1,598 width=50) (actual time=5.333..6.067 rows=1,519 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 42,482
187. 3.156 3.156 ↑ 1.0 809 4 / 4

Seq Scan on products_total_views_2020_09_hash_48 (cost=0.00..685.44 rows=846 width=50) (actual time=2.751..3.156 rows=809 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 22,888
188. 6.219 6.219 ↑ 1.0 1,685 4 / 4

Seq Scan on products_total_views_2020_09_hash_49 (cost=0.00..1,280.83 rows=1,719 width=50) (actual time=5.546..6.219 rows=1,685 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 42,630
189. 3.954 3.954 ↑ 1.0 1,152 4 / 4

Seq Scan on products_total_views_2020_09_hash_50 (cost=0.00..898.78 rows=1,204 width=50) (actual time=3.488..3.954 rows=1,152 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 29,908
190. 6.867 6.867 ↑ 1.1 1,935 4 / 4

Seq Scan on products_total_views_2020_09_hash_51 (cost=0.00..1,566.29 rows=2,061 width=50) (actual time=6.037..6.867 rows=1,935 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 52,242
191. 4.745 4.745 ↑ 1.1 1,193 4 / 4

Seq Scan on products_total_views_2020_09_hash_52 (cost=0.00..1,024.00 rows=1,256 width=50) (actual time=4.176..4.745 rows=1,193 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 34,225
192. 3.972 3.972 ↑ 1.0 1,095 4 / 4

Seq Scan on products_total_views_2020_09_hash_53 (cost=0.00..872.14 rows=1,146 width=50) (actual time=3.479..3.972 rows=1,095 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 29,043
193. 4.868 4.868 ↓ 1.0 1,295 4 / 4

Seq Scan on products_total_views_2020_09_hash_54 (cost=0.00..1,067.78 rows=1,271 width=50) (actual time=4.160..4.868 rows=1,295 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 35,647
194. 5.672 5.672 ↑ 1.1 1,363 4 / 4

Seq Scan on products_total_views_2020_09_hash_55 (cost=0.00..1,118.84 rows=1,449 width=50) (actual time=4.931..5.672 rows=1,363 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 37,359
195. 3.534 3.534 ↑ 1.0 912 4 / 4

Seq Scan on products_total_views_2020_09_hash_56 (cost=0.00..669.17 rows=957 width=50) (actual time=3.035..3.534 rows=912 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 22,254
196. 5.670 5.670 ↑ 1.1 1,204 4 / 4

Seq Scan on products_total_views_2020_09_hash_57 (cost=0.00..1,076.41 rows=1,270 width=50) (actual time=5.013..5.670 rows=1,204 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 36,023
197. 4.318 4.318 ↑ 1.0 984 4 / 4

Seq Scan on products_total_views_2020_09_hash_58 (cost=0.00..865.05 rows=1,028 width=50) (actual time=3.838..4.318 rows=984 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 28,918
198. 3.322 3.322 ↑ 1.0 927 4 / 4

Seq Scan on products_total_views_2020_09_hash_59 (cost=0.00..687.00 rows=969 width=50) (actual time=2.905..3.322 rows=927 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 22,852
199. 5.343 5.343 ↑ 1.0 1,397 4 / 4

Seq Scan on products_total_views_2020_09_hash_60 (cost=0.00..1,037.81 rows=1,466 width=50) (actual time=4.685..5.343 rows=1,397 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 34,493
200. 4.804 4.804 ↑ 1.0 1,209 4 / 4

Seq Scan on products_total_views_2020_09_hash_61 (cost=0.00..954.67 rows=1,253 width=50) (actual time=4.172..4.804 rows=1,209 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 31,845
201. 2.224 2.224 ↑ 1.0 520 4 / 4

Seq Scan on products_total_views_2020_09_hash_62 (cost=0.00..431.50 rows=542 width=50) (actual time=1.944..2.224 rows=520 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 14,402
202. 5.135 5.135 ↑ 1.1 1,097 4 / 4

Seq Scan on products_total_views_2020_09_hash_63 (cost=0.00..960.51 rows=1,156 width=50) (actual time=4.559..5.135 rows=1,097 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 32,132
203. 41.671 2,092.701 ↑ 3.4 8,580 1

GroupAggregate (cost=171,014.31..174,067.51 rows=29,347 width=82) (actual time=1,777.610..2,092.701 rows=8,580 loops=1)

  • Group Key: c_7.merchant_id, c_7.product_id
204. 894.070 2,051.030 ↓ 2.7 180,128 1

Gather Merge (cost=171,014.31..173,023.72 rows=67,695 width=66) (actual time=1,777.573..2,051.030 rows=180,128 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
205. 76.896 1,156.960 ↓ 2.1 45,032 4 / 4

Merge Join (cost=171,004.27..172,096.41 rows=21,837 width=66) (actual time=1,040.015..1,156.960 rows=45,032 loops=4)

  • Merge Cond: (((c_7.merchant_id)::text = (cart_item_histories_2020_09_hash_0.merchant_id)::text) AND ((c_7.product_id)::text = (cart_item_histories_2020_09_hash_0.product_id)::text))
206. 739.759 1,016.460 ↓ 2.1 195,290 4 / 4

Sort (cost=162,654.25..162,890.91 rows=94,666 width=66) (actual time=980.826..1,016.460 rows=195,290 loops=4)

  • Sort Key: c_7.merchant_id, c_7.product_id
  • Sort Method: quicksort Memory: 61,737kB
  • Worker 0: Sort Method: quicksort Memory: 26,144kB
  • Worker 1: Sort Method: quicksort Memory: 28,866kB
  • Worker 2: Sort Method: quicksort Memory: 20,753kB
207. 15.731 276.701 ↓ 2.1 195,290 4 / 4

Parallel Append (cost=0.00..154,829.84 rows=94,666 width=66) (actual time=88.097..276.701 rows=195,290 loops=4)

208. 24.887 24.887 ↓ 24.1 68,520 1 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_7 c_7 (cost=0.00..18,195.07 rows=2,839 width=66) (actual time=83.708..99.550 rows=68,520 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 670,108
209. 41.683 41.683 ↓ 23.9 64,727 1 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_9 c_9 (cost=0.00..16,957.03 rows=2,705 width=66) (actual time=139.004..166.731 rows=64,727 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 623,608
210. 38.912 38.912 ↓ 25.3 60,755 1 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_1 c_1 (cost=0.00..15,936.92 rows=2,406 width=66) (actual time=129.664..155.649 rows=60,755 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 586,204
211. 20.835 20.835 ↓ 24.0 56,781 1 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_0 c (cost=0.00..15,159.16 rows=2,369 width=66) (actual time=70.101..83.342 rows=56,781 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 558,598
212. 25.601 25.601 ↓ 23.9 52,442 1 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_8 c_8 (cost=0.00..14,438.33 rows=2,193 width=66) (actual time=89.793..102.402 rows=52,442 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 533,648
213. 23.488 23.488 ↓ 25.7 56,273 1 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_2 c_2 (cost=0.00..14,217.14 rows=2,187 width=66) (actual time=74.036..93.952 rows=56,273 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 520,884
214. 22.738 22.738 ↓ 6.4 13,163 4 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_4 c_4 (cost=0.00..13,582.14 rows=2,042 width=66) (actual time=19.409..22.738 rows=13,163 loops=4)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 124,677
215. 18.660 18.660 ↓ 12.6 24,883 2 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_5 c_5 (cost=0.00..13,326.92 rows=1,975 width=66) (actual time=31.460..37.319 rows=24,883 loops=2)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 245,620
216. 16.147 16.147 ↓ 49.9 40,713 1 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_6 c_6 (cost=0.00..12,640.60 rows=816 width=66) (actual time=54.917..64.588 rows=40,713 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 436,012
217. 15.678 15.678 ↓ 21.0 45,622 1 / 4

Parallel Seq Scan on cart_item_histories_2020_08_hash_3 c_3 (cost=0.00..12,391.29 rows=2,170 width=66) (actual time=52.383..62.711 rows=45,622 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 421,694
218. 1.544 1.544 ↓ 1.7 28,344 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_7 c_17 (cost=0.00..912.29 rows=16,357 width=66) (actual time=0.004..6.176 rows=28,344 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,111
219. 1.395 1.395 ↓ 1.7 26,662 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_9 c_19 (cost=0.00..859.46 rows=15,418 width=66) (actual time=0.005..5.578 rows=26,662 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,022
220. 1.353 1.353 ↓ 1.7 26,068 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_1 c_11 (cost=0.00..843.02 rows=15,034 width=66) (actual time=0.004..5.410 rows=26,068 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,069
221. 1.234 1.234 ↓ 1.7 23,429 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_0 c_10 (cost=0.00..752.16 rows=13,529 width=66) (actual time=0.004..4.935 rows=23,429 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,660
222. 1.208 1.208 ↓ 1.7 23,286 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_8 c_18 (cost=0.00..749.11 rows=13,398 width=66) (actual time=0.004..4.834 rows=23,286 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,713
223. 1.207 1.207 ↓ 1.7 23,229 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_2 c_12 (cost=0.00..745.76 rows=13,419 width=66) (actual time=0.006..4.828 rows=23,229 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,656
224. 1.314 1.314 ↓ 1.7 22,740 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_5 c_15 (cost=0.00..734.12 rows=13,128 width=66) (actual time=0.004..5.255 rows=22,740 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,750
225. 1.141 1.141 ↓ 1.7 21,942 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_4 c_14 (cost=0.00..710.89 rows=12,624 width=66) (actual time=0.004..4.562 rows=21,942 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,764
226. 1.029 1.029 ↓ 1.7 19,763 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_3 c_13 (cost=0.00..637.36 rows=11,348 width=66) (actual time=0.004..4.115 rows=19,763 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,518
227. 0.918 0.918 ↓ 1.7 17,446 1 / 4

Parallel Seq Scan on cart_item_histories_2020_09_hash_6 c_16 (cost=0.00..567.72 rows=10,028 width=66) (actual time=0.008..3.673 rows=17,446 loops=1)

  • Filter: ((partition_time >= '2020-08-27 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-08-28 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,485
228. 28.072 63.604 ↓ 5.5 50,422 4 / 4

Sort (cost=8,350.02..8,373.09 rows=9,227 width=50) (actual time=59.152..63.604 rows=50,422 loops=4)

  • Sort Key: cart_item_histories_2020_09_hash_0.merchant_id, cart_item_histories_2020_09_hash_0.product_id
  • Sort Method: quicksort Memory: 1,683kB
  • Worker 0: Sort Method: quicksort Memory: 1,683kB
  • Worker 1: Sort Method: quicksort Memory: 1,683kB
  • Worker 2: Sort Method: quicksort Memory: 1,683kB
229. 0.717 35.532 ↓ 1.0 9,235 4 / 4

Append (cost=0.00..7,742.35 rows=9,227 width=50) (actual time=3.013..35.532 rows=9,235 loops=4)

230. 3.386 3.386 ↑ 1.0 895 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_0 (cost=0.00..770.61 rows=895 width=50) (actual time=3.012..3.386 rows=895 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 24,194
231. 3.723 3.723 ↑ 1.0 1,035 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_1 (cost=0.00..863.71 rows=1,035 width=50) (actual time=3.274..3.723 rows=1,035 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 27,102
232. 3.198 3.198 ↑ 1.0 941 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_2 (cost=0.00..764.06 rows=941 width=50) (actual time=2.821..3.198 rows=941 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 23,944
233. 2.816 2.816 ↑ 1.0 741 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_3 (cost=0.00..653.01 rows=741 width=50) (actual time=2.475..2.816 rows=741 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 20,540
234. 3.396 3.396 ↑ 1.0 829 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_4 (cost=0.00..728.33 rows=829 width=50) (actual time=2.949..3.396 rows=829 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 22,877
235. 3.696 3.696 ↑ 1.0 902 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_5 (cost=0.00..752.12 rows=902 width=50) (actual time=3.237..3.696 rows=902 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 23,588
236. 2.875 2.875 ↑ 1.0 684 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_6 (cost=0.00..581.64 rows=684 width=50) (actual time=2.505..2.875 rows=684 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 18,247
237. 4.373 4.373 ↓ 1.0 1,219 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_7 (cost=0.00..934.69 rows=1,211 width=50) (actual time=3.845..4.373 rows=1,219 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 29,236
238. 3.403 3.403 ↑ 1.0 973 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_8 (cost=0.00..767.49 rows=973 width=50) (actual time=2.994..3.403 rows=973 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 24,026
239. 3.949 3.949 ↑ 1.0 1,016 4 / 4

Seq Scan on cart_item_histories_2020_09_hash_9 (cost=0.00..880.55 rows=1,016 width=50) (actual time=3.489..3.949 rows=1,016 loops=4)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 27,668
240. 1.266 97.871 ↓ 12.3 4,402 1

Hash (cost=58,195.32..58,195.32 rows=358 width=63) (actual time=97.871..97.871 rows=4,402 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 504kB
241. 3.867 96.605 ↓ 12.3 4,402 1

Gather (cost=10.00..58,195.32 rows=358 width=63) (actual time=0.920..96.605 rows=4,402 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
242. 92.738 92.738 ↓ 9.8 880 5 / 5

Parallel Seq Scan on products_total_sold_lifetime (cost=0.00..58,184.96 rows=90 width=63) (actual time=0.138..92.738 rows=880 loops=5)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 653,421
Planning time : 39.094 ms
Execution time : 13,707.372 ms