explain.depesz.com

PostgreSQL's explain analyze made readable

Result: soNN

Settings
# exclusive inclusive rows x rows loops node
1. 52,754.329 8,065,875.577 ↓ 1.6 9,709,529 1

Hash Left Join (cost=241,969,607.08..284,928,280.98 rows=5,983,516 width=1,069) (actual time=7,067,251.883..8,065,875.577 rows=9,709,529 loops=1)

  • Hash Cond: (((product_seller_daily_price_2016_10.client_typ)::text = (e.client_typ)::text) AND ((product_seller_daily_price_2016_10.client_nm)::text = (e.client_nm)::text) AND ((product_seller_daily_price_2016_10.marketplace)::text = (e.marketplace)::text))
2. 96,573.402 8,013,100.301 ↓ 1.6 9,709,529 1

Merge Right Join (cost=241,969,335.72..284,271,277.06 rows=5,983,516 width=459) (actual time=7,067,230.820..8,013,100.301 rows=9,709,529 loops=1)

  • Merge Cond: (((fba_product_daily_run_2019_8.product_asin)::text = (product_seller_daily_price_2016_10.product_asin)::text) AND (fba_product_daily_run_2019_8.as_of_date = product_seller_daily_price_2016_10.as_of_date) AND ((fba_product_daily_run_2019_8.merchant_id)::text = (product_seller_daily_price_2016_10.seller_id)::text) AND ((fba_product_daily_run_2019_8.marketplace)::text = (product_seller_daily_price_2016_10.marketplace)::text))
3. 168,631.644 7,031,310.254 ↑ 1.0 755,851,490 1

Merge Append (cost=214,327,847.63..248,977,187.65 rows=756,110,311 width=89) (actual time=6,194,697.927..7,031,310.254 rows=755,851,490 loops=1)

  • Sort Key: fba_product_daily_run_2019_8.product_asin, fba_product_daily_run_2019_8.as_of_date, fba_product_daily_run_2019_8.merchant_id, fba_product_daily_run_2019_8.marketplace
4. 663,706.442 759,814.225 ↑ 1.0 74,761,276 1

Sort (cost=24,232,664.73..24,419,636.59 rows=74,788,744 width=88) (actual time=699,950.170..759,814.225 rows=74,761,276 loops=1)

  • Sort Key: fba_product_daily_run_2019_8.product_asin, fba_product_daily_run_2019_8.as_of_date, fba_product_daily_run_2019_8.merchant_id, fba_product_daily_run_2019_8.marketplace
  • Sort Method: external merge Disk: 7589648kB
5. 96,107.783 96,107.783 ↓ 1.0 74,807,140 1

Seq Scan on fba_product_daily_run_2019_8 (cost=0.00..3,715,392.44 rows=74,788,744 width=88) (actual time=0.025..96,107.783 rows=74,807,140 loops=1)

6. 519,810.702 606,180.723 ↓ 1.0 70,803,870 1

Sort (cost=22,872,054.05..23,049,032.75 rows=70,791,480 width=88) (actual time=551,395.895..606,180.723 rows=70,803,870 loops=1)

  • Sort Key: fba_product_daily_run_2019_7.product_asin, fba_product_daily_run_2019_7.as_of_date, fba_product_daily_run_2019_7.merchant_id, fba_product_daily_run_2019_7.marketplace
  • Sort Method: external merge Disk: 7197112kB
7. 86,370.021 86,370.021 ↓ 1.0 70,812,699 1

Seq Scan on fba_product_daily_run_2019_7 (cost=0.00..3,479,424.80 rows=70,791,480 width=88) (actual time=3.266..86,370.021 rows=70,812,699 loops=1)

8. 19,952.648 19,952.648 ↑ 1.0 1,314,462 1

Index Scan using fba_product_daily_run_2017_4_idx on fba_product_daily_run_2017_4 (cost=0.55..4,680,637.68 rows=1,314,556 width=92) (actual time=8.513..19,952.648 rows=1,314,462 loops=1)

9. 29,673.561 29,673.561 ↑ 1.0 2,045,777 1

Index Scan using fba_product_daily_run_2017_5_idx on fba_product_daily_run_2017_5 (cost=0.55..7,293,795.14 rows=2,045,852 width=93) (actual time=7.053..29,673.561 rows=2,045,777 loops=1)

10. 10,919.367 12,343.122 ↑ 1.0 2,150,395 1

Sort (cost=515,743.19..521,119.79 rows=2,150,639 width=94) (actual time=9,314.750..12,343.122 rows=2,150,395 loops=1)

  • Sort Key: fba_product_daily_run_2017_6.product_asin, fba_product_daily_run_2017_6.as_of_date, fba_product_daily_run_2017_6.merchant_id, fba_product_daily_run_2017_6.marketplace
  • Sort Method: external merge Disk: 226952kB
11. 1,423.755 1,423.755 ↑ 1.0 2,150,395 1

Seq Scan on fba_product_daily_run_2017_6 (cost=0.00..69,007.39 rows=2,150,639 width=94) (actual time=1.731..1,423.755 rows=2,150,395 loops=1)

12. 11,525.244 12,713.112 ↓ 1.0 2,375,154 1

Sort (cost=571,371.75..577,308.28 rows=2,374,612 width=94) (actual time=9,817.709..12,713.112 rows=2,375,154 loops=1)

  • Sort Key: fba_product_daily_run_2017_7.product_asin, fba_product_daily_run_2017_7.as_of_date, fba_product_daily_run_2017_7.merchant_id, fba_product_daily_run_2017_7.marketplace
  • Sort Method: external merge Disk: 252328kB
13. 1,187.868 1,187.868 ↓ 1.0 2,375,155 1

Seq Scan on fba_product_daily_run_2017_7 (cost=0.00..76,414.12 rows=2,374,612 width=94) (actual time=1.103..1,187.868 rows=2,375,155 loops=1)

14. 21,363.844 23,202.340 ↑ 1.0 3,106,282 1

Sort (cost=753,804.27..761,572.36 rows=3,107,236 width=95) (actual time=18,753.581..23,202.340 rows=3,106,282 loops=1)

  • Sort Key: fba_product_daily_run_2017_8.product_asin, fba_product_daily_run_2017_8.as_of_date, fba_product_daily_run_2017_8.merchant_id, fba_product_daily_run_2017_8.marketplace
  • Sort Method: external merge Disk: 331440kB
15. 1,838.496 1,838.496 ↑ 1.0 3,106,298 1

Seq Scan on fba_product_daily_run_2017_8 (cost=0.00..100,113.36 rows=3,107,236 width=95) (actual time=0.911..1,838.496 rows=3,106,298 loops=1)

16. 30,591.348 32,806.536 ↑ 1.0 3,428,044 1

Sort (cost=834,028.05..842,600.15 rows=3,428,842 width=94) (actual time=28,598.543..32,806.536 rows=3,428,044 loops=1)

  • Sort Key: fba_product_daily_run_2017_9.product_asin, fba_product_daily_run_2017_9.as_of_date, fba_product_daily_run_2017_9.merchant_id, fba_product_daily_run_2017_9.marketplace
  • Sort Method: external merge Disk: 363944kB
17. 2,215.188 2,215.188 ↑ 1.0 3,428,192 1

Seq Scan on fba_product_daily_run_2017_9 (cost=0.00..110,243.42 rows=3,428,842 width=94) (actual time=2.537..2,215.188 rows=3,428,192 loops=1)

18. 30,644.518 32,983.449 ↑ 1.0 4,223,468 1

Sort (cost=1,033,531.21..1,044,090.50 rows=4,223,719 width=94) (actual time=27,990.126..32,983.449 rows=4,223,468 loops=1)

  • Sort Key: fba_product_daily_run_2017_10.product_asin, fba_product_daily_run_2017_10.as_of_date, fba_product_daily_run_2017_10.merchant_id, fba_product_daily_run_2017_10.marketplace
  • Sort Method: external merge Disk: 446752kB
19. 2,338.931 2,338.931 ↑ 1.0 4,223,627 1

Seq Scan on fba_product_daily_run_2017_10 (cost=0.00..135,612.19 rows=4,223,719 width=94) (actual time=3.627..2,338.931 rows=4,223,627 loops=1)

20. 53,826.041 58,027.675 ↓ 1.0 7,159,616 1

Sort (cost=1,779,716.90..1,797,614.92 rows=7,159,208 width=93) (actual time=50,872.117..58,027.675 rows=7,159,616 loops=1)

  • Sort Key: fba_product_daily_run_2017_11.product_asin, fba_product_daily_run_2017_11.as_of_date, fba_product_daily_run_2017_11.merchant_id, fba_product_daily_run_2017_11.marketplace
  • Sort Method: external merge Disk: 762424kB
21. 4,201.634 4,201.634 ↓ 1.0 7,159,731 1

Seq Scan on fba_product_daily_run_2017_11 (cost=0.00..230,488.08 rows=7,159,208 width=93) (actual time=2.784..4,201.634 rows=7,159,731 loops=1)

22. 78,823.873 85,085.326 ↑ 1.0 9,855,381 1

Sort (cost=2,475,153.21..2,499,807.46 rows=9,861,699 width=94) (actual time=76,172.587..85,085.326 rows=9,855,381 loops=1)

  • Sort Key: fba_product_daily_run_2017_12.product_asin, fba_product_daily_run_2017_12.as_of_date, fba_product_daily_run_2017_12.merchant_id, fba_product_daily_run_2017_12.marketplace
  • Sort Method: external merge Disk: 1049264kB
23. 6,261.453 6,261.453 ↑ 1.0 9,855,500 1

Seq Scan on fba_product_daily_run_2017_12 (cost=0.00..318,335.99 rows=9,861,699 width=94) (actual time=1.638..6,261.453 rows=9,855,500 loops=1)

24. 69,439.857 75,247.447 ↑ 1.0 9,212,472 1

Sort (cost=2,306,428.78..2,329,460.32 rows=9,212,616 width=93) (actual time=67,281.602..75,247.447 rows=9,212,472 loops=1)

  • Sort Key: fba_product_daily_run_2018_1.product_asin, fba_product_daily_run_2018_1.as_of_date, fba_product_daily_run_2018_1.merchant_id, fba_product_daily_run_2018_1.marketplace
  • Sort Method: external merge Disk: 978344kB
25. 5,807.590 5,807.590 ↑ 1.0 9,212,527 1

Seq Scan on fba_product_daily_run_2018_1 (cost=0.00..296,094.16 rows=9,212,616 width=93) (actual time=0.958..5,807.590 rows=9,212,527 loops=1)

26. 64,120.898 69,777.469 ↑ 1.0 8,057,932 1

Sort (cost=2,009,685.08..2,029,834.65 rows=8,059,829 width=92) (actual time=62,595.149..69,777.469 rows=8,057,932 loops=1)

  • Sort Key: fba_product_daily_run_2018_2.product_asin, fba_product_daily_run_2018_2.as_of_date, fba_product_daily_run_2018_2.merchant_id, fba_product_daily_run_2018_2.marketplace
  • Sort Method: external merge Disk: 852800kB
27. 5,656.571 5,656.571 ↑ 1.0 8,058,025 1

Seq Scan on fba_product_daily_run_2018_2 (cost=0.00..258,681.29 rows=8,059,829 width=92) (actual time=2.062..5,656.571 rows=8,058,025 loops=1)

28. 79,629.038 87,133.682 ↓ 1.0 10,778,267 1

Sort (cost=2,709,491.69..2,736,436.02 rows=10,777,730 width=93) (actual time=78,325.996..87,133.682 rows=10,778,267 loops=1)

  • Sort Key: fba_product_daily_run_2018_3.product_asin, fba_product_daily_run_2018_3.as_of_date, fba_product_daily_run_2018_3.merchant_id, fba_product_daily_run_2018_3.marketplace
  • Sort Method: external merge Disk: 1136408kB
29. 7,504.644 7,504.644 ↓ 1.0 10,778,372 1

Seq Scan on fba_product_daily_run_2018_3 (cost=0.00..345,430.30 rows=10,777,730 width=93) (actual time=2.912..7,504.644 rows=10,778,372 loops=1)

30. 86,835.923 93,667.058 ↓ 1.0 11,806,563 1

Sort (cost=2,975,885.86..3,005,400.62 rows=11,805,904 width=92) (actual time=84,036.415..93,667.058 rows=11,806,563 loops=1)

  • Sort Key: fba_product_daily_run_2018_4.product_asin, fba_product_daily_run_2018_4.as_of_date, fba_product_daily_run_2018_4.merchant_id, fba_product_daily_run_2018_4.marketplace
  • Sort Method: external merge Disk: 1245904kB
31. 6,831.135 6,831.135 ↓ 1.0 11,806,649 1

Seq Scan on fba_product_daily_run_2018_4 (cost=0.00..378,532.04 rows=11,805,904 width=92) (actual time=2.712..6,831.135 rows=11,806,649 loops=1)

32. 135,790.006 145,518.766 ↑ 1.0 14,246,432 1

Sort (cost=3,639,314.80..3,674,954.89 rows=14,256,036 width=93) (actual time=132,847.333..145,518.766 rows=14,246,432 loops=1)

  • Sort Key: fba_product_daily_run_2018_5.product_asin, fba_product_daily_run_2018_5.as_of_date, fba_product_daily_run_2018_5.merchant_id, fba_product_daily_run_2018_5.marketplace
  • Sort Method: external merge Disk: 1508712kB
33. 9,728.760 9,728.760 ↑ 1.0 14,246,561 1

Seq Scan on fba_product_daily_run_2018_5 (cost=0.00..483,533.36 rows=14,256,036 width=93) (actual time=1.765..9,728.760 rows=14,246,561 loops=1)

34. 166,648.891 179,992.511 ↑ 1.0 15,890,443 1

Sort (cost=4,320,470.33..4,360,235.19 rows=15,905,947 width=93) (actual time=166,073.273..179,992.511 rows=15,890,443 loops=1)

  • Sort Key: fba_product_daily_run_2018_6.product_asin, fba_product_daily_run_2018_6.as_of_date, fba_product_daily_run_2018_6.merchant_id, fba_product_daily_run_2018_6.marketplace
  • Sort Method: external merge Disk: 1679672kB
35. 13,343.620 13,343.620 ↑ 1.0 15,890,688 1

Seq Scan on fba_product_daily_run_2018_6 (cost=0.00..786,889.47 rows=15,905,947 width=93) (actual time=2.747..13,343.620 rows=15,890,688 loops=1)

36. 182,308.922 199,932.024 ↓ 1.0 17,624,302 1

Sort (cost=4,806,252.42..4,850,287.86 rows=17,614,176 width=93) (actual time=184,709.471..199,932.024 rows=17,624,302 loops=1)

  • Sort Key: fba_product_daily_run_2018_7.product_asin, fba_product_daily_run_2018_7.as_of_date, fba_product_daily_run_2018_7.merchant_id, fba_product_daily_run_2018_7.marketplace
  • Sort Method: external merge Disk: 1850440kB
37. 17,623.102 17,623.102 ↓ 1.0 17,624,531 1

Seq Scan on fba_product_daily_run_2018_7 (cost=0.00..880,218.76 rows=17,614,176 width=93) (actual time=2.719..17,623.102 rows=17,624,531 loops=1)

38. 222,040.602 249,839.466 ↓ 1.0 20,527,168 1

Sort (cost=5,614,001.75..5,665,307.08 rows=20,522,132 width=90) (actual time=233,730.410..249,839.466 rows=20,527,168 loops=1)

  • Sort Key: fba_product_daily_run_2018_8.product_asin, fba_product_daily_run_2018_8.as_of_date, fba_product_daily_run_2018_8.merchant_id, fba_product_daily_run_2018_8.marketplace
  • Sort Method: external merge Disk: 2125056kB
39. 27,798.864 27,798.864 ↓ 1.0 20,527,256 1

Seq Scan on fba_product_daily_run_2018_8 (cost=0.00..1,017,193.32 rows=20,522,132 width=90) (actual time=1.786..27,798.864 rows=20,527,256 loops=1)

40. 200,082.012 222,582.990 ↑ 1.0 19,986,706 1

Sort (cost=5,461,275.56..5,511,261.26 rows=19,994,280 width=89) (actual time=206,640.488..222,582.990 rows=19,986,706 loops=1)

  • Sort Key: fba_product_daily_run_2018_9.product_asin, fba_product_daily_run_2018_9.as_of_date, fba_product_daily_run_2018_9.merchant_id, fba_product_daily_run_2018_9.marketplace
  • Sort Method: external merge Disk: 2043264kB
41. 22,500.978 22,500.978 ↑ 1.0 19,986,706 1

Seq Scan on fba_product_daily_run_2018_9 (cost=0.00..986,465.80 rows=19,994,280 width=89) (actual time=1.481..22,500.978 rows=19,986,706 loops=1)

42. 175,483.261 192,333.988 ↓ 1.0 21,341,071 1

Sort (cost=5,864,166.70..5,917,510.20 rows=21,337,400 width=89) (actual time=175,646.435..192,333.988 rows=21,341,071 loops=1)

  • Sort Key: fba_product_daily_run_2018_10.product_asin, fba_product_daily_run_2018_10.as_of_date, fba_product_daily_run_2018_10.merchant_id, fba_product_daily_run_2018_10.marketplace
  • Sort Method: external merge Disk: 2175376kB
43. 16,850.727 16,850.727 ↓ 1.0 21,341,071 1

Seq Scan on fba_product_daily_run_2018_10 (cost=0.00..1,078,751.00 rows=21,337,400 width=89) (actual time=3.295..16,850.727 rows=21,341,071 loops=1)

44. 204,649.183 230,870.352 ↓ 1.0 21,559,109 1

Sort (cost=5,743,017.73..5,796,888.11 rows=21,548,152 width=87) (actual time=214,222.457..230,870.352 rows=21,559,109 loops=1)

  • Sort Key: fba_product_daily_run_2018_11.product_asin, fba_product_daily_run_2018_11.as_of_date, fba_product_daily_run_2018_11.merchant_id, fba_product_daily_run_2018_11.marketplace
  • Sort Method: external merge Disk: 2142616kB
45. 26,221.169 26,221.169 ↓ 1.0 21,559,109 1

Seq Scan on fba_product_daily_run_2018_11 (cost=0.00..1,056,110.52 rows=21,548,152 width=87) (actual time=1.094..26,221.169 rows=21,559,109 loops=1)

46. 237,012.256 256,214.173 ↓ 1.0 22,646,111 1

Sort (cost=6,039,680.21..6,096,289.75 rows=22,643,816 width=88) (actual time=237,985.452..256,214.173 rows=22,646,111 loops=1)

  • Sort Key: fba_product_daily_run_2018_12.product_asin, fba_product_daily_run_2018_12.as_of_date, fba_product_daily_run_2018_12.merchant_id, fba_product_daily_run_2018_12.marketplace
  • Sort Method: external merge Disk: 2264928kB
47. 19,201.917 19,201.917 ↓ 1.0 22,646,136 1

Seq Scan on fba_product_daily_run_2018_12 (cost=0.00..1,106,354.16 rows=22,643,816 width=88) (actual time=3.856..19,201.917 rows=22,646,136 loops=1)

48. 255,077.865 277,904.526 ↓ 1.0 30,852,856 1

Sort (cost=8,297,117.24..8,374,226.57 rows=30,843,732 width=88) (actual time=253,801.542..277,904.526 rows=30,852,856 loops=1)

  • Sort Key: fba_product_daily_run_2019_1.product_asin, fba_product_daily_run_2019_1.as_of_date, fba_product_daily_run_2019_1.merchant_id, fba_product_daily_run_2019_1.marketplace
  • Sort Method: external merge Disk: 3088088kB
49. 22,826.661 22,826.661 ↓ 1.0 30,852,919 1

Seq Scan on fba_product_daily_run_2019_1 (cost=0.00..1,508,548.32 rows=30,843,732 width=88) (actual time=3.293..22,826.661 rows=30,852,919 loops=1)

50. 261,454.936 286,330.779 ↑ 1.0 35,549,412 1

Sort (cost=9,598,378.76..9,687,320.96 rows=35,576,880 width=88) (actual time=258,856.110..286,330.779 rows=35,549,412 loops=1)

  • Sort Key: fba_product_daily_run_2019_2.product_asin, fba_product_daily_run_2019_2.as_of_date, fba_product_daily_run_2019_2.merchant_id, fba_product_daily_run_2019_2.marketplace
  • Sort Method: external merge Disk: 3576280kB
51. 24,875.843 24,875.843 ↑ 1.0 35,549,412 1

Seq Scan on fba_product_daily_run_2019_2 (cost=0.00..1,731,427.80 rows=35,576,880 width=88) (actual time=0.910..24,875.843 rows=35,549,412 loops=1)

52. 297,582.171 321,193.775 ↓ 1.0 39,000,862 1

Sort (cost=10,823,347.38..10,920,815.35 rows=38,987,188 width=89) (actual time=290,599.562..321,193.775 rows=39,000,862 loops=1)

  • Sort Key: fba_product_daily_run_2019_3.product_asin, fba_product_daily_run_2019_3.as_of_date, fba_product_daily_run_2019_3.merchant_id, fba_product_daily_run_2019_3.marketplace
  • Sort Method: external merge Disk: 3968200kB
53. 23,611.604 23,611.604 ↓ 1.0 39,000,889 1

Seq Scan on fba_product_daily_run_2019_3 (cost=0.00..1,910,031.88 rows=38,987,188 width=89) (actual time=1.896..23,611.604 rows=39,000,889 loops=1)

54. 392,880.213 463,110.516 ↓ 1.0 57,275,864 1

Sort (cost=15,656,011.06..15,799,125.08 rows=57,245,608 width=88) (actual time=414,716.498..463,110.516 rows=57,275,864 loops=1)

  • Sort Key: fba_product_daily_run_2019_4.product_asin, fba_product_daily_run_2019_4.as_of_date, fba_product_daily_run_2019_4.merchant_id, fba_product_daily_run_2019_4.marketplace
  • Sort Method: external merge Disk: 5797384kB
55. 70,230.303 70,230.303 ↓ 1.0 57,276,198 1

Seq Scan on fba_product_daily_run_2019_4 (cost=0.00..2,801,140.08 rows=57,245,608 width=88) (actual time=1.833..70,230.303 rows=57,276,198 loops=1)

56. 451,002.706 506,187.505 ↑ 1.0 57,905,960 1

Sort (cost=15,846,584.60..15,991,396.86 rows=57,924,904 width=88) (actual time=457,650.175..506,187.505 rows=57,905,960 loops=1)

  • Sort Key: fba_product_daily_run_2019_5.product_asin, fba_product_daily_run_2019_5.as_of_date, fba_product_daily_run_2019_5.merchant_id, fba_product_daily_run_2019_5.marketplace
  • Sort Method: external merge Disk: 5858520kB
57. 55,184.799 55,184.799 ↑ 1.0 57,906,491 1

Seq Scan on fba_product_daily_run_2019_5 (cost=0.00..2,834,239.04 rows=57,924,904 width=88) (actual time=1.917..55,184.799 rows=57,906,491 loops=1)

58. 423,486.970 461,177.279 ↑ 1.0 62,136,925 1

Sort (cost=17,041,899.96..17,197,286.64 rows=62,154,672 width=88) (actual time=409,543.508..461,177.279 rows=62,136,925 loops=1)

  • Sort Key: fba_product_daily_run_2019_6.product_asin, fba_product_daily_run_2019_6.as_of_date, fba_product_daily_run_2019_6.merchant_id, fba_product_daily_run_2019_6.marketplace
  • Sort Method: external merge Disk: 6304776kB
59. 37,690.309 37,690.309 ↑ 1.0 62,139,903 1

Seq Scan on fba_product_daily_run_2019_6 (cost=0.00..3,047,779.72 rows=62,154,672 width=88) (actual time=1.003..37,690.309 rows=62,139,903 loops=1)

60. 549,799.377 609,474.933 ↑ 1.0 71,561,167 1

Sort (cost=23,343,519.09..23,522,827.61 rows=71,723,408 width=87) (actual time=555,767.329..609,474.933 rows=71,561,167 loops=1)

  • Sort Key: fba_product_daily_run_2019_9.product_asin, fba_product_daily_run_2019_9.as_of_date, fba_product_daily_run_2019_9.merchant_id, fba_product_daily_run_2019_9.marketplace
  • Sort Method: external merge Disk: 7264176kB
61. 59,675.556 59,675.556 ↑ 1.0 71,680,741 1

Seq Scan on fba_product_daily_run_2019_9 (cost=0.00..3,688,833.08 rows=71,723,408 width=87) (actual time=1.013..59,675.556 rows=71,680,741 loops=1)

62. 237,430.772 261,406.633 ↑ 1.0 26,668,168 1

Sort (cost=7,163,238.34..7,230,061.55 rows=26,729,284 width=87) (actual time=236,787.577..261,406.633 rows=26,668,168 loops=1)

  • Sort Key: fba_product_daily_run_2019_10.product_asin, fba_product_daily_run_2019_10.as_of_date, fba_product_daily_run_2019_10.merchant_id, fba_product_daily_run_2019_10.marketplace
  • Sort Method: external merge Disk: 2704288kB
63. 23,975.861 23,975.861 ↓ 1.0 26,745,551 1

Seq Scan on fba_product_daily_run_2019_10 (cost=0.00..1,307,844.84 rows=26,729,284 width=87) (actual time=2.320..23,975.861 rows=26,745,551 loops=1)

64. 0.017 0.021 ↓ 0.0 0 1

Sort (cost=11.04..11.11 rows=30 width=1,284) (actual time=0.021..0.021 rows=0 loops=1)

  • Sort Key: fba_product_daily_run_2019_11.product_asin, fba_product_daily_run_2019_11.as_of_date, fba_product_daily_run_2019_11.merchant_id, fba_product_daily_run_2019_11.marketplace
  • Sort Method: quicksort Memory: 25kB
65. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on fba_product_daily_run_2019_11 (cost=0.00..10.30 rows=30 width=1,284) (actual time=0.004..0.004 rows=0 loops=1)

66. 1,376.851 885,216.645 ↓ 1.6 9,709,529 1

Materialize (cost=27,641,488.09..27,671,405.67 rows=5,983,516 width=434) (actual time=869,851.755..885,216.645 rows=9,709,529 loops=1)

67. 121,593.947 883,839.794 ↓ 1.6 9,641,049 1

Sort (cost=27,641,488.09..27,656,446.88 rows=5,983,516 width=434) (actual time=869,851.747..883,839.794 rows=9,641,049 loops=1)

  • Sort Key: product_seller_daily_price_2016_10.product_asin, product_seller_daily_price_2016_10.as_of_date, product_seller_daily_price_2016_10.seller_id, product_seller_daily_price_2016_10.marketplace
  • Sort Method: external merge Disk: 3568144kB
68. 0.000 762,245.847 ↓ 1.6 9,641,049 1

Gather Merge (cost=23,742,633.24..24,595,589.71 rows=5,983,516 width=434) (actual time=531,561.843..762,245.847 rows=9,641,049 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
69. 141,562.908 1,829,893.914 ↓ 1.3 3,213,683 3

Merge Left Join (cost=23,741,633.22..23,903,943.48 rows=2,493,132 width=434) (actual time=531,000.919..609,964.638 rows=3,213,683 loops=3)

  • Merge Cond: (((product_seller_daily_price_2016_10.product_asin)::text = (b.product_asin_alt)::text) AND ((product_seller_daily_price_2016_10.client_nm)::text = (b.client_nm)::text))
  • Join Filter: ((product_seller_daily_price_2016_10.seller_nm)::text = (b.seller_nm_alt)::text)
  • Rows Removed by Join Filter: 141545814
70. 12,077.802 1,366,419.294 ↓ 1.3 3,116,625 3

Merge Left Join (cost=21,302,289.90..21,337,104.25 rows=2,493,132 width=369) (actual time=443,521.435..455,473.098 rows=3,116,625 loops=3)

  • Merge 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))
71. 75,144.087 1,281,036.039 ↓ 1.3 3,116,625 3

Sort (cost=20,728,036.74..20,734,269.57 rows=2,493,132 width=159) (actual time=422,308.511..427,012.013 rows=3,116,625 loops=3)

  • Sort Key: product_seller_daily_price_2016_10.product_asin, product_seller_daily_price_2016_10.client_nm
  • Sort Method: external merge Disk: 442032kB
72. 5,575.101 1,205,891.952 ↓ 1.3 3,116,625 3

Merge Left Join (cost=20,041,840.13..20,071,154.35 rows=2,493,132 width=159) (actual time=397,895.229..401,963.984 rows=3,116,625 loops=3)

  • Merge 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))
73. 44,243.643 1,190,085.156 ↓ 1.3 3,116,625 3

Sort (cost=19,981,158.75..19,987,391.58 rows=2,493,132 width=91) (actual time=394,833.713..396,695.052 rows=3,116,625 loops=3)

  • Sort Key: product_seller_daily_price_2016_10.seller_id, product_seller_daily_price_2016_10.seller_nm, product_seller_daily_price_2016_10.marketplace
  • Sort Method: external merge Disk: 305080kB
74. 63,948.366 1,145,841.513 ↓ 1.3 3,116,625 3

Hash Join (cost=270.18..19,460,622.36 rows=2,493,132 width=91) (actual time=44,049.410..381,947.171 rows=3,116,625 loops=3)

  • Hash Cond: ((product_seller_daily_price_2016_10.client_nm)::text = (product_urls.client_nm)::text)
75. 42,933.474 1,081,852.410 ↑ 1.3 101,594,227 3

Append (cost=0.00..19,098,132.74 rows=127,419,689 width=91) (actual time=1.707..360,617.470 rows=101,594,227 loops=3)

76. 22.092 22.092 ↑ 1.8 519 3

Parallel Seq Scan on product_seller_daily_price_2016_10 (cost=0.00..41.46 rows=916 width=81) (actual time=0.304..7.364 rows=519 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
77. 24.249 24.249 ↑ 1.8 755 3

Parallel Seq Scan on product_seller_daily_price_2016_11 (cost=0.00..59.65 rows=1,332 width=81) (actual time=0.357..8.083 rows=755 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
78. 3.048 3.048 ↑ 1.8 19 3

Parallel Seq Scan on product_seller_daily_price_2016_12 (cost=0.00..2.42 rows=34 width=81) (actual time=0.694..1.016 rows=19 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
79. 57.801 57.801 ↑ 1.8 10,101 3

Parallel Seq Scan on product_seller_daily_price_2017_1 (cost=0.00..809.81 rows=17,825 width=85) (actual time=1.217..19.267 rows=10,101 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
80. 138.408 138.408 ↑ 1.8 48,072 3

Parallel Seq Scan on product_seller_daily_price_2017_2 (cost=0.00..3,901.40 rows=84,832 width=87) (actual time=0.240..46.136 rows=48,072 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
81. 169.314 169.314 ↑ 1.2 70,867 3

Parallel Seq Scan on product_seller_daily_price_2017_3 (cost=0.00..5,479.17 rows=88,420 width=87) (actual time=1.208..56.438 rows=70,867 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 2488
82. 546.306 546.306 ↑ 1.3 129,353 3

Parallel Seq Scan on product_seller_daily_price_2017_4 (cost=0.00..9,985.06 rows=161,930 width=87) (actual time=1.710..182.102 rows=129,353 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 4602
83. 1,453.386 1,453.386 ↑ 1.2 369,398 3

Parallel Seq Scan on product_seller_daily_price_2017_5 (cost=0.00..28,511.39 rows=461,125 width=87) (actual time=5.110..484.462 rows=369,398 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 22563
84. 2,018.943 2,018.943 ↑ 1.2 464,818 3

Parallel Seq Scan on product_seller_daily_price_2017_6 (cost=0.00..38,273.84 rows=580,375 width=86) (actual time=3.279..672.981 rows=464,818 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 69188
85. 2,509.374 2,509.374 ↑ 1.3 514,561 3

Parallel Seq Scan on product_seller_daily_price_2017_7 (cost=0.00..44,016.89 rows=644,091 width=86) (actual time=8.833..836.458 rows=514,561 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 100164
86. 2,737.077 2,737.077 ↑ 1.2 639,552 3

Parallel Seq Scan on product_seller_daily_price_2017_8 (cost=0.00..55,411.20 rows=798,710 width=86) (actual time=10.012..912.359 rows=639,552 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 136452
87. 3,196.224 3,196.224 ↑ 1.2 801,514 3

Parallel Seq Scan on product_seller_daily_price_2017_9 (cost=0.00..64,730.88 rows=1,000,673 width=85) (actual time=2.545..1,065.408 rows=801,514 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 98624
88. 7,712.895 7,712.895 ↑ 1.3 1,269,254 3

Parallel Seq Scan on product_seller_daily_price_2017_10 (cost=0.00..153,236.66 rows=1,595,192 width=85) (actual time=2.024..2,570.965 rows=1,269,254 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 773239
89. 13,298.010 13,298.010 ↑ 1.3 1,512,306 3

Parallel Seq Scan on product_seller_daily_price_2017_11 (cost=0.00..263,442.37 rows=1,913,527 width=87) (actual time=25.038..4,432.670 rows=1,512,306 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 1985176
90. 24,338.241 24,338.241 ↑ 1.2 1,720,316 3

Parallel Seq Scan on product_seller_daily_price_2017_12 (cost=0.00..476,533.73 rows=2,121,305 width=88) (actual time=26.537..8,112.747 rows=1,720,316 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 4616098
91. 12,452.268 12,452.268 ↑ 1.2 1,771,163 3

Parallel Seq Scan on product_seller_daily_price_2018_1 (cost=0.00..250,823.73 rows=2,202,565 width=86) (actual time=26.630..4,150.756 rows=1,771,163 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 1578508
92. 11,974.677 11,974.677 ↑ 1.3 1,781,609 3

Parallel Seq Scan on product_seller_daily_price_2018_2 (cost=0.00..241,748.20 rows=2,230,593 width=88) (actual time=1.891..3,991.559 rows=1,781,609 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 1425205
93. 20,930.625 20,930.625 ↑ 1.3 2,402,699 3

Parallel Seq Scan on product_seller_daily_price_2018_3 (cost=0.00..404,062.00 rows=3,007,368 width=88) (actual time=3.394..6,976.875 rows=2,402,699 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 2477400
94. 16,236.963 16,236.963 ↑ 1.2 2,293,714 3

Parallel Seq Scan on product_seller_daily_price_2018_4 (cost=0.00..327,371.02 rows=2,831,029 width=87) (actual time=1.696..5,412.321 rows=2,293,714 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 1880867
95. 17,795.703 17,795.703 ↑ 1.3 2,223,849 3

Parallel Seq Scan on product_seller_daily_price_2018_5 (cost=0.00..376,604.68 rows=2,803,939 width=89) (actual time=2.869..5,931.901 rows=2,223,849 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 2557838
96. 24,857.190 24,857.190 ↑ 1.3 2,265,593 3

Parallel Seq Scan on product_seller_daily_price_2018_6 (cost=0.00..488,930.45 rows=2,842,697 width=90) (actual time=1.466..8,285.730 rows=2,265,593 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 3924070
97. 24,077.712 24,077.712 ↑ 1.2 2,689,095 3

Parallel Seq Scan on product_seller_daily_price_2018_7 (cost=0.00..489,069.01 rows=3,360,277 width=89) (actual time=2.780..8,025.904 rows=2,689,095 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 3511552
98. 31,190.472 31,190.472 ↑ 1.3 3,195,139 3

Parallel Seq Scan on product_seller_daily_price_2018_8 (cost=0.00..595,966.92 rows=4,102,618 width=89) (actual time=1.549..10,396.824 rows=3,195,139 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 4340341
99. 37,311.702 37,311.702 ↑ 1.2 3,400,159 3

Parallel Seq Scan on product_seller_daily_price_2018_9 (cost=0.00..734,999.35 rows=4,229,771 width=91) (actual time=26.694..12,437.234 rows=3,400,159 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 5797733
100. 36,710.544 36,710.544 ↑ 1.2 3,915,169 3

Parallel Seq Scan on product_seller_daily_price_2018_10 (cost=0.00..712,029.77 rows=4,839,975 width=89) (actual time=2.552..12,236.848 rows=3,915,169 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 5081016
101. 48,245.370 48,245.370 ↑ 1.2 4,165,919 3

Parallel Seq Scan on product_seller_daily_price_2018_11 (cost=0.00..766,372.79 rows=5,169,598 width=90) (actual time=1.945..16,081.790 rows=4,165,919 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 5358349
102. 43,827.825 43,827.825 ↑ 1.3 4,508,144 3

Parallel Seq Scan on product_seller_daily_price_2018_12 (cost=0.00..873,783.42 rows=5,746,368 width=90) (actual time=35.088..14,609.275 rows=4,508,144 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 6493995
103. 40,678.245 40,678.245 ↑ 1.2 4,482,768 3

Parallel Seq Scan on product_seller_daily_price_2019_1 (cost=0.00..814,334.75 rows=5,576,517 width=90) (actual time=2.614..13,559.415 rows=4,482,768 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 5757375
104. 62,864.562 62,864.562 ↑ 1.3 5,757,884 3

Parallel Seq Scan on product_seller_daily_price_2019_2 (cost=0.00..1,000,155.12 rows=7,213,168 width=91) (actual time=1.780..20,954.854 rows=5,757,884 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 6820024
105. 91,725.810 91,725.810 ↑ 1.3 7,409,985 3

Parallel Seq Scan on product_seller_daily_price_2019_3 (cost=0.00..1,283,091.04 rows=9,318,815 width=91) (actual time=0.950..30,575.270 rows=7,409,985 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 8729490
106. 91,848.165 91,848.165 ↑ 1.3 7,470,118 3

Parallel Seq Scan on product_seller_daily_price_2019_4 (cost=0.00..1,378,772.83 rows=9,344,186 width=90) (actual time=1.189..30,616.055 rows=7,470,118 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 9894094
107. 68,398.566 68,398.566 ↑ 1.3 7,386,085 3

Parallel Seq Scan on product_seller_daily_price_2019_5 (cost=0.00..1,326,920.27 rows=9,243,144 width=91) (actual time=3.524..22,799.522 rows=7,386,085 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 9266518
108. 71,745.099 71,745.099 ↑ 1.3 6,828,785 3

Parallel Seq Scan on product_seller_daily_price_2019_6 (cost=0.00..1,396,081.58 rows=8,623,744 width=92) (actual time=25.480..23,915.033 rows=6,828,785 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 10562580
109. 71,768.907 71,768.907 ↑ 1.2 6,591,461 3

Parallel Seq Scan on product_seller_daily_price_2019_7 (cost=0.00..1,403,491.23 rows=8,238,870 width=94) (actual time=1.686..23,922.969 rows=6,591,461 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 10748588
110. 75,557.154 75,557.154 ↑ 1.3 5,895,714 3

Parallel Seq Scan on product_seller_daily_price_2019_8 (cost=0.00..1,404,794.15 rows=7,528,107 width=94) (actual time=2.360..25,185.718 rows=5,895,714 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 11459068
111. 60,152.979 60,152.979 ↑ 1.2 5,566,320 3

Parallel Seq Scan on product_seller_daily_price_2019_9 (cost=0.00..1,268,246.08 rows=6,913,447 width=94) (actual time=4.594..20,050.993 rows=5,566,320 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 9917818
112. 20,341.212 20,341.212 ↑ 1.3 2,041,451 3

Parallel Seq Scan on product_seller_daily_price_2019_10 (cost=0.00..416,047.42 rows=2,582,605 width=92) (actual time=8.934..6,780.404 rows=2,041,451 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 3001866
113. 1.818 1.818 ↓ 0.0 0 3

Parallel Seq Scan on product_seller_daily_price_2019_11 (cost=0.00..1.01 rows=1 width=85) (actual time=0.605..0.606 rows=0 loops=3)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 0
114. 0.033 40.737 ↓ 1.1 8 3

Hash (cost=270.09..270.09 rows=7 width=13) (actual time=13.579..13.579 rows=8 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
115. 0.063 40.704 ↓ 1.1 8 3

HashAggregate (cost=270.02..270.09 rows=7 width=13) (actual time=13.566..13.568 rows=8 loops=3)

  • Group Key: (product_urls.client_nm)::text
116. 40.641 40.641 ↓ 1.3 9 3

Seq Scan on product_urls (cost=0.00..270.00 rows=7 width=13) (actual time=3.872..13.547 rows=9 loops=3)

  • Filter: (((url_status)::text = 'Active'::text) AND ((dashboard_nm)::text = 'CONVERSE'::text))
  • Rows Removed by Filter: 3849
117. 605.190 10,231.695 ↓ 9.0 3,169,164 3

Materialize (cost=60,681.38..62,435.00 rows=350,724 width=78) (actual time=3,061.492..3,410.565 rows=3,169,164 loops=3)

118. 9,161.802 9,626.505 ↑ 1.0 350,722 3

Sort (cost=60,681.38..61,558.19 rows=350,724 width=78) (actual time=3,061.479..3,208.835 rows=350,722 loops=3)

  • Sort Key: f.seller_id_alt, f.seller_nm_alt, f.marketplace
  • Sort Method: external merge Disk: 24056kB
119. 464.703 464.703 ↑ 1.0 350,724 3

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

120. 1,361.721 73,305.453 ↓ 2.9 4,657,468 3

Materialize (cost=574,253.17..582,225.10 rows=1,594,387 width=223) (actual time=21,209.984..24,435.151 rows=4,657,468 loops=3)

121. 68,323.857 71,943.732 ↑ 1.0 1,588,974 3

Sort (cost=574,253.17..578,239.13 rows=1,594,387 width=223) (actual time=21,209.972..23,981.244 rows=1,588,974 loops=3)

  • Sort Key: c.product_asin_alt, c.client_nm
  • Sort Method: external merge Disk: 315416kB
122. 3,619.875 3,619.875 ↑ 1.0 1,594,062 3

Seq Scan on pki_products c (cost=0.00..72,118.87 rows=1,594,387 width=223) (actual time=0.562..1,206.625 rows=1,594,062 loops=3)

123. 30,047.457 321,911.712 ↓ 17.0 153,396,201 3

Materialize (cost=2,439,343.32..2,484,573.06 rows=9,045,948 width=105) (actual time=87,450.757..107,303.904 rows=153,396,201 loops=3)

124. 278,594.805 291,864.255 ↑ 1.0 8,950,675 3

Sort (cost=2,439,343.32..2,461,958.19 rows=9,045,948 width=105) (actual time=87,450.746..97,288.085 rows=8,950,675 loops=3)

  • Sort Key: b.product_asin_alt, b.client_nm
  • Sort Method: external merge Disk: 1052632kB
125. 13,269.450 13,269.450 ↑ 1.0 9,045,948 3

Seq Scan on pki_product_seller_map b (cost=0.00..342,897.48 rows=9,045,948 width=105) (actual time=0.386..4,423.150 rows=9,045,948 loops=3)

126. 0.448 20.947 ↑ 1.1 625 1

Hash (cost=259.34..259.34 rows=687 width=64) (actual time=20.947..20.947 rows=625 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 65kB
127. 20.499 20.499 ↑ 1.1 625 1

Seq Scan on product_urls e (cost=0.00..259.34 rows=687 width=64) (actual time=1.103..20.499 rows=625 loops=1)

  • Filter: ((client_typ)::text = 'C'::text)
  • Rows Removed by Filter: 3233
Planning time : 32.611 ms