explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m9YEg

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 0.108 ↑ 1.5 26 1

HashAggregate (cost=3.10..3.48 rows=38 width=16) (actual time=0.105..0.108 rows=26 loops=1)

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

Index Only Scan using tb_trade_counterparty_idx_01 on tb_trade_counterparty (cost=0.56..2.84 rows=51 width=8) (actual time=0.034..0.066 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))
  • Heap Fetches: 0