explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xxR7

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.531 ↑ 1.0 8 1

Limit (cost=2,154.82..2,156.04 rows=8 width=1,169) (actual time=0.422..0.531 rows=8 loops=1)

2. 0.107 0.527 ↑ 3.5 8 1

Unique (cost=2,154.82..2,159.09 rows=28 width=1,169) (actual time=0.420..0.527 rows=8 loops=1)

3. 0.151 0.420 ↑ 3.5 8 1

Sort (cost=2,154.82..2,154.89 rows=28 width=1,169) (actual time=0.418..0.420 rows=8 loops=1)

  • Sort Key: shop_catalog_product.sort, shop_catalog_product.price, shop_catalog_product.id, shop_catalog_product.name, shop_catalog_product.name_overwrite, shop_catalog_product.old_price, shop_catalog_product.is_on_sale, shop_catalog_product.is_popular, shop_catalog_product.is_new, shop_catalog_product.is_active, shop_catalog_product.is_main_active, shop_catalog_product.created_at, shop_catalog_product.last_updated_at, shop_catalog_product.is_main_color_variant, shop_catalog_product.color_variant_of_id, shop_catalog_product.is_main_size_variant, shop_catalog_product.size_variant_of_id, shop_catalog_product.category_manual_id, shop_catalog_product.sex, shop_catalog_product.main_image, shop_catalog_product.rotate_counter_clockwise, shop_catalog_product.rotate_clockwise, shop_catalog_product.disable_update_main_image, shop_catalog_product.popularity, shop_catalog_product.need_upload_to_crm, shop_catalog_product.article, shop_catalog_product.bpm_id, shop_catalog_product.update_price, shop_catalog_product.disable_update, shop_catalog_productsupplierinfo.id, shop_catalog_productsupplierinfo.product_id, shop_catalog_productsupplierinfo.supplier_id, shop_catalog_productsupplierinfo.remote_id, shop_catalog_productsupplierinfo.remote_size_group_id, shop_catalog_productsupplierinfo.remote_color_group_id, shop_catalog_productsupplierinfo.price, shop_catalog_productsupplierinfo.purchase_price, shop_catalog_productsupplierinfo.stock, shop_catalog_productsupplierinfo.description, shop_catalog_productsupplierinfo.brand_id, shop_catalog_productsupplierinfo.collection_id, shop_catalog_productsupplierinfo.size, shop_catalog_productsupplierinfo.new_size_id, shop_catalog_productsupplierinfo.created_at, shop_catalog_productsupplierinfo.last_updated_at, shop_catalog_productsupplierinfo.is_active, shop_catalog_productsupplierinfo.more_properties, shop_catalog_productsupplierinfo.prints, shop_catalog_productsupplierinfo.storage, shop_catalog_productbrand.id, shop_catalog_productbrand.title, shop_catalog_productbrand.description, shop_catalog_productbrand.keywords, shop_catalog_productbrand.name, shop_catalog_productbrand.slug, shop_catalog_productbrand.descr, shop_catalog_productbrand.icon, shop_catalog_productbrand.updated_at, shop_catalog_productbrand.supplier_id, shop_catalog_productbrand.is_active
  • Sort Method: quicksort Memory: 57kB
4. 0.004 0.269 ↑ 3.5 8 1

Nested Loop (cost=7.31..2,154.14 rows=28 width=1,169) (actual time=0.104..0.269 rows=8 loops=1)

5. 0.022 0.022 ↑ 1.0 1 1

Index Only Scan using shop_catalog_category_pkey on shop_catalog_category u0 (cost=0.15..8.17 rows=1 width=4) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (id = 284)
  • Heap Fetches: 1
6. 0.012 0.243 ↑ 3.5 8 1

Nested Loop Left Join (cost=7.16..2,145.70 rows=28 width=1,173) (actual time=0.079..0.243 rows=8 loops=1)

7. 0.015 0.223 ↑ 3.5 8 1

Nested Loop Left Join (cost=6.89..2,137.21 rows=28 width=1,065) (actual time=0.076..0.223 rows=8 loops=1)

8. 0.001 0.144 ↑ 3.5 8 1

Nested Loop (cost=6.47..2,053.10 rows=28 width=228) (actual time=0.058..0.144 rows=8 loops=1)

9. 0.030 0.062 ↑ 23.3 9 1

Bitmap Heap Scan on shop_catalog_product_full_category (cost=6.05..482.60 rows=210 width=8) (actual time=0.037..0.062 rows=9 loops=1)

  • Recheck Cond: (category_id = 284)
  • Heap Blocks: exact=5
10. 0.032 0.032 ↑ 21.0 10 1

Bitmap Index Scan on shop_catalog_product_full_category_category_id_60608c45 (cost=0.00..6.00 rows=210 width=0) (actual time=0.031..0.032 rows=10 loops=1)

  • Index Cond: (category_id = 284)
11. 0.081 0.081 ↑ 1.0 1 9

Index Scan using shop_catalog_product_pkey on shop_catalog_product (cost=0.42..7.47 rows=1 width=224) (actual time=0.008..0.009 rows=1 loops=9)

  • Index Cond: (id = shop_catalog_product_full_category.product_id)
  • 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: 0
12. 0.064 0.064 ↑ 1.0 1 8

Index Scan using shop_catalog_productsupplierinfo_product_id_533dfedc_uniq on shop_catalog_productsupplierinfo (cost=0.42..2.99 rows=1 width=837) (actual time=0.008..0.008 rows=1 loops=8)

  • Index Cond: (shop_catalog_product.id = product_id)
13. 0.008 0.008 ↑ 1.0 1 8

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

  • Index Cond: (shop_catalog_productsupplierinfo.brand_id = id)
Planning time : 4.258 ms
Execution time : 0.780 ms