explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VjG5

Settings
# exclusive inclusive rows x rows loops node
1. 14.925 49.167 ↓ 10.0 60 1

Gather (cost=1,000.41..8,240.24 rows=6 width=52) (actual time=10.852..49.167 rows=60 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.060 34.242 ↓ 10.0 20 3 / 3

Nested Loop (cost=0.41..7,239.64 rows=2 width=52) (actual time=6.612..34.242 rows=20 loops=3)

3. 33.582 33.582 ↓ 4.0 20 3 / 3

Parallel Seq Scan on product_stock productsto0_ (cost=0.00..7,197.45 rows=5 width=40) (actual time=6.535..33.582 rows=20 loops=3)

  • Filter: (enabled AND (NOT is_deleted) AND (warehouse_id = 53) AND (product_detail_id = ANY ('{36328,15951,15954,15956,15958,15962,15963,15965,15968,15969,15975,15979,15981,15983,15985,15988,15990,15994,15997,16002,16004,16008,16010,16012,16013,16019,16021,16023,16026,16027,16034,16035,16038,16039,16041,16044,16045,16048,16050,16051,16053,16055,16057,16059,16061,16064,16066,16068,16072,16076,16077,16080,16081,16083,16086,16087,16092,16093,16096,16097,16100}'::bigint[])))
  • Rows Removed by Filter: 33255
4. 0.600 0.600 ↑ 1.0 1 60 / 3

Index Scan using product_detail_pkey on product_detail productdet1_ (cost=0.41..8.44 rows=1 width=20) (actual time=0.030..0.030 rows=1 loops=60)

  • Index Cond: (id = productsto0_.product_detail_id)
  • Filter: main_unit
Planning time : 2.204 ms
Execution time : 49.272 ms