explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TUkEO

Settings
# exclusive inclusive rows x rows loops node
1. 0.894 16,451.108 ↑ 1.0 1 1

Aggregate (cost=6,761.29..6,761.30 rows=1 width=0) (actual time=16,451.107..16,451.108 rows=1 loops=1)

2. 1.606 16,450.214 ↓ 2.6 779 1

Nested Loop (cost=0.99..6,760.53 rows=304 width=0) (actual time=9.640..16,450.214 rows=779 loops=1)

3. 2.988 6.255 ↑ 1.0 779 1

Merge Anti Join (cost=0.55..202.25 rows=779 width=16) (actual time=0.063..6.255 rows=779 loops=1)

  • Merge Cond: (cp1.id = cp2.id)
  • Join Filter: cp1.user_decision_done
  • Rows Removed by Join Filter: 779
4. 1.453 1.453 ↑ 1.0 780 1

Index Scan using category_predictions_pkey on category_predictions cp1 (cost=0.28..95.28 rows=780 width=17) (actual time=0.011..1.453 rows=780 loops=1)

5. 1.814 1.814 ↑ 1.0 780 1

Index Only Scan using category_predictions_pkey on category_predictions cp2 (cost=0.28..95.28 rows=780 width=16) (actual time=0.047..1.814 rows=780 loops=1)

  • Heap Fetches: 780
6. 16,442.353 16,442.353 ↑ 1.0 1 779

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

  • Index Cond: (id = cp1.id)
  • Filter: (product_data_sheet_type = 'masterProductDataSheet'::text)
Planning time : 132.372 ms
Execution time : 16,451.599 ms