explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w1w8 : Optimization for: Optimization for: plan #dIxw; plan #wyMul

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.027 34.600 ↑ 1.2 191 1

Limit (cost=866.52..8,052.57 rows=227 width=1,173) (actual time=1.392..34.600 rows=191 loops=1)

2. 0.165 34.573 ↑ 1.2 191 1

Nested Loop Left Join (cost=866.52..8,052.57 rows=227 width=1,173) (actual time=1.392..34.573 rows=191 loops=1)

3. 0.237 34.217 ↑ 1.2 191 1

Nested Loop Left Join (cost=866.24..7,983.79 rows=227 width=1,065) (actual time=1.388..34.217 rows=191 loops=1)

4. 2.496 33.407 ↑ 1.2 191 1

Hash Join (cost=865.83..7,335.29 rows=227 width=227) (actual time=1.378..33.407 rows=191 loops=1)

  • Hash Cond: (scp.id = scpfc.product_id)
5. 29.607 29.607 ↓ 1.1 22,081 1

Seq Scan on shop_catalog_product scp (cost=0.00..5,711.41 rows=19,504 width=227) (actual time=0.010..29.607 rows=22,081 loops=1)

  • Filter: (is_active AND is_main_active AND is_main_color_variant AND is_main_size_variant AND ((main_image)::text <> ''::text))
  • Rows Removed by Filter: 107312
6. 0.246 1.304 ↑ 1.0 1,502 1

Hash (cost=847.00..847.00 rows=1,506 width=4) (actual time=1.304..1.304 rows=1,502 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 69kB
7. 0.908 1.058 ↑ 1.0 1,502 1

Bitmap Heap Scan on shop_catalog_product_full_category scpfc (cost=32.09..847.00 rows=1,506 width=4) (actual time=0.207..1.058 rows=1,502 loops=1)

  • Recheck Cond: (category_id = 2)
  • Heap Blocks: exact=465
8. 0.150 0.150 ↑ 1.0 1,502 1

Bitmap Index Scan on shop_catalog_product_full_category_category_id_60608c45 (cost=0.00..31.72 rows=1,506 width=0) (actual time=0.150..0.150 rows=1,502 loops=1)

  • Index Cond: (category_id = 2)
9. 0.573 0.573 ↑ 1.0 1 191

Index Scan using shop_catalog_productsupplierinfo_product_id_533dfedc_uniq on shop_catalog_productsupplierinfo scpsi (cost=0.42..2.85 rows=1 width=838) (actual time=0.003..0.003 rows=1 loops=191)

  • Index Cond: (product_id = scp.id)
10. 0.191 0.191 ↑ 1.0 1 191

Index Scan using shop_catalog_productbrand_pkey on shop_catalog_productbrand scpb (cost=0.28..0.29 rows=1 width=108) (actual time=0.001..0.001 rows=1 loops=191)

  • Index Cond: (id = scpsi.brand_id)
Planning time : 1.572 ms
Execution time : 34.709 ms