explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dyr7 : teste clientes contratos

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.020 0.020 ↑ 4.7 3 1

Index Scan using contratos_documento_cliente_indx on contratos (cost=0.43..60.67 rows=14 width=1,507) (actual time=0.017..0.020 rows=3 loops=1)

  • Index Cond: (documento_cliente = '31517237807'::numeric)
  • Buffers: shared hit=6