explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cxu4

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.027 ↓ 0.0 0 1

Sort (cost=1,165.39..1,165.39 rows=1 width=70) (actual time=0.027..0.027 rows=0 loops=1)

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

Nested Loop (cost=2.11..1,165.38 rows=1 width=70) (actual time=0.022..0.022 rows=0 loops=1)

3. 0.000 0.021 ↓ 0.0 0 1

Nested Loop (cost=1.69..1,163.23 rows=1 width=53) (actual time=0.021..0.021 rows=0 loops=1)

4. 0.000 0.021 ↓ 0.0 0 1

Nested Loop (cost=1.27..806.20 rows=1 width=24) (actual time=0.021..0.021 rows=0 loops=1)

5. 0.000 0.021 ↓ 0.0 0 1

Nested Loop (cost=0.83..4.33 rows=1 width=20) (actual time=0.021..0.021 rows=0 loops=1)

  • Join Filter: (((tb_investor_broker_account.account_number)::character varying)::text = (tb_oms_account.account)::text)
6. 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 = '88840020'::bigint))
  • Filter: (id_contract = 8)
7. 0.007 0.007 ↓ 0.0 0 1

Index Scan using tb_oms_account_pk on tb_oms_account (cost=0.42..1.87 rows=1 width=13) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (id_broker = '88840020'::bigint)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_operation_id_investor_idx on tb_operation (cost=0.43..792.78 rows=909 width=18) (never executed)

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

Index Scan using tb_operation_bonds_pk on tb_operation_bonds (cost=0.41..357.02 rows=1 width=37) (never executed)

  • Index Cond: (id_operation = tb_operation.id_operation)
  • Filter: ((dt_pre_settl_money IS NULL) AND (dt_settl_money IS NULL) AND (dt_settl_custody IS NULL) AND (cd_side = 'B'::bpchar))
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)