explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pv8p

Settings
# exclusive inclusive rows x rows loops node
1. 0.115 2.834 ↓ 10.0 60 1

Nested Loop (cost=299.51..435.04 rows=6 width=52) (actual time=1.214..2.834 rows=60 loops=1)

2. 0.667 1.819 ↓ 5.5 60 1

Bitmap Heap Scan on product_stock productsto0_ (cost=299.10..342.22 rows=11 width=40) (actual time=1.183..1.819 rows=60 loops=1)

  • Recheck Cond: ((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[])))
  • Filter: (enabled AND (NOT is_deleted))
  • Heap Blocks: exact=49
3. 0.121 1.152 ↓ 0.0 0 1

BitmapAnd (cost=299.10..299.10 rows=11 width=0) (actual time=1.152..1.152 rows=0 loops=1)

4. 0.682 0.682 ↑ 1.0 2,923 1

Bitmap Index Scan on product_stock_warehouse_idx (cost=0.00..58.25 rows=2,928 width=0) (actual time=0.681..0.682 rows=2,923 loops=1)

  • Index Cond: (warehouse_id = 53)
5. 0.349 0.349 ↑ 1.1 360 1

Bitmap Index Scan on product_stock_product_idx (cost=0.00..240.59 rows=386 width=0) (actual time=0.348..0.349 rows=360 loops=1)

  • Index Cond: (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[]))
6. 0.900 0.900 ↑ 1.0 1 60

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

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