explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RRk : n index

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

Bitmap Heap Scan on products (cost=406.11..13,084.51 rows=28,401 width=30) (actual time=3.133..13.104 rows=27,196 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = '6cb8ead7-804b-4fc5-8ac0-3b9cf5801eae'::uuid) AND is_valid)
  • Heap Blocks: exact=3195
2. 2.726 2.726 ↑ 1.0 27,196 1

Bitmap Index Scan on products_seller_marketplace_tm_id_incl_sku_where_is_valid_idx (cost=0.00..404.69 rows=28,401 width=0) (actual time=2.726..2.726 rows=27,196 loops=1)

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