explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G42Ei

Settings
# exclusive inclusive rows x rows loops node
1. 267.010 309.833 ↑ 1.0 10 1

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

  • Functions: 279
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 38.446 ms, Inlining 0.000 ms, Optimization 13.086 ms, Emission 250.104 ms, Total 301.635 ms
2. 0.083 42.823 ↑ 10.3 10 1

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

3. 0.016 42.690 ↑ 10.3 10 1

Merge Left Join (cost=135,340.61..136,386.09 rows=103 width=674) (actual time=42.488..42.690 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.026 41.689 ↑ 10.3 10 1

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

5. 0.064 41.543 ↑ 10.0 20 1

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

  • Group Key: daily_product_metrics_ongoing_totals_p2019_02_20.product_tm_id
6. 0.344 41.479 ↑ 1,677.2 21 1

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

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

Hash Join (cost=66,252.94..132,738.31 rows=35,221 width=61) (actual time=40.480..41.135 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.980 17.962 ↑ 1.4 24,703 1

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

9. 0.507 0.610 ↑ 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.146..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=326
10. 0.103 0.103 ↑ 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.103..0.103 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.521 0.600 ↑ 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.114..0.600 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.079 0.079 ↑ 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.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))
13. 0.506 0.587 ↑ 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.587 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.081 0.081 ↑ 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.081..0.081 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.506 0.584 ↑ 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.584 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.078 0.078 ↑ 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.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))
17. 0.495 0.570 ↑ 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.111..0.570 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.075 0.075 ↑ 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.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))
19. 0.498 0.573 ↑ 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.109..0.573 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.075 0.075 ↑ 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.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))
21. 0.495 0.571 ↑ 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.110..0.571 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.500 0.578 ↑ 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.113..0.578 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.078 0.078 ↑ 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.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))
25. 0.490 0.565 ↑ 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.110..0.565 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.075 0.075 ↑ 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.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))
27. 0.508 0.582 ↑ 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.109..0.582 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.074 0.074 ↑ 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.074..0.074 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.498 0.570 ↑ 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.107..0.570 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.072 0.072 ↑ 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.072..0.072 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.505 0.578 ↑ 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.108..0.578 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.073 0.073 ↑ 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.073..0.073 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.506 0.581 ↑ 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.110..0.581 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.075 0.075 ↑ 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.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))
35. 0.499 0.573 ↑ 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.109..0.573 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.074 0.074 ↑ 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.074..0.074 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.486 0.559 ↑ 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.107..0.559 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.073 0.073 ↑ 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.073..0.073 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.491 0.565 ↑ 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.108..0.565 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.074 0.074 ↑ 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.074..0.074 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.476 0.549 ↑ 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.107..0.549 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.073 0.073 ↑ 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.073..0.073 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.458 0.530 ↑ 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.104..0.530 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.072 0.072 ↑ 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.072..0.072 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.483 0.557 ↑ 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.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=314
46. 0.074 0.074 ↑ 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.074..0.074 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.463 0.534 ↑ 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.104..0.534 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.071 0.071 ↑ 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.071..0.071 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.453 0.523 ↑ 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.102..0.523 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.070 0.070 ↑ 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.070..0.070 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.360 0.421 ↑ 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.081..0.421 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.362 0.423 ↑ 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.083..0.423 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.061 0.061 ↑ 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.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))
55. 0.358 0.420 ↑ 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.083..0.420 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.062 0.062 ↑ 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.062..0.062 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.357 0.420 ↑ 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.083..0.420 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.373 0.435 ↑ 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.083..0.435 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.062 0.062 ↑ 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.062..0.062 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.362 0.425 ↑ 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.084..0.425 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.063 0.063 ↑ 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.062..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))
63. 0.410 0.483 ↑ 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.103..0.483 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.073 0.073 ↑ 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.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))
65. 0.410 0.483 ↑ 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.483 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.459 0.533 ↑ 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.109..0.533 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.074 0.074 ↑ 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.074..0.074 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 21.258 ↑ 200.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
70. 1.703 21.253 ↑ 200.0 1 1

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

  • Group Key: daily_product_metrics_ongoing_totals_p2019_02_20_1.seller_marketplace_tm_id
71. 1.722 19.550 ↑ 1.4 24,703 1

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

72. 0.597 0.668 ↑ 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.108..0.668 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. 0.574 0.658 ↑ 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.120..0.658 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.084 0.084 ↑ 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.084..0.084 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. 0.578 0.666 ↑ 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.125..0.666 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.088 0.088 ↑ 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.088..0.088 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.549 0.635 ↑ 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.122..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=326
79. 0.086 0.086 ↑ 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.086..0.086 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. 0.541 0.623 ↑ 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.117..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=327
81. 0.082 0.082 ↑ 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.082..0.082 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. 0.537 0.622 ↑ 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.120..0.622 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.085 0.085 ↑ 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.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))
84. 0.536 0.619 ↑ 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.117..0.619 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.083 0.083 ↑ 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.083..0.083 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. 0.554 0.638 ↑ 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.119..0.638 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.084 0.084 ↑ 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.084..0.084 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. 0.542 0.629 ↑ 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.122..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=329
89. 0.087 0.087 ↑ 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.087..0.087 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. 0.550 0.633 ↑ 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.119..0.633 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.083 0.083 ↑ 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.083..0.083 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.547 0.628 ↑ 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.116..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
93. 0.081 0.081 ↑ 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.081..0.081 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. 0.580 0.664 ↑ 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.118..0.664 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.084 0.084 ↑ 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.084..0.084 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.549 0.635 ↑ 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.121..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=334
97. 0.086 0.086 ↑ 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.086..0.086 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. 0.592 0.677 ↑ 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.121..0.677 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.085 0.085 ↑ 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.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))
100. 0.555 0.641 ↑ 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.121..0.641 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.086 0.086 ↑ 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.086..0.086 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.569 0.656 ↑ 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.121..0.656 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.087 0.087 ↑ 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.087..0.087 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.544 0.632 ↑ 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.121..0.632 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.088 0.088 ↑ 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.088..0.088 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.530 0.616 ↑ 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.118..0.616 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.086 0.086 ↑ 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.086..0.086 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.556 0.639 ↑ 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.117..0.639 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.083 0.083 ↑ 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.083..0.083 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.545 0.630 ↑ 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.117..0.630 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.085 0.085 ↑ 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.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))
112. 0.519 0.602 ↑ 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.116..0.602 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.083 0.083 ↑ 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.083..0.083 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.371 0.443 ↑ 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.092..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=198
115. 0.072 0.072 ↑ 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.072..0.072 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.379 0.454 ↑ 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.096..0.454 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.075 0.075 ↑ 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.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))
118. 0.386 0.460 ↑ 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.095..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=206
119. 0.074 0.074 ↑ 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.074..0.074 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.398 0.469 ↑ 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.092..0.469 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.071 0.071 ↑ 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.071..0.071 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.395 0.470 ↑ 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.096..0.470 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.075 0.075 ↑ 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.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))
124. 0.393 0.467 ↑ 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.095..0.467 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.074 0.074 ↑ 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.074..0.074 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.452 0.538 ↑ 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.117..0.538 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.086 0.086 ↑ 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.086..0.086 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.453 0.537 ↑ 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.114..0.537 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.084 0.084 ↑ 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.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))
130. 0.492 0.579 ↑ 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.120..0.579 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.087 0.087 ↑ 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.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))
132. 0.120 0.120 ↓ 0.0 0 20

Index Scan using products_pkey on products x2 (cost=0.11..4.12 rows=1 width=210) (actual time=0.006..0.006 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 0.985 ↑ 10.0 20 1

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

  • Group Key: daily_product_metrics_ongoing_totals_p2019_02_20_2.product_tm_id
134. 0.349 0.931 ↑ 52.4 21 1

Sort (cost=2,070.21..2,070.76 rows=1,100 width=61) (actual time=0.929..0.931 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.510 0.582 ↑ 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.109..0.582 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.072 0.072 ↑ 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.072..0.072 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date = '2019-02-20'::date))
137. 0.050 0.050 ↑ 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.005..0.005 rows=1 loops=10)

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