explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FJC9

Settings
# exclusive inclusive rows x rows loops node
1. 24.719 4,233.138 ↑ 100.0 2 1

GroupAggregate (cost=396,742.63..401,256.31 rows=200 width=20) (actual time=4,231.271..4,233.138 rows=2 loops=1)

  • Group Key: marketplace_upc.marketplace_id
2. 132.135 4,208.419 ↑ 1.5 77,530 1

GroupAggregate (cost=396,742.63..398,998.47 rows=112,792 width=26) (actual time=2,875.902..4,208.419 rows=77,530 loops=1)

  • Group Key: marketplace_upc.marketplace_id, marketplace_upc.gtin_14
3. 2,558.714 4,076.284 ↓ 2.8 316,372 1

Sort (cost=396,742.63..397,024.61 rows=112,792 width=22) (actual time=2,875.890..4,076.284 rows=316,372 loops=1)

  • Sort Key: marketplace_upc.marketplace_id, marketplace_upc.gtin_14
  • Sort Method: external merge Disk: 10,408kB
4. 196.987 1,517.570 ↓ 2.8 316,372 1

Nested Loop Left Join (cost=3,049.91..384,964.02 rows=112,792 width=22) (actual time=9.232..1,517.570 rows=316,372 loops=1)

5. 35.699 79.975 ↓ 1.1 77,538 1

Nested Loop (cost=3,049.48..342,051.09 rows=71,954 width=18) (actual time=9.219..79.975 rows=77,538 loops=1)

6. 0.050 0.050 ↑ 1.0 2 1

Seq Scan on retailer (cost=0.00..7.75 rows=2 width=4) (actual time=0.009..0.050 rows=2 loops=1)

  • Filter: (organization_id = 211)
  • Rows Removed by Filter: 298
7. 35.976 44.226 ↑ 1.9 38,769 2

Bitmap Heap Scan on marketplace_upc (cost=3,049.48..170,282.42 rows=73,925 width=18) (actual time=4.644..22.113 rows=38,769 loops=2)

  • Recheck Cond: (marketplace_id = retailer.marketplace_id)
  • Heap Blocks: exact=6,913
8. 8.250 8.250 ↑ 1.9 38,769 2

Bitmap Index Scan on marketplace_upc_pk (cost=0.00..3,031.00 rows=73,925 width=0) (actual time=4.125..4.125 rows=38,769 loops=2)

  • Index Cond: (marketplace_id = retailer.marketplace_id)
9. 1,240.608 1,240.608 ↑ 1.0 4 77,538

Index Scan using product_ids_gtin_14_index on product_ids _unmatched_upcs (cost=0.43..0.56 rows=4 width=18) (actual time=0.012..0.016 rows=4 loops=77,538)

  • Index Cond: ((marketplace_upc.gtin_14)::text = (gtin_14)::text)
Planning time : 1.117 ms
Execution time : 4,235.419 ms