explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ot1A

Settings
# exclusive inclusive rows x rows loops node
1. 7,868.209 95,898.105 ↓ 1.7 35,913,393 1

Nested Loop (cost=0.69..4,891,384.56 rows=21,225,002 width=25) (actual time=163.157..95,898.105 rows=35,913,393 loops=1)

  • Functions: 7
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.022 ms, Inlining 15.188 ms, Optimization 94.382 ms, Emission 52.781 ms, Total 164.374 ms
2. 165.864 165.864 ↑ 1.0 2,252 1

Seq Scan on mws_credentials (cost=0.00..168.68 rows=2,265 width=14) (actual time=162.639..165.864 rows=2,252 loops=1)

  • Filter: ((state)::text = 'Authorized'::text)
  • Rows Removed by Filter: 3,946
3. 87,864.032 87,864.032 ↓ 1.0 15,947 2,252

Index Scan using products_seller_marketplace_sku_unique on products (cost=0.69..2,001.72 rows=15,776 width=39) (actual time=0.135..39.016 rows=15,947 loops=2,252)

  • Index Cond: (((seller_id)::text = (mws_credentials.seller_id)::text) AND ((marketplace_id)::text = ANY ('{A17E79C6D8DWNP,A21TJRUUN4KGV,ATVPDKIKX0DER,ARBP9OOSHTCHU,APJ6JRA9NG5V4,A1PA6795UKMFR9,A1RKKUPIHCS9HS,A2EUQ1WTGCTBG2,ABCDEFG,A2VIGQ35RCS4UG,A1VC38T7YXB528,A39IBJ37TRP1C6,A1AM78C64UM0Y8,A1F83G8C2ARO7P,A1805IZSGTT6HS,HALKEAD}'::text[])))
Planning time : 2.895 ms
Execution time : 98,261.775 ms