explain.depesz.com

PostgreSQL's explain analyze made readable

Result: skdb

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.016 ↓ 0.0 0 1

Limit (cost=71.81..71.81 rows=1 width=186) (actual time=1.016..1.016 rows=0 loops=1)

2. 0.012 1.015 ↓ 0.0 0 1

Sort (cost=71.81..71.81 rows=1 width=186) (actual time=1.015..1.015 rows=0 loops=1)

  • Sort Key: tb_bond_operation.id_operation DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 1.003 ↓ 0.0 0 1

Nested Loop Left Join (cost=39.61..71.81 rows=1 width=186) (actual time=1.003..1.003 rows=0 loops=1)

  • Join Filter: ((tb_bond_operation.id_contract = tb_bond_issuer.id_contract) AND (tb_bond_operation.id_issuer = tb_bond_issuer.id_issuer))
4. 0.002 1.003 ↓ 0.0 0 1

Nested Loop Left Join (cost=39.61..71.24 rows=1 width=164) (actual time=1.003..1.003 rows=0 loops=1)

5. 0.000 1.001 ↓ 0.0 0 1

Nested Loop Left Join (cost=39.57..70.79 rows=1 width=139) (actual time=1.001..1.001 rows=0 loops=1)

6. 0.000 1.001 ↓ 0.0 0 1

Nested Loop Left Join (cost=39.54..70.36 rows=1 width=133) (actual time=1.001..1.001 rows=0 loops=1)

7. 0.000 1.001 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.27..30.72 rows=1 width=117) (actual time=1.001..1.001 rows=0 loops=1)

8. 0.000 1.001 ↓ 0.0 0 1

Nested Loop (cost=0.03..30.27 rows=1 width=113) (actual time=1.001..1.001 rows=0 loops=1)

9. 0.000 1.001 ↓ 0.0 0 1

Nested Loop (cost=0.03..29.96 rows=1 width=72) (actual time=1.001..1.001 rows=0 loops=1)

  • Join Filter: ((tb_bond_operation.side)::text = (dm_side_operation.cd_side_operation)::text)
10. 1.001 1.001 ↓ 0.0 0 1

Index Scan using tb_bond_operation_cd_account_sinacor_side_id_status_idx on tb_bond_operation (cost=0.03..29.75 rows=1 width=61) (actual time=1.001..1.001 rows=0 loops=1)

  • Index Cond: (id_status = 1)
  • Filter: ((dt_operation >= 20191129) AND (dt_operation <= 20191129) AND (id_contract = 39))
11. 0.000 0.000 ↓ 0.0 0

Seq Scan on dm_side_operation (cost=0.00..0.21 rows=4 width=17) (never executed)

  • Filter: (id_contract = 39)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on tb_bond_operation_status (cost=0.00..0.31 rows=1 width=49) (never executed)

  • Filter: ((id_contract = 39) AND (id_status = 1))
13. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on tb_bond_custody_external_instrument custody_external_instrument (cost=0.24..0.44 rows=1 width=20) (never executed)

  • Recheck Cond: ((tb_bond_operation.id_contract = id_contract) AND (id_contract = 39) AND (tb_bond_operation.id_instrument = id_instrument))
14. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on tb_bond_custody_external_instrument_id_contract_id_instrument_i (cost=0.00..0.24 rows=1 width=0) (never executed)

  • Index Cond: ((tb_bond_operation.id_contract = id_contract) AND (id_contract = 39) AND (tb_bond_operation.id_instrument = id_instrument))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_bond_custody_external_dt_reference_id_operation_external_idx on tb_bond_custody_external custody_external (cost=39.27..39.64 rows=1 width=44) (never executed)

  • Index Cond: ((dt_reference = (SubPlan 1)) AND (id_operation_external = custody_external_instrument.id_operation_external))
  • Filter: ((id_contract = 39) AND (id_contract = custody_external_instrument.id_contract))
16.          

SubPlan (for Index Scan)

17. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=39.21..39.22 rows=1 width=4) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_bond_custody_external_id_operation_external_idx on tb_bond_custody_external custody_external_dt_reference (cost=0.04..39.16 rows=230 width=4) (never executed)

  • Index Cond: (id_operation_external = custody_external_instrument.id_operation_external)
  • Filter: (id_contract = custody_external_instrument.id_contract)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_bond_title_pk on tb_bond_title (cost=0.03..0.43 rows=1 width=14) (never executed)

  • Index Cond: ((tb_bond_operation.id_contract = id_contract) AND (id_contract = 39) AND (tb_bond_operation.id_bond = id_bond))
20. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_core_customer_data_pk on tb_core_customer_data (cost=0.04..0.44 rows=1 width=37) (never executed)

  • Index Cond: ((tb_bond_operation.id_contract = id_contract) AND (id_contract = 39) AND (tb_bond_operation.id_customer = id_customer))
21. 0.000 0.000 ↓ 0.0 0

Seq Scan on tb_bond_issuer (cost=0.00..0.48 rows=63 width=33) (never executed)

  • Filter: (id_contract = 39)
Planning time : 6.166 ms