explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QDte

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=10,339,495.62..12,752,722.64 rows=40,000 width=141) (actual rows= loops=)

  • Hash Cond: (((c.merchant_id)::text = (products_total_sold_lifetime.merchant_id)::text) AND ((c.product_id)::text = (products_total_sold_lifetime.product_id)::text))
2. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=10,281,294.94..12,694,221.94 rows=40,000 width=164) (actual rows= loops=)

  • Merge Cond: (((p_179.merchant_id)::text = (c.merchant_id)::text) AND ((p_179.product_id)::text = (c.product_id)::text))
3. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=9,767,884.38..12,177,869.38 rows=40,000 width=82) (actual rows= loops=)

  • Group Key: p_179.merchant_id, p_179.product_id
4. 0.000 0.000 ↓ 0.0

Gather Merge (cost=9,767,884.38..12,176,169.38 rows=120,000 width=82) (actual rows= loops=)

  • Workers Planned: 3
5. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=9,767,874.34..12,174,533.34 rows=40,000 width=82) (actual rows= loops=)

  • Group Key: p_179.merchant_id, p_179.product_id
6. 0.000 0.000 ↓ 0.0

Merge Join (cost=9,767,874.34..11,550,366.23 rows=83,155,615 width=58) (actual rows= loops=)

  • Merge Cond: (((p_179.merchant_id)::text = (products_total_views_2020_09_hash_0.merchant_id)::text) AND ((p_179.product_id)::text = (products_total_views_2020_09_hash_0.product_id)::text))
7. 0.000 0.000 ↓ 0.0

Sort (cost=9,703,006.51..9,812,095.98 rows=43,635,787 width=58) (actual rows= loops=)

  • Sort Key: p_179.merchant_id, p_179.product_id
8. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..3,228,353.47 rows=43,635,787 width=58) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_51 p_179 (cost=0.00..26,483.37 rows=402,295 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
10. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_51 p_115 (cost=0.00..24,611.79 rows=373,860 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_51 p_51 (cost=0.00..24,562.49 rows=332,317 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
12. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_7 p_135 (cost=0.00..23,410.00 rows=355,611 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_22 p_150 (cost=0.00..23,013.60 rows=349,585 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
14. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_31 p_159 (cost=0.00..22,795.89 rows=346,272 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
15. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_7 p_71 (cost=0.00..22,745.57 rows=345,517 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
16. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_38 p_166 (cost=0.00..22,701.54 rows=344,849 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
17. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_22 p_86 (cost=0.00..22,674.12 rows=344,420 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
18. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_7 p_7 (cost=0.00..22,279.24 rows=303,749 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
19. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_60 p_124 (cost=0.00..22,049.85 rows=334,937 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
20. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_47 p_175 (cost=0.00..21,841.34 rows=331,771 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
21. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_8 p_136 (cost=0.00..21,499.45 rows=326,578 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
22. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_38 p_102 (cost=0.00..21,485.38 rows=326,374 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
23. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_44 p_172 (cost=0.00..21,314.41 rows=323,776 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
24. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_24 p_152 (cost=0.00..21,256.11 rows=322,890 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
25. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_24 p_88 (cost=0.00..21,057.98 rows=319,882 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
26. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_22 p_22 (cost=0.00..21,057.84 rows=285,482 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
27. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_23 p_151 (cost=0.00..20,993.02 rows=318,885 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
28. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_31 p_95 (cost=0.00..20,976.42 rows=318,645 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
29. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_8 p_72 (cost=0.00..20,552.87 rows=312,208 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
30. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_47 p_111 (cost=0.00..20,357.31 rows=309,239 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
31. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_47 p_47 (cost=0.00..20,183.75 rows=271,446 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
32. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_44 p_108 (cost=0.00..20,153.93 rows=306,147 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
33. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_49 p_177 (cost=0.00..20,126.81 rows=305,739 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
34. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_1 p_129 (cost=0.00..20,078.72 rows=305,000 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
35. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_10 p_138 (cost=0.00..19,984.31 rows=303,574 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
36. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_31 p_31 (cost=0.00..19,836.67 rows=266,031 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
37. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_57 p_185 (cost=0.00..19,806.86 rows=300,877 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
38. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_54 p_182 (cost=0.00..19,770.42 rows=300,315 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
39. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_38 p_38 (cost=0.00..19,743.18 rows=268,169 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
40. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_60 p_188 (cost=0.00..19,478.95 rows=295,884 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
41. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_24 p_24 (cost=0.00..19,472.71 rows=262,986 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
42. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_19 p_147 (cost=0.00..19,466.03 rows=295,690 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
43. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_8 p_8 (cost=0.00..19,391.10 rows=262,215 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
44. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_42 p_170 (cost=0.00..19,129.36 rows=290,579 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
45. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_10 p_74 (cost=0.00..19,099.69 rows=290,134 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
46. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_55 p_183 (cost=0.00..19,078.97 rows=289,819 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
47. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_1 p_65 (cost=0.00..18,821.01 rows=285,889 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
48. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_12 p_140 (cost=0.00..18,708.52 rows=284,191 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
49. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_60 p_60 (cost=0.00..18,595.83 rows=252,947 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
50. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_42 p_106 (cost=0.00..18,568.57 rows=282,060 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
51. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_20 p_148 (cost=0.00..18,561.95 rows=281,953 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
52. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_11 p_139 (cost=0.00..18,440.27 rows=280,108 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
53. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_54 p_118 (cost=0.00..18,326.25 rows=278,373 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
54. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_44 p_44 (cost=0.00..18,306.85 rows=249,226 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
55. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_12 p_76 (cost=0.00..18,277.16 rows=277,634 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
56. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_23 p_87 (cost=0.00..18,259.13 rows=277,365 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
57. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_57 p_121 (cost=0.00..18,242.34 rows=277,113 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
58. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_35 p_163 (cost=0.00..17,970.24 rows=272,974 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
59. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_1 p_1 (cost=0.00..17,835.51 rows=241,871 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
60. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_41 p_169 (cost=0.00..17,817.43 rows=270,653 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
61. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_52 p_180 (cost=0.00..17,767.99 rows=269,891 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
62. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_11 p_75 (cost=0.00..17,659.31 rows=268,245 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
63. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_49 p_113 (cost=0.00..17,655.59 rows=268,197 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
64. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_35 p_99 (cost=0.00..17,560.93 rows=266,753 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
65. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_42 p_42 (cost=0.00..17,454.65 rows=235,108 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
66. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_57 p_57 (cost=0.00..17,453.42 rows=235,011 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
67. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_20 p_84 (cost=0.00..17,194.40 rows=261,185 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
68. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_55 p_119 (cost=0.00..17,047.92 rows=258,954 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
69. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_41 p_105 (cost=0.00..16,851.28 rows=255,979 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
70. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_25 p_153 (cost=0.00..16,825.19 rows=255,574 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
71. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_10 p_10 (cost=0.00..16,801.86 rows=230,446 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
72. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_19 p_83 (cost=0.00..16,678.98 rows=253,359 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
73. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_12 p_12 (cost=0.00..16,638.82 rows=223,619 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
74. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_21 p_149 (cost=0.00..16,506.71 rows=250,742 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
75. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_54 p_54 (cost=0.00..16,405.79 rows=221,841 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
76. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_23 p_23 (cost=0.00..16,334.34 rows=221,023 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
77. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_37 p_101 (cost=0.00..16,215.23 rows=246,310 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
78. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_50 p_178 (cost=0.00..16,062.54 rows=243,998 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
79. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_49 p_49 (cost=0.00..16,027.49 rows=216,194 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
80. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_18 p_82 (cost=0.00..15,978.39 rows=242,721 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
81. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_20 p_20 (cost=0.00..15,978.29 rows=216,458 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
82. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_63 p_63 (cost=0.00..15,904.54 rows=215,698 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
83. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_58 p_186 (cost=0.00..15,865.62 rows=241,004 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
84. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_3 p_131 (cost=0.00..15,848.68 rows=240,741 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
85. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_25 p_89 (cost=0.00..15,828.06 rows=240,434 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
86. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_6 p_70 (cost=0.00..15,813.90 rows=240,221 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
87. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_52 p_116 (cost=0.00..15,780.05 rows=239,699 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
88. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_37 p_37 (cost=0.00..15,778.72 rows=212,999 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
89. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_50 p_114 (cost=0.00..15,605.30 rows=237,049 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
90. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_53 p_181 (cost=0.00..15,556.13 rows=236,305 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
91. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_63 p_127 (cost=0.00..15,553.51 rows=236,264 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
92. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_63 p_191 (cost=0.00..15,536.56 rows=236,001 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
93. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_6 p_134 (cost=0.00..15,473.17 rows=235,041 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
94. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_40 p_168 (cost=0.00..15,404.45 rows=233,993 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
95. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_18 p_146 (cost=0.00..15,361.65 rows=233,340 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
96. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_3 p_67 (cost=0.00..15,290.60 rows=232,270 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
97. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_29 p_93 (cost=0.00..15,277.57 rows=232,068 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
98. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_50 p_50 (cost=0.00..15,236.17 rows=206,133 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
99. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_29 p_157 (cost=0.00..15,101.58 rows=229,403 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
100. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_37 p_165 (cost=0.00..15,067.84 rows=228,887 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
101. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_55 p_55 (cost=0.00..14,972.05 rows=203,866 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
102. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_52 p_52 (cost=0.00..14,852.91 rows=202,519 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
103. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_13 p_141 (cost=0.00..14,821.66 rows=225,142 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
104. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_11 p_11 (cost=0.00..14,789.41 rows=200,593 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
105. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_61 p_189 (cost=0.00..14,777.69 rows=224,478 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
106. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_35 p_35 (cost=0.00..14,764.73 rows=201,462 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
107. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_3 p_3 (cost=0.00..14,716.72 rows=201,669 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
108. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_40 p_104 (cost=0.00..14,707.60 rows=223,405 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
109. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_53 p_117 (cost=0.00..14,664.85 rows=222,755 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
110. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_6 p_6 (cost=0.00..14,598.97 rows=197,188 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
111. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_25 p_25 (cost=0.00..14,561.46 rows=198,560 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
112. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_41 p_41 (cost=0.00..14,532.98 rows=195,570 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
113. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_26 p_90 (cost=0.00..14,482.28 rows=219,984 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
114. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_19 p_19 (cost=0.00..14,424.15 rows=194,113 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
115. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_58 p_58 (cost=0.00..14,319.23 rows=192,917 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
116. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_21 p_85 (cost=0.00..14,271.30 rows=216,786 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
117. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_27 p_155 (cost=0.00..14,242.69 rows=216,346 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
118. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_5 p_133 (cost=0.00..14,193.61 rows=215,607 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
119. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_46 p_174 (cost=0.00..14,177.96 rows=215,364 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
120. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_58 p_122 (cost=0.00..14,171.53 rows=215,269 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
121. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_46 p_110 (cost=0.00..14,168.90 rows=215,226 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
122. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_5 p_69 (cost=0.00..14,082.01 rows=213,901 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
123. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_26 p_154 (cost=0.00..13,830.87 rows=210,092 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
124. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_13 p_77 (cost=0.00..13,828.17 rows=210,045 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
125. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_28 p_92 (cost=0.00..13,815.39 rows=209,860 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
126. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_18 p_18 (cost=0.00..13,810.04 rows=186,405 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
127. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_28 p_156 (cost=0.00..13,724.35 rows=208,457 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
128. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_61 p_125 (cost=0.00..13,653.54 rows=207,404 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
129. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_5 p_5 (cost=0.00..13,373.75 rows=181,698 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
130. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_29 p_29 (cost=0.00..13,343.89 rows=181,515 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
131. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_26 p_26 (cost=0.00..13,211.71 rows=180,101 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
132. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_27 p_91 (cost=0.00..13,157.49 rows=199,868 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
133. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_59 p_123 (cost=0.00..13,096.59 rows=198,941 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
134. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_61 p_61 (cost=0.00..13,055.00 rows=177,230 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
135. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_33 p_161 (cost=0.00..13,020.21 rows=197,783 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
136. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_46 p_46 (cost=0.00..12,878.85 rows=175,334 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
137. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_39 p_167 (cost=0.00..12,876.38 rows=195,595 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
138. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_33 p_97 (cost=0.00..12,846.52 rows=195,137 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
139. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_17 p_145 (cost=0.00..12,779.08 rows=194,108 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
140. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_14 p_142 (cost=0.00..12,734.00 rows=193,437 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
141. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_59 p_187 (cost=0.00..12,710.55 rows=193,074 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
142. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_36 p_164 (cost=0.00..12,679.81 rows=233,284 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
143. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_17 p_81 (cost=0.00..12,644.44 rows=192,065 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
144. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_0 p_128 (cost=0.00..12,643.79 rows=232,616 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
145. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_59 p_59 (cost=0.00..12,597.94 rows=169,865 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
146. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_4 p_68 (cost=0.00..12,589.83 rows=231,619 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
147. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_28 p_28 (cost=0.00..12,527.87 rows=206,834 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
148. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_21 p_21 (cost=0.00..12,526.69 rows=169,384 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
149. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_48 p_112 (cost=0.00..12,495.83 rows=229,885 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
150. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_16 p_144 (cost=0.00..12,389.44 rows=188,200 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
151. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_56 p_120 (cost=0.00..12,384.24 rows=227,847 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
152. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_27 p_27 (cost=0.00..12,379.01 rows=167,125 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
153. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_43 p_107 (cost=0.00..12,341.37 rows=227,055 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
154. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_15 p_143 (cost=0.00..12,337.64 rows=187,413 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
155. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_48 p_48 (cost=0.00..12,337.04 rows=201,245 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
156. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_17 p_17 (cost=0.00..12,305.51 rows=201,979 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
157. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_0 p_64 (cost=0.00..12,294.26 rows=226,182 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
158. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_30 p_158 (cost=0.00..12,274.19 rows=186,450 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
159. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_39 p_103 (cost=0.00..12,263.71 rows=186,285 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
160. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_43 p_171 (cost=0.00..12,248.86 rows=225,356 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
161. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_13 p_13 (cost=0.00..12,215.85 rows=164,839 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
162. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_40 p_40 (cost=0.00..12,214.51 rows=163,016 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
163. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_15 p_15 (cost=0.00..12,184.80 rows=164,293 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
164. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_15 p_79 (cost=0.00..12,175.63 rows=184,946 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
165. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_53 p_53 (cost=0.00..12,148.41 rows=164,563 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
166. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_14 p_78 (cost=0.00..12,103.82 rows=222,686 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
167. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_36 p_100 (cost=0.00..12,087.70 rows=183,617 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
168. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_30 p_94 (cost=0.00..12,072.15 rows=183,381 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
169. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_39 p_39 (cost=0.00..12,005.61 rows=197,335 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
170. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_4 p_4 (cost=0.00..11,988.94 rows=196,625 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
171. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_56 p_184 (cost=0.00..11,987.85 rows=182,095 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
172. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_30 p_30 (cost=0.00..11,984.99 rows=197,304 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
173. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_36 p_36 (cost=0.00..11,943.74 rows=162,133 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
174. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_45 p_173 (cost=0.00..11,932.33 rows=219,521 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
175. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_34 p_162 (cost=0.00..11,792.82 rows=216,954 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
176. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_33 p_33 (cost=0.00..11,701.79 rows=192,668 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
177. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_16 p_80 (cost=0.00..11,625.64 rows=213,876 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
178. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_43 p_43 (cost=0.00..11,461.39 rows=186,908 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
179. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_56 p_56 (cost=0.00..11,446.17 rows=187,085 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
180. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_48 p_176 (cost=0.00..11,400.67 rows=209,745 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
181. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_9 p_137 (cost=0.00..11,327.61 rows=208,408 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
182. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_45 p_109 (cost=0.00..11,301.25 rows=207,918 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
183. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_9 p_73 (cost=0.00..11,273.60 rows=207,408 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
184. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_4 p_132 (cost=0.00..11,182.39 rows=205,727 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
185. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_0 p (cost=0.00..10,931.10 rows=178,749 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
186. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_14 p_14 (cost=0.00..10,926.83 rows=177,864 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
187. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_16 p_16 (cost=0.00..10,848.01 rows=177,424 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
188. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_34 p_98 (cost=0.00..10,777.54 rows=198,271 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
189. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_32 p_96 (cost=0.00..10,631.15 rows=195,579 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
190. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_2 p_130 (cost=0.00..10,604.92 rows=195,098 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
191. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_2 p_66 (cost=0.00..10,384.11 rows=191,044 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
192. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_45 p_45 (cost=0.00..9,966.74 rows=162,840 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
193. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_32 p_160 (cost=0.00..9,960.09 rows=183,244 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
194. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_2 p_2 (cost=0.00..9,845.27 rows=161,199 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
195. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_9 p_9 (cost=0.00..9,729.25 rows=159,592 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
196. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_34 p_34 (cost=0.00..9,497.46 rows=155,322 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
197. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_32 p_32 (cost=0.00..9,225.16 rows=152,051 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
198. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_07_hash_62 p_126 (cost=0.00..8,533.18 rows=156,988 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
199. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_06_hash_62 p_62 (cost=0.00..8,484.72 rows=138,757 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
200. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_08_hash_62 p_190 (cost=0.00..8,440.59 rows=155,282 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
201. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_51 p_243 (cost=0.00..1,316.34 rows=29,855 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
202. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_7 p_199 (cost=0.00..1,202.77 rows=27,079 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
203. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_31 p_223 (cost=0.00..1,170.09 rows=26,509 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
204. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_38 p_230 (cost=0.00..1,108.66 rows=24,826 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
205. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_23 p_215 (cost=0.00..1,107.41 rows=25,111 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
206. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_22 p_214 (cost=0.00..1,107.23 rows=25,286 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
207. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_49 p_241 (cost=0.00..1,077.96 rows=24,481 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
208. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_8 p_200 (cost=0.00..1,073.43 rows=24,508 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
209. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_47 p_239 (cost=0.00..1,068.96 rows=24,196 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
210. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_19 p_211 (cost=0.00..1,060.95 rows=24,031 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
211. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_10 p_202 (cost=0.00..1,048.84 rows=23,982 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
212. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_44 p_236 (cost=0.00..1,008.58 rows=22,909 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
213. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_1 p_193 (cost=0.00..970.11 rows=22,119 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
214. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_11 p_203 (cost=0.00..953.41 rows=21,849 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
215. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_42 p_234 (cost=0.00..944.09 rows=21,148 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
216. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_55 p_247 (cost=0.00..942.70 rows=21,118 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
217. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_24 p_216 (cost=0.00..938.01 rows=21,446 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
218. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_12 p_204 (cost=0.00..937.90 rows=21,431 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
219. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_20 p_212 (cost=0.00..921.35 rows=20,955 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
220. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_57 p_249 (cost=0.00..902.63 rows=20,309 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
221. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_54 p_246 (cost=0.00..892.17 rows=20,122 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
222. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_41 p_233 (cost=0.00..890.36 rows=20,214 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
223. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_60 p_252 (cost=0.00..871.98 rows=19,799 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
224. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_35 p_227 (cost=0.00..868.86 rows=19,692 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
225. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_52 p_244 (cost=0.00..859.86 rows=19,256 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
226. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_18 p_210 (cost=0.00..833.57 rows=19,070 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
227. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_21 p_213 (cost=0.00..831.94 rows=18,945 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
228. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_63 p_255 (cost=0.00..806.00 rows=18,160 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
229. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_61 p_253 (cost=0.00..804.09 rows=18,182 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
230. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_25 p_217 (cost=0.00..802.79 rows=18,142 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
231. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_40 p_232 (cost=0.00..785.90 rows=17,867 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
232. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_29 p_221 (cost=0.00..768.82 rows=17,227 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
233. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_3 p_195 (cost=0.00..764.47 rows=17,177 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
234. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_50 p_242 (cost=0.00..756.74 rows=17,170 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
235. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_6 p_198 (cost=0.00..744.05 rows=16,964 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
236. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_53 p_245 (cost=0.00..733.54 rows=16,591 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
237. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_58 p_250 (cost=0.00..728.89 rows=16,484 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
238. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_26 p_218 (cost=0.00..724.31 rows=16,183 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
239. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_13 p_205 (cost=0.00..724.16 rows=16,468 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
240. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_5 p_197 (cost=0.00..717.82 rows=16,288 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
241. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_27 p_219 (cost=0.00..693.26 rows=15,672 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
242. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_37 p_229 (cost=0.00..692.95 rows=15,720 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
243. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_33 p_225 (cost=0.00..690.09 rows=15,641 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
244. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_39 p_231 (cost=0.00..677.88 rows=15,235 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
245. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_14 p_206 (cost=0.00..670.65 rows=15,285 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
246. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_28 p_220 (cost=0.00..662.49 rows=15,003 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
247. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_46 p_238 (cost=0.00..645.77 rows=14,648 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
248. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_15 p_207 (cost=0.00..636.69 rows=14,469 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
249. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_17 p_209 (cost=0.00..619.45 rows=13,868 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
250. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_34 p_226 (cost=0.00..610.60 rows=13,887 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
251. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_43 p_235 (cost=0.00..598.05 rows=13,559 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
252. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_30 p_222 (cost=0.00..586.71 rows=13,345 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
253. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_48 p_240 (cost=0.00..578.26 rows=13,109 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
254. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_59 p_251 (cost=0.00..578.12 rows=13,078 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
255. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_0 p_192 (cost=0.00..574.89 rows=12,878 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
256. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_16 p_208 (cost=0.00..565.73 rows=12,850 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
257. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_36 p_228 (cost=0.00..564.53 rows=12,775 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
258. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_56 p_248 (cost=0.00..561.07 rows=12,624 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
259. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_9 p_201 (cost=0.00..542.93 rows=12,662 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
260. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_45 p_237 (cost=0.00..539.52 rows=12,222 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
261. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_4 p_196 (cost=0.00..524.41 rows=11,944 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
262. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_2 p_194 (cost=0.00..516.58 rows=11,746 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
263. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_32 p_224 (cost=0.00..425.75 rows=9,528 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
264. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on products_total_views_2020_09_hash_62 p_254 (cost=0.00..362.81 rows=8,192 width=58) (actual rows= loops=)

  • Filter: ((partition_time >= '2020-06-04 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone))
265. 0.000 0.000 ↓ 0.0

Sort (cost=64,867.83..65,058.39 rows=76,227 width=50) (actual rows= loops=)

  • Sort Key: products_total_views_2020_09_hash_0.merchant_id, products_total_views_2020_09_hash_0.product_id
266. 0.000 0.000 ↓ 0.0

Append (cost=0.00..58,686.57 rows=76,227 width=50) (actual rows= loops=)

267. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_0 (cost=0.00..658.59 rows=843 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
268. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_1 (cost=0.00..1,111.41 rows=1,468 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
269. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_2 (cost=0.00..591.83 rows=735 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
270. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_3 (cost=0.00..875.91 rows=1,043 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
271. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_4 (cost=0.00..600.84 rows=814 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
272. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_5 (cost=0.00..822.33 rows=990 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
273. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_6 (cost=0.00..852.40 rows=1,007 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
274. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_7 (cost=0.00..1,378.09 rows=1,612 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
275. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_8 (cost=0.00..1,229.86 rows=1,648 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
276. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_9 (cost=0.00..622.06 rows=927 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
277. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_10 (cost=0.00..1,201.69 rows=1,595 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
278. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_11 (cost=0.00..1,092.34 rows=1,422 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
279. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_12 (cost=0.00..1,074.53 rows=1,293 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
280. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_13 (cost=0.00..829.64 rows=1,002 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
281. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_14 (cost=0.00..768.42 rows=1,030 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
282. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_15 (cost=0.00..729.48 rows=1,022 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
283. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_16 (cost=0.00..648.11 rows=843 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
284. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_17 (cost=0.00..709.64 rows=1,034 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
285. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_18 (cost=0.00..955.06 rows=1,301 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
286. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_19 (cost=0.00..1,215.51 rows=1,429 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
287. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_20 (cost=0.00..1,055.66 rows=1,449 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
288. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_21 (cost=0.00..953.16 rows=1,291 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
289. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_22 (cost=0.00..1,268.58 rows=1,640 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
290. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_23 (cost=0.00..1,268.84 rows=1,928 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
291. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_24 (cost=0.00..1,074.67 rows=1,450 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
292. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_25 (cost=0.00..919.79 rows=1,450 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
293. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_26 (cost=0.00..829.85 rows=1,075 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
294. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_27 (cost=0.00..794.20 rows=1,045 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
295. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_28 (cost=0.00..758.94 rows=1,022 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
296. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_29 (cost=0.00..880.83 rows=1,009 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
297. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_30 (cost=0.00..672.01 rows=969 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
298. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_31 (cost=0.00..1,340.54 rows=1,729 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
299. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_32 (cost=0.00..487.73 rows=684 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
300. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_33 (cost=0.00..790.54 rows=999 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
301. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_34 (cost=0.00..699.60 rows=974 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
302. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_35 (cost=0.00..995.48 rows=1,412 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
303. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_36 (cost=0.00..646.84 rows=846 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
304. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_37 (cost=0.00..793.76 rows=1,039 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
305. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_38 (cost=0.00..1,270.19 rows=1,507 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
306. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_39 (cost=0.00..776.58 rows=900 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
307. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_40 (cost=0.00..900.44 rows=1,204 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
308. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_41 (cost=0.00..1,020.09 rows=1,257 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
309. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_42 (cost=0.00..1,081.62 rows=1,438 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
310. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_43 (cost=0.00..685.15 rows=1,023 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
311. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_44 (cost=0.00..1,155.49 rows=1,473 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
312. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_45 (cost=0.00..618.08 rows=858 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
313. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_46 (cost=0.00..739.84 rows=993 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
314. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_47 (cost=0.00..1,224.78 rows=1,538 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
315. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_48 (cost=0.00..662.54 rows=818 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
316. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_49 (cost=0.00..1,235.03 rows=1,658 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
317. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_50 (cost=0.00..867.05 rows=1,161 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
318. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_51 (cost=0.00..1,508.15 rows=1,984 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
319. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_52 (cost=0.00..985.23 rows=1,208 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
320. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_53 (cost=0.00..840.42 rows=1,104 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
321. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_54 (cost=0.00..1,022.24 rows=1,315 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
322. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_55 (cost=0.00..1,080.08 rows=1,399 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
323. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_56 (cost=0.00..642.76 rows=920 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
324. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_57 (cost=0.00..1,034.14 rows=1,220 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
325. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_58 (cost=0.00..835.10 rows=992 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
326. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_59 (cost=0.00..662.34 rows=934 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
327. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_60 (cost=0.00..999.05 rows=1,411 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
328. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_61 (cost=0.00..921.21 rows=1,210 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
329. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_62 (cost=0.00..415.65 rows=522 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
330. 0.000 0.000 ↓ 0.0

Seq Scan on products_total_views_2020_09_hash_63 (cost=0.00..923.50 rows=1,111 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
331. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=513,410.56..514,752.56 rows=40,000 width=82) (actual rows= loops=)

  • Group Key: c.merchant_id, c.product_id
332. 0.000 0.000 ↓ 0.0

Gather Merge (cost=513,410.56..513,852.56 rows=40,000 width=82) (actual rows= loops=)

  • Workers Planned: 1
333. 0.000 0.000 ↓ 0.0

Sort (cost=513,400.55..513,500.55 rows=40,000 width=82) (actual rows= loops=)

  • Sort Key: c.merchant_id, c.product_id
334. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=509,843.01..510,343.01 rows=40,000 width=82) (actual rows= loops=)

  • Group Key: c.merchant_id, c.product_id
335. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..487,717.95 rows=2,212,506 width=66) (actual rows= loops=)

336. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..6,205.81 rows=5,638 width=50) (actual rows= loops=)

337. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_7 (cost=0.00..749.68 rows=742 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
338. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_9 (cost=0.00..707.72 rows=621 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
339. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_1 (cost=0.00..692.36 rows=633 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
340. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_0 (cost=0.00..619.34 rows=545 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
341. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_8 (cost=0.00..617.68 rows=594 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
342. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_2 (cost=0.00..614.86 rows=573 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
343. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_5 (cost=0.00..603.67 rows=551 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
344. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_4 (cost=0.00..584.21 rows=508 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
345. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_3 (cost=0.00..524.97 rows=453 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
346. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cart_item_histories_2020_09_hash_6 (cost=0.00..463.12 rows=418 width=50) (actual rows= loops=)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
347. 0.000 0.000 ↓ 0.0

Append (cost=0.42..85.00 rows=40 width=66) (actual rows= loops=)

348. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_0_product_id_idx on cart_item_histories_2020_06_hash_0 c (cost=0.42..2.57 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
349. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_1_product_id_idx on cart_item_histories_2020_06_hash_1 c_1 (cost=0.42..2.52 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
350. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_2_product_id_idx on cart_item_histories_2020_06_hash_2 c_2 (cost=0.42..2.51 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
351. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_3_product_id_idx on cart_item_histories_2020_06_hash_3 c_3 (cost=0.42..1.98 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
352. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_4_product_id_idx on cart_item_histories_2020_06_hash_4 c_4 (cost=0.42..2.54 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
353. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_5_product_id_idx on cart_item_histories_2020_06_hash_5 c_5 (cost=0.42..2.17 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
354. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_6_product_id_idx on cart_item_histories_2020_06_hash_6 c_6 (cost=0.42..2.10 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
355. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_7_product_id_idx on cart_item_histories_2020_06_hash_7 c_7 (cost=0.42..2.97 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
356. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_8_product_id_idx on cart_item_histories_2020_06_hash_8 c_8 (cost=0.42..2.42 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
357. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_06_hash_9_product_id_idx on cart_item_histories_2020_06_hash_9 c_9 (cost=0.42..2.74 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
358. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_0_product_id_idx on cart_item_histories_2020_07_hash_0 c_10 (cost=0.42..2.88 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
359. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_1_product_id_idx on cart_item_histories_2020_07_hash_1 c_11 (cost=0.42..2.62 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
360. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_2_product_id_idx on cart_item_histories_2020_07_hash_2 c_12 (cost=0.42..2.62 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
361. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_3_product_id_idx on cart_item_histories_2020_07_hash_3 c_13 (cost=0.42..2.24 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
362. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_4_product_id_idx on cart_item_histories_2020_07_hash_4 c_14 (cost=0.42..2.76 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
363. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_5_product_id_idx on cart_item_histories_2020_07_hash_5 c_15 (cost=0.42..2.37 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
364. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_6_product_id_idx on cart_item_histories_2020_07_hash_6 c_16 (cost=0.42..2.41 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
365. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_7_product_id_idx on cart_item_histories_2020_07_hash_7 c_17 (cost=0.42..3.20 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
366. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_8_product_id_idx on cart_item_histories_2020_07_hash_8 c_18 (cost=0.42..2.65 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
367. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_07_hash_9_product_id_idx on cart_item_histories_2020_07_hash_9 c_19 (cost=0.42..2.96 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
368. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_0_product_id_idx on cart_item_histories_2020_08_hash_0 c_20 (cost=0.42..2.97 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
369. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_1_product_id_idx on cart_item_histories_2020_08_hash_1 c_21 (cost=0.42..2.98 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
370. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_2_product_id_idx on cart_item_histories_2020_08_hash_2 c_22 (cost=0.42..2.94 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
371. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_3_product_id_idx on cart_item_histories_2020_08_hash_3 c_23 (cost=0.42..2.40 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
372. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_4_product_id_idx on cart_item_histories_2020_08_hash_4 c_24 (cost=0.42..2.82 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
373. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_5_product_id_idx on cart_item_histories_2020_08_hash_5 c_25 (cost=0.42..2.72 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
374. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_6_product_id_idx on cart_item_histories_2020_08_hash_6 c_26 (cost=0.42..2.42 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
375. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_7_product_id_idx on cart_item_histories_2020_08_hash_7 c_27 (cost=0.42..3.46 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
376. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_8_product_id_idx on cart_item_histories_2020_08_hash_8 c_28 (cost=0.42..2.91 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
377. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_part_2020_08_hash_9_product_id_idx on cart_item_histories_2020_08_hash_9 c_29 (cost=0.42..3.20 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
378. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_0_product_id_idx1 on cart_item_histories_2020_09_hash_0 c_30 (cost=0.41..0.54 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
379. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_1_product_id_idx1 on cart_item_histories_2020_09_hash_1 c_31 (cost=0.41..0.55 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
380. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_2_product_id_idx1 on cart_item_histories_2020_09_hash_2 c_32 (cost=0.41..0.54 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
381. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_3_product_id_idx1 on cart_item_histories_2020_09_hash_3 c_33 (cost=0.29..0.40 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
382. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_4_product_id_idx1 on cart_item_histories_2020_09_hash_4 c_34 (cost=0.29..0.41 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
383. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_5_product_id_idx1 on cart_item_histories_2020_09_hash_5 c_35 (cost=0.29..0.41 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
384. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_6_product_id_idx1 on cart_item_histories_2020_09_hash_6 c_36 (cost=0.29..0.40 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
385. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_7_product_id_idx1 on cart_item_histories_2020_09_hash_7 c_37 (cost=0.41..0.55 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
386. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_8_product_id_idx1 on cart_item_histories_2020_09_hash_8 c_38 (cost=0.29..0.41 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
387. 0.000 0.000 ↓ 0.0

Index Scan using cart_item_histories_2020_09_hash_9_product_id_idx1 on cart_item_histories_2020_09_hash_9 c_39 (cost=0.41..0.55 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((product_id)::text = (cart_item_histories_2020_09_hash_7.product_id)::text)
  • Filter: ((partition_time >= '2020-06-03 07:00:00'::timestamp without time zone) AND (partition_time < '2020-09-02 07:00:00'::timestamp without time zone) AND (started_hour >= '2020-06-04 07:00:00'::timestamp without time zone) AND (started_hour < '2020-09-02 07:00:00'::timestamp without time zone) AND ((cart_item_histories_2020_09_hash_7.merchant_id)::text = (merchant_id)::text))
388. 0.000 0.000 ↓ 0.0

Hash (cost=58,195.32..58,195.32 rows=358 width=63) (actual rows= loops=)

389. 0.000 0.000 ↓ 0.0

Gather (cost=10.00..58,195.32 rows=358 width=63) (actual rows= loops=)

  • Workers Planned: 4
390. 0.000 0.000 ↓ 0.0

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

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)