explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wyMul : Optimization for: plan #dIxw

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.022 20.161 ↑ 1.2 191 1

Limit (cost=1,602.19..7,519.48 rows=227 width=1,173) (actual time=5.231..20.161 rows=191 loops=1)

2. 0.136 20.139 ↑ 1.2 191 1

Nested Loop Left Join (cost=1,602.19..7,519.48 rows=227 width=1,173) (actual time=5.231..20.139 rows=191 loops=1)

3. 0.127 19.812 ↑ 1.2 191 1

Nested Loop Left Join (cost=1,601.92..7,450.70 rows=227 width=1,065) (actual time=5.224..19.812 rows=191 loops=1)

4. 2.149 19.112 ↑ 1.2 191 1

Hash Join (cost=1,601.50..6,802.20 rows=227 width=227) (actual time=5.214..19.112 rows=191 loops=1)

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

Bitmap Heap Scan on shop_catalog_product scp (cost=735.67..5,178.32 rows=19,504 width=227) (actual time=4.176..15.959 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: 1,062
  • Heap Blocks: exact=3,990
6. 3.507 3.507 ↑ 1.2 23,143 1

Bitmap Index Scan on scp_is_active (cost=0.00..730.80 rows=27,892 width=0) (actual time=3.507..3.507 rows=23,143 loops=1)

  • Index Cond: ((is_active = true) AND (is_main_active = true) AND (is_main_color_variant = true) AND (is_main_size_variant = true))
7. 0.192 1.004 ↑ 1.0 1,502 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 69kB
8. 0.660 0.812 ↑ 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.201..0.812 rows=1,502 loops=1)

  • Recheck Cond: (category_id = 2)
  • Heap Blocks: exact=465
9. 0.152 0.152 ↑ 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.152..0.152 rows=1,502 loops=1)

  • Index Cond: (category_id = 2)
10. 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)
11. 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.028 ms
Execution time : 20.314 ms