explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dIxw

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.019 35.915 ↑ 1.2 191 1

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

2. 0.210 35.896 ↑ 1.2 191 1

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

3. 0.204 35.495 ↑ 1.2 191 1

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

4. 2.366 34.718 ↑ 1.2 191 1

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

  • Hash Cond: (scp.id = scpfc.product_id)
5. 31.191 31.191 ↓ 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.011..31.191 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: 107,312
6. 0.202 1.161 ↑ 1.0 1,502 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 69kB
7. 0.781 0.959 ↑ 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.234..0.959 rows=1,502 loops=1)

  • Recheck Cond: (category_id = 2)
  • Heap Blocks: exact=465
8. 0.178 0.178 ↑ 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.178..0.178 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 : 0.835 ms
Execution time : 36.062 ms