explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bytU

Settings
# exclusive inclusive rows x rows loops node
1. 27,495.157 63,033.953 ↓ 0.0 0 1

Update on fba_asin_list fal (cost=5.17..449,130.77 rows=133,601 width=233) (actual time=63,033.953..63,033.953 rows=0 loops=1)

2. 3,005.014 35,538.796 ↓ 47.1 6,290,913 1

Nested Loop (cost=5.17..449,130.77 rows=133,601 width=233) (actual time=0.063..35,538.796 rows=6,290,913 loops=1)

  • Join Filter: ((m.country_code)::text = feed.marketplace)
  • Rows Removed by Join Filter: 4920345
3. 1,793.496 9,603.770 ↓ 11.2 1,637,858 1

Nested Loop (cost=4.74..148,154.47 rows=146,117 width=117) (actual time=0.045..9,603.770 rows=1,637,858 loops=1)

4. 661.198 1,183.178 ↓ 10.1 1,656,774 1

Hash Join (cost=4.31..59,054.70 rows=164,585 width=30) (actual time=0.036..1,183.178 rows=1,656,774 loops=1)

  • Hash Cond: (p.marketplace_id = m.marketplace_id)
5. 521.954 521.954 ↑ 1.0 1,864,114 1

Seq Scan on products p (cost=0.00..54,031.93 rows=1,865,293 width=25) (actual time=0.005..521.954 rows=1,864,114 loops=1)

6. 0.005 0.026 ↑ 1.0 15 1

Hash (cost=4.12..4.12 rows=15 width=13) (actual time=0.026..0.026 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.021 0.021 ↑ 1.0 15 1

Seq Scan on marketplace m (cost=0.00..4.12 rows=15 width=13) (actual time=0.006..0.021 rows=15 loops=1)

  • Filter: ((marketplace_nm)::text ~~ 'amazon%'::text)
  • Rows Removed by Filter: 155
8. 6,627.096 6,627.096 ↑ 1.0 1 1,656,774

Index Scan using fba_asin_list_pkey on fba_asin_list fal (cost=0.43..0.54 rows=1 width=91) (actual time=0.004..0.004 rows=1 loops=1,656,774)

  • Index Cond: (product_id = p.product_id)
9. 22,930.012 22,930.012 ↑ 5.3 7 1,637,858

Index Scan using fba_product_daily_run_feed_product_asin_idx on fba_product_daily_run_feed feed (cost=0.43..1.60 rows=37 width=20) (actual time=0.011..0.014 rows=7 loops=1,637,858)

  • Index Cond: (product_asin = (p.product_asin)::text)
Planning time : 1.987 ms
Execution time : 63,034.030 ms