explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A9j4

Settings
# exclusive inclusive rows x rows loops node
1. 11.262 11.262 ↑ 1.0 27,196 1

Index Only Scan using products_seller_marketplace_tm_id_incl_sku_where_is_valid_idx on products (cost=0.08..7,695.00 rows=28,401 width=30) (actual time=0.052..11.262 rows=27,196 loops=1)

  • Index Cond: (seller_marketplace_tm_id = '6cb8ead7-804b-4fc5-8ac0-3b9cf5801eae'::uuid)
  • Heap Fetches: 20441
Planning time : 0.234 ms
Execution time : 12.223 ms