explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Q26

Settings
# exclusive inclusive rows x rows loops node
1. 1,520.121 6,082.864 ↓ 1.3 668,010 1

Merge Right Join (cost=340,834.22..482,666.88 rows=520,505 width=16) (actual time=3,599.794..6,082.864 rows=668,010 loops=1)

  • Merge Cond: ((product_ids.gtin_14)::text = (marketplace_upc.gtin_14)::text)
2. 758.241 758.241 ↑ 1.2 2,393,052 1

Index Only Scan using product_ids_gtin_14_index on product_ids (cost=0.43..149,530.89 rows=2,821,231 width=15) (actual time=0.006..758.241 rows=2,393,052 loops=1)

  • Heap Fetches: 59,786
3. 3,571.343 3,804.502 ↓ 1.4 668,010 1

Sort (cost=340,833.79..342,040.67 rows=482,752 width=29) (actual time=3,599.780..3,804.502 rows=668,010 loops=1)

  • Sort Key: marketplace_upc.gtin_14
  • Sort Method: quicksort Memory: 52,255kB
4. 198.710 233.159 ↓ 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=38.669..233.159 rows=511,575 loops=1)

  • Recheck Cond: (marketplace_id = 35)
  • Heap Blocks: exact=24,318
5. 34.449 34.449 ↓ 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=34.449..34.449 rows=511,575 loops=1)

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