explain.depesz.com

PostgreSQL's explain analyze made readable

Result: neAj

Settings
# exclusive inclusive rows x rows loops node
1. 8,190.080 104,151.662 ↓ 1.7 35,913,393 1

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

  • Functions: 7
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.019 ms, Inlining 36.837 ms, Optimization 146.398 ms, Emission 69.229 ms, Total 254.483 ms
2. 256.086 256.086 ↑ 1.0 2,252 1

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

  • Filter: ((state)::text = 'Authorized'::text)
  • Rows Removed by Filter: 3,946
3. 95,705.496 95,705.496 ↓ 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.150..42.498 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.831 ms
Execution time : 106,664.534 ms