explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yIINF

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.704 ↑ 1.0 1 1

Aggregate (cost=522.45..522.46 rows=1 width=8) (actual time=0.703..0.704 rows=1 loops=1)

2. 0.108 0.685 ↓ 18.4 294 1

Nested Loop (cost=405.70..522.41 rows=16 width=0) (actual time=0.244..0.685 rows=294 loops=1)

3. 0.115 0.283 ↓ 18.4 294 1

HashAggregate (cost=405.42..405.58 rows=16 width=16) (actual time=0.236..0.283 rows=294 loops=1)

  • Group Key: product_classifications.product_id
4. 0.026 0.168 ↓ 18.5 296 1

Nested Loop (cost=10.89..405.38 rows=16 width=16) (actual time=0.040..0.168 rows=296 loops=1)

5. 0.012 0.012 ↑ 1.0 1 1

Index Only Scan using classification_values_pkey on classification_values (cost=0.28..8.29 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (id = 47)
  • Heap Fetches: 1
6. 0.114 0.130 ↓ 18.5 296 1

Bitmap Heap Scan on product_classifications (cost=10.61..396.93 rows=16 width=20) (actual time=0.026..0.130 rows=296 loops=1)

  • Recheck Cond: (value_id = 47)
  • Filter: ((feature_code)::text = 'EF002169'::text)
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=89
7. 0.016 0.016 ↓ 1.0 310 1

Bitmap Index Scan on idx_search_by_value_id (cost=0.00..10.60 rows=309 width=0) (actual time=0.016..0.016 rows=310 loops=1)

  • Index Cond: (value_id = 47)
8. 0.294 0.294 ↑ 1.0 1 294

Index Scan using products_pkey on products (cost=0.28..7.30 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=294)

  • Index Cond: (id = product_classifications.product_id)
  • Filter: (deleted_at IS NULL)
Planning time : 0.221 ms
Execution time : 0.743 ms