explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ySMKY

Settings
# exclusive inclusive rows x rows loops node
1. 18.533 22.439 ↓ 0.0 0 1

Delete on bs_positions (cost=220.78..2,023.44 rows=6,773 width=6) (actual time=22.439..22.439 rows=0 loops=1)

  • Buffers: shared hit=23,603 dirtied=99
2. 3.298 3.906 ↓ 1.7 11,248 1

Bitmap Heap Scan on bs_positions (cost=220.78..2,023.44 rows=6,773 width=6) (actual time=0.757..3.906 rows=11,248 loops=1)

  • Recheck Cond: (contragents_registry_id = 92,881)
  • Heap Blocks: exact=1,077
  • Buffers: shared hit=1,107
3. 0.608 0.608 ↓ 1.7 11,248 1

Bitmap Index Scan on bs_positions_contragents_registry_id_has_bs_idx (cost=0.00..219.09 rows=6,773 width=0) (actual time=0.608..0.608 rows=11,248 loops=1)

  • Index Cond: (contragents_registry_id = 92,881)
  • Buffers: shared hit=30
Planning time : 0.072 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint bs_list_price_positions_original_position_id_fkey on bs_positions 285.048 ms 11248 0.025 ms
for constraint bs_acts_positions_position_id_fkey on bs_positions 100.097 ms 11248 0.009 ms
for constraint bs_position_amounts_position_id_fkey on bs_positions 219.096 ms 11248 0.019 ms
for constraint bs_positions_for_contragents_position_id_fk on bs_positions 103.556 ms 11248 0.009 ms
for constraint bs_positions_from_id_fkey on bs_positions 82,114.865 ms 11248 7.300 ms