explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V9sP

Settings
# exclusive inclusive rows x rows loops node
1. 5.657 5.657 ↓ 1.1 11,131 1

Index Only Scan using products_is_valid_idx on products (cost=0.11..10,755.77 rows=10,121 width=32) (actual time=0.032..5.657 rows=11,131 loops=1)

  • Index Cond: ((is_valid = true) AND (seller_marketplace_tm_id = '3f741566-775e-4738-b19b-ca288aa45c38'::uuid))
  • Heap Fetches: 11131
Planning time : 0.111 ms
Execution time : 6.234 ms