explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Oxs

Settings
# exclusive inclusive rows x rows loops node
1. 3.476 32.317 ↓ 12.3 3,705 1

Nested Loop (cost=0.20..21,375.10 rows=301 width=16) (actual time=0.103..32.317 rows=3,705 loops=1)

2. 4.631 4.631 ↑ 1.2 4,842 1

Index Only Scan using products_seller_marketplace_sku_unique on products p (cost=0.11..157.90 rows=5,958 width=32) (actual time=0.066..4.631 rows=4,842 loops=1)

  • Index Cond: ((seller_id = 'A1LMQBEOGTEVAC'::text) AND (marketplace_id = 'ATVPDKIKX0DER'::text))
  • Heap Fetches: 1353
3. 24.210 24.210 ↑ 1.0 1 4,842

Index Only Scan using product_firsts_nonnull_cost_or_ad_data_index on product_firsts pfs (cost=0.09..3.56 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=4,842)

  • Index Cond: (tm_product_id = p.tm_id)
  • Heap Fetches: 3705
Planning time : 0.893 ms
Execution time : 32.653 ms