explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lYHc

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.455 174.978 ↑ 2.2 256 1

Sort (cost=28,036.62..28,038.04 rows=567 width=1,061) (actual time=174.924..174.978 rows=256 loops=1)

  • Sort Key: shop_catalog_product.is_main_color_variant DESC
  • Sort Method: quicksort Memory: 441kB
2. 5.697 174.523 ↑ 2.2 256 1

Hash Join (cost=21,988.25..28,010.69 rows=567 width=1,061) (actual time=136.233..174.523 rows=256 loops=1)

  • Hash Cond: (shop_catalog_product.id = shop_catalog_productsupplierinfo.product_id)
3. 32.627 32.627 ↑ 1.1 53,814 1

Seq Scan on shop_catalog_product (cost=0.00..5,797.18 rows=58,558 width=224) (actual time=0.012..32.627 rows=53,814 loops=1)

  • Filter: (is_main_size_variant AND ((main_image)::text <> ''::text))
  • Rows Removed by Filter: 79,320
4. 2.485 136.199 ↓ 1.5 1,971 1

Hash (cost=21,972.15..21,972.15 rows=1,288 width=837) (actual time=136.199..136.199 rows=1,971 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 1,978kB
5. 133.714 133.714 ↓ 1.5 1,971 1

Seq Scan on shop_catalog_productsupplierinfo (cost=0.00..21,972.15 rows=1,288 width=837) (actual time=0.211..133.714 rows=1,971 loops=1)

  • Filter: ((remote_color_group_id IS NOT NULL) AND ((remote_color_group_id)::text = ANY ('{makros-3879822,1-000021900,makros-5944421,makros-6307900,884,1-000032034,1013,36842,108239,1-000016584,00000004253,makros-8234375,makros-4605364,makros-8469708,makros-6653143,makros-2870184,makros-9756433,makros-1144739,00000003847,701825,105977,makros-1550214,893,105082,36459,00000008288,makros-1895838,00000000386,160387,makros-7383248,makros-3915666,76158,60029,makros-7621158,00000011966,makros-9669287,makros-5140298,makros-5042068,39706}'::text[])))
  • Rows Removed by Filter: 131,155
Planning time : 0.819 ms
Execution time : 175.504 ms