explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6djd

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 12.322 ↑ 4.6 14 1

Hash Full Join (cost=6,043.02..6,352.17 rows=64 width=141) (actual time=12.315..12.322 rows=14 loops=1)

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

Seq Scan on products_total_sold_lifetime (cost=0.00..309.00 rows=3 width=63) (actual time=1.620..1.620 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 11,237
3. 0.008 10.687 ↑ 4.6 14 1

Hash (cost=6,042.06..6,042.06 rows=64 width=164) (actual time=10.687..10.687 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
4. 0.012 10.679 ↑ 4.6 14 1

Merge Full Join (cost=6,039.49..6,042.06 rows=64 width=164) (actual time=10.612..10.679 rows=14 loops=1)

  • Merge Cond: (((p.merchant_id)::text = (c.merchant_id)::text) AND ((p.product_id)::text = (c.product_id)::text))
5. 0.032 6.369 ↑ 8.0 8 1

GroupAggregate (cost=5,359.56..5,361.00 rows=64 width=82) (actual time=6.339..6.369 rows=8 loops=1)

  • Group Key: p.merchant_id, p.product_id
6. 0.044 6.337 ↓ 1.1 70 1

Sort (cost=5,359.56..5,359.72 rows=64 width=58) (actual time=6.330..6.337 rows=70 loops=1)

  • Sort Key: p.merchant_id, p.product_id
  • Sort Method: quicksort Memory: 34kB
7. 1.686 6.293 ↓ 1.1 70 1

Hash Join (cost=1,068.45..5,357.64 rows=64 width=58) (actual time=0.418..6.293 rows=70 loops=1)

  • Hash Cond: (((p.merchant_id)::text = (products_total_views_2020_09_hash_0.merchant_id)::text) AND ((p.product_id)::text = (products_total_views_2020_09_hash_0.product_id)::text))
8. 1.067 4.395 ↓ 1.2 15,444 1

Append (cost=0.00..4,188.24 rows=13,374 width=59) (actual time=0.009..4.395 rows=15,444 loops=1)

9. 0.009 0.009 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_06_hash_0 p (cost=0.00..18.70 rows=3 width=72) (actual time=0.009..0.009 rows=3 loops=1)

  • 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.006 0.006 ↓ 6.0 18 1

Seq Scan on products_total_views_2020_06_hash_1 p_1 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.006 rows=18 loops=1)

  • 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.006 0.006 ↓ 5.3 16 1

Seq Scan on products_total_views_2020_06_hash_2 p_2 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.006 rows=16 loops=1)

  • 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.004 0.004 ↓ 2.7 8 1

Seq Scan on products_total_views_2020_06_hash_3 p_3 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=8 loops=1)

  • 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.037 0.037 ↑ 1.0 178 1

Seq Scan on products_total_views_2020_06_hash_4 p_4 (cost=0.00..6.98 rows=179 width=58) (actual time=0.007..0.037 rows=178 loops=1)

  • 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))
  • Rows Removed by Filter: 21
14. 0.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_06_hash_5 p_5 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=2 loops=1)

  • 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))
  • Rows Removed by Filter: 1
15. 0.005 0.005 ↓ 4.0 12 1

Seq Scan on products_total_views_2020_06_hash_6 p_6 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=12 loops=1)

  • 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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_06_hash_7 p_7 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_part_2_merchant_id_partition_time__idx2663 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.019 0.019 ↑ 1.0 64 1

Seq Scan on products_total_views_2020_06_hash_8 p_8 (cost=0.00..3.65 rows=65 width=58) (actual time=0.008..0.019 rows=64 loops=1)

  • 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))
  • Rows Removed by Filter: 46
19. 0.010 0.010 ↓ 16.0 48 1

Seq Scan on products_total_views_2020_06_hash_9 p_9 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.010 rows=48 loops=1)

  • 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))
  • Rows Removed by Filter: 1
20. 0.013 0.013 ↑ 1.0 54 1

Seq Scan on products_total_views_2020_06_hash_10 p_10 (cost=0.00..1.85 rows=56 width=58) (actual time=0.006..0.013 rows=54 loops=1)

  • 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))
  • Rows Removed by Filter: 3
21. 0.007 0.007 ↓ 9.3 28 1

Seq Scan on products_total_views_2020_06_hash_11 p_11 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.007 rows=28 loops=1)

  • 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))
  • Rows Removed by Filter: 1
22. 0.008 0.008 ↓ 10.3 31 1

Seq Scan on products_total_views_2020_06_hash_12 p_12 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=31 loops=1)

  • 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))
  • Rows Removed by Filter: 3
23. 0.007 0.007 ↓ 5.7 17 1

Seq Scan on products_total_views_2020_06_hash_13 p_13 (cost=0.00..18.70 rows=3 width=72) (actual time=0.005..0.007 rows=17 loops=1)

  • 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))
  • Rows Removed by Filter: 16
24. 0.005 0.005 ↓ 5.0 15 1

Seq Scan on products_total_views_2020_06_hash_14 p_14 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=15 loops=1)

  • 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))
  • Rows Removed by Filter: 3
25. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_06_hash_15 p_15 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=3 loops=1)

  • 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))
  • Rows Removed by Filter: 1
26. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_06_hash_16 p_16 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_part_2_merchant_id_partition_time__idx2672 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.006 0.006 ↓ 6.0 18 1

Seq Scan on products_total_views_2020_06_hash_17 p_17 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=18 loops=1)

  • 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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_06_hash_18 p_18 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_part_2_merchant_id_partition_time__idx2674 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.003 0.003 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_06_hash_19 p_19 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=3 loops=1)

  • 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.003 0.003 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_06_hash_20 p_20 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=3 loops=1)

  • 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.007 0.007 ↓ 6.3 19 1

Seq Scan on products_total_views_2020_06_hash_21 p_21 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.007 rows=19 loops=1)

  • 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))
  • Rows Removed by Filter: 4
34. 0.009 0.009 ↓ 10.0 30 1

Seq Scan on products_total_views_2020_06_hash_22 p_22 (cost=0.00..18.70 rows=3 width=72) (actual time=0.005..0.009 rows=30 loops=1)

  • 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))
  • Rows Removed by Filter: 8
35. 0.008 0.008 ↓ 9.7 29 1

Seq Scan on products_total_views_2020_06_hash_23 p_23 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=29 loops=1)

  • 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))
  • Rows Removed by Filter: 7
36. 0.013 0.013 ↑ 1.0 55 1

Seq Scan on products_total_views_2020_06_hash_24 p_24 (cost=0.00..3.02 rows=56 width=58) (actual time=0.006..0.013 rows=55 loops=1)

  • 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))
  • Rows Removed by Filter: 13
37. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_06_hash_25 p_25 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_part_2_merchant_id_partition_time__idx2681 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.004 0.004 ↓ 1.3 4 1

Seq Scan on products_total_views_2020_06_hash_26 p_26 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.004 rows=4 loops=1)

  • 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))
  • Rows Removed by Filter: 2
40. 0.028 0.028 ↑ 1.0 138 1

Seq Scan on products_total_views_2020_06_hash_27 p_27 (cost=0.00..5.19 rows=139 width=58) (actual time=0.005..0.028 rows=138 loops=1)

  • 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))
  • Rows Removed by Filter: 8
41. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_06_hash_28 p_28 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=1 loops=1)

  • 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.027 0.027 ↑ 1.0 144 1

Seq Scan on products_total_views_2020_06_hash_29 p_29 (cost=0.00..5.22 rows=144 width=58) (actual time=0.004..0.027 rows=144 loops=1)

  • 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))
  • Rows Removed by Filter: 4
43. 0.007 0.007 ↓ 5.7 17 1

Seq Scan on products_total_views_2020_06_hash_30 p_30 (cost=0.00..18.70 rows=3 width=72) (actual time=0.005..0.007 rows=17 loops=1)

  • 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))
  • Rows Removed by Filter: 16
44. 0.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_06_hash_31 p_31 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=2 loops=1)

  • 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))
  • Rows Removed by Filter: 1
45. 0.005 0.005 ↓ 4.0 12 1

Seq Scan on products_total_views_2020_06_hash_32 p_32 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=12 loops=1)

  • 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.004 0.004 ↓ 4.0 12 1

Seq Scan on products_total_views_2020_06_hash_33 p_33 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=12 loops=1)

  • 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.010 0.010 ↓ 13.7 41 1

Seq Scan on products_total_views_2020_06_hash_34 p_34 (cost=0.00..18.70 rows=3 width=72) (actual time=0.005..0.010 rows=41 loops=1)

  • 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))
  • Rows Removed by Filter: 8
48. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_06_hash_35 p_35 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=1 loops=1)

  • 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))
  • Rows Removed by Filter: 1
49. 0.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_06_hash_36 p_36 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=2 loops=1)

  • 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))
  • Rows Removed by Filter: 2
50. 0.005 0.005 ↓ 3.3 10 1

Seq Scan on products_total_views_2020_06_hash_37 p_37 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=10 loops=1)

  • 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))
  • Rows Removed by Filter: 1
51. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_06_hash_38 p_38 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_part_2_merchant_id_partition_time__idx2694 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.004 0.004 ↓ 1.3 4 1

Seq Scan on products_total_views_2020_06_hash_39 p_39 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=4 loops=1)

  • 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.011 0.011 ↑ 1.0 50 1

Seq Scan on products_total_views_2020_06_hash_40 p_40 (cost=0.00..1.77 rows=51 width=58) (actual time=0.004..0.011 rows=50 loops=1)

  • 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))
  • Rows Removed by Filter: 1
55. 0.048 0.048 ↑ 1.0 232 1

Seq Scan on products_total_views_2020_06_hash_41 p_41 (cost=0.00..9.26 rows=232 width=58) (actual time=0.008..0.048 rows=232 loops=1)

  • 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))
  • Rows Removed by Filter: 52
56. 0.004 0.004 ↓ 2.7 8 1

Seq Scan on products_total_views_2020_06_hash_42 p_42 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=8 loops=1)

  • 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.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_06_hash_43 p_43 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_part_2_merchant_id_partition_time__idx2699 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.045 0.045 ↑ 1.0 206 1

Seq Scan on products_total_views_2020_06_hash_44 p_44 (cost=0.00..9.04 rows=207 width=58) (actual time=0.012..0.045 rows=206 loops=1)

  • 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))
  • Rows Removed by Filter: 63
60. 0.003 0.003 ↓ 1.3 4 1

Seq Scan on products_total_views_2020_06_hash_45 p_45 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=4 loops=1)

  • 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))
  • Rows Removed by Filter: 1
61. 0.013 0.013 ↑ 1.0 63 1

Seq Scan on products_total_views_2020_06_hash_46 p_46 (cost=0.00..2.94 rows=63 width=58) (actual time=0.005..0.013 rows=63 loops=1)

  • 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.008 0.008 ↓ 10.3 31 1

Seq Scan on products_total_views_2020_06_hash_47 p_47 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=31 loops=1)

  • 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.010 0.010 ↓ 15.0 45 1

Seq Scan on products_total_views_2020_06_hash_48 p_48 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.010 rows=45 loops=1)

  • 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.008 0.008 ↓ 11.0 33 1

Seq Scan on products_total_views_2020_06_hash_49 p_49 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=33 loops=1)

  • 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))
  • Rows Removed by Filter: 6
65. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_06_hash_50 p_50 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=1 loops=1)

  • 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.004 0.004 ↓ 1.7 5 1

Seq Scan on products_total_views_2020_06_hash_51 p_51 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=5 loops=1)

  • 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))
  • Rows Removed by Filter: 2
67. 0.007 0.007 ↓ 9.0 27 1

Seq Scan on products_total_views_2020_06_hash_52 p_52 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.007 rows=27 loops=1)

  • 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.004 0.004 ↓ 2.3 7 1

Seq Scan on products_total_views_2020_06_hash_53 p_53 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=7 loops=1)

  • 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.004 0.004 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_06_hash_54 p_54 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.004 rows=3 loops=1)

  • 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))
  • Rows Removed by Filter: 9
70. 0.013 0.013 ↑ 1.0 63 1

Seq Scan on products_total_views_2020_06_hash_55 p_55 (cost=0.00..2.94 rows=63 width=58) (actual time=0.005..0.013 rows=63 loops=1)

  • 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.004 0.004 ↓ 2.3 7 1

Seq Scan on products_total_views_2020_06_hash_56 p_56 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=7 loops=1)

  • 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.005 0.005 ↓ 4.7 14 1

Seq Scan on products_total_views_2020_06_hash_57 p_57 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=14 loops=1)

  • 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))
  • Rows Removed by Filter: 1
73. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_06_hash_58 p_58 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=3 loops=1)

  • 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))
  • Rows Removed by Filter: 2
74. 0.004 0.004 ↓ 1.7 5 1

Seq Scan on products_total_views_2020_06_hash_59 p_59 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=5 loops=1)

  • 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.009 0.009 ↓ 13.0 39 1

Seq Scan on products_total_views_2020_06_hash_60 p_60 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.009 rows=39 loops=1)

  • 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))
  • Rows Removed by Filter: 1
76. 0.006 0.006 ↓ 5.7 17 1

Seq Scan on products_total_views_2020_06_hash_61 p_61 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=17 loops=1)

  • 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.006 0.006 ↓ 4.0 12 1

Seq Scan on products_total_views_2020_06_hash_62 p_62 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.006 rows=12 loops=1)

  • 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))
  • Rows Removed by Filter: 4
78. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_06_hash_63 p_63 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.005 rows=3 loops=1)

  • 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))
  • Rows Removed by Filter: 6
79. 0.009 0.009 ↓ 11.3 34 1

Seq Scan on products_total_views_2020_07_hash_0 p_64 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.009 rows=34 loops=1)

  • 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.007 0.007 ↓ 7.7 23 1

Seq Scan on products_total_views_2020_07_hash_1 p_65 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.007 rows=23 loops=1)

  • 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.019 0.019 ↑ 1.0 96 1

Seq Scan on products_total_views_2020_07_hash_2 p_66 (cost=0.00..3.44 rows=96 width=58) (actual time=0.005..0.019 rows=96 loops=1)

  • 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.007 0.007 ↓ 5.3 16 1

Seq Scan on products_total_views_2020_07_hash_3 p_67 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.007 rows=16 loops=1)

  • 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.067 0.067 ↑ 1.0 377 1

Seq Scan on products_total_views_2020_07_hash_4 p_68 (cost=0.00..12.65 rows=377 width=58) (actual time=0.005..0.067 rows=377 loops=1)

  • 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.014 0.014 ↑ 1.0 68 1

Seq Scan on products_total_views_2020_07_hash_5 p_69 (cost=0.00..3.02 rows=68 width=58) (actual time=0.004..0.014 rows=68 loops=1)

  • 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.019 0.019 ↑ 1.0 104 1

Seq Scan on products_total_views_2020_07_hash_6 p_70 (cost=0.00..3.56 rows=104 width=58) (actual time=0.004..0.019 rows=104 loops=1)

  • 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.512 0.512 ↑ 1.0 3,114 1

Seq Scan on products_total_views_2020_07_hash_7 p_71 (cost=0.00..98.71 rows=3,114 width=58) (actual time=0.004..0.512 rows=3,114 loops=1)

  • 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.010 0.010 ↓ 13.7 41 1

Seq Scan on products_total_views_2020_07_hash_8 p_72 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.010 rows=41 loops=1)

  • 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.011 0.011 ↑ 1.0 52 1

Seq Scan on products_total_views_2020_07_hash_9 p_73 (cost=0.00..1.78 rows=52 width=58) (actual time=0.004..0.011 rows=52 loops=1)

  • 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.016 0.016 ↑ 1.0 75 1

Seq Scan on products_total_views_2020_07_hash_10 p_74 (cost=0.00..3.12 rows=75 width=58) (actual time=0.005..0.016 rows=75 loops=1)

  • 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.008 0.008 ↓ 10.7 32 1

Seq Scan on products_total_views_2020_07_hash_11 p_75 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.008 rows=32 loops=1)

  • 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.011 0.011 ↓ 16.3 49 1

Seq Scan on products_total_views_2020_07_hash_12 p_76 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.011 rows=49 loops=1)

  • 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.004 0.004 ↓ 1.7 5 1

Seq Scan on products_total_views_2020_07_hash_13 p_77 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=5 loops=1)

  • 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.040 0.040 ↑ 1.0 210 1

Seq Scan on products_total_views_2020_07_hash_14 p_78 (cost=0.00..7.15 rows=210 width=58) (actual time=0.006..0.040 rows=210 loops=1)

  • 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.008 0.008 ↓ 10.7 32 1

Seq Scan on products_total_views_2020_07_hash_15 p_79 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=32 loops=1)

  • 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.006 0.006 ↓ 7.0 21 1

Seq Scan on products_total_views_2020_07_hash_16 p_80 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=21 loops=1)

  • 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.006 0.006 ↓ 4.3 13 1

Seq Scan on products_total_views_2020_07_hash_17 p_81 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.006 rows=13 loops=1)

  • 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.004 0.004 ↓ 1.7 5 1

Seq Scan on products_total_views_2020_07_hash_18 p_82 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=5 loops=1)

  • 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.005 0.005 ↓ 4.7 14 1

Seq Scan on products_total_views_2020_07_hash_19 p_83 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=14 loops=1)

  • 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.004 0.004 ↓ 1.7 5 1

Seq Scan on products_total_views_2020_07_hash_20 p_84 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=5 loops=1)

  • 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.008 0.008 ↓ 11.0 33 1

Seq Scan on products_total_views_2020_07_hash_21 p_85 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=33 loops=1)

  • 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.008 0.008 ↓ 10.3 31 1

Seq Scan on products_total_views_2020_07_hash_22 p_86 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=31 loops=1)

  • 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.173 0.173 ↑ 1.0 1,037 1

Seq Scan on products_total_views_2020_07_hash_23 p_87 (cost=0.00..32.55 rows=1,037 width=58) (actual time=0.005..0.173 rows=1,037 loops=1)

  • 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.116 0.116 ↑ 1.0 694 1

Seq Scan on products_total_views_2020_07_hash_24 p_88 (cost=0.00..22.41 rows=694 width=58) (actual time=0.004..0.116 rows=694 loops=1)

  • 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.004 0.004 ↓ 4.3 13 1

Seq Scan on products_total_views_2020_07_hash_25 p_89 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=13 loops=1)

  • 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.006 0.006 ↓ 8.3 25 1

Seq Scan on products_total_views_2020_07_hash_26 p_90 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=25 loops=1)

  • 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.041 0.041 ↑ 1.0 219 1

Seq Scan on products_total_views_2020_07_hash_27 p_91 (cost=0.00..7.29 rows=219 width=58) (actual time=0.005..0.041 rows=219 loops=1)

  • 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.005 0.005 ↓ 2.0 6 1

Seq Scan on products_total_views_2020_07_hash_28 p_92 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.005 rows=6 loops=1)

  • 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.049 0.049 ↑ 1.0 262 1

Seq Scan on products_total_views_2020_07_hash_29 p_93 (cost=0.00..8.93 rows=262 width=58) (actual time=0.005..0.049 rows=262 loops=1)

  • 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.007 0.007 ↓ 9.3 28 1

Seq Scan on products_total_views_2020_07_hash_30 p_94 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.007 rows=28 loops=1)

  • 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.008 0.008 ↓ 10.3 31 1

Seq Scan on products_total_views_2020_07_hash_31 p_95 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=31 loops=1)

  • 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.019 0.019 ↑ 1.0 107 1

Seq Scan on products_total_views_2020_07_hash_32 p_96 (cost=0.00..3.60 rows=107 width=58) (actual time=0.004..0.019 rows=107 loops=1)

  • 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.012 0.012 ↑ 1.0 58 1

Seq Scan on products_total_views_2020_07_hash_33 p_97 (cost=0.00..1.87 rows=58 width=58) (actual time=0.005..0.012 rows=58 loops=1)

  • 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.012 0.012 ↑ 1.0 55 1

Seq Scan on products_total_views_2020_07_hash_34 p_98 (cost=0.00..1.82 rows=55 width=58) (actual time=0.005..0.012 rows=55 loops=1)

  • 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.005 0.005 ↓ 3.3 10 1

Seq Scan on products_total_views_2020_07_hash_35 p_99 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=10 loops=1)

  • 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.004 0.004 ↓ 2.7 8 1

Seq Scan on products_total_views_2020_07_hash_36 p_100 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=8 loops=1)

  • 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.016 0.016 ↑ 1.0 77 1

Seq Scan on products_total_views_2020_07_hash_37 p_101 (cost=0.00..3.16 rows=77 width=58) (actual time=0.005..0.016 rows=77 loops=1)

  • 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.006 0.006 ↓ 5.0 15 1

Seq Scan on products_total_views_2020_07_hash_38 p_102 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.006 rows=15 loops=1)

  • 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.006 0.006 ↓ 6.7 20 1

Seq Scan on products_total_views_2020_07_hash_39 p_103 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=20 loops=1)

  • 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.032 0.032 ↑ 1.0 177 1

Seq Scan on products_total_views_2020_07_hash_40 p_104 (cost=0.00..5.65 rows=177 width=58) (actual time=0.004..0.032 rows=177 loops=1)

  • 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.036 0.036 ↑ 1.0 195 1

Seq Scan on products_total_views_2020_07_hash_41 p_105 (cost=0.00..6.92 rows=195 width=58) (actual time=0.005..0.036 rows=195 loops=1)

  • 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.004 0.004 ↓ 2.7 8 1

Seq Scan on products_total_views_2020_07_hash_42 p_106 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=8 loops=1)

  • 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.004 0.004 ↓ 2.7 8 1

Seq Scan on products_total_views_2020_07_hash_43 p_107 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=8 loops=1)

  • 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.059 0.059 ↑ 1.0 322 1

Seq Scan on products_total_views_2020_07_hash_44 p_108 (cost=0.00..10.83 rows=322 width=58) (actual time=0.005..0.059 rows=322 loops=1)

  • 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.030 0.030 ↑ 1.0 173 1

Seq Scan on products_total_views_2020_07_hash_45 p_109 (cost=0.00..5.59 rows=173 width=58) (actual time=0.004..0.030 rows=173 loops=1)

  • 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.019 0.019 ↑ 1.0 94 1

Seq Scan on products_total_views_2020_07_hash_46 p_110 (cost=0.00..3.41 rows=94 width=58) (actual time=0.005..0.019 rows=94 loops=1)

  • 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.006 0.006 ↓ 7.3 22 1

Seq Scan on products_total_views_2020_07_hash_47 p_111 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=22 loops=1)

  • 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.014 0.014 ↑ 1.0 66 1

Seq Scan on products_total_views_2020_07_hash_48 p_112 (cost=0.00..2.99 rows=66 width=58) (actual time=0.005..0.014 rows=66 loops=1)

  • 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.025 0.025 ↑ 1.0 129 1

Seq Scan on products_total_views_2020_07_hash_49 p_113 (cost=0.00..4.93 rows=129 width=58) (actual time=0.005..0.025 rows=129 loops=1)

  • 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.009 0.009 ↓ 8.3 25 1

Seq Scan on products_total_views_2020_07_hash_50 p_114 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.009 rows=25 loops=1)

  • 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.007 0.007 ↓ 5.0 15 1

Seq Scan on products_total_views_2020_07_hash_51 p_115 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.007 rows=15 loops=1)

  • 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.009 0.009 ↓ 12.3 37 1

Seq Scan on products_total_views_2020_07_hash_52 p_116 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.009 rows=37 loops=1)

  • 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.004 0.004 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_07_hash_53 p_117 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=3 loops=1)

  • 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.010 0.010 ↓ 12.7 38 1

Seq Scan on products_total_views_2020_07_hash_54 p_118 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.010 rows=38 loops=1)

  • 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.015 0.015 ↑ 1.0 63 1

Seq Scan on products_total_views_2020_07_hash_55 p_119 (cost=0.00..2.94 rows=63 width=58) (actual time=0.006..0.015 rows=63 loops=1)

  • 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.006 0.006 ↓ 4.7 14 1

Seq Scan on products_total_views_2020_07_hash_56 p_120 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=14 loops=1)

  • 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.006 0.006 ↓ 6.7 20 1

Seq Scan on products_total_views_2020_07_hash_57 p_121 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=20 loops=1)

  • 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.008 0.008 ↓ 6.7 20 1

Seq Scan on products_total_views_2020_07_hash_58 p_122 (cost=0.00..18.70 rows=3 width=72) (actual time=0.005..0.008 rows=20 loops=1)

  • 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.019 0.019 ↑ 1.0 100 1

Seq Scan on products_total_views_2020_07_hash_59 p_123 (cost=0.00..3.50 rows=100 width=58) (actual time=0.004..0.019 rows=100 loops=1)

  • 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.010 0.010 ↓ 16.0 48 1

Seq Scan on products_total_views_2020_07_hash_60 p_124 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.010 rows=48 loops=1)

  • 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.009 0.009 ↓ 12.0 36 1

Seq Scan on products_total_views_2020_07_hash_61 p_125 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.009 rows=36 loops=1)

  • 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.027 0.027 ↑ 1.0 146 1

Seq Scan on products_total_views_2020_07_hash_62 p_126 (cost=0.00..5.19 rows=146 width=58) (actual time=0.005..0.027 rows=146 loops=1)

  • 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.005 0.005 ↓ 3.3 10 1

Seq Scan on products_total_views_2020_07_hash_63 p_127 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=10 loops=1)

  • 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.009 0.009 ↓ 12.7 38 1

Seq Scan on products_total_views_2020_08_hash_0 p_128 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.009 rows=38 loops=1)

  • 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.004 0.004 ↓ 2.0 6 1

Seq Scan on products_total_views_2020_08_hash_1 p_129 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=6 loops=1)

  • 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.022 0.022 ↑ 1.0 107 1

Seq Scan on products_total_views_2020_08_hash_2 p_130 (cost=0.00..3.60 rows=107 width=58) (actual time=0.005..0.022 rows=107 loops=1)

  • 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.006 0.006 ↓ 5.7 17 1

Seq Scan on products_total_views_2020_08_hash_3 p_131 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=17 loops=1)

  • 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.049 0.049 ↑ 1.0 277 1

Seq Scan on products_total_views_2020_08_hash_4 p_132 (cost=0.00..9.16 rows=277 width=58) (actual time=0.005..0.049 rows=277 loops=1)

  • 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.006 0.006 ↓ 5.0 15 1

Seq Scan on products_total_views_2020_08_hash_5 p_133 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=15 loops=1)

  • 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.008 0.008 ↓ 12.0 36 1

Seq Scan on products_total_views_2020_08_hash_6 p_134 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=36 loops=1)

  • 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.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_08_hash_7 p_135 (cost=9.95..17.07 rows=3 width=72) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((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.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_part_2_merchant_id_partition_time__idx2793 (cost=0.00..9.95 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((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.007 0.007 ↓ 7.3 22 1

Seq Scan on products_total_views_2020_08_hash_8 p_136 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.007 rows=22 loops=1)

  • 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.010 0.010 ↓ 15.0 45 1

Seq Scan on products_total_views_2020_08_hash_9 p_137 (cost=0.00..18.70 rows=3 width=72) (actual time=0.005..0.010 rows=45 loops=1)

  • 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.009 0.009 ↓ 12.0 36 1

Seq Scan on products_total_views_2020_08_hash_10 p_138 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.009 rows=36 loops=1)

  • 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.004 0.004 ↓ 2.0 6 1

Seq Scan on products_total_views_2020_08_hash_11 p_139 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=6 loops=1)

  • 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.007 0.007 ↓ 7.0 21 1

Seq Scan on products_total_views_2020_08_hash_12 p_140 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.007 rows=21 loops=1)

  • 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.006 0.006 ↓ 4.0 12 1

Seq Scan on products_total_views_2020_08_hash_13 p_141 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.006 rows=12 loops=1)

  • 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.052 0.052 ↑ 1.0 281 1

Seq Scan on products_total_views_2020_08_hash_14 p_142 (cost=0.00..9.21 rows=281 width=58) (actual time=0.005..0.052 rows=281 loops=1)

  • 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.004 0.004 ↓ 2.0 6 1

Seq Scan on products_total_views_2020_08_hash_15 p_143 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=6 loops=1)

  • 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.016 0.016 ↑ 1.0 83 1

Seq Scan on products_total_views_2020_08_hash_16 p_144 (cost=0.00..3.25 rows=83 width=58) (actual time=0.004..0.016 rows=83 loops=1)

  • 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.007 0.007 ↓ 7.3 22 1

Seq Scan on products_total_views_2020_08_hash_17 p_145 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.007 rows=22 loops=1)

  • 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.004 0.004 ↓ 2.3 7 1

Seq Scan on products_total_views_2020_08_hash_18 p_146 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=7 loops=1)

  • 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.006 0.006 ↓ 5.7 17 1

Seq Scan on products_total_views_2020_08_hash_19 p_147 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.006 rows=17 loops=1)

  • 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.006 0.006 ↓ 5.7 17 1

Seq Scan on products_total_views_2020_08_hash_20 p_148 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=17 loops=1)

  • 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.008 0.008 ↓ 11.3 34 1

Seq Scan on products_total_views_2020_08_hash_21 p_149 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=34 loops=1)

  • 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.020 0.020 ↑ 1.0 96 1

Seq Scan on products_total_views_2020_08_hash_22 p_150 (cost=0.00..3.44 rows=96 width=58) (actual time=0.006..0.020 rows=96 loops=1)

  • 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.024 0.024 ↑ 1.0 121 1

Seq Scan on products_total_views_2020_08_hash_23 p_151 (cost=0.00..3.81 rows=121 width=58) (actual time=0.006..0.024 rows=121 loops=1)

  • 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.107 0.107 ↓ 1.0 638 1

Seq Scan on products_total_views_2020_08_hash_24 p_152 (cost=0.00..20.55 rows=637 width=58) (actual time=0.004..0.107 rows=638 loops=1)

  • 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.003 0.003 ↓ 1.7 5 1

Seq Scan on products_total_views_2020_08_hash_25 p_153 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=5 loops=1)

  • 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.004 0.004 ↓ 2.3 7 1

Seq Scan on products_total_views_2020_08_hash_26 p_154 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=7 loops=1)

  • 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.043 0.043 ↑ 1.2 246 1

Seq Scan on products_total_views_2020_08_hash_27 p_155 (cost=0.00..9.52 rows=301 width=58) (actual time=0.004..0.043 rows=246 loops=1)

  • 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.004 0.004 ↓ 2.3 7 1

Seq Scan on products_total_views_2020_08_hash_28 p_156 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=7 loops=1)

  • 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.019 0.019 ↑ 1.0 96 1

Seq Scan on products_total_views_2020_08_hash_29 p_157 (cost=0.00..3.44 rows=96 width=58) (actual time=0.005..0.019 rows=96 loops=1)

  • 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.054 0.054 ↑ 1.0 304 1

Seq Scan on products_total_views_2020_08_hash_30 p_158 (cost=0.00..9.56 rows=304 width=58) (actual time=0.005..0.054 rows=304 loops=1)

  • 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.008 0.008 ↓ 11.3 34 1

Seq Scan on products_total_views_2020_08_hash_31 p_159 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=34 loops=1)

  • 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.008 0.008 ↓ 10.3 31 1

Seq Scan on products_total_views_2020_08_hash_32 p_160 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.008 rows=31 loops=1)

  • 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.005 0.005 ↓ 6.7 20 1

Seq Scan on products_total_views_2020_08_hash_33 p_161 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=20 loops=1)

  • 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.019 0.019 ↑ 1.0 95 1

Seq Scan on products_total_views_2020_08_hash_34 p_162 (cost=0.00..3.42 rows=95 width=58) (actual time=0.005..0.019 rows=95 loops=1)

  • 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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_08_hash_35 p_163 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_part_2_merchant_id_partition_time__idx2821 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.005 0.005 ↓ 5.3 16 1

Seq Scan on products_total_views_2020_08_hash_36 p_164 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=16 loops=1)

  • 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.007 0.007 ↓ 10.0 30 1

Seq Scan on products_total_views_2020_08_hash_37 p_165 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.007 rows=30 loops=1)

  • 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.005 0.005 ↓ 3.7 11 1

Seq Scan on products_total_views_2020_08_hash_38 p_166 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=11 loops=1)

  • 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.012 0.012 ↑ 1.0 55 1

Seq Scan on products_total_views_2020_08_hash_39 p_167 (cost=0.00..1.82 rows=55 width=58) (actual time=0.005..0.012 rows=55 loops=1)

  • 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.023 0.023 ↑ 1.0 122 1

Seq Scan on products_total_views_2020_08_hash_40 p_168 (cost=0.00..3.83 rows=122 width=58) (actual time=0.005..0.023 rows=122 loops=1)

  • 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.047 0.047 ↓ 1.0 264 1

Seq Scan on products_total_views_2020_08_hash_41 p_169 (cost=0.00..8.95 rows=263 width=58) (actual time=0.005..0.047 rows=264 loops=1)

  • 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.009 0.009 ↓ 13.7 41 1

Seq Scan on products_total_views_2020_08_hash_42 p_170 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.009 rows=41 loops=1)

  • 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.004 0.004 ↓ 2.3 7 1

Seq Scan on products_total_views_2020_08_hash_43 p_171 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=7 loops=1)

  • 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.030 0.030 ↓ 1.0 165 1

Seq Scan on products_total_views_2020_08_hash_44 p_172 (cost=0.00..5.46 rows=164 width=58) (actual time=0.004..0.030 rows=165 loops=1)

  • 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.023 0.023 ↑ 1.0 120 1

Seq Scan on products_total_views_2020_08_hash_45 p_173 (cost=0.00..3.80 rows=120 width=58) (actual time=0.004..0.023 rows=120 loops=1)

  • 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.006 0.006 ↓ 7.0 21 1

Seq Scan on products_total_views_2020_08_hash_46 p_174 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=21 loops=1)

  • 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.007 0.007 ↓ 7.0 21 1

Seq Scan on products_total_views_2020_08_hash_47 p_175 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.007 rows=21 loops=1)

  • 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.006 0.006 ↓ 8.3 25 1

Seq Scan on products_total_views_2020_08_hash_48 p_176 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=25 loops=1)

  • 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.011 0.011 ↓ 15.7 47 1

Seq Scan on products_total_views_2020_08_hash_49 p_177 (cost=0.00..18.70 rows=3 width=72) (actual time=0.005..0.011 rows=47 loops=1)

  • 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.015 0.015 ↑ 1.0 71 1

Seq Scan on products_total_views_2020_08_hash_50 p_178 (cost=0.00..3.06 rows=71 width=58) (actual time=0.005..0.015 rows=71 loops=1)

  • 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.007 0.007 ↓ 6.0 18 1

Seq Scan on products_total_views_2020_08_hash_51 p_179 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.007 rows=18 loops=1)

  • 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.003 0.003 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_08_hash_52 p_180 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=3 loops=1)

  • 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.005 0.005 ↓ 4.7 14 1

Seq Scan on products_total_views_2020_08_hash_53 p_181 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=14 loops=1)

  • 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.008 0.008 ↓ 7.7 23 1

Seq Scan on products_total_views_2020_08_hash_54 p_182 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.008 rows=23 loops=1)

  • 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.008 0.008 ↓ 7.0 21 1

Seq Scan on products_total_views_2020_08_hash_55 p_183 (cost=0.00..18.70 rows=3 width=72) (actual time=0.005..0.008 rows=21 loops=1)

  • 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.007 0.007 ↓ 6.0 18 1

Seq Scan on products_total_views_2020_08_hash_56 p_184 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.007 rows=18 loops=1)

  • 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.004 0.004 ↓ 2.7 8 1

Seq Scan on products_total_views_2020_08_hash_57 p_185 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=8 loops=1)

  • 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.020 0.020 ↑ 1.0 105 1

Seq Scan on products_total_views_2020_08_hash_58 p_186 (cost=0.00..3.58 rows=105 width=58) (actual time=0.005..0.020 rows=105 loops=1)

  • 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.011 0.011 ↓ 15.7 47 1

Seq Scan on products_total_views_2020_08_hash_59 p_187 (cost=0.00..18.70 rows=3 width=72) (actual time=0.005..0.011 rows=47 loops=1)

  • 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.010 0.010 ↓ 14.0 42 1

Seq Scan on products_total_views_2020_08_hash_60 p_188 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.010 rows=42 loops=1)

  • 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.010 0.010 ↓ 14.7 44 1

Seq Scan on products_total_views_2020_08_hash_61 p_189 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.010 rows=44 loops=1)

  • 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.028 0.028 ↑ 1.0 151 1

Seq Scan on products_total_views_2020_08_hash_62 p_190 (cost=0.00..5.27 rows=151 width=58) (actual time=0.005..0.028 rows=151 loops=1)

  • 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.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_08_hash_63 p_191 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=1 loops=1)

  • 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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_0 p_192 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09__merchant_id_partition_time_pr_idx (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.002 0.002 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_1 p_193 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.002 rows=1 loops=1)

  • 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.007 0.007 ↓ 8.3 25 1

Seq Scan on products_total_views_2020_09_hash_2 p_194 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.007 rows=25 loops=1)

  • 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))
  • Rows Removed by Filter: 1
213. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_3 p_195 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=1 loops=1)

  • 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.006 0.006 ↓ 6.0 18 1

Seq Scan on products_total_views_2020_09_hash_4 p_196 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=18 loops=1)

  • 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.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_5 p_197 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09__merchant_id_partition_time_p_idx5 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.005 0.005 ↓ 3.7 11 1

Seq Scan on products_total_views_2020_09_hash_6 p_198 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=11 loops=1)

  • 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))
  • Rows Removed by Filter: 1
218. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_7 p_199 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09__merchant_id_partition_time_p_idx7 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.021 0.021 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_8 p_200 (cost=0.00..18.70 rows=3 width=72) (actual time=0.021..0.021 rows=1 loops=1)

  • 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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_9 p_201 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09__merchant_id_partition_time_p_idx9 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_10 p_202 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx10 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_09_hash_11 p_203 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=2 loops=1)

  • 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.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_12 p_204 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=1 loops=1)

  • 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.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_13 p_205 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx13 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_09_hash_14 p_206 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=2 loops=1)

  • 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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_15 p_207 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx15 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_16 p_208 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx16 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_17 p_209 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=1 loops=1)

  • 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.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_09_hash_18 p_210 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=2 loops=1)

  • 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.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_19 p_211 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx19 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_09_hash_20 p_212 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=2 loops=1)

  • 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.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_21 p_213 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx21 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.006 0.006 ↓ 5.7 17 1

Seq Scan on products_total_views_2020_09_hash_22 p_214 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=17 loops=1)

  • 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))
  • Rows Removed by Filter: 1
242. 0.003 0.003 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_09_hash_23 p_215 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=3 loops=1)

  • 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.006 0.006 ↓ 5.7 17 1

Seq Scan on products_total_views_2020_09_hash_24 p_216 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.006 rows=17 loops=1)

  • 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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_25 p_217 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx25 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_26 p_218 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx26 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.009 0.009 ↓ 12.7 38 1

Seq Scan on products_total_views_2020_09_hash_27 p_219 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.009 rows=38 loops=1)

  • 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))
  • Rows Removed by Filter: 1
249. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_28 p_220 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx28 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_29 p_221 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx29 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.008 0.008 ↓ 10.7 32 1

Seq Scan on products_total_views_2020_09_hash_30 p_222 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.008 rows=32 loops=1)

  • 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))
  • Rows Removed by Filter: 1
254. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_31 p_223 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx31 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_09_hash_32 p_224 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=2 loops=1)

  • 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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_33 p_225 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx33 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.004 0.004 ↓ 2.3 7 1

Seq Scan on products_total_views_2020_09_hash_34 p_226 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=7 loops=1)

  • 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.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_35 p_227 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx35 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_36 p_228 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx36 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_37 p_229 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx37 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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))
266. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_38 p_230 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: ((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))
267. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx38 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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))
268. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_39 p_231 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=1 loops=1)

  • 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))
269. 0.007 0.007 ↓ 6.0 18 1

Seq Scan on products_total_views_2020_09_hash_40 p_232 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.007 rows=18 loops=1)

  • 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))
  • Rows Removed by Filter: 1
270. 0.007 0.007 ↓ 7.3 22 1

Seq Scan on products_total_views_2020_09_hash_41 p_233 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.007 rows=22 loops=1)

  • 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))
  • Rows Removed by Filter: 3
271. 0.003 0.003 ↓ 1.7 5 1

Seq Scan on products_total_views_2020_09_hash_42 p_234 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=5 loops=1)

  • 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))
272. 0.003 0.003 ↓ 1.7 5 1

Seq Scan on products_total_views_2020_09_hash_43 p_235 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=5 loops=1)

  • 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))
273. 0.004 0.004 ↓ 2.3 7 1

Seq Scan on products_total_views_2020_09_hash_44 p_236 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=7 loops=1)

  • 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))
274. 0.003 0.003 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_09_hash_45 p_237 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=3 loops=1)

  • 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))
275. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_46 p_238 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=1 loops=1)

  • 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))
276. 0.003 0.003 ↑ 1.0 3 1

Seq Scan on products_total_views_2020_09_hash_47 p_239 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=3 loops=1)

  • 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))
277. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_48 p_240 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=1 loops=1)

  • 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))
278. 0.004 0.004 ↓ 2.0 6 1

Seq Scan on products_total_views_2020_09_hash_49 p_241 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=6 loops=1)

  • 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))
279. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_50 p_242 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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))
280. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx50 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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))
281. 0.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_09_hash_51 p_243 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=2 loops=1)

  • 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))
282. 0.004 0.004 ↓ 1.7 5 1

Seq Scan on products_total_views_2020_09_hash_52 p_244 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=5 loops=1)

  • 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))
  • Rows Removed by Filter: 1
283. 0.003 0.003 ↓ 1.3 4 1

Seq Scan on products_total_views_2020_09_hash_53 p_245 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=4 loops=1)

  • 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))
284. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_54 p_246 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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))
285. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx54 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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))
286. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_55 p_247 (cost=9.95..17.07 rows=3 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: ((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))
287. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx55 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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))
288. 0.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_09_hash_56 p_248 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.003 rows=2 loops=1)

  • 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))
289. 0.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_09_hash_57 p_249 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=2 loops=1)

  • 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))
290. 0.007 0.007 ↓ 7.3 22 1

Seq Scan on products_total_views_2020_09_hash_58 p_250 (cost=0.00..18.70 rows=3 width=72) (actual time=0.004..0.007 rows=22 loops=1)

  • 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))
291. 0.003 0.003 ↓ 1.3 4 1

Seq Scan on products_total_views_2020_09_hash_59 p_251 (cost=0.00..18.70 rows=3 width=72) (actual time=0.002..0.003 rows=4 loops=1)

  • 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))
292. 0.005 0.005 ↓ 3.7 11 1

Seq Scan on products_total_views_2020_09_hash_60 p_252 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=11 loops=1)

  • 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))
  • Rows Removed by Filter: 2
293. 0.005 0.005 ↓ 3.7 11 1

Seq Scan on products_total_views_2020_09_hash_61 p_253 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.005 rows=11 loops=1)

  • 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))
294. 0.004 0.004 ↓ 2.0 6 1

Seq Scan on products_total_views_2020_09_hash_62 p_254 (cost=0.00..18.70 rows=3 width=72) (actual time=0.003..0.004 rows=6 loops=1)

  • 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))
295. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_63 p_255 (cost=9.95..17.07 rows=3 width=72) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((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))
296. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx63 (cost=0.00..9.95 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((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))
297. 0.005 0.212 ↑ 24.0 8 1

Hash (cost=1,065.57..1,065.57 rows=192 width=64) (actual time=0.212..0.212 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
298. 0.009 0.207 ↑ 24.0 8 1

Append (cost=8.50..1,065.57 rows=192 width=64) (actual time=0.040..0.207 rows=8 loops=1)

299. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_0 (cost=8.50..15.61 rows=3 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
300. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09__merchant_id_partition_time_pr_idx (cost=0.00..8.50 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
301. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_1 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
302. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_2 (cost=0.00..17.25 rows=3 width=64) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 26
303. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_3 (cost=0.00..17.25 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
304. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_4 (cost=0.00..17.25 rows=3 width=64) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 18
305. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_5 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
306. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09__merchant_id_partition_time_p_idx5 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
307. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_6 (cost=0.00..17.25 rows=3 width=64) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 12
308. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_7 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
309. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09__merchant_id_partition_time_p_idx7 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
310. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_8 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
311. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_9 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
312. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09__merchant_id_partition_time_p_idx9 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
313. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_10 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
314. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx10 (cost=0.00..8.50 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
315. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_11 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
316. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_12 (cost=0.00..17.25 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
317. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_13 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
318. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx13 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
319. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_14 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 2
320. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_15 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
321. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx15 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
322. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_16 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
323. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx16 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
324. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_17 (cost=0.00..17.25 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
325. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_18 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 2
326. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_19 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
327. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx19 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
328. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_20 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 2
329. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_21 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
330. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx21 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
331. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_22 (cost=0.00..17.25 rows=3 width=64) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 18
332. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_23 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 3
333. 0.021 0.021 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_24 (cost=0.00..17.25 rows=3 width=64) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 16
334. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_25 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
335. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx25 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
336. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_26 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
337. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx26 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
338. 0.007 0.007 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_27 (cost=0.00..17.25 rows=3 width=64) (actual time=0.007..0.007 rows=1 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 38
339. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_28 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
340. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx28 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
341. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_29 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
342. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx29 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
343. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_30 (cost=0.00..17.25 rows=3 width=64) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 33
344. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_31 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
345. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx31 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
346. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_32 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 2
347. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_33 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
348. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx33 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
349. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_34 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 7
350. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_35 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
351. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx35 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
352. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_36 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
353. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx36 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
354. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_37 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
355. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx37 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
356. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_38 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
357. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx38 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
358. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_39 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
359. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_40 (cost=0.00..17.25 rows=3 width=64) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 19
360. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_41 (cost=0.00..17.25 rows=3 width=64) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 25
361. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_42 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 5
362. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_43 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 4
363. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_44 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 7
364. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_45 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 3
365. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_46 (cost=0.00..17.25 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
366. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_47 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 3
367. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_48 (cost=0.00..17.25 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
368. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_49 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 6
369. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_50 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
370. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx50 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
371. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_51 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 2
372. 0.003 0.003 ↑ 1.5 2 1

Seq Scan on products_total_views_2020_09_hash_52 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=2 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 4
373. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_53 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 4
374. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_54 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
375. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx54 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
376. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_55 (cost=8.50..15.61 rows=3 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
377. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx55 (cost=0.00..8.50 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
378. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_56 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 2
379. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_57 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 2
380. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_58 (cost=0.00..17.25 rows=3 width=64) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 22
381. 0.003 0.003 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_59 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 3
382. 0.005 0.005 ↑ 3.0 1 1

Seq Scan on products_total_views_2020_09_hash_60 (cost=0.00..17.25 rows=3 width=64) (actual time=0.004..0.005 rows=1 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 12
383. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_61 (cost=0.00..17.25 rows=3 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 11
384. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on products_total_views_2020_09_hash_62 (cost=0.00..17.25 rows=3 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 6
385. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on products_total_views_2020_09_hash_63 (cost=8.50..15.61 rows=3 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
386. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on products_total_views_2020_09_merchant_id_partition_time_p_idx63 (cost=0.00..8.50 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
387. 0.035 4.298 ↓ 1.8 7 1

GroupAggregate (cost=679.94..680.03 rows=4 width=82) (actual time=4.269..4.298 rows=7 loops=1)

  • Group Key: c.merchant_id, c.product_id
388. 0.061 4.263 ↓ 18.5 74 1

Sort (cost=679.94..679.95 rows=4 width=66) (actual time=4.257..4.263 rows=74 loops=1)

  • Sort Key: c.merchant_id, c.product_id
  • Sort Method: quicksort Memory: 35kB
389. 1.172 4.202 ↓ 18.5 74 1

Hash Join (cost=122.92..679.90 rows=4 width=66) (actual time=0.836..4.202 rows=74 loops=1)

  • Hash Cond: (((c.merchant_id)::text = (cart_item_histories_2020_09_hash_0.merchant_id)::text) AND ((c.product_id)::text = (cart_item_histories_2020_09_hash_0.product_id)::text))
390. 0.639 2.958 ↓ 1.0 7,648 1

Append (cost=0.00..501.60 rows=7,379 width=66) (actual time=0.012..2.958 rows=7,648 loops=1)

391. 0.101 0.101 ↓ 1.1 436 1

Seq Scan on cart_item_histories_2020_06_hash_0 c (cost=0.00..18.76 rows=407 width=66) (actual time=0.011..0.101 rows=436 loops=1)

  • 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))
  • Rows Removed by Filter: 52
392. 0.029 0.029 ↓ 1.0 135 1

Seq Scan on cart_item_histories_2020_06_hash_1 c_1 (cost=0.00..5.80 rows=134 width=66) (actual time=0.005..0.029 rows=135 loops=1)

  • 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))
  • Rows Removed by Filter: 5
393. 0.010 0.010 ↓ 36.0 36 1

Seq Scan on cart_item_histories_2020_06_hash_2 c_2 (cost=0.00..17.60 rows=1 width=80) (actual time=0.004..0.010 rows=36 loops=1)

  • 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))
  • Rows Removed by Filter: 4
394. 0.018 0.018 ↓ 1.0 72 1

Seq Scan on cart_item_histories_2020_06_hash_3 c_3 (cost=0.00..3.54 rows=71 width=66) (actual time=0.005..0.018 rows=72 loops=1)

  • 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))
  • Rows Removed by Filter: 5
395. 0.065 0.065 ↓ 1.2 270 1

Seq Scan on cart_item_histories_2020_06_hash_4 c_4 (cost=0.00..13.96 rows=234 width=66) (actual time=0.013..0.065 rows=270 loops=1)

  • 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))
  • Rows Removed by Filter: 78
396. 0.022 0.022 ↓ 1.1 92 1

Seq Scan on cart_item_histories_2020_06_hash_5 c_5 (cost=0.00..4.12 rows=87 width=66) (actual time=0.006..0.022 rows=92 loops=1)

  • 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))
  • Rows Removed by Filter: 14
397. 0.016 0.016 ↓ 1.0 62 1

Seq Scan on cart_item_histories_2020_06_hash_6 c_6 (cost=0.00..3.38 rows=60 width=66) (actual time=0.005..0.016 rows=62 loops=1)

  • 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))
  • Rows Removed by Filter: 7
398. 0.072 0.072 ↓ 1.0 345 1

Seq Scan on cart_item_histories_2020_06_hash_7 c_7 (cost=0.00..14.16 rows=339 width=66) (actual time=0.007..0.072 rows=345 loops=1)

  • 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))
  • Rows Removed by Filter: 13
399. 0.036 0.036 ↑ 1.0 161 1

Seq Scan on cart_item_histories_2020_06_hash_8 c_8 (cost=0.00..7.48 rows=161 width=66) (actual time=0.006..0.036 rows=161 loops=1)

  • 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))
  • Rows Removed by Filter: 13
400. 0.025 0.025 ↓ 1.1 103 1

Seq Scan on cart_item_histories_2020_06_hash_9 c_9 (cost=0.00..5.30 rows=96 width=66) (actual time=0.006..0.025 rows=103 loops=1)

  • 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))
  • Rows Removed by Filter: 12
401. 0.138 0.138 ↑ 1.0 689 1

Seq Scan on cart_item_histories_2020_07_hash_0 c_10 (cost=0.00..26.78 rows=689 width=66) (actual time=0.004..0.138 rows=689 loops=1)

  • 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))
402. 0.055 0.055 ↑ 1.0 268 1

Seq Scan on cart_item_histories_2020_07_hash_1 c_11 (cost=0.00..10.36 rows=268 width=66) (actual time=0.004..0.055 rows=268 loops=1)

  • 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))
403. 0.044 0.044 ↑ 1.0 209 1

Seq Scan on cart_item_histories_2020_07_hash_2 c_12 (cost=0.00..8.18 rows=209 width=66) (actual time=0.004..0.044 rows=209 loops=1)

  • 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))
404. 0.025 0.025 ↑ 1.0 110 1

Seq Scan on cart_item_histories_2020_07_hash_3 c_13 (cost=0.00..4.20 rows=110 width=66) (actual time=0.005..0.025 rows=110 loops=1)

  • 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))
405. 0.080 0.080 ↑ 1.0 394 1

Seq Scan on cart_item_histories_2020_07_hash_4 c_14 (cost=0.00..15.88 rows=394 width=66) (actual time=0.004..0.080 rows=394 loops=1)

  • 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))
406. 0.033 0.033 ↑ 1.0 162 1

Seq Scan on cart_item_histories_2020_07_hash_5 c_15 (cost=0.00..6.24 rows=162 width=66) (actual time=0.004..0.033 rows=162 loops=1)

  • 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))
407. 0.032 0.032 ↑ 1.0 146 1

Seq Scan on cart_item_histories_2020_07_hash_6 c_16 (cost=0.00..5.92 rows=146 width=66) (actual time=0.004..0.032 rows=146 loops=1)

  • 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))
408. 0.175 0.175 ↑ 1.0 499 1

Seq Scan on cart_item_histories_2020_07_hash_7 c_17 (cost=0.00..19.98 rows=499 width=66) (actual time=0.007..0.175 rows=499 loops=1)

  • 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))
409. 0.102 0.102 ↑ 1.0 298 1

Seq Scan on cart_item_histories_2020_07_hash_8 c_18 (cost=0.00..11.96 rows=298 width=66) (actual time=0.008..0.102 rows=298 loops=1)

  • 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))
410. 0.083 0.083 ↑ 1.0 201 1

Seq Scan on cart_item_histories_2020_07_hash_9 c_19 (cost=0.00..8.02 rows=201 width=66) (actual time=0.008..0.083 rows=201 loops=1)

  • 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))
411. 0.258 0.258 ↓ 1.0 653 1

Seq Scan on cart_item_histories_2020_08_hash_0 c_20 (cost=0.00..24.98 rows=649 width=66) (actual time=0.007..0.258 rows=653 loops=1)

  • 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))
412. 0.111 0.111 ↑ 1.0 273 1

Seq Scan on cart_item_histories_2020_08_hash_1 c_21 (cost=0.00..10.46 rows=273 width=66) (actual time=0.008..0.111 rows=273 loops=1)

  • 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))
413. 0.120 0.120 ↑ 1.0 340 1

Seq Scan on cart_item_histories_2020_08_hash_2 c_22 (cost=0.00..13.80 rows=340 width=66) (actual time=0.007..0.120 rows=340 loops=1)

  • 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))
414. 0.056 0.056 ↑ 1.0 151 1

Seq Scan on cart_item_histories_2020_08_hash_3 c_23 (cost=0.00..6.02 rows=151 width=66) (actual time=0.008..0.056 rows=151 loops=1)

  • 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))
415. 0.078 0.078 ↑ 1.0 213 1

Seq Scan on cart_item_histories_2020_08_hash_4 c_24 (cost=0.00..8.26 rows=213 width=66) (actual time=0.007..0.078 rows=213 loops=1)

  • 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))
416. 0.037 0.037 ↑ 1.0 99 1

Seq Scan on cart_item_histories_2020_08_hash_5 c_25 (cost=0.00..3.98 rows=99 width=66) (actual time=0.008..0.037 rows=99 loops=1)

  • 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))
417. 0.054 0.054 ↑ 1.0 150 1

Seq Scan on cart_item_histories_2020_08_hash_6 c_26 (cost=0.00..6.00 rows=150 width=66) (actual time=0.007..0.054 rows=150 loops=1)

  • 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))
418. 0.141 0.141 ↑ 1.0 342 1

Seq Scan on cart_item_histories_2020_08_hash_7 c_27 (cost=0.00..13.84 rows=342 width=66) (actual time=0.006..0.141 rows=342 loops=1)

  • 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))
419. 0.107 0.107 ↑ 1.0 300 1

Seq Scan on cart_item_histories_2020_08_hash_8 c_28 (cost=0.00..12.00 rows=300 width=66) (actual time=0.007..0.107 rows=300 loops=1)

  • 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))
420. 0.064 0.064 ↑ 1.0 174 1

Seq Scan on cart_item_histories_2020_08_hash_9 c_29 (cost=0.00..7.48 rows=174 width=66) (actual time=0.009..0.064 rows=174 loops=1)

  • 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))
421. 0.037 0.037 ↓ 1.5 101 1

Seq Scan on cart_item_histories_2020_09_hash_0 c_30 (cost=0.00..3.38 rows=68 width=66) (actual time=0.007..0.037 rows=101 loops=1)

  • 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))
  • Rows Removed by Filter: 1
422. 0.015 0.015 ↓ 33.0 33 1

Seq Scan on cart_item_histories_2020_09_hash_1 c_31 (cost=0.00..17.60 rows=1 width=80) (actual time=0.006..0.015 rows=33 loops=1)

  • 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))
  • Rows Removed by Filter: 3
423. 0.012 0.012 ↓ 24.0 24 1

Seq Scan on cart_item_histories_2020_09_hash_2 c_32 (cost=0.00..17.60 rows=1 width=80) (actual time=0.006..0.012 rows=24 loops=1)

  • 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))
  • Rows Removed by Filter: 2
424. 0.005 0.005 ↓ 2.0 2 1

Seq Scan on cart_item_histories_2020_09_hash_3 c_33 (cost=0.00..17.60 rows=1 width=80) (actual time=0.004..0.005 rows=2 loops=1)

  • 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))
  • Rows Removed by Filter: 2
425. 0.009 0.009 ↓ 11.0 11 1

Seq Scan on cart_item_histories_2020_09_hash_4 c_34 (cost=0.00..17.60 rows=1 width=80) (actual time=0.005..0.009 rows=11 loops=1)

  • 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))
  • Rows Removed by Filter: 4
426. 0.007 0.007 ↓ 10.0 10 1

Seq Scan on cart_item_histories_2020_09_hash_5 c_35 (cost=0.00..17.60 rows=1 width=80) (actual time=0.004..0.007 rows=10 loops=1)

  • 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))
427. 0.009 0.009 ↓ 10.0 10 1

Seq Scan on cart_item_histories_2020_09_hash_6 c_36 (cost=0.00..17.60 rows=1 width=80) (actual time=0.005..0.009 rows=10 loops=1)

  • 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))
  • Rows Removed by Filter: 2
428. 0.008 0.008 ↓ 10.0 10 1

Seq Scan on cart_item_histories_2020_09_hash_7 c_37 (cost=0.00..17.60 rows=1 width=80) (actual time=0.005..0.008 rows=10 loops=1)

  • 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))
429. 0.021 0.021 ↓ 1.0 48 1

Seq Scan on cart_item_histories_2020_09_hash_8 c_38 (cost=0.00..2.08 rows=46 width=66) (actual time=0.007..0.021 rows=48 loops=1)

  • 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))
  • Rows Removed by Filter: 6
430. 0.009 0.009 ↓ 16.0 16 1

Seq Scan on cart_item_histories_2020_09_hash_9 c_39 (cost=0.00..17.60 rows=1 width=80) (actual time=0.004..0.009 rows=16 loops=1)

  • 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))
  • Rows Removed by Filter: 2
431. 0.003 0.072 ↑ 2.7 7 1

Hash (cost=122.63..122.63 rows=19 width=62) (actual time=0.072..0.072 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
432. 0.002 0.069 ↑ 2.7 7 1

Append (cost=0.00..122.63 rows=19 width=62) (actual time=0.016..0.069 rows=7 loops=1)

433. 0.016 0.016 ↓ 2.0 2 1

Seq Scan on cart_item_histories_2020_09_hash_0 (cost=0.00..2.86 rows=1 width=50) (actual time=0.016..0.016 rows=2 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 100
434. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on cart_item_histories_2020_09_hash_1 (cost=0.00..14.75 rows=2 width=64) (actual time=0.006..0.007 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 36
435. 0.007 0.007 ↑ 2.0 1 1

Seq Scan on cart_item_histories_2020_09_hash_2 (cost=0.00..14.75 rows=2 width=64) (actual time=0.006..0.007 rows=1 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 25
436. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on cart_item_histories_2020_09_hash_3 (cost=0.00..14.75 rows=2 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 4
437. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on cart_item_histories_2020_09_hash_4 (cost=0.00..14.75 rows=2 width=64) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 15
438. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on cart_item_histories_2020_09_hash_5 (cost=0.00..14.75 rows=2 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 10
439. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on cart_item_histories_2020_09_hash_6 (cost=0.00..14.75 rows=2 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 12
440. 0.004 0.004 ↑ 2.0 1 1

Seq Scan on cart_item_histories_2020_09_hash_7 (cost=0.00..14.75 rows=2 width=64) (actual time=0.004..0.004 rows=1 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 9
441. 0.010 0.010 ↑ 1.0 2 1

Seq Scan on cart_item_histories_2020_09_hash_8 (cost=0.00..1.68 rows=2 width=50) (actual time=0.009..0.010 rows=2 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 52
442. 0.006 0.006 ↑ 2.0 1 1

Seq Scan on cart_item_histories_2020_09_hash_9 (cost=0.00..14.75 rows=2 width=64) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: (partition_time = '2020-09-02 06:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 17
Planning time : 44.984 ms
Execution time : 13.770 ms