explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SoWW

Settings
# exclusive inclusive rows x rows loops node
1. 8.588 13.573 ↓ 0.0 0 1

Delete on bs_positions (cost=0.00..605.09 rows=11,051 width=6) (actual time=13.573..13.573 rows=0 loops=1)

  • Buffers: shared hit=22,913 dirtied=310
2. 4.985 4.985 ↓ 1.0 11,248 1

Seq Scan on bs_positions (cost=0.00..605.09 rows=11,051 width=6) (actual time=0.435..4.985 rows=11,248 loops=1)

  • Filter: (contragents_registry_id = 7,334)
  • Rows Removed by Filter: 3,833
  • Buffers: shared hit=417
Planning time : 0.043 ms
Execution time : 9,591.214 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint bs_acts_positions_position_id_fkey on bs_positions 51.762 ms 11248 0.005 ms
for constraint bs_position_amounts_position_id_fkey on bs_positions 94.478 ms 11248 0.008 ms
for constraint bs_positions_for_contragents_position_id_fk on bs_positions 266.579 ms 11248 0.024 ms
for constraint bs_positions_from_id_fkey on bs_positions 6,862.391 ms 11248 0.610 ms
for constraint bs_list_price_positions_original_position_id_fkey on bs_positions 110.831 ms 11248 0.010 ms
for constraint bs_position_amounts_from_id_fkey on bs_position_amounts 2,167.174 ms 11248 0.193 ms