explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ct21

Settings
# exclusive inclusive rows x rows loops node
1. 344.645 401.131 ↑ 1.0 10 1

Limit (cost=135,340.70..135,443.55 rows=10 width=743) (actual time=400.788..401.131 rows=10 loops=1)

  • Functions: 279
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 32.777 ms, Inlining 0.000 ms, Optimization 32.105 ms, Emission 309.221 ms, Total 374.102 ms
2. 0.082 56.486 ↑ 10.3 10 1

Nested Loop Left Join (cost=135,340.70..136,400.06 rows=103 width=743) (actual time=56.145..56.486 rows=10 loops=1)

3. 0.016 56.324 ↑ 10.3 10 1

Merge Left Join (cost=135,340.61..136,386.09 rows=103 width=674) (actual time=56.109..56.324 rows=10 loops=1)

  • Merge Cond: (daily_product_metrics_ongoing_totals_p2019_02_20.product_tm_id = daily_product_metrics_ongoing_totals_p2019_02_20_2.product_tm_id)
4. 0.025 55.296 ↑ 10.3 10 1

Nested Loop (cost=133,270.40..134,307.02 rows=103 width=450) (actual time=55.126..55.296 rows=10 loops=1)

5. 0.063 55.111 ↑ 10.0 20 1

GroupAggregate (cost=133,270.29..133,482.82 rows=200 width=240) (actual time=55.064..55.111 rows=20 loops=1)

  • Group Key: daily_product_metrics_ongoing_totals_p2019_02_20.product_tm_id
6. 0.351 55.048 ↑ 1,677.2 21 1

Sort (cost=133,270.29..133,287.90 rows=35,221 width=61) (actual time=55.046..55.048 rows=21 loops=1)

  • Sort Key: daily_product_metrics_ongoing_totals_p2019_02_20.product_tm_id
  • Sort Method: quicksort Memory: 105kB
7. 1.999 54.697 ↑ 42.7 824 1

Hash Join (cost=66,252.94..132,738.31 rows=35,221 width=61) (actual time=53.990..54.697 rows=824 loops=1)

  • Hash Cond: (daily_product_metrics_ongoing_totals_p2019_02_20.date = (COALESCE(max(daily_product_metrics_ongoing_totals_p2019_02_20_1.date), '2019-03-21'::date)))
8. 1.832 18.991 ↑ 1.4 24,703 1

Append (cost=14.92..66,200.90 rows=35,221 width=81) (actual time=0.191..18.991 rows=24,703 loops=1)

9. 0.561 0.704 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_20 (cost=14.92..2,060.20 rows=1,100 width=81) (actual time=0.190..0.704 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=326
10. 0.143 0.143 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx307 (cost=0.00..14.86 rows=1,100 width=0) (actual time=0.142..0.143 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
11. 0.530 0.606 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_21 (cost=14.94..2,081.58 rows=1,110 width=81) (actual time=0.113..0.606 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=327
12. 0.076 0.076 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx308 (cost=0.00..14.89 rows=1,110 width=0) (actual time=0.076..0.076 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
13. 0.531 0.610 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_22 (cost=14.88..2,039.73 rows=1,086 width=81) (actual time=0.116..0.610 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=323
14. 0.079 0.079 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx309 (cost=0.00..14.83 rows=1,086 width=0) (actual time=0.079..0.079 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
15. 0.527 0.604 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_23 (cost=15.03..2,141.54 rows=1,143 width=81) (actual time=0.114..0.604 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=326
16. 0.077 0.077 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx310 (cost=0.00..14.97 rows=1,143 width=0) (actual time=0.077..0.077 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
17. 0.532 0.608 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_24 (cost=14.90..2,054.47 rows=1,094 width=81) (actual time=0.114..0.608 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=327
18. 0.076 0.076 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx311 (cost=0.00..14.85 rows=1,094 width=0) (actual time=0.076..0.076 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
19. 0.537 0.613 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_25 (cost=14.91..2,061.77 rows=1,098 width=81) (actual time=0.111..0.613 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=318
20. 0.076 0.076 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx312 (cost=0.00..14.86 rows=1,098 width=0) (actual time=0.076..0.076 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
21. 0.528 0.604 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_26 (cost=14.87..2,034.59 rows=1,083 width=81) (actual time=0.112..0.604 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=316
22. 0.076 0.076 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx313 (cost=0.00..14.82 rows=1,083 width=0) (actual time=0.076..0.076 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
23. 0.532 0.617 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_27 (cost=14.89..2,049.28 rows=1,091 width=81) (actual time=0.121..0.617 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=325
24. 0.085 0.085 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx314 (cost=0.00..14.84 rows=1,091 width=0) (actual time=0.085..0.085 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
25. 0.539 0.617 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_28 (cost=14.94..2,082.04 rows=1,109 width=81) (actual time=0.115..0.617 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=329
26. 0.078 0.078 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx315 (cost=0.00..14.88 rows=1,109 width=0) (actual time=0.078..0.078 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
27. 0.558 0.635 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_01 (cost=14.94..2,083.74 rows=1,108 width=81) (actual time=0.116..0.635 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=331
28. 0.077 0.077 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx316 (cost=0.00..14.88 rows=1,108 width=0) (actual time=0.077..0.077 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
29. 0.558 0.635 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_02 (cost=15.12..2,209.24 rows=1,178 width=81) (actual time=0.114..0.635 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=333
30. 0.077 0.077 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx317 (cost=0.00..15.06 rows=1,178 width=0) (actual time=0.077..0.077 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
31. 0.577 0.653 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_03 (cost=15.04..2,153.19 rows=1,147 width=81) (actual time=0.114..0.653 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=338
32. 0.076 0.076 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx318 (cost=0.00..14.98 rows=1,147 width=0) (actual time=0.076..0.076 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
33. 0.549 0.629 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_04 (cost=15.08..2,192.41 rows=1,166 width=81) (actual time=0.117..0.629 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=334
34. 0.080 0.080 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx319 (cost=0.00..15.03 rows=1,166 width=0) (actual time=0.080..0.080 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
35. 0.553 0.631 ↑ 1.5 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_05 (cost=17.24..2,301.82 rows=1,226 width=81) (actual time=0.116..0.631 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=330
36. 0.078 0.078 ↑ 1.5 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx320 (cost=0.00..17.18 rows=1,226 width=0) (actual time=0.078..0.078 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
37. 0.548 0.625 ↑ 1.5 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_06 (cost=17.21..2,285.47 rows=1,217 width=81) (actual time=0.115..0.625 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=331
38. 0.077 0.077 ↑ 1.5 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx321 (cost=0.00..17.15 rows=1,217 width=0) (actual time=0.077..0.077 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
39. 0.553 0.628 ↑ 1.5 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_07 (cost=17.26..2,316.35 rows=1,235 width=81) (actual time=0.112..0.628 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=333
40. 0.075 0.075 ↑ 1.5 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx322 (cost=0.00..17.20 rows=1,235 width=0) (actual time=0.075..0.075 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
41. 0.546 0.623 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_08 (cost=15.14..2,229.46 rows=1,188 width=81) (actual time=0.114..0.623 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=313
42. 0.077 0.077 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx323 (cost=0.00..15.08 rows=1,188 width=0) (actual time=0.077..0.077 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
43. 0.506 0.582 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_09 (cost=15.19..2,268.01 rows=1,208 width=81) (actual time=0.110..0.582 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=300
44. 0.076 0.076 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx324 (cost=0.00..15.13 rows=1,208 width=0) (actual time=0.076..0.076 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
45. 0.505 0.582 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_10 (cost=15.16..2,246.61 rows=1,196 width=81) (actual time=0.113..0.582 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=314
46. 0.077 0.077 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx325 (cost=0.00..15.10 rows=1,196 width=0) (actual time=0.077..0.077 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
47. 0.488 0.563 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_11 (cost=17.26..2,318.72 rows=1,234 width=81) (actual time=0.109..0.563 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=308
48. 0.075 0.075 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx326 (cost=0.00..17.20 rows=1,234 width=0) (actual time=0.075..0.075 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
49. 0.484 0.557 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_12 (cost=17.28..2,333.43 rows=1,242 width=81) (actual time=0.108..0.557 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=299
50. 0.073 0.073 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx327 (cost=0.00..17.22 rows=1,242 width=0) (actual time=0.073..0.073 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
51. 0.378 0.439 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_13 (cost=17.22..2,289.79 rows=1,218 width=81) (actual time=0.082..0.439 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=198
52. 0.061 0.061 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx328 (cost=0.00..17.16 rows=1,218 width=0) (actual time=0.061..0.061 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
53. 0.394 0.460 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_14 (cost=17.21..2,283.81 rows=1,216 width=81) (actual time=0.088..0.460 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=209
54. 0.066 0.066 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx329 (cost=0.00..17.15 rows=1,216 width=0) (actual time=0.066..0.066 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
55. 0.385 0.449 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_15 (cost=15.18..2,260.03 rows=1,204 width=81) (actual time=0.086..0.449 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=206
56. 0.064 0.064 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx330 (cost=0.00..15.12 rows=1,204 width=0) (actual time=0.064..0.064 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
57. 0.380 0.443 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_16 (cost=17.24..2,301.04 rows=1,225 width=81) (actual time=0.085..0.443 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=204
58. 0.063 0.063 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx331 (cost=0.00..17.17 rows=1,225 width=0) (actual time=0.063..0.063 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
59. 0.379 0.442 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_17 (cost=17.27..2,324.89 rows=1,238 width=81) (actual time=0.085..0.442 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=211
60. 0.063 0.063 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx332 (cost=0.00..17.21 rows=1,238 width=0) (actual time=0.063..0.063 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
61. 0.377 0.441 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_18 (cost=17.23..2,295.85 rows=1,222 width=81) (actual time=0.086..0.441 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=211
62. 0.064 0.064 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx333 (cost=0.00..17.17 rows=1,222 width=0) (actual time=0.064..0.064 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
63. 0.425 0.501 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_19 (cost=17.27..2,328.52 rows=1,238 width=81) (actual time=0.107..0.501 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=257
64. 0.076 0.076 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx334 (cost=0.00..17.21 rows=1,238 width=0) (actual time=0.076..0.076 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
65. 0.431 0.504 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_20 (cost=17.23..2,299.55 rows=1,222 width=81) (actual time=0.103..0.504 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=255
66. 0.073 0.073 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx335 (cost=0.00..17.17 rows=1,222 width=0) (actual time=0.073..0.073 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
67. 0.479 0.554 ↑ 1.4 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_21 (cost=15.12..2,220.95 rows=1,179 width=81) (actual time=0.108..0.554 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=288
68. 0.075 0.075 ↑ 1.4 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx336 (cost=0.00..15.06 rows=1,179 width=0) (actual time=0.075..0.075 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
69. 0.005 33.707 ↑ 200.0 1 1

Hash (cost=66,237.32..66,237.32 rows=200 width=20) (actual time=33.707..33.707 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
70. 1.776 33.702 ↑ 200.0 1 1

GroupAggregate (cost=14.92..66,236.72 rows=200 width=20) (actual time=33.702..33.702 rows=1 loops=1)

  • Group Key: daily_product_metrics_ongoing_totals_p2019_02_20_1.seller_marketplace_tm_id
71. 1.774 31.926 ↑ 1.4 24,703 1

Append (cost=14.92..66,200.90 rows=35,221 width=20) (actual time=0.108..31.926 rows=24,703 loops=1)

72. 1.102 1.173 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_20 daily_product_metrics_ongoing_totals_p2019_02_20_1 (cost=14.92..2,060.20 rows=1,100 width=20) (actual time=0.107..1.173 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=326
73. 0.071 0.071 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx307 (cost=0.00..14.86 rows=1,100 width=0) (actual time=0.071..0.071 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
74. 1.068 1.160 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_21 daily_product_metrics_ongoing_totals_p2019_02_21_1 (cost=14.94..2,081.58 rows=1,110 width=20) (actual time=0.129..1.160 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=327
75. 0.092 0.092 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx308 (cost=0.00..14.89 rows=1,110 width=0) (actual time=0.091..0.092 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
76. 1.068 1.178 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_22 daily_product_metrics_ongoing_totals_p2019_02_22_1 (cost=14.88..2,039.73 rows=1,086 width=20) (actual time=0.153..1.178 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=323
77. 0.110 0.110 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx309 (cost=0.00..14.83 rows=1,086 width=0) (actual time=0.110..0.110 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
78. 0.908 1.001 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_23 daily_product_metrics_ongoing_totals_p2019_02_23_1 (cost=15.03..2,141.54 rows=1,143 width=20) (actual time=0.136..1.001 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=326
79. 0.093 0.093 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx310 (cost=0.00..14.97 rows=1,143 width=0) (actual time=0.093..0.093 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
80. 1.111 1.205 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_24 daily_product_metrics_ongoing_totals_p2019_02_24_1 (cost=14.90..2,054.47 rows=1,094 width=20) (actual time=0.135..1.205 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=327
81. 0.094 0.094 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx311 (cost=0.00..14.85 rows=1,094 width=0) (actual time=0.094..0.094 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
82. 1.019 1.116 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_25 daily_product_metrics_ongoing_totals_p2019_02_25_1 (cost=14.91..2,061.77 rows=1,098 width=20) (actual time=0.136..1.116 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=318
83. 0.097 0.097 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx312 (cost=0.00..14.86 rows=1,098 width=0) (actual time=0.097..0.097 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
84. 1.094 1.191 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_26 daily_product_metrics_ongoing_totals_p2019_02_26_1 (cost=14.87..2,034.59 rows=1,083 width=20) (actual time=0.139..1.191 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=316
85. 0.097 0.097 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx313 (cost=0.00..14.82 rows=1,083 width=0) (actual time=0.097..0.097 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
86. 1.051 1.147 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_27 daily_product_metrics_ongoing_totals_p2019_02_27_1 (cost=14.89..2,049.28 rows=1,091 width=20) (actual time=0.139..1.147 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=325
87. 0.096 0.096 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx314 (cost=0.00..14.84 rows=1,091 width=0) (actual time=0.096..0.096 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
88. 1.049 1.149 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_28 daily_product_metrics_ongoing_totals_p2019_02_28_1 (cost=14.94..2,082.04 rows=1,109 width=20) (actual time=0.139..1.149 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=329
89. 0.100 0.100 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx315 (cost=0.00..14.88 rows=1,109 width=0) (actual time=0.100..0.100 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
90. 1.067 1.157 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_01 daily_product_metrics_ongoing_totals_p2019_03_01_1 (cost=14.94..2,083.74 rows=1,108 width=20) (actual time=0.136..1.157 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=331
91. 0.090 0.090 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx316 (cost=0.00..14.88 rows=1,108 width=0) (actual time=0.090..0.090 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
92. 0.982 1.071 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_02 daily_product_metrics_ongoing_totals_p2019_03_02_1 (cost=15.12..2,209.24 rows=1,178 width=20) (actual time=0.129..1.071 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=333
93. 0.089 0.089 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx317 (cost=0.00..15.06 rows=1,178 width=0) (actual time=0.089..0.089 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
94. 1.009 1.102 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_03 daily_product_metrics_ongoing_totals_p2019_03_03_1 (cost=15.04..2,153.19 rows=1,147 width=20) (actual time=0.147..1.102 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=338
95. 0.093 0.093 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx318 (cost=0.00..14.98 rows=1,147 width=0) (actual time=0.093..0.093 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
96. 0.908 1.009 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_04 daily_product_metrics_ongoing_totals_p2019_03_04_1 (cost=15.08..2,192.41 rows=1,166 width=20) (actual time=0.139..1.009 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=334
97. 0.101 0.101 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx319 (cost=0.00..15.03 rows=1,166 width=0) (actual time=0.101..0.101 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
98. 1.061 1.151 ↑ 1.5 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_05 daily_product_metrics_ongoing_totals_p2019_03_05_1 (cost=17.24..2,301.82 rows=1,226 width=20) (actual time=0.131..1.151 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=330
99. 0.090 0.090 ↑ 1.5 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx320 (cost=0.00..17.18 rows=1,226 width=0) (actual time=0.090..0.090 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
100. 1.001 1.097 ↑ 1.5 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_06 daily_product_metrics_ongoing_totals_p2019_03_06_1 (cost=17.21..2,285.47 rows=1,217 width=20) (actual time=0.132..1.097 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=331
101. 0.096 0.096 ↑ 1.5 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx321 (cost=0.00..17.15 rows=1,217 width=0) (actual time=0.096..0.096 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
102. 0.931 1.028 ↑ 1.5 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_07 daily_product_metrics_ongoing_totals_p2019_03_07_1 (cost=17.26..2,316.35 rows=1,235 width=20) (actual time=0.133..1.028 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=333
103. 0.097 0.097 ↑ 1.5 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx322 (cost=0.00..17.20 rows=1,235 width=0) (actual time=0.097..0.097 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
104. 0.866 0.959 ↑ 1.4 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_08 daily_product_metrics_ongoing_totals_p2019_03_08_1 (cost=15.14..2,229.46 rows=1,188 width=20) (actual time=0.128..0.959 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=313
105. 0.093 0.093 ↑ 1.4 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx323 (cost=0.00..15.08 rows=1,188 width=0) (actual time=0.093..0.093 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
106. 0.845 0.939 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_09 daily_product_metrics_ongoing_totals_p2019_03_09_1 (cost=15.19..2,268.01 rows=1,208 width=20) (actual time=0.128..0.939 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=300
107. 0.094 0.094 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx324 (cost=0.00..15.13 rows=1,208 width=0) (actual time=0.094..0.094 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
108. 0.877 0.966 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_10 daily_product_metrics_ongoing_totals_p2019_03_10_1 (cost=15.16..2,246.61 rows=1,196 width=20) (actual time=0.124..0.966 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=314
109. 0.089 0.089 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx325 (cost=0.00..15.10 rows=1,196 width=0) (actual time=0.089..0.089 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
110. 0.852 0.951 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_11 daily_product_metrics_ongoing_totals_p2019_03_11_1 (cost=17.26..2,318.72 rows=1,234 width=20) (actual time=0.134..0.951 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=308
111. 0.099 0.099 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx326 (cost=0.00..17.20 rows=1,234 width=0) (actual time=0.099..0.099 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
112. 0.800 0.887 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_12 daily_product_metrics_ongoing_totals_p2019_03_12_1 (cost=17.28..2,333.43 rows=1,242 width=20) (actual time=0.121..0.887 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=299
113. 0.087 0.087 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx327 (cost=0.00..17.22 rows=1,242 width=0) (actual time=0.087..0.087 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
114. 0.576 0.656 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_13 daily_product_metrics_ongoing_totals_p2019_03_13_1 (cost=17.22..2,289.79 rows=1,218 width=20) (actual time=0.101..0.656 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=198
115. 0.080 0.080 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx328 (cost=0.00..17.16 rows=1,218 width=0) (actual time=0.080..0.080 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
116. 0.647 0.742 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_14 daily_product_metrics_ongoing_totals_p2019_03_14_1 (cost=17.21..2,283.81 rows=1,216 width=20) (actual time=0.117..0.742 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=209
117. 0.095 0.095 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx329 (cost=0.00..17.15 rows=1,216 width=0) (actual time=0.095..0.095 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
118. 0.662 0.746 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_15 daily_product_metrics_ongoing_totals_p2019_03_15_1 (cost=15.18..2,260.03 rows=1,204 width=20) (actual time=0.105..0.746 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=206
119. 0.084 0.084 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx330 (cost=0.00..15.12 rows=1,204 width=0) (actual time=0.084..0.084 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
120. 0.710 0.795 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_16 daily_product_metrics_ongoing_totals_p2019_03_16_1 (cost=17.24..2,301.04 rows=1,225 width=20) (actual time=0.110..0.795 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=204
121. 0.085 0.085 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx331 (cost=0.00..17.17 rows=1,225 width=0) (actual time=0.085..0.085 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
122. 0.741 0.836 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_17 daily_product_metrics_ongoing_totals_p2019_03_17_1 (cost=17.27..2,324.89 rows=1,238 width=20) (actual time=0.120..0.836 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=211
123. 0.095 0.095 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx332 (cost=0.00..17.21 rows=1,238 width=0) (actual time=0.095..0.095 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
124. 0.708 0.798 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_18 daily_product_metrics_ongoing_totals_p2019_03_18_1 (cost=17.23..2,295.85 rows=1,222 width=20) (actual time=0.112..0.798 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=211
125. 0.090 0.090 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx333 (cost=0.00..17.17 rows=1,222 width=0) (actual time=0.090..0.090 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
126. 0.833 0.927 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_19 daily_product_metrics_ongoing_totals_p2019_03_19_1 (cost=17.27..2,328.52 rows=1,238 width=20) (actual time=0.124..0.927 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=257
127. 0.094 0.094 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx334 (cost=0.00..17.21 rows=1,238 width=0) (actual time=0.094..0.094 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
128. 0.870 0.972 ↑ 1.5 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_20 daily_product_metrics_ongoing_totals_p2019_03_20_1 (cost=17.23..2,299.55 rows=1,222 width=20) (actual time=0.132..0.972 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=255
129. 0.102 0.102 ↑ 1.5 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx335 (cost=0.00..17.17 rows=1,222 width=0) (actual time=0.102..0.102 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
130. 0.939 1.043 ↑ 1.4 824 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_03_21 daily_product_metrics_ongoing_totals_p2019_03_21_1 (cost=15.12..2,220.95 rows=1,179 width=20) (actual time=0.138..1.043 rows=824 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
  • Heap Blocks: exact=288
131. 0.104 0.104 ↑ 1.4 824 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx336 (cost=0.00..15.06 rows=1,179 width=0) (actual time=0.104..0.104 rows=824 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2019-02-20'::date) AND (date <= '2019-03-21'::date))
132. 0.160 0.160 ↓ 0.0 0 20

Index Scan using products_pkey on products x2 (cost=0.11..4.12 rows=1 width=210) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (tm_id = daily_product_metrics_ongoing_totals_p2019_02_20.product_tm_id)
  • Filter: (is_valid AND ((product_relationship_type)::text = ANY ('{ChildProduct,SingletonProduct}'::text[])))
  • Rows Removed by Filter: 0
133. 0.054 1.012 ↑ 10.0 20 1

GroupAggregate (cost=2,070.21..2,078.01 rows=200 width=240) (actual time=0.972..1.012 rows=20 loops=1)

  • Group Key: daily_product_metrics_ongoing_totals_p2019_02_20_2.product_tm_id
134. 0.345 0.958 ↑ 52.4 21 1

Sort (cost=2,070.21..2,070.76 rows=1,100 width=61) (actual time=0.956..0.958 rows=21 loops=1)

  • Sort Key: daily_product_metrics_ongoing_totals_p2019_02_20_2.product_tm_id
  • Sort Method: quicksort Memory: 105kB
135. 0.538 0.613 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_20 daily_product_metrics_ongoing_totals_p2019_02_20_2 (cost=14.37..2,059.10 rows=1,100 width=61) (actual time=0.113..0.613 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date = '2019-02-20'::date))
  • Heap Blocks: exact=326
136. 0.075 0.075 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx307 (cost=0.00..14.31 rows=1,100 width=0) (actual time=0.075..0.075 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date = '2019-02-20'::date))
137. 0.080 0.080 ↑ 1.0 1 10

Index Scan using product_associated_campaigns_pkey on product_associated_campaigns x3 (cost=0.09..0.10 rows=1 width=116) (actual time=0.008..0.008 rows=1 loops=10)

  • Index Cond: (product_tm_id = x2.tm_id)
Execution time : 790.285 ms