explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yunS

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 3.194 ↓ 0.0 0 1

Delete on stock_move (cost=5.90..763.72 rows=30 width=6) (actual time=3.194..3.194 rows=0 loops=1)

2. 2.750 3.118 ↑ 3.0 10 1

Bitmap Heap Scan on stock_move (cost=5.90..763.72 rows=30 width=6) (actual time=0.407..3.118 rows=10 loops=1)

  • Recheck Cond: (id > 3237620)
  • Filter: ((state)::text = 'cancel'::text)
  • Rows Removed by Filter: 154
  • Heap Blocks: exact=36
3. 0.368 0.368 ↑ 1.1 184 1

Bitmap Index Scan on stock_move_pkey (cost=0.00..5.89 rows=195 width=0) (actual time=0.368..0.368 rows=184 loops=1)

  • Index Cond: (id > 3237620)
Planning time : 2.853 ms
Execution time : 9,206.828 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint mrp_batch_recipe_move_id_fkey 0.767 ms 10 0.077 ms
for constraint mrp_production_declaration_line_move_id_fkey 0.394 ms 10 0.039 ms
for constraint mrp_production_for_move_id_fkey 109.947 ms 10 10.995 ms
for constraint mrp_production_recipe_lot_reservation_for_move_id_fkey 0.472 ms 10 0.047 ms
for constraint mrp_production_run_day_move_id_fkey 4.430 ms 10 0.443 ms
for constraint mrp_production_stock_move_rel_stock_move_id_fkey 0.210 ms 10 0.021 ms
for constraint mrp_repair_line_move_id_fkey 0.344 ms 10 0.034 ms
for constraint mrp_repair_move_id_fkey 0.482 ms 10 0.048 ms
for constraint procurement_order_for_move_id_fkey 1,124.069 ms 10 112.407 ms
for constraint procurement_order_move_dest_id_fkey 1,006.702 ms 10 100.670 ms
for constraint procurement_order_stock_move_rel_stock_move_id_fkey 0.423 ms 10 0.042 ms
for constraint sale_season_line_virtual_move_id_fkey 0.617 ms 10 0.062 ms
for constraint stock_location_route_move_move_id_fkey 0.221 ms 10 0.022 ms
for constraint stock_move_batch_move_id_fkey 0.308 ms 10 0.031 ms
for constraint stock_move_lots_move_id_fkey 0.364 ms 10 0.036 ms
for constraint stock_move_move_dest_id_fkey 2.803 ms 10 0.280 ms
for constraint stock_move_operation_link_move_id_fkey 0.251 ms 10 0.025 ms
for constraint stock_move_origin_returned_move_id_fkey 2.129 ms 10 0.213 ms
for constraint stock_move_split_from_fkey 2.727 ms 10 0.273 ms
for constraint stock_move_wizard_confirm_action_rel_stock_move_id_fkey 0.232 ms 10 0.023 ms
for constraint stock_move_wizard_select_tank_fillup_rel_stock_move_id_fkey 0.155 ms 10 0.015 ms
for constraint stock_move_wizard_select_workorder_data_rel_stock_move_id_fkey 0.167 ms 10 0.017 ms
for constraint stock_move_wizard_set_workorder_lot_componen_stock_move_id_fkey 0.228 ms 10 0.023 ms
for constraint stock_picking_dispatch_move_id_fkey 0.227 ms 10 0.023 ms
for constraint stock_production_lot_finished_move_id_fkey 1,040.251 ms 10 104.025 ms
for constraint stock_quant_move_rel_move_id_fkey 0.459 ms 10 0.046 ms
for constraint stock_quant_negative_move_id_fkey 5,884.656 ms 10 588.466 ms
for constraint stock_quant_package_production_move_id_fkey 0.817 ms 10 0.082 ms
for constraint stock_quant_reservation_id_fkey 0.527 ms 10 0.053 ms
for constraint stock_return_picking_line_move_id_fkey 0.252 ms 10 0.025 ms
for constraint stock_scrap_move_id_fkey 13.190 ms 10 1.319 ms
for constraint wizard_declare_production_consume_line_move_id_fkey 1.035 ms 10 0.103 ms
for constraint wizard_declare_production_consumed_line_move_id_fkey 0.225 ms 10 0.022 ms
for constraint wizard_declare_production_produced_line_move_id_fkey 0.339 ms 10 0.034 ms
for constraint wizard_declare_transformation_consume_line_move_id_fkey 0.239 ms 10 0.024 ms
for constraint wizard_get_io_stock_line_move_id_fkey 0.208 ms 10 0.021 ms
for constraint wizard_modify_reservations_line_reservation_id_fkey 0.319 ms 10 0.032 ms
for constraint wizard_modify_reservations_move_id_fkey 0.155 ms 10 0.015 ms
for constraint wizard_select_tank_fillup_moves_1_rel_stock_move_id_fkey 0.186 ms 10 0.019 ms
for constraint wizard_select_tank_fillup_moves_2_rel_stock_move_id_fkey 0.138 ms 10 0.014 ms
for constraint wizard_select_tank_fillup_moves_3_rel_stock_move_id_fkey 0.130 ms 10 0.013 ms
for constraint wizard_select_tank_fillup_moves_4_rel_stock_move_id_fkey 0.172 ms 10 0.017 ms
for constraint wizard_select_tank_fillup_moves_5_rel_stock_move_id_fkey 0.171 ms 10 0.017 ms
for constraint wizard_select_tank_fillup_moves_6_rel_stock_move_id_fkey 0.144 ms 10 0.014 ms
for constraint wizard_select_tank_fillup_moves_7_rel_stock_move_id_fkey 0.136 ms 10 0.014 ms
for constraint wizard_select_tank_fillup_moves_8_rel_stock_move_id_fkey 0.141 ms 10 0.014 ms
for constraint wizard_select_workorder_data_chocolate_location_li_move_id_fkey 0.205 ms 10 0.020 ms
for constraint wizard_special_production_actions_move_id_fkey 0.132 ms 10 0.013 ms
for constraint wizard_stock_search_line_move_id_fkey 0.251 ms 10 0.025 ms
for constraint wizard_stock_transfer_recipe_line_move_id_fkey 0.224 ms 10 0.022 ms