explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XbG

Settings
# exclusive inclusive rows x rows loops node
1. 2,934.801 472,142.931 ↓ 1.5 16,850,003 1

Nested Loop (cost=0.69..4,721,373.66 rows=11,125,905 width=25) (actual time=312.629..472,142.931 rows=16,850,003 loops=1)

  • Functions: 9
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.657 ms, Inlining 133.747 ms, Optimization 110.422 ms, Emission 64.184 ms, Total 311.011 ms
2. 312.956 312.956 ↑ 1.0 2,246 1

Seq Scan on mws_credentials (cost=0.00..168.68 rows=2,265 width=14) (actual time=308.717..312.956 rows=2,246 loops=1)

  • Filter: ((state)::text = 'Authorized'::text)
  • Rows Removed by Filter: 3,953
3. 468,895.174 468,895.174 ↑ 1.1 7,502 2,246

Index Scan using products_seller_marketplace_sku_unique on products x2 (cost=0.69..2,001.72 rows=8,270 width=39) (actual time=2.248..208.769 rows=7,502 loops=2,246)

  • 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: 8,487
Planning time : 5.173 ms
Execution time : 473,438.053 ms