explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MDAX : First Explain

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.040 9.048 ↑ 1.0 1 1

Aggregate (cost=6,628.73..6,628.74 rows=1 width=0) (actual time=9.048..9.048 rows=1 loops=1)

2. 0.000 9.008 ↓ 1.2 356 1

Nested Loop (cost=0.43..6,627.98 rows=301 width=0) (actual time=0.024..9.008 rows=356 loops=1)

3. 0.468 0.468 ↑ 1.0 779 1

Seq Scan on category_predictions (cost=0.00..67.80 rows=779 width=19) (actual time=0.004..0.468 rows=779 loops=1)

  • Filter: (NOT user_decision_done)
  • Rows Removed by Filter: 1
4. 8.569 8.569 ↓ 0.0 0 779

Index Scan using product_data_sheet_pkey on product_data_sheet (cost=0.43..8.41 rows=1 width=19) (actual time=0.011..0.011 rows=0 loops=779)

  • Index Cond: (id = category_predictions.id)
  • Filter: ((product_data_sheet_type = 'masterProductDataSheet'::text) AND (category_predictions.first_prediction_label <> category_code))
  • Rows Removed by Filter: 1