explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bwP8

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 2,255.826 ↓ 0.0 0 1

Sort (cost=7,561.16..7,562.45 rows=514 width=70) (actual time=2,255.826..2,255.826 rows=0 loops=1)

  • Sort Key: tb_operation_bonds.id_basket, tb_operation_bonds.seq
  • Sort Method: quicksort Memory: 25kB
2. 0.001 2,255.818 ↓ 0.0 0 1

Nested Loop (cost=1,824.94..7,538.02 rows=514 width=70) (actual time=2,255.818..2,255.818 rows=0 loops=1)

3. 0.001 2,255.817 ↓ 0.0 0 1

Nested Loop (cost=824.94..2,079.22 rows=1 width=70) (actual time=2,255.817..2,255.817 rows=0 loops=1)

4. 465.108 2,255.816 ↓ 0.0 0 1

Hash Join (cost=824.51..2,077.07 rows=1 width=53) (actual time=2,255.815..2,255.816 rows=0 loops=1)

  • Hash Cond: (tb_operation_bonds.id_operation = tb_operation.id_operation)
5. 3.937 3.937 ↑ 48.7 37 1

Index Scan using tb_operation_bonds_id_broker_account_cblc_cd_side_dt_pre_se_idx on tb_operation_bonds (cost=0.41..1,246.21 rows=1,802 width=37) (actual time=0.402..3.937 rows=37 loops=1)

  • Index Cond: ((cd_side = 'B'::bpchar) AND (dt_pre_settl_money IS NULL) AND (dt_settl_money IS NULL))
  • Filter: (dt_settl_custody IS NULL)
6. 728.063 1,786.771 ↓ 1,528.4 2,419,471 1

Hash (cost=804.31..804.31 rows=1,583 width=24) (actual time=1,786.770..1,786.771 rows=2,419,471 loops=1)

  • Buckets: 1,048,576 (originally 2048) Batches: 4 (originally 1) Memory Usage: 57,345kB
7. 253.703 1,058.708 ↓ 1,528.4 2,419,471 1

Nested Loop (cost=0.85..804.31 rows=1,583 width=24) (actual time=0.026..1,058.708 rows=2,419,471 loops=1)

8. 0.014 0.014 ↑ 1.0 1 1

Index Scan using tb_investor_broker_account_idx0 on tb_investor_broker_account (cost=0.42..2.44 rows=1 width=16) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: ((id_broker = 13) AND (account_number = '9999316'::bigint))
  • Filter: (id_contract = 8)
9. 804.991 804.991 ↓ 2,661.7 2,419,471 1

Index Scan using tb_operation_id_investor_idx on tb_operation (cost=0.43..792.78 rows=909 width=18) (actual time=0.010..804.991 rows=2,419,471 loops=1)

  • Index Cond: (id_investor = tb_investor_broker_account.id_investor)
  • Filter: (id_broker = 13)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_instrument_pk on tb_instrument (cost=0.42..2.14 rows=1 width=33) (never executed)

  • Index Cond: (id_instrument = tb_operation_bonds.id_instrument)
11. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..5,453.66 rows=514 width=13) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
12. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on tb_oms_account (cost=0.00..4,402.26 rows=214 width=13) (never executed)

  • Filter: ((id_broker = 13) AND ((account)::bigint = '9999316'::bigint))