explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PWlw

Settings
# exclusive inclusive rows x rows loops node
1. 0.078 8.897 ↓ 0.0 0 1

Delete on stock_move (cost=3.83..89.25 rows=10 width=34) (actual time=8.897..8.897 rows=0 loops=1)

  • Buffers: shared hit=75 read=5 dirtied=3
2. 0.018 8.819 ↑ 1.0 10 1

Nested Loop (cost=3.83..89.25 rows=10 width=34) (actual time=8.765..8.819 rows=10 loops=1)

  • Buffers: shared hit=55 read=5
3. 0.014 8.751 ↑ 1.0 10 1

HashAggregate (cost=3.27..3.37 rows=10 width=32) (actual time=8.748..8.751 rows=10 loops=1)

  • Group Key: "ANY_subquery".id
  • Buffers: shared hit=5 read=5
4. 0.031 8.737 ↑ 1.0 10 1

Subquery Scan on ANY_subquery (cost=0.56..3.25 rows=10 width=32) (actual time=7.858..8.737 rows=10 loops=1)

  • Buffers: shared hit=5 read=5
5. 0.005 8.706 ↑ 1.0 10 1

Limit (cost=0.56..3.15 rows=10 width=12) (actual time=7.844..8.706 rows=10 loops=1)

  • Buffers: shared hit=5 read=5
6. 8.701 8.701 ↑ 35,702.6 10 1

Index Scan using stock_move_create_date_index on stock_move stock_move_1 (cost=0.56..92,455.43 rows=357,026 width=12) (actual time=7.843..8.701 rows=10 loops=1)

  • Index Cond: (create_date <= '2018-03-31 18:29:59'::timestamp without time zone)
  • Buffers: shared hit=5 read=5
7. 0.050 0.050 ↑ 1.0 1 10

Index Scan using stock_move_pkey on stock_move (cost=0.56..8.58 rows=1 width=10) (actual time=0.004..0.005 rows=1 loops=10)

  • Index Cond: (id = "ANY_subquery".id)
  • Buffers: shared hit=50
Planning time : 15.856 ms
Execution time : 228,995.132 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint procurement_order_move_dest_id_fkey 13,351.474 ms 10 1,335.147 ms
for constraint stock_location_route_move_move_id_fkey 50.747 ms 10 5.075 ms
for constraint stock_move_move_dest_id_fkey 0.889 ms 10 0.089 ms
for constraint stock_move_operation_link_move_id_fkey 9.377 ms 10 0.938 ms
for constraint stock_move_origin_returned_move_id_fkey 116,503.615 ms 10 11,650.362 ms
for constraint stock_move_split_from_fkey 52,599.149 ms 10 5,259.915 ms
for constraint stock_quant_move_rel_move_id_fkey 51.040 ms 10 5.104 ms
for constraint stock_quant_negative_move_id_fkey 46,413.465 ms 10 4,641.346 ms
for constraint stock_quant_reservation_id_fkey 1.268 ms 10 0.127 ms
for constraint stock_return_picking_line_move_id_fkey 4.366 ms 10 0.437 ms
for constraint stock_scrap_move_id_fkey 0.392 ms 10 0.039 ms
for constraint stock_move_lots_move_id_fkey 0.270 ms 10 0.027 ms