explain.depesz.com

PostgreSQL's explain analyze made readable

Result: upWz : Optimization for: plan #GWIW

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.009 103,991.737 ↑ 1.0 100 1

Limit (cost=0.84..862.41 rows=100 width=457) (actual time=103,934.265..103,991.737 rows=100 loops=1)

  • Buffers: shared hit=222430592
2. 23,955.413 103,991.728 ↑ 67,798.3 100 1

Nested Loop (cost=0.84..58,412,343.43 rows=6,779,827 width=457) (actual time=103,934.263..103,991.728 rows=100 loops=1)

  • Buffers: shared hit=222430592
3. 24,177.543 24,177.543 ↑ 2.0 55,858,772 1

Index Scan using file_pkey on file f (cost=0.57..23,409,008.61 rows=113,831,736 width=330) (actual time=0.025..24,177.543 rows=55,858,772 loops=1)

  • Buffers: shared hit=55652672
4. 55,858.772 55,858.772 ↓ 0.0 0 55,858,772

Index Scan using product_collection_pkey on product_collection pc (cost=0.28..0.30 rows=1 width=127) (actual time=0.001..0.001 rows=0 loops=55,858,772)

  • Index Cond: (id = f.product_collection_id)
  • Filter: (mission_id = 7)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=166777920