explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N6Nb

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 141.344 ↑ 1.0 1 1

Nested Loop (cost=0.98..31,502.75 rows=1 width=28) (actual time=40.298..141.344 rows=1 loops=1)

  • -> Index Scan using tb_bond_custody_external_dt_reference_id_operation_external_idx on tb_bond_custody_external (cost=0.56..2.58 rows=1 width=28) (actual time=0.023..0.024rows=1 loops=1)
2. 141.310 141.310 ↑ 1.0 1 1

Index Scan using tb_bond_custody_external_instrument_id_contract_id_instrument_i on tb_bond_custody_external_instrument (cost=0.42..31,500.15 rows=1 width=16) (actual time=40.267..141.310 rows=1 loops=1)

  • Index Cond: (id_instrument = '918035'::bigint)
  • Index Cond: ((dt_reference = 20,200,608) AND (id_operation_external = tb_bond_custody_external_instrument.id_operation_external))
  • Filter: (id_contract = 8)
Planning time : 1.272 ms
Execution time : 141.400 ms