explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t8l5

Settings
# exclusive inclusive rows x rows loops node
1. 2,489.497 91,658.631 ↓ 1.5 16,850,406 1

Nested Loop (cost=0.69..4,721,373.66 rows=11,125,905 width=25) (actual time=204.834..91,658.631 rows=16,850,406 loops=1)

  • Functions: 9
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.722 ms, Inlining 12.341 ms, Optimization 119.299 ms, Emission 71.853 ms, Total 206.215 ms
2. 207.176 207.176 ↑ 1.0 2,253 1

Seq Scan on mws_credentials (cost=0.00..168.68 rows=2,265 width=14) (actual time=203.813..207.176 rows=2,253 loops=1)

  • Filter: ((state)::text = 'Authorized'::text)
  • Rows Removed by Filter: 3,946
3. 88,961.958 88,961.958 ↑ 1.1 7,479 2,253

Index Scan using products_seller_marketplace_sku_unique on products s18 (cost=0.69..2,001.72 rows=8,270 width=39) (actual time=0.513..39.486 rows=7,479 loops=2,253)

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