explain.depesz.com

PostgreSQL's explain analyze made readable

Result: roM1

Settings
# exclusive inclusive rows x rows loops node
1. 1.643 41.507 ↓ 166.4 21,965 1

Nested Loop (cost=0.42..9,637.55 rows=132 width=25) (actual time=0.154..41.507 rows=21,965 loops=1)

2. 0.018 0.018 ↑ 1.0 3 1

Seq Scan on mws_credentials (cost=0.00..16.50 rows=3 width=32) (actual time=0.012..0.018 rows=3 loops=1)

  • Filter: ((state)::text = 'Authorized'::text)
  • Rows Removed by Filter: 6
3. 39.846 39.846 ↓ 2.2 7,322 3

Index Scan using products_seller_marketplace_sku_unique on products x2 (cost=0.42..3,174.30 rows=3,272 width=39) (actual time=0.101..13.282 rows=7,322 loops=3)

  • Index Cond: (((seller_id)::text = (mws_credentials.seller_id)::text) AND ((marketplace_id)::text = ANY ('{A39IBJ37TRP1C6,A1805IZSGTT6HS,A2VIGQ35RCS4UG,A17E79C6D8DWNP,HALKEAD,A1F83G8C2ARO7P,ABCDEFG,ATVPDKIKX0DER,APJ6JRA9NG5V4,A2EUQ1WTGCTBG2,A1RKKUPIHCS9HS,A1VC38T7YXB528,A1AM78C64UM0Y8,A21TJRUUN4KGV,ARBP9OOSHTCHU,A1PA6795UKMFR9}'::text[])))
  • Filter: is_active
  • Rows Removed by Filter: 11,588
Planning time : 0.526 ms
Execution time : 42.162 ms