explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XbwC : Optimization for: plan #lYHc

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.519 176.462 ↑ 2.5 256 1

Sort (cost=28,044.18..28,045.80 rows=649 width=1,061) (actual time=176.405..176.462 rows=256 loops=1)

  • Sort Key: shop_catalog_product.is_main_color_variant DESC
  • Sort Method: quicksort Memory: 441kB
2. 6.293 175.943 ↑ 2.5 256 1

Hash Join (cost=21,990.60..28,013.86 rows=649 width=1,061) (actual time=134.696..175.943 rows=256 loops=1)

  • Hash Cond: (shop_catalog_product.id = shop_catalog_productsupplierinfo.product_id)
3. 34.989 34.989 ↑ 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..34.989 rows=53,814 loops=1)

  • Filter: (is_main_size_variant AND ((main_image)::text <> ''::text))
  • Rows Removed by Filter: 79,320
4. 2.580 134.661 ↓ 1.3 1,971 1

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

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

Seq Scan on shop_catalog_productsupplierinfo (cost=0.00..21,972.15 rows=1,476 width=837) (actual time=0.396..132.081 rows=1,971 loops=1)

  • Filter: ((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 : 1.829 ms
Execution time : 176.980 ms