explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zy2X8 : 3rd version

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.083 42.290 ↑ 1.0 1 1

Aggregate (cost=6,773.92..6,773.93 rows=1 width=0) (actual time=42.290..42.290 rows=1 loops=1)

2. 3.345 42.207 ↓ 2.1 356 1

Nested Loop Anti Join (cost=0.71..6,773.50 rows=169 width=0) (actual time=0.738..42.207 rows=356 loops=1)

  • Join Filter: (cp1.id = cp2.id)
  • Rows Removed by Join Filter: 25646
3. 0.376 21.724 ↓ 2.6 779 1

Nested Loop (cost=0.43..6,626.03 rows=304 width=19) (actual time=0.045..21.724 rows=779 loops=1)

4. 0.315 0.315 ↑ 1.0 779 1

Seq Scan on category_predictions cp1 (cost=0.00..67.80 rows=779 width=16) (actual time=0.005..0.315 rows=779 loops=1)

  • Filter: (NOT user_decision_done)
  • Rows Removed by Filter: 1
5. 21.033 21.033 ↑ 1.0 1 779

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

  • Index Cond: (id = cp1.id)
  • Filter: (product_data_sheet_type = 'masterProductDataSheet'::text)
6. 17.138 17.138 ↓ 4.7 33 779

Index Scan using idx_category_predictions_first_prediction_label on category_predictions cp2 (cost=0.28..0.40 rows=7 width=19) (actual time=0.006..0.022 rows=33 loops=779)

  • Index Cond: (first_prediction_label = pds.category_code)