explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8QiY

Settings
# exclusive inclusive rows x rows loops node
1. 253.225 273.657 ↑ 1.0 10 1

Limit (cost=138,766.20..138,891.14 rows=10 width=743) (actual time=273.420..273.657 rows=10 loops=1)

  • Functions: 200
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 46.071 ms, Inlining 0.000 ms, Optimization 13.880 ms, Emission 237.945 ms, Total 297.897 ms
2. 0.135 20.432 ↑ 9.0 10 1

Nested Loop Left Join (cost=138,766.20..139,890.69 rows=90 width=743) (actual time=20.197..20.432 rows=10 loops=1)

3. 0.023 20.247 ↑ 9.0 10 1

Merge Left Join (cost=138,766.11..139,878.45 rows=90 width=674) (actual time=20.119..20.247 rows=10 loops=1)

  • Merge Cond: (daily_product_metrics_ongoing_totals_p2020_02_20.product_tm_id = daily_product_metrics_ongoing_totals_p2020_02_20_2.product_tm_id)
4. 0.025 19.695 ↑ 9.0 10 1

Nested Loop (cost=135,899.63..137,000.74 rows=90 width=450) (actual time=19.599..19.695 rows=10 loops=1)

5. 0.061 19.580 ↑ 20.0 10 1

GroupAggregate (cost=135,899.51..136,176.44 rows=200 width=240) (actual time=19.551..19.580 rows=10 loops=1)

  • Group Key: daily_product_metrics_ongoing_totals_p2020_02_20.product_tm_id
6. 0.208 19.519 ↑ 4,177.7 11 1

Sort (cost=135,899.51..135,922.49 rows=45,955 width=59) (actual time=19.517..19.519 rows=11 loops=1)

  • Sort Key: daily_product_metrics_ongoing_totals_p2020_02_20.product_tm_id
  • Sort Method: quicksort Memory: 82kB
7. 1.049 19.311 ↑ 110.5 416 1

Hash Join (cost=47,513.42..135,187.76 rows=45,955 width=59) (actual time=19.106..19.311 rows=416 loops=1)

  • Hash Cond: (daily_product_metrics_ongoing_totals_p2020_02_20.date = (COALESCE(max(daily_product_metrics_ongoing_totals_p2020_02_20_1.date), '2020-03-21'::date)))
8. 1.089 8.534 ↑ 3.6 12,896 1

Append (cost=25.94..87,309.66 rows=45,955 width=79) (actual time=0.159..8.534 rows=12,896 loops=1)

9. 0.277 0.384 ↑ 3.6 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_20 (cost=25.94..2,852.15 rows=1,501 width=79) (actual time=0.150..0.384 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=152
10. 0.107 0.107 ↑ 3.6 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx672 (cost=0.00..25.86 rows=1,501 width=0) (actual time=0.107..0.107 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
11. 0.216 0.258 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_21 (cost=26.01..2,900.39 rows=1,527 width=79) (actual time=0.064..0.258 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=128
12. 0.042 0.042 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx673 (cost=0.00..25.93 rows=1,527 width=0) (actual time=0.042..0.042 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
13. 0.242 0.280 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_22 (cost=26.02..2,911.47 rows=1,533 width=79) (actual time=0.069..0.280 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=151
14. 0.038 0.038 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx674 (cost=0.00..25.94 rows=1,533 width=0) (actual time=0.038..0.038 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
15. 0.251 0.296 ↑ 3.8 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_23 (cost=26.10..2,968.20 rows=1,564 width=79) (actual time=0.075..0.296 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=143
16. 0.045 0.045 ↑ 3.8 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx675 (cost=0.00..26.02 rows=1,564 width=0) (actual time=0.045..0.045 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
17. 0.237 0.287 ↑ 3.6 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_24 (cost=25.96..2,867.33 rows=1,509 width=79) (actual time=0.074..0.287 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=118
18. 0.050 0.050 ↑ 3.6 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx676 (cost=0.00..25.88 rows=1,509 width=0) (actual time=0.050..0.050 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
19. 0.230 0.267 ↑ 3.8 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_25 (cost=26.14..2,995.94 rows=1,580 width=79) (actual time=0.065..0.267 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=124
20. 0.037 0.037 ↑ 3.8 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx677 (cost=0.00..26.06 rows=1,580 width=0) (actual time=0.037..0.037 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
21. 0.267 0.306 ↑ 3.6 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_26 (cost=25.95..2,863.47 rows=1,507 width=79) (actual time=0.068..0.306 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=149
22. 0.039 0.039 ↑ 3.6 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx678 (cost=0.00..25.88 rows=1,507 width=0) (actual time=0.039..0.039 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
23. 0.242 0.281 ↑ 3.6 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_27 (cost=25.93..2,843.21 rows=1,496 width=79) (actual time=0.068..0.281 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=134
24. 0.039 0.039 ↑ 3.6 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx679 (cost=0.00..25.85 rows=1,496 width=0) (actual time=0.039..0.039 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
25. 0.238 0.281 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_28 (cost=26.02..2,909.41 rows=1,532 width=79) (actual time=0.065..0.281 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=141
26. 0.043 0.043 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx680 (cost=0.00..25.94 rows=1,532 width=0) (actual time=0.043..0.043 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
27. 0.230 0.273 ↑ 3.6 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_29 (cost=25.96..2,868.87 rows=1,510 width=79) (actual time=0.066..0.273 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=117
28. 0.043 0.043 ↑ 3.6 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx681 (cost=0.00..25.89 rows=1,510 width=0) (actual time=0.043..0.043 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
29. 0.239 0.275 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_01 (cost=26.02..2,911.28 rows=1,533 width=79) (actual time=0.063..0.275 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=119
30. 0.036 0.036 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx682 (cost=0.00..25.94 rows=1,533 width=0) (actual time=0.036..0.036 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
31. 0.244 0.282 ↑ 3.6 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_02 (cost=25.98..2,879.94 rows=1,516 width=79) (actual time=0.076..0.282 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=122
32. 0.038 0.038 ↑ 3.6 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx683 (cost=0.00..25.90 rows=1,516 width=0) (actual time=0.038..0.038 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
33. 0.235 0.271 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_03 (cost=25.99..2,891.16 rows=1,522 width=79) (actual time=0.063..0.271 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=104
34. 0.036 0.036 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx684 (cost=0.00..25.92 rows=1,522 width=0) (actual time=0.036..0.036 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
35. 0.178 0.211 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_04 (cost=28.02..2,910.81 rows=1,532 width=79) (actual time=0.056..0.211 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=77
36. 0.033 0.033 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx685 (cost=0.00..27.94 rows=1,532 width=0) (actual time=0.033..0.033 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
37. 0.173 0.208 ↑ 3.8 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_05 (cost=28.14..2,995.46 rows=1,579 width=79) (actual time=0.059..0.208 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=75
38. 0.035 0.035 ↑ 3.8 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx686 (cost=0.00..28.06 rows=1,579 width=0) (actual time=0.034..0.035 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
39. 0.190 0.226 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_06 (cost=28.09..2,960.71 rows=1,559 width=79) (actual time=0.061..0.226 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=71
40. 0.036 0.036 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx687 (cost=0.00..28.01 rows=1,559 width=0) (actual time=0.036..0.036 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
41. 0.179 0.215 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_07 (cost=26.02..2,910.55 rows=1,532 width=79) (actual time=0.062..0.215 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=71
42. 0.036 0.036 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx688 (cost=0.00..25.94 rows=1,532 width=0) (actual time=0.036..0.036 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
43. 0.170 0.208 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_08 (cost=26.01..2,903.20 rows=1,528 width=79) (actual time=0.055..0.208 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=65
44. 0.038 0.038 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx689 (cost=0.00..25.93 rows=1,528 width=0) (actual time=0.038..0.038 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
45. 0.186 0.224 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_09 (cost=28.03..2,922.06 rows=1,538 width=79) (actual time=0.076..0.224 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=65
46. 0.038 0.038 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx690 (cost=0.00..27.96 rows=1,538 width=0) (actual time=0.038..0.038 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
47. 0.167 0.203 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_10 (cost=28.07..2,947.86 rows=1,552 width=80) (actual time=0.058..0.203 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=64
48. 0.036 0.036 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx691 (cost=0.00..27.99 rows=1,552 width=0) (actual time=0.036..0.036 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
49. 0.173 0.213 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_11 (cost=28.07..2,947.96 rows=1,552 width=79) (actual time=0.063..0.213 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=73
50. 0.040 0.040 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx692 (cost=0.00..27.99 rows=1,552 width=0) (actual time=0.040..0.040 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
51. 0.155 0.190 ↑ 3.7 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_12 (cost=28.06..2,940.59 rows=1,548 width=79) (actual time=0.053..0.190 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=56
52. 0.035 0.035 ↑ 3.7 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx693 (cost=0.00..27.98 rows=1,548 width=0) (actual time=0.035..0.035 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
53. 0.171 0.215 ↑ 3.9 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_13 (cost=28.23..3,061.95 rows=1,615 width=79) (actual time=0.069..0.215 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=62
54. 0.044 0.044 ↑ 3.9 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx694 (cost=0.00..28.15 rows=1,615 width=0) (actual time=0.044..0.044 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
55. 0.182 0.225 ↑ 3.8 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_14 (cost=28.13..2,988.56 rows=1,575 width=80) (actual time=0.061..0.225 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=48
56. 0.043 0.043 ↑ 3.8 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx695 (cost=0.00..28.05 rows=1,575 width=0) (actual time=0.043..0.043 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
57. 0.156 0.199 ↑ 3.8 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_15 (cost=28.11..2,976.68 rows=1,569 width=79) (actual time=0.064..0.199 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=49
58. 0.043 0.043 ↑ 3.8 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx696 (cost=0.00..28.03 rows=1,569 width=0) (actual time=0.043..0.043 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
59. 0.143 0.188 ↑ 3.8 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_16 (cost=28.10..2,967.80 rows=1,563 width=79) (actual time=0.061..0.188 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=39
60. 0.045 0.045 ↑ 3.8 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx697 (cost=0.00..28.02 rows=1,563 width=0) (actual time=0.045..0.045 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
61. 0.172 0.216 ↑ 3.6 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_17 (cost=27.90..2,829.02 rows=1,486 width=80) (actual time=0.063..0.216 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=38
62. 0.044 0.044 ↑ 3.6 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx698 (cost=0.00..27.83 rows=1,486 width=0) (actual time=0.044..0.044 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
63. 0.170 0.214 ↑ 3.5 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_18 (cost=27.80..2,757.18 rows=1,447 width=80) (actual time=0.081..0.214 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=32
64. 0.044 0.044 ↑ 3.5 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx699 (cost=0.00..27.73 rows=1,447 width=0) (actual time=0.044..0.044 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
65. 0.155 0.195 ↑ 2.4 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_19 (cost=14.68..1,899.42 rows=1,008 width=80) (actual time=0.059..0.195 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=15
66. 0.040 0.040 ↑ 2.4 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx700 (cost=0.00..14.63 rows=1,008 width=0) (actual time=0.040..0.040 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
67. 0.122 0.178 ↑ 2.3 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_20 (cost=14.57..1,831.66 rows=972 width=80) (actual time=0.071..0.178 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=15
68. 0.056 0.056 ↑ 1.2 804 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx701 (cost=0.00..14.52 rows=972 width=0) (actual time=0.056..0.056 rows=804 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
69. 0.121 0.176 ↑ 2.3 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_21 (cost=14.56..1,826.44 rows=970 width=80) (actual time=0.072..0.176 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=14
70. 0.055 0.055 ↑ 1.4 715 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx702 (cost=0.00..14.51 rows=970 width=0) (actual time=0.055..0.055 rows=715 loops=1)

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

Hash (cost=47,486.78..47,486.78 rows=200 width=20) (actual time=9.728..9.728 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
72. 0.977 9.721 ↑ 200.0 1 1

GroupAggregate (cost=0.11..47,486.18 rows=200 width=20) (actual time=9.720..9.721 rows=1 loops=1)

  • Group Key: daily_product_metrics_ongoing_totals_p2020_02_20_1.seller_marketplace_tm_id
73. 0.970 8.744 ↑ 3.6 12,896 1

Append (cost=0.11..47,439.63 rows=45,955 width=20) (actual time=0.031..8.744 rows=12,896 loops=1)

74. 0.302 0.302 ↑ 3.6 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx672 on daily_product_metrics_ongoing_totals_p2020_02_20 daily_product_metrics_ongoing_totals_p2020_02_20_1 (cost=0.11..1,592.24 rows=1,501 width=20) (actual time=0.020..0.302 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 362
75. 0.321 0.321 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx673 on daily_product_metrics_ongoing_totals_p2020_02_21 daily_product_metrics_ongoing_totals_p2020_02_21_1 (cost=0.11..1,658.43 rows=1,527 width=20) (actual time=0.017..0.321 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 371
76. 0.339 0.339 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx674 on daily_product_metrics_ongoing_totals_p2020_02_22 daily_product_metrics_ongoing_totals_p2020_02_22_1 (cost=0.11..1,604.19 rows=1,533 width=20) (actual time=0.030..0.339 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 394
77. 0.292 0.292 ↑ 3.8 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx675 on daily_product_metrics_ongoing_totals_p2020_02_23 daily_product_metrics_ongoing_totals_p2020_02_23_1 (cost=0.11..1,738.30 rows=1,564 width=20) (actual time=0.016..0.292 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 386
78. 0.277 0.277 ↑ 3.6 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx676 on daily_product_metrics_ongoing_totals_p2020_02_24 daily_product_metrics_ongoing_totals_p2020_02_24_1 (cost=0.11..1,604.05 rows=1,509 width=20) (actual time=0.020..0.277 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 338
79. 0.315 0.315 ↑ 3.8 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx677 on daily_product_metrics_ongoing_totals_p2020_02_25 daily_product_metrics_ongoing_totals_p2020_02_25_1 (cost=0.11..1,678.28 rows=1,580 width=20) (actual time=0.023..0.315 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 352
80. 0.280 0.280 ↑ 3.6 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx678 on daily_product_metrics_ongoing_totals_p2020_02_26 daily_product_metrics_ongoing_totals_p2020_02_26_1 (cost=0.11..1,625.90 rows=1,507 width=20) (actual time=0.021..0.280 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 343
81. 0.284 0.284 ↑ 3.6 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx679 on daily_product_metrics_ongoing_totals_p2020_02_27 daily_product_metrics_ongoing_totals_p2020_02_27_1 (cost=0.11..1,572.08 rows=1,496 width=20) (actual time=0.020..0.284 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 346
82. 0.266 0.266 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx680 on daily_product_metrics_ongoing_totals_p2020_02_28 daily_product_metrics_ongoing_totals_p2020_02_28_1 (cost=0.11..1,634.25 rows=1,532 width=20) (actual time=0.016..0.266 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 358
83. 0.253 0.253 ↑ 3.6 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx681 on daily_product_metrics_ongoing_totals_p2020_02_29 daily_product_metrics_ongoing_totals_p2020_02_29_1 (cost=0.11..1,546.29 rows=1,510 width=20) (actual time=0.020..0.253 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 350
84. 0.259 0.259 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx682 on daily_product_metrics_ongoing_totals_p2020_03_01 daily_product_metrics_ongoing_totals_p2020_03_01_1 (cost=0.11..1,570.39 rows=1,533 width=20) (actual time=0.023..0.259 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 357
85. 0.250 0.250 ↑ 3.6 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx683 on daily_product_metrics_ongoing_totals_p2020_03_02 daily_product_metrics_ongoing_totals_p2020_03_02_1 (cost=0.11..1,542.39 rows=1,516 width=20) (actual time=0.021..0.250 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 342
86. 0.262 0.262 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx684 on daily_product_metrics_ongoing_totals_p2020_03_03 daily_product_metrics_ongoing_totals_p2020_03_03_1 (cost=0.11..1,550.14 rows=1,522 width=20) (actual time=0.016..0.262 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 357
87. 0.255 0.255 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx685 on daily_product_metrics_ongoing_totals_p2020_03_04 daily_product_metrics_ongoing_totals_p2020_03_04_1 (cost=0.11..1,687.11 rows=1,532 width=20) (actual time=0.027..0.255 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 398
88. 0.242 0.242 ↑ 3.8 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx686 on daily_product_metrics_ongoing_totals_p2020_03_05 daily_product_metrics_ongoing_totals_p2020_03_05_1 (cost=0.11..1,735.58 rows=1,579 width=20) (actual time=0.017..0.242 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 416
89. 0.251 0.251 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx687 on daily_product_metrics_ongoing_totals_p2020_03_06 daily_product_metrics_ongoing_totals_p2020_03_06_1 (cost=0.11..1,777.87 rows=1,559 width=20) (actual time=0.025..0.251 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 415
90. 0.244 0.244 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx688 on daily_product_metrics_ongoing_totals_p2020_03_07 daily_product_metrics_ongoing_totals_p2020_03_07_1 (cost=0.11..1,386.31 rows=1,532 width=20) (actual time=0.022..0.244 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 379
91. 0.244 0.244 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx689 on daily_product_metrics_ongoing_totals_p2020_03_08 daily_product_metrics_ongoing_totals_p2020_03_08_1 (cost=0.11..1,384.52 rows=1,528 width=20) (actual time=0.021..0.244 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 390
92. 0.259 0.259 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx690 on daily_product_metrics_ongoing_totals_p2020_03_09 daily_product_metrics_ongoing_totals_p2020_03_09_1 (cost=0.11..1,768.40 rows=1,538 width=20) (actual time=0.019..0.259 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 396
93. 0.262 0.262 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx691 on daily_product_metrics_ongoing_totals_p2020_03_10 daily_product_metrics_ongoing_totals_p2020_03_10_1 (cost=0.11..1,808.20 rows=1,552 width=20) (actual time=0.025..0.262 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 396
94. 0.255 0.255 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx692 on daily_product_metrics_ongoing_totals_p2020_03_11 daily_product_metrics_ongoing_totals_p2020_03_11_1 (cost=0.11..1,878.19 rows=1,552 width=20) (actual time=0.017..0.255 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 410
95. 0.257 0.257 ↑ 3.7 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx693 on daily_product_metrics_ongoing_totals_p2020_03_12 daily_product_metrics_ongoing_totals_p2020_03_12_1 (cost=0.11..1,893.60 rows=1,548 width=20) (actual time=0.024..0.257 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 413
96. 0.244 0.244 ↑ 3.9 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx694 on daily_product_metrics_ongoing_totals_p2020_03_13 daily_product_metrics_ongoing_totals_p2020_03_13_1 (cost=0.11..1,934.68 rows=1,615 width=20) (actual time=0.018..0.244 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 407
97. 0.247 0.247 ↑ 3.8 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx695 on daily_product_metrics_ongoing_totals_p2020_03_14 daily_product_metrics_ongoing_totals_p2020_03_14_1 (cost=0.11..1,712.42 rows=1,575 width=20) (actual time=0.023..0.247 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 414
98. 0.229 0.229 ↑ 3.8 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx696 on daily_product_metrics_ongoing_totals_p2020_03_15 daily_product_metrics_ongoing_totals_p2020_03_15_1 (cost=0.11..1,876.15 rows=1,569 width=20) (actual time=0.015..0.229 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 416
99. 0.218 0.218 ↑ 3.8 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx697 on daily_product_metrics_ongoing_totals_p2020_03_16 daily_product_metrics_ongoing_totals_p2020_03_16_1 (cost=0.11..1,854.66 rows=1,563 width=20) (actual time=0.023..0.218 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 416
100. 0.195 0.195 ↑ 3.6 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx698 on daily_product_metrics_ongoing_totals_p2020_03_17 daily_product_metrics_ongoing_totals_p2020_03_17_1 (cost=0.11..38.28 rows=1,486 width=20) (actual time=0.025..0.195 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 312
101. 0.201 0.201 ↑ 3.5 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx699 on daily_product_metrics_ongoing_totals_p2020_03_18 daily_product_metrics_ongoing_totals_p2020_03_18_1 (cost=0.11..34.07 rows=1,447 width=20) (actual time=0.038..0.201 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 334
102. 0.083 0.083 ↑ 2.4 416 1

Index Only Scan using daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx700 on daily_product_metrics_ongoing_totals_p2020_03_19 daily_product_metrics_ongoing_totals_p2020_03_19_1 (cost=0.11..25.65 rows=1,008 width=20) (actual time=0.030..0.083 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Fetches: 0
103. 0.118 0.197 ↑ 2.3 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_20 daily_product_metrics_ongoing_totals_p2020_03_20_1 (cost=14.57..1,831.66 rows=972 width=20) (actual time=0.097..0.197 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=15
104. 0.079 0.079 ↑ 1.2 804 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx701 (cost=0.00..14.52 rows=972 width=0) (actual time=0.079..0.079 rows=804 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
105. 0.106 0.191 ↑ 2.3 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_03_21 daily_product_metrics_ongoing_totals_p2020_03_21_1 (cost=14.56..1,826.44 rows=970 width=20) (actual time=0.100..0.191 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
  • Heap Blocks: exact=14
106. 0.085 0.085 ↑ 1.4 715 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx702 (cost=0.00..14.51 rows=970 width=0) (actual time=0.085..0.085 rows=715 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date >= '2020-02-20'::date) AND (date <= '2020-03-21'::date))
107. 0.090 0.090 ↑ 1.0 1 10

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

  • Index Cond: (tm_id = daily_product_metrics_ongoing_totals_p2020_02_20.product_tm_id)
  • Filter: (is_valid AND (((product_relationship_type)::text = 'ChildProduct'::text) OR ((product_relationship_type)::text = 'SingletonProduct'::text)))
108. 0.068 0.529 ↑ 20.0 10 1

GroupAggregate (cost=2,866.49..2,876.69 rows=200 width=240) (actual time=0.504..0.529 rows=10 loops=1)

  • Group Key: daily_product_metrics_ongoing_totals_p2020_02_20_2.product_tm_id
109. 0.186 0.461 ↑ 136.5 11 1

Sort (cost=2,866.49..2,867.24 rows=1,501 width=59) (actual time=0.460..0.461 rows=11 loops=1)

  • Sort Key: daily_product_metrics_ongoing_totals_p2020_02_20_2.product_tm_id
  • Sort Method: quicksort Memory: 82kB
110. 0.228 0.275 ↑ 3.6 416 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2020_02_20 daily_product_metrics_ongoing_totals_p2020_02_20_2 (cost=25.19..2,850.65 rows=1,501 width=59) (actual time=0.067..0.275 rows=416 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date = '2020-02-20'::date))
  • Heap Blocks: exact=152
111. 0.047 0.047 ↑ 3.6 416 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx672 (cost=0.00..25.11 rows=1,501 width=0) (actual time=0.047..0.047 rows=416 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date = '2020-02-20'::date))
112. 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=114) (actual time=0.005..0.005 rows=1 loops=10)

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