explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eiPb

Settings
# exclusive inclusive rows x rows loops node
1. 3,217.409 376,509.259 ↓ 225.4 350,753 1

Nested Loop (cost=2.96..887,639.67 rows=1,556 width=1,071) (actual time=553.199..376,509.259 rows=350,753 loops=1)

  • Buffers: shared hit=46554129 read=238871
2. 824.482 365,926.037 ↓ 225.4 350,753 1

Nested Loop (cost=2.41..875,695.8 rows=1,556 width=444) (actual time=542.554..365,926.037 rows=350,753 loops=1)

  • Buffers: shared hit=44801757 read=236241
3. 488.399 352,474.447 ↓ 225.4 350,753 1

Nested Loop (cost=1.98..864,081.28 rows=1,556 width=245) (actual time=533.537..352,474.447 rows=350,753 loops=1)

  • Buffers: shared hit=43397832 read=230102
4. 532.245 334,024.260 ↓ 222.0 345,419 1

Merge Join (cost=1.42..852,249.91 rows=1,556 width=180) (actual time=526.085..334,024.26 rows=345,419 loops=1)

  • Buffers: shared hit=41841738 read=223385
5. 909.470 333,231.331 ↓ 222.0 345,419 1

Nested Loop (cost=1.14..849,687.44 rows=1,556 width=158) (actual time=466.717..333,231.331 rows=345,419 loops=1)

  • Buffers: shared hit=41672719 read=223278
6. 110.634 72,912.192 ↓ 222.0 345,419 1

Nested Loop (cost=0.57..489,655.66 rows=1,556 width=109) (actual time=305.195..72,912.192 rows=345,419 loops=1)

  • Buffers: shared hit=145301 read=150357
7. 28.764 28.764 ↓ 2.0 2 1

Index Only Scan using dashboard_list_pk on dashboard_list g (cost=0.28..216.54 rows=1 width=29) (actual time=6.548..28.764 rows=2 loops=1)

  • Index Cond: ((g.dashboard_nm = 'CONVERSE'::text) AND (g.dashboard_status = 'Active'::text) AND (g.client_typ = 'C'::text))
  • Buffers: shared hit=3 read=25
8. 69.078 72,772.794 ↓ 45.9 172,710 2

Append (cost=0.29..489,401.53 rows=3,759 width=93) (actual time=228.583..36,386.397 rows=172,710 loops=2)

  • Buffers: shared hit=145298 read=150332
9. 7.692 7.692 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2016_10_idx1 on product_seller_daily_price_2016_10 product_seller_daily_price_2016_10 (cost=0.29..6.06 rows=1 width=81) (actual time=3.846..3.846 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2016_10.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2016_10.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2016_10.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2016_10.client_nm)::text))
  • Buffers: shared read=4
10. 6.528 6.528 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2016_11_idx1 on product_seller_daily_price_2016_11 product_seller_daily_price_2016_11 (cost=0.29..8.31 rows=1 width=81) (actual time=3.264..3.264 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2016_11.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2016_11.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2016_11.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2016_11.client_nm)::text))
  • Buffers: shared read=4
11. 5.218 5.218 ↓ 0.0 0 2

Seq Scan on product_seller_daily_price_2016_12 product_seller_daily_price_2016_12 (cost=0..3.57 rows=1 width=81) (actual time=2.609..2.609 rows=0 loops=2)

  • Filter: ((product_seller_daily_price_2016_12.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2016_12.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2016_12.client_nm)::text) AND (product_seller_daily_price_2016_12.as_of_date >= date((now() - '5 days'::interval))))
  • Buffers: shared hit=1 read=3
12. 12.934 12.934 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_1_indx1 on product_seller_daily_price_2017_1 product_seller_daily_price_2017_1 (cost=0.29..6.07 rows=1 width=85) (actual time=6.467..6.467 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_1.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_1.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_1.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_1.client_nm)::text))
  • Buffers: shared read=4
13. 9.130 9.130 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_2_idx1 on product_seller_daily_price_2017_2 product_seller_daily_price_2017_2 (cost=0.43..6.2 rows=1 width=87) (actual time=4.565..4.565 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_2.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_2.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_2.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_2.client_nm)::text))
  • Buffers: shared read=6
14. 12.148 12.148 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_3_idx1 on product_seller_daily_price_2017_3 product_seller_daily_price_2017_3 (cost=0.43..8.45 rows=1 width=87) (actual time=6.074..6.074 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_3.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_3.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_3.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_3.client_nm)::text))
  • Buffers: shared read=6
15. 10.522 10.522 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_4_idx1 on product_seller_daily_price_2017_4 product_seller_daily_price_2017_4 (cost=0.43..8.46 rows=1 width=87) (actual time=5.261..5.261 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_4.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_4.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_4.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_4.client_nm)::text))
  • Buffers: shared read=6
16. 10.630 10.630 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_5_indx1 on product_seller_daily_price_2017_5 product_seller_daily_price_2017_5 (cost=0.43..6.21 rows=1 width=87) (actual time=5.315..5.315 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_5.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_5.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_5.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_5.client_nm)::text))
  • Buffers: shared read=6
17. 14.732 14.732 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_6_idx1 on product_seller_daily_price_2017_6 product_seller_daily_price_2017_6 (cost=0.56..8.59 rows=1 width=86) (actual time=7.366..7.366 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_6.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_6.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_6.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_6.client_nm)::text))
  • Buffers: shared read=8
18. 10.764 10.764 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_7_idx1 on product_seller_daily_price_2017_7 product_seller_daily_price_2017_7 (cost=0.56..8.59 rows=1 width=86) (actual time=5.382..5.382 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_7.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_7.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_7.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_7.client_nm)::text))
  • Buffers: shared read=8
19. 15.390 15.390 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_8_idx1 on product_seller_daily_price_2017_8 product_seller_daily_price_2017_8 (cost=0.56..8.59 rows=1 width=86) (actual time=7.695..7.695 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_8.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_8.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_8.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_8.client_nm)::text))
  • Buffers: shared read=8
20. 12.678 12.678 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_9_idx1 on product_seller_daily_price_2017_9 product_seller_daily_price_2017_9 (cost=0.56..6.34 rows=1 width=85) (actual time=6.339..6.339 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_9.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_9.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_9.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_9.client_nm)::text))
  • Buffers: shared read=8
21. 11.028 11.028 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_10_idx1 on product_seller_daily_price_2017_10 product_seller_daily_price_2017_10 (cost=0.56..6.34 rows=1 width=85) (actual time=5.514..5.514 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_10.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_10.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_10.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_10.client_nm)::text))
  • Buffers: shared read=8
22. 15.404 15.404 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_11_idx1 on product_seller_daily_price_2017_11 product_seller_daily_price_2017_11 (cost=0.57..8.59 rows=1 width=87) (actual time=7.702..7.702 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_11.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_11.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_11.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_11.client_nm)::text))
  • Buffers: shared read=8
23. 14.500 14.500 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2017_12_idx1 on product_seller_daily_price_2017_12 product_seller_daily_price_2017_12 (cost=0.57..6.35 rows=1 width=88) (actual time=7.25..7.25 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2017_12.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2017_12.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2017_12.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2017_12.client_nm)::text))
  • Buffers: shared read=8
24. 19.474 19.474 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_1_idx1 on product_seller_daily_price_2018_1 product_seller_daily_price_2018_1 (cost=0.57..8.59 rows=1 width=86) (actual time=9.737..9.737 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_1.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_1.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_1.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_1.client_nm)::text))
  • Buffers: shared read=8
25. 15.336 15.336 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_2_idx1 on product_seller_daily_price_2018_2 product_seller_daily_price_2018_2 (cost=0.57..8.59 rows=1 width=88) (actual time=7.668..7.668 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_2.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_2.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_2.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_2.client_nm)::text))
  • Buffers: shared read=8
26. 11.834 11.834 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_3_idx1 on product_seller_daily_price_2018_3 product_seller_daily_price_2018_3 (cost=0.57..6.34 rows=1 width=88) (actual time=5.917..5.917 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_3.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_3.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_3.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_3.client_nm)::text))
  • Buffers: shared read=8
27. 12.312 12.312 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_4_idx1 on product_seller_daily_price_2018_4 product_seller_daily_price_2018_4 (cost=0.57..8.59 rows=1 width=87) (actual time=6.156..6.156 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_4.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_4.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_4.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_4.client_nm)::text))
  • Buffers: shared read=8
28. 13.650 13.650 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_5_idx1 on product_seller_daily_price_2018_5 product_seller_daily_price_2018_5 (cost=0.57..6.34 rows=1 width=89) (actual time=6.825..6.825 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_5.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_5.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_5.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_5.client_nm)::text))
  • Buffers: shared read=8
29. 18.604 18.604 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_6_idx1 on product_seller_daily_price_2018_6 product_seller_daily_price_2018_6 (cost=0.57..6.35 rows=1 width=90) (actual time=9.302..9.302 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_6.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_6.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_6.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_6.client_nm)::text))
  • Buffers: shared read=8
30. 11.940 11.940 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_7_idx1 on product_seller_daily_price_2018_7 product_seller_daily_price_2018_7 (cost=0.57..8.6 rows=1 width=89) (actual time=5.97..5.97 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_7.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_7.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_7.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_7.client_nm)::text))
  • Buffers: shared read=8
31. 12.678 12.678 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_8_idx1 on product_seller_daily_price_2018_8 product_seller_daily_price_2018_8 (cost=0.57..8.6 rows=1 width=89) (actual time=6.339..6.339 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_8.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_8.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_8.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_8.client_nm)::text))
  • Buffers: shared read=8
32. 11.994 11.994 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_9_idx1 on product_seller_daily_price_2018_9 product_seller_daily_price_2018_9 (cost=0.57..8.6 rows=1 width=91) (actual time=5.997..5.997 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_9.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_9.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_9.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_9.client_nm)::text))
  • Buffers: shared read=8
33. 13.564 13.564 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_10_idx1 on product_seller_daily_price_2018_10 product_seller_daily_price_2018_10 (cost=0.57..8.6 rows=1 width=89) (actual time=6.782..6.782 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_10.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_10.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_10.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_10.client_nm)::text))
  • Buffers: shared read=8
34. 11.604 11.604 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_11_idx1 on product_seller_daily_price_2018_11 product_seller_daily_price_2018_11 (cost=0.57..6.35 rows=1 width=90) (actual time=5.802..5.802 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_11.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_11.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_11.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_11.client_nm)::text))
  • Buffers: shared read=8
35. 10.028 10.028 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2018_12_idx1 on product_seller_daily_price_2018_12 product_seller_daily_price_2018_12 (cost=0.57..6.35 rows=1 width=90) (actual time=5.014..5.014 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2018_12.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2018_12.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2018_12.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2018_12.client_nm)::text))
  • Buffers: shared read=8
36. 10.748 10.748 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2019_1_idx1 on product_seller_daily_price_2019_1 product_seller_daily_price_2019_1 (cost=0.57..8.6 rows=1 width=90) (actual time=5.374..5.374 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2019_1.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2019_1.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_1.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_1.client_nm)::text))
  • Buffers: shared read=8
37. 10.894 10.894 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2019_2_idx1 on product_seller_daily_price_2019_2 product_seller_daily_price_2019_2 (cost=0.57..6.35 rows=1 width=91) (actual time=5.447..5.447 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2019_2.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2019_2.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_2.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_2.client_nm)::text))
  • Buffers: shared read=8
38. 14.794 14.794 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2019_3_idx1 on product_seller_daily_price_2019_3 product_seller_daily_price_2019_3 (cost=0.57..8.6 rows=1 width=91) (actual time=7.397..7.397 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2019_3.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2019_3.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_3.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_3.client_nm)::text))
  • Buffers: shared read=8
39. 14.440 14.440 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2019_4_idx1 on product_seller_daily_price_2019_4 product_seller_daily_price_2019_4 (cost=0.57..8.6 rows=1 width=90) (actual time=7.22..7.22 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2019_4.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2019_4.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_4.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_4.client_nm)::text))
  • Buffers: shared read=8
40. 13.924 13.924 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2019_5_idx1 on product_seller_daily_price_2019_5 product_seller_daily_price_2019_5 (cost=0.57..6.35 rows=1 width=91) (actual time=6.962..6.962 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2019_5.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2019_5.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_5.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_5.client_nm)::text))
  • Buffers: shared read=8
41. 14.690 14.690 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2019_6_idx1 on product_seller_daily_price_2019_6 product_seller_daily_price_2019_6 (cost=0.57..6.35 rows=1 width=92) (actual time=7.345..7.345 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2019_6.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2019_6.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_6.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_6.client_nm)::text))
  • Buffers: shared read=8
42. 16.574 16.574 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2019_7_idx1 on product_seller_daily_price_2019_7 product_seller_daily_price_2019_7 (cost=0.57..8.6 rows=1 width=94) (actual time=8.287..8.287 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2019_7.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2019_7.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_7.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_7.client_nm)::text))
  • Buffers: shared read=8
43. 15.506 15.506 ↓ 0.0 0 2

Index Scan using product_seller_daily_price_2019_8_idx1 on product_seller_daily_price_2019_8 product_seller_daily_price_2019_8 (cost=0.57..6.35 rows=1 width=94) (actual time=7.753..7.753 rows=0 loops=2)

  • Index Cond: (product_seller_daily_price_2019_8.as_of_date >= date((now() - '5 days'::interval)))
  • Filter: ((product_seller_daily_price_2019_8.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_8.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_8.client_nm)::text))
  • Buffers: shared read=8
44. 68,227.116 68,227.116 ↓ 70.4 87,848 2

Index Scan using product_seller_daily_price_2019_9_idx1 on product_seller_daily_price_2019_9 product_seller_daily_price_2019_9 (cost=0.57..276,843.09 rows=1,247 width=94) (actual time=6.417..34,113.558 rows=87,848 loops=2)

  • Index Cond: ((product_seller_daily_price_2019_9.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2019_9.client_nm)::text = (g.client_nm)::text))
  • Filter: ((product_seller_daily_price_2019_9.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_9.client_typ)::text = 'C'::text))
  • Buffers: shared hit=49888 read=54668
45. 4,027.740 4,027.740 ↓ 34.3 84,862 2

Seq Scan on product_seller_daily_price_2019_10 product_seller_daily_price_2019_10 (cost=0..212,299.09 rows=2,476 width=92) (actual time=34.36..2,013.87 rows=84,862 loops=2)

  • Filter: ((product_seller_daily_price_2019_10.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_10.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_10.client_nm)::text) AND (product_seller_daily_price_2019_10.as_of_date >= date((now() - '5 days'::interval))))
  • Buffers: shared hit=95408 read=95408
46. 4.974 4.974 ↓ 0.0 0 2

Seq Scan on product_seller_daily_price_2019_11 product_seller_daily_price_2019_11 (cost=0..1 rows=1 width=1,024) (actual time=2.487..2.487 rows=0 loops=2)

  • Filter: ((product_seller_daily_price_2019_11.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2019_11.client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (product_seller_daily_price_2019_11.client_nm)::text) AND (product_seller_daily_price_2019_11.as_of_date >= date((now() - '5 days'::interval))))
  • Buffers: shared hit=1 read=1
47. 15,889.274 259,409.669 ↓ 0.0 0 345,419

Append (cost=0.57..231.06 rows=32 width=88) (actual time=0.74..0.751 rows=0 loops=345,419)

  • Buffers: shared hit=41527418 read=72921
48. 12,435.084 12,435.084 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_8_idx1 on fba_product_daily_run_2019_8 fba_product_daily_run_2019_8 (cost=0.57..7.65 rows=1 width=88) (actual time=0.036..0.036 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_8.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_8.as_of_date) AND (fba_product_daily_run_2019_8.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_8.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_8.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_8.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1378530 read=3798
49. 11,053.408 11,053.408 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_7_idx1 on fba_product_daily_run_2019_7 fba_product_daily_run_2019_7 (cost=0.57..7.65 rows=1 width=88) (actual time=0.032..0.032 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_7.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_7.as_of_date) AND (fba_product_daily_run_2019_7.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_7.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_7.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_7.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1378699 read=3642
50. 690.838 690.838 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2017_4_indx1 on fba_product_daily_run_2017_4 fba_product_daily_run_2017_4 (cost=0.43..5.5 rows=1 width=93) (actual time=0.002..0.002 rows=0 loops=345,419)

  • Index Cond: ((product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2017_4.as_of_date) AND (fba_product_daily_run_2017_4.as_of_date >= date((now() - '5 days'::interval))))
  • Filter: ((fba_product_daily_run_2017_4.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2017_4.merchant_id)::text) AND ((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2017_4.product_asin)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2017_4.marketplace)::text))
  • Buffers: shared hit=1036257
51. 690.838 690.838 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2017_5_indx1 on fba_product_daily_run_2017_5 fba_product_daily_run_2017_5 (cost=0.43..5.5 rows=1 width=92) (actual time=0.002..0.002 rows=0 loops=345,419)

  • Index Cond: ((product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2017_5.as_of_date) AND (fba_product_daily_run_2017_5.as_of_date >= date((now() - '5 days'::interval))))
  • Filter: ((fba_product_daily_run_2017_5.as_of_month = ANY ('{9,10}'::integer[])) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2017_5.merchant_id)::text) AND ((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2017_5.product_asin)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2017_5.marketplace)::text))
  • Buffers: shared hit=1036254 read=3
52. 4,490.447 4,490.447 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2017_6_idx1 on fba_product_daily_run_2017_6 fba_product_daily_run_2017_6 (cost=0.56..7.6 rows=1 width=94) (actual time=0.013..0.013 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2017_6.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2017_6.as_of_date) AND (fba_product_daily_run_2017_6.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2017_6.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2017_6.marketplace)::text))
  • Filter: (fba_product_daily_run_2017_6.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1381465 read=784
53. 4,490.447 4,490.447 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2017_7_idx1 on fba_product_daily_run_2017_7 fba_product_daily_run_2017_7 (cost=0.56..7.6 rows=1 width=94) (actual time=0.013..0.013 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2017_7.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2017_7.as_of_date) AND (fba_product_daily_run_2017_7.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2017_7.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2017_7.marketplace)::text))
  • Filter: (fba_product_daily_run_2017_7.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1381045 read=794
54. 4,490.447 4,490.447 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2017_8_idx1 on fba_product_daily_run_2017_8 fba_product_daily_run_2017_8 (cost=0.56..7.6 rows=1 width=95) (actual time=0.013..0.013 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2017_8.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2017_8.as_of_date) AND (fba_product_daily_run_2017_8.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2017_8.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2017_8.marketplace)::text))
  • Filter: (fba_product_daily_run_2017_8.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1381086 read=836
55. 4,490.447 4,490.447 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2017_9_idx1 on fba_product_daily_run_2017_9 fba_product_daily_run_2017_9 (cost=0.56..7.6 rows=1 width=94) (actual time=0.013..0.013 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2017_9.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2017_9.as_of_date) AND (fba_product_daily_run_2017_9.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2017_9.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2017_9.marketplace)::text))
  • Filter: (fba_product_daily_run_2017_9.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1381270 read=868
56. 4,490.447 4,490.447 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2017_10_idx1 on fba_product_daily_run_2017_10 fba_product_daily_run_2017_10 (cost=0.56..7.6 rows=1 width=94) (actual time=0.013..0.013 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2017_10.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2017_10.as_of_date) AND (fba_product_daily_run_2017_10.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2017_10.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2017_10.marketplace)::text))
  • Filter: (fba_product_daily_run_2017_10.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1381532 read=928
57. 4,835.866 4,835.866 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2017_11_idx1 on fba_product_daily_run_2017_11 fba_product_daily_run_2017_11 (cost=0.56..7.6 rows=1 width=93) (actual time=0.014..0.014 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2017_11.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2017_11.as_of_date) AND (fba_product_daily_run_2017_11.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2017_11.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2017_11.marketplace)::text))
  • Filter: (fba_product_daily_run_2017_11.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1380956 read=1044
58. 5,526.704 5,526.704 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2017_12_idx1 on fba_product_daily_run_2017_12 fba_product_daily_run_2017_12 (cost=0.57..7.6 rows=1 width=93) (actual time=0.016..0.016 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2017_12.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2017_12.as_of_date) AND (fba_product_daily_run_2017_12.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2017_12.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2017_12.marketplace)::text))
  • Filter: (fba_product_daily_run_2017_12.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1387903 read=1185
59. 5,872.123 5,872.123 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_1_idx1 on fba_product_daily_run_2018_1 fba_product_daily_run_2018_1 (cost=0.57..7.6 rows=1 width=93) (actual time=0.017..0.017 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_1.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_1.as_of_date) AND (fba_product_daily_run_2018_1.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_1.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_1.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_1.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1381101 read=1364
60. 5,526.704 5,526.704 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_2_idx1 on fba_product_daily_run_2018_2 fba_product_daily_run_2018_2 (cost=0.56..7.6 rows=1 width=92) (actual time=0.016..0.016 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_2.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_2.as_of_date) AND (fba_product_daily_run_2018_2.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_2.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_2.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_2.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1381455 read=1241
61. 5,526.704 5,526.704 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_3_idx1 on fba_product_daily_run_2018_3 fba_product_daily_run_2018_3 (cost=0.57..7.6 rows=1 width=92) (actual time=0.016..0.016 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_3.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_3.as_of_date) AND (fba_product_daily_run_2018_3.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_3.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_3.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_3.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1380743 read=1329
62. 5,872.123 5,872.123 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_4_idx1 on fba_product_daily_run_2018_4 fba_product_daily_run_2018_4 (cost=0.57..7.61 rows=1 width=92) (actual time=0.017..0.017 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_4.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_4.as_of_date) AND (fba_product_daily_run_2018_4.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_4.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_4.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_4.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1381032 read=1398
63. 7,599.218 7,599.218 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_5_idx1 on fba_product_daily_run_2018_5 fba_product_daily_run_2018_5 (cost=0.57..7.6 rows=1 width=93) (actual time=0.022..0.022 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_5.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_5.as_of_date) AND (fba_product_daily_run_2018_5.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_5.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_5.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_5.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1380067 read=2140
64. 7,944.637 7,944.637 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_6_idx1 on fba_product_daily_run_2018_6 fba_product_daily_run_2018_6 (cost=0.57..7.61 rows=1 width=94) (actual time=0.023..0.023 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_6.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_6.as_of_date) AND (fba_product_daily_run_2018_6.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_6.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_6.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_6.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1380093 read=2275
65. 8,290.056 8,290.056 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_7_idx1 on fba_product_daily_run_2018_7 fba_product_daily_run_2018_7 (cost=0.57..7.62 rows=1 width=93) (actual time=0.024..0.024 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_7.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_7.as_of_date) AND (fba_product_daily_run_2018_7.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_7.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_7.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_7.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1398305 read=2339
66. 8,980.894 8,980.894 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_8_idx1 on fba_product_daily_run_2018_8 fba_product_daily_run_2018_8 (cost=0.57..7.62 rows=1 width=91) (actual time=0.026..0.026 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_8.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_8.as_of_date) AND (fba_product_daily_run_2018_8.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_8.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_8.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_8.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1379608 read=2658
67. 9,326.313 9,326.313 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_9_idx1 on fba_product_daily_run_2018_9 fba_product_daily_run_2018_9 (cost=0.57..7.61 rows=1 width=89) (actual time=0.027..0.027 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_9.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_9.as_of_date) AND (fba_product_daily_run_2018_9.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_9.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_9.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_9.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1389290 read=2877
68. 9,326.313 9,326.313 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_10_idx1 on fba_product_daily_run_2018_10 fba_product_daily_run_2018_10 (cost=0.57..7.62 rows=1 width=89) (actual time=0.027..0.027 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_10.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_10.as_of_date) AND (fba_product_daily_run_2018_10.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_10.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_10.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_10.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1379465 read=2915
69. 9,671.732 9,671.732 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_11_idx1 on fba_product_daily_run_2018_11 fba_product_daily_run_2018_11 (cost=0.57..7.62 rows=1 width=87) (actual time=0.028..0.028 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_11.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_11.as_of_date) AND (fba_product_daily_run_2018_11.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_11.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_11.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_11.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1388656 read=2940
70. 9,671.732 9,671.732 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2018_12_idx1 on fba_product_daily_run_2018_12 fba_product_daily_run_2018_12 (cost=0.57..7.62 rows=1 width=88) (actual time=0.028..0.028 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2018_12.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2018_12.as_of_date) AND (fba_product_daily_run_2018_12.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2018_12.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2018_12.marketplace)::text))
  • Filter: (fba_product_daily_run_2018_12.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1379590 read=3020
71. 10,017.151 10,017.151 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_1_idx1 on fba_product_daily_run_2019_1 fba_product_daily_run_2019_1 (cost=0.57..7.61 rows=1 width=88) (actual time=0.029..0.029 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_1.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_1.as_of_date) AND (fba_product_daily_run_2019_1.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_1.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_1.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_1.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1379150 read=3219
72. 9,671.732 9,671.732 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_2_idx1 on fba_product_daily_run_2019_2 fba_product_daily_run_2019_2 (cost=0.57..7.63 rows=1 width=88) (actual time=0.028..0.028 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_2.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_2.as_of_date) AND (fba_product_daily_run_2019_2.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_2.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_2.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_2.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1379557 read=3127
73. 10,362.570 10,362.570 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_3_idx1 on fba_product_daily_run_2019_3 fba_product_daily_run_2019_3 (cost=0.57..7.63 rows=1 width=89) (actual time=0.03..0.03 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_3.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_3.as_of_date) AND (fba_product_daily_run_2019_3.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_3.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_3.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_3.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1379127 read=3324
74. 10,707.989 10,707.989 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_4_idx1 on fba_product_daily_run_2019_4 fba_product_daily_run_2019_4 (cost=0.57..7.64 rows=1 width=88) (actual time=0.031..0.031 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_4.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_4.as_of_date) AND (fba_product_daily_run_2019_4.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_4.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_4.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_4.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1380087 read=3435
75. 10,707.989 10,707.989 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_5_idx1 on fba_product_daily_run_2019_5 fba_product_daily_run_2019_5 (cost=0.57..7.64 rows=1 width=88) (actual time=0.031..0.031 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_5.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_5.as_of_date) AND (fba_product_daily_run_2019_5.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_5.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_5.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_5.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1379748 read=3461
76. 10,707.989 10,707.989 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_6_idx1 on fba_product_daily_run_2019_6 fba_product_daily_run_2019_6 (cost=0.57..7.65 rows=1 width=88) (actual time=0.031..0.031 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_6.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_6.as_of_date) AND (fba_product_daily_run_2019_6.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_6.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_6.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_6.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1378632 read=3522
77. 29,360.615 29,360.615 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_9_idx1 on fba_product_daily_run_2019_9 fba_product_daily_run_2019_9 (cost=0.57..7.67 rows=1 width=88) (actual time=0.075..0.085 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_9.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_9.as_of_date) AND (fba_product_daily_run_2019_9.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_9.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_9.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_9.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=1455877 read=12455
78. 345.419 345.419 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_10_idx1 on fba_product_daily_run_2019_10 fba_product_daily_run_2019_10 (cost=0.14..3.38 rows=1 width=1,284) (actual time=0.001..0.001 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_10.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_10.as_of_date) AND (fba_product_daily_run_2019_10.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_10.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_10.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_10.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=345419
79. 345.419 345.419 ↓ 0.0 0 345,419

Index Scan using fba_product_daily_run_2019_11_idx1 on fba_product_daily_run_2019_11 fba_product_daily_run_2019_11 (cost=0.14..3.38 rows=1 width=1,284) (actual time=0.001..0.001 rows=0 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (fba_product_daily_run_2019_11.product_asin)::text) AND (product_seller_daily_price_2016_10.as_of_date = fba_product_daily_run_2019_11.as_of_date) AND (fba_product_daily_run_2019_11.as_of_date >= date((now() - '5 days'::interval))) AND ((product_seller_daily_price_2016_10.seller_id)::text = (fba_product_daily_run_2019_11.merchant_id)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (fba_product_daily_run_2019_11.marketplace)::text))
  • Filter: (fba_product_daily_run_2019_11.as_of_month = ANY ('{9,10}'::integer[]))
  • Buffers: shared hit=345419
80. 260.684 260.684 ↓ 503.0 345,527 1

Index Scan using product_urls_1_idx on product_urls e (cost=0.28..2,552.58 rows=687 width=50) (actual time=7.476..260.684 rows=345,527 loops=1)

  • Index Cond: ((e.client_typ)::text = 'C'::text)
  • Buffers: shared hit=169019 read=107
81. 17,961.788 17,961.788 ↑ 1.0 1 345,419

Index Scan using pki_psm_index1 on pki_product_seller_map b (cost=0.56..7.59 rows=1 width=105) (actual time=0.051..0.052 rows=1 loops=345,419)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (b.product_asin_alt)::text) AND ((product_seller_daily_price_2016_10.seller_nm)::text = (b.seller_nm_alt)::text) AND ((product_seller_daily_price_2016_10.client_nm)::text = (b.client_nm)::text))
  • Buffers: shared hit=1556094 read=6717
82. 12,627.108 12,627.108 ↑ 1.0 1 350,753

Index Scan using pki_products_index1 on pki_products c (cost=0.43..7.45 rows=1 width=223) (actual time=0.035..0.036 rows=1 loops=350,753)

  • Index Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (c.product_asin_alt)::text) AND ((product_seller_daily_price_2016_10.client_nm)::text = (c.client_nm)::text))
  • Buffers: shared hit=1403925 read=6139
83. 7,365.813 7,365.813 ↑ 1.0 1 350,753

Index Scan using pki_sel_index2 on pki_sellers f (cost=0.55..7.58 rows=1 width=78) (actual time=0.02..0.021 rows=1 loops=350,753)

  • Index Cond: (((product_seller_daily_price_2016_10.seller_id)::text = (f.seller_id_alt)::text) AND ((product_seller_daily_price_2016_10.seller_nm)::text = (f.seller_nm_alt)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (f.marketplace)::text))
  • Buffers: shared hit=1752372 read=2630