explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JFC1

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 0.173 ↑ 1.0 1 1

Nested Loop (cost=0.98..5.03 rows=1 width=28) (actual time=0.036..0.173 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.016..0.017rows=1 loops=1)
2. 0.152 0.152 ↑ 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..2.44 rows=1 width=16) (actual time=0.016..0.152 rows=1 loops=1)

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