explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pgvw

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=288,856,030.23..296,315,082.72 rows=988 width=1,071) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=288,856,029.80..296,307,627.96 rows=988 width=300) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=288,856,029.24..296,300,123.36 rows=988 width=235) (actual rows= loops=)

  • Hash Cond: (((a.client_typ)::text = (e.client_typ)::text) AND ((a.client_nm)::text = (e.client_nm)::text) AND ((a.marketplace)::text = (e.marketplace)::text))
4. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=288,855,759.21..296,299,834.80 rows=988 width=213) (actual rows= loops=)

  • Merge Cond: (((a.marketplace)::text = (d.marketplace)::text) AND ((a.seller_id)::text = (d.merchant_id)::text))
  • Join Filter: ((a.as_of_date = d.as_of_date) AND ((a.product_asin)::text = (d.product_asin)::text))
5. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=2,255,510.83..2,259,904.77 rows=988 width=177) (actual rows= loops=)

  • Merge Cond: (((a.marketplace)::text = (f.marketplace)::text) AND ((a.seller_id)::text = (f.seller_id_alt)::text) AND ((a.seller_nm)::text = (f.seller_nm_alt)::text))
6. 0.000 0.000 ↓ 0.0

Sort (cost=2,194,829.45..2,194,831.92 rows=988 width=109) (actual rows= loops=)

  • Sort Key: a.marketplace, a.seller_id, a.seller_nm
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.60..2,194,780.31 rows=988 width=109) (actual rows= loops=)

  • Hash Cond: ((a.client_nm)::text = (g.client_nm)::text)
8. 0.000 0.000 ↓ 0.0

Append (cost=0.29..2,188,091.38 rows=2,540,809 width=94) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2016_10_indx1 on product_seller_daily_price_2016_10 a (cost=0.29..6.06 rows=1 width=81) (actual rows= loops=)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text))
10. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2016_11_indx1 on product_seller_daily_price_2016_11 a_1 (cost=0.29..6.06 rows=1 width=81) (actual rows= loops=)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text))
11. 0.000 0.000 ↓ 0.0

Seq Scan on product_seller_daily_price_2016_12 a_2 (cost=0.00..4.60 rows=1 width=81) (actual rows= loops=)

  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND (as_of_date >= date((now() - '3 days'::interval))))
12. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_1_indx1 on product_seller_daily_price_2017_1 a_3 (cost=0.29..6.07 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text))
13. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_2_indx1 on product_seller_daily_price_2017_2 a_4 (cost=0.43..8.45 rows=1 width=87) (actual rows= loops=)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text))
14. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_3_indx1 on product_seller_daily_price_2017_3 a_5 (cost=0.43..6.20 rows=1 width=87) (actual rows= loops=)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text))
15. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_4_indx1 on product_seller_daily_price_2017_4 a_6 (cost=0.43..8.45 rows=1 width=87) (actual rows= loops=)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text))
16. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_5_indx1 on product_seller_daily_price_2017_5 a_7 (cost=0.43..6.21 rows=1 width=87) (actual rows= loops=)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text))
17. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_6_idx on product_seller_daily_price_2017_6 a_8 (cost=0.43..10.64 rows=1 width=86) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
18. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_7_idx on product_seller_daily_price_2017_7 a_9 (cost=0.43..10.64 rows=1 width=86) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
19. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_8_idx on product_seller_daily_price_2017_8 a_10 (cost=0.44..10.65 rows=1 width=86) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
20. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_9_idx on product_seller_daily_price_2017_9 a_11 (cost=0.44..10.65 rows=1 width=85) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
21. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_10_idx on product_seller_daily_price_2017_10 a_12 (cost=0.44..10.65 rows=1 width=85) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
22. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_11_idx on product_seller_daily_price_2017_11 a_13 (cost=0.44..10.66 rows=1 width=87) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
23. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2017_12_idx on product_seller_daily_price_2017_12 a_14 (cost=0.45..10.66 rows=1 width=88) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
24. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_1_idx on product_seller_daily_price_2018_1 a_15 (cost=0.44..10.66 rows=1 width=86) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
25. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_2_idx on product_seller_daily_price_2018_2 a_16 (cost=0.44..10.66 rows=1 width=88) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
26. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_3_idx on product_seller_daily_price_2018_3 a_17 (cost=0.44..10.66 rows=1 width=88) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
27. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_4_idx on product_seller_daily_price_2018_4 a_18 (cost=0.44..10.66 rows=1 width=87) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
28. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_5_idx on product_seller_daily_price_2018_5 a_19 (cost=0.44..10.66 rows=1 width=89) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
29. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_6_idx on product_seller_daily_price_2018_6 a_20 (cost=0.45..10.66 rows=1 width=90) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
30. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_7_idx on product_seller_daily_price_2018_7 a_21 (cost=0.45..10.66 rows=1 width=89) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
31. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_8_idx on product_seller_daily_price_2018_8 a_22 (cost=0.45..10.66 rows=1 width=89) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
32. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_9_idx on product_seller_daily_price_2018_9 a_23 (cost=0.45..10.66 rows=1 width=91) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
33. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_10_idx on product_seller_daily_price_2018_10 a_24 (cost=0.45..10.66 rows=1 width=89) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
34. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_11_idx on product_seller_daily_price_2018_11 a_25 (cost=0.45..10.66 rows=1 width=90) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
35. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2018_12_idx on product_seller_daily_price_2018_12 a_26 (cost=0.57..10.91 rows=1 width=90) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
36. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2019_1_idx on product_seller_daily_price_2019_1 a_27 (cost=0.57..10.91 rows=1 width=90) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
37. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2019_2_idx on product_seller_daily_price_2019_2 a_28 (cost=0.57..10.92 rows=1 width=91) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
38. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2019_3_idx on product_seller_daily_price_2019_3 a_29 (cost=0.57..10.92 rows=1 width=91) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
39. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2019_4_idx on product_seller_daily_price_2019_4 a_30 (cost=0.57..10.92 rows=1 width=90) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
40. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2019_5_idx on product_seller_daily_price_2019_5 a_31 (cost=0.57..10.92 rows=1 width=91) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
41. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2019_6_idx on product_seller_daily_price_2019_6 a_32 (cost=0.57..10.92 rows=1 width=92) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
42. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2019_7_idx on product_seller_daily_price_2019_7 a_33 (cost=0.57..10.92 rows=1 width=94) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
43. 0.000 0.000 ↓ 0.0

Index Scan using product_seller_daily_price_2019_8_idx on product_seller_daily_price_2019_8 a_34 (cost=0.57..10.92 rows=1 width=94) (actual rows= loops=)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((client_typ)::text = 'C'::text)
44. 0.000 0.000 ↓ 0.0

Seq Scan on product_seller_daily_price_2019_9 a_35 (cost=0.00..2,187,737.40 rows=2,540,772 width=94) (actual rows= loops=)

  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND (as_of_date >= date((now() - '3 days'::interval))))
45. 0.000 0.000 ↓ 0.0

Seq Scan on product_seller_daily_price_2019_10 a_36 (cost=0.00..1.00 rows=1 width=1,024) (actual rows= loops=)

  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND (as_of_date >= date((now() - '3 days'::interval))))
46. 0.000 0.000 ↓ 0.0

Seq Scan on product_seller_daily_price_2019_11 a_37 (cost=0.00..10.75 rows=1 width=1,024) (actual rows= loops=)

  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND (as_of_date >= date((now() - '3 days'::interval))))
47. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=29) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Index Scan using dashboard_list_1_idx on dashboard_list g (cost=0.28..8.30 rows=1 width=29) (actual rows= loops=)

  • Index Cond: ((dashboard_nm)::text = '3M'::text)
  • Filter: (((client_typ)::text = 'C'::text) AND ((dashboard_status)::text = 'Active'::text))
49. 0.000 0.000 ↓ 0.0

Materialize (cost=60,681.38..62,435.00 rows=350,724 width=78) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Sort (cost=60,681.38..61,558.19 rows=350,724 width=78) (actual rows= loops=)

  • Sort Key: f.marketplace, f.seller_id_alt, f.seller_nm_alt
51. 0.000 0.000 ↓ 0.0

Seq Scan on pki_sellers f (cost=0.00..12,794.24 rows=350,724 width=78) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Materialize (cost=286,600,248.38..290,187,190.53 rows=717,388,430 width=89) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Sort (cost=286,600,248.38..288,393,719.46 rows=717,388,430 width=89) (actual rows= loops=)

  • Sort Key: d.marketplace, d.merchant_id
54. 0.000 0.000 ↓ 0.0

Append (cost=0.00..33,958,261.30 rows=717,388,430 width=89) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_8 d (cost=0.00..3,715,576.36 rows=74,807,136 width=88) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_7 d_1 (cost=0.00..3,479,636.96 rows=70,812,696 width=88) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2017_4 d_2 (cost=0.00..41,926.56 rows=1,314,556 width=93) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2017_5 d_3 (cost=0.00..65,320.30 rows=2,045,830 width=93) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2017_6 d_4 (cost=0.00..69,004.95 rows=2,150,395 width=94) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2017_7 d_5 (cost=0.00..76,419.55 rows=2,375,155 width=94) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2017_8 d_6 (cost=0.00..100,103.98 rows=3,106,298 width=95) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2017_9 d_7 (cost=0.00..110,236.92 rows=3,428,192 width=93) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2017_10 d_8 (cost=0.00..135,611.27 rows=4,223,627 width=93) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2017_11 d_9 (cost=0.00..230,493.31 rows=7,159,731 width=93) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2017_12 d_10 (cost=0.00..318,274.00 rows=9,855,500 width=94) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_1 d_11 (cost=0.00..296,093.27 rows=9,212,527 width=93) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_2 d_12 (cost=0.00..258,663.25 rows=8,058,025 width=92) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_3 d_13 (cost=0.00..345,436.72 rows=10,778,372 width=93) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_4 d_14 (cost=0.00..378,539.49 rows=11,806,649 width=92) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_5 d_15 (cost=0.00..483,438.61 rows=14,246,561 width=93) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_6 d_16 (cost=0.00..786,736.88 rows=15,890,688 width=94) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_7 d_17 (cost=0.00..880,322.32 rows=17,624,532 width=93) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_8 d_18 (cost=0.00..1,017,244.56 rows=20,527,256 width=91) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_9 d_19 (cost=0.00..986,390.06 rows=19,986,706 width=90) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_10 d_20 (cost=0.00..1,078,787.72 rows=21,341,072 width=89) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_11 d_21 (cost=0.00..1,056,220.08 rows=21,559,108 width=87) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2018_12 d_22 (cost=0.00..1,106,377.36 rows=22,646,136 width=88) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_1 d_23 (cost=0.00..1,508,640.20 rows=30,852,920 width=88) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_2 d_24 (cost=0.00..1,731,153.12 rows=35,549,412 width=88) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_3 d_25 (cost=0.00..1,910,168.88 rows=39,000,888 width=89) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_4 d_26 (cost=0.00..2,801,446.00 rows=57,276,200 width=88) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_5 d_27 (cost=0.00..2,834,054.92 rows=57,906,492 width=88) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_6 d_28 (cost=0.00..3,047,632.04 rows=62,139,904 width=88) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_9 d_29 (cost=0.00..3,108,301.36 rows=59,705,836 width=87) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Seq Scan on fba_product_daily_run_2019_10 d_30 (cost=0.00..10.30 rows=30 width=1,284) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Hash (cost=258.07..258.07 rows=683 width=50) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Seq Scan on product_urls e (cost=0.00..258.07 rows=683 width=50) (actual rows= loops=)

  • Filter: ((client_typ)::text = 'C'::text)
88. 0.000 0.000 ↓ 0.0

Index Scan using pki_psm_index1 on pki_product_seller_map b (cost=0.56..7.59 rows=1 width=105) (actual rows= loops=)

  • Index Cond: (((a.product_asin)::text = (product_asin_alt)::text) AND ((a.seller_nm)::text = (seller_nm_alt)::text) AND ((a.client_nm)::text = (client_nm)::text))
89. 0.000 0.000 ↓ 0.0

Index Scan using pki_products_index1 on pki_products c (cost=0.43..7.45 rows=1 width=223) (actual rows= loops=)

  • Index Cond: (((a.product_asin)::text = (product_asin_alt)::text) AND ((a.client_nm)::text = (client_nm)::text))