explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5o1G

Settings
# exclusive inclusive rows x rows loops node
1. 201.072 236.382 ↓ 1.1 511,575 1

Bitmap Heap Scan on marketplace_upc (cost=11,329.76..295,259.77 rows=482,752 width=29) (actual time=39.475..236.382 rows=511,575 loops=1)

  • Recheck Cond: (marketplace_id = 35)
  • Heap Blocks: exact=24,318
2. 35.310 35.310 ↓ 1.1 511,575 1

Bitmap Index Scan on marketplace_upc_marketplace_id_index (cost=0.00..11,209.07 rows=482,752 width=0) (actual time=35.310..35.310 rows=511,575 loops=1)

  • Index Cond: (marketplace_id = 35)
Planning time : 1.549 ms
Execution time : 6,242.936 ms