explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VZLS

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.97..149.23 rows=61 width=25) (actual time=0.011..0.012 rows=0 loops=1)

2. 0.011 0.011 ↓ 0.0 0 1

Index Scan using mws_credentials_pkey on mws_credentials (cost=0.28..2.30 rows=1 width=14) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((seller_id)::text = 'SellerId1'::text)
  • Filter: ((state)::text = 'Authorized'::text)
3. 0.000 0.000 ↓ 0.0 0

Index Scan using products_seller_marketplace_isvalid_sku_id_idx on products x2 (cost=0.69..146.32 rows=61 width=39) (never executed)

  • Index Cond: (((seller_id)::text = 'SellerId1'::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
Planning time : 0.672 ms
Execution time : 0.044 ms