explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xelk

Settings
# exclusive inclusive rows x rows loops node
1. 0.093 0.265 ↑ 1.5 26 1

HashAggregate (cost=26.53..26.91 rows=38 width=16) (actual time=0.261..0.265 rows=26 loops=1)

  • Group Key: cd_contraparte
2. 0.172 0.172 ↓ 5.3 269 1

Index Scan using tb_trade_counterparty_cpfcnpj_ix on tb_trade_counterparty (cost=0.56..26.28 rows=51 width=8) (actual time=0.026..0.172 rows=269 loops=1)

  • Index Cond: ((id_contract = 8) AND (cpf_cnpj = '22437258191'::bigint) AND (dt_pregao >= 20,200,606) AND (dt_pregao <= 20,200,624))