explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6fDz

Settings
# exclusive inclusive rows x rows loops node
1. 4,267.992 4,496.902 ↓ 1.1 511,575 1

Sort (cost=352,395.50..353,603.00 rows=482,999 width=29) (actual time=2,990.309..4,496.902 rows=511,575 loops=1)

  • Sort Key: marketplace_upc.gtin_14
  • Sort Method: external merge Disk: 20,208kB
2. 194.450 228.910 ↓ 1.1 511,575 1

Bitmap Heap Scan on marketplace_upc (cost=11,331.67..295,239.39 rows=482,999 width=29) (actual time=38.632..228.910 rows=511,575 loops=1)

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

Bitmap Index Scan on marketplace_upc_marketplace_id_index (cost=0.00..11,210.93 rows=482,999 width=0) (actual time=34.460..34.460 rows=511,575 loops=1)

  • Index Cond: (marketplace_id = 35)
Planning time : 0.997 ms