explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LpCV

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.481 ↑ 1.0 1 1

Limit (cost=108.32..111.31 rows=1 width=4) (actual time=0.481..0.481 rows=1 loops=1)

2. 0.001 0.480 ↑ 263.0 1 1

Append (cost=108.32..894.16 rows=263 width=4) (actual time=0.480..0.480 rows=1 loops=1)

3. 0.001 0.479 ↑ 193.0 1 1

Subquery Scan on x (cost=108.32..110.73 rows=193 width=4) (actual time=0.479..0.479 rows=1 loops=1)

4. 0.162 0.478 ↑ 193.0 1 1

Sort (cost=108.32..108.80 rows=193 width=8) (actual time=0.478..0.478 rows=1 loops=1)

  • Sort Key: cun.cun_cd_cliente_unidade_negocio
  • Sort Method: top-N heapsort Memory: 25kB
5. 0.316 0.316 ↓ 4.7 914 1

Index Scan using cliente_unidade_negocio_idx_unidade_negocio on cliente_unidade_negocio cun (cost=0.42..100.99 rows=193 width=8) (actual time=0.029..0.316 rows=914 loops=1)

  • Index Cond: (cun_cd_unidade_negocio = 647)
6. 0.000 0.000 ↓ 0.0 0

Subquery Scan on x_1 (cost=781.24..782.11 rows=70 width=4) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Sort (cost=781.24..781.41 rows=70 width=8) (never executed)

  • Sort Key: fun.fun_cd_for_unidade_negocio
8. 0.000 0.000 ↓ 0.0 0

Index Scan using fornecedor_unidade_negocio_idx on fornecedor_unidade_negocio fun (cost=0.29..779.09 rows=70 width=8) (never executed)

  • Index Cond: (fun_cd_unidade_negocio = 647)
Planning time : 0.302 ms
Execution time : 0.512 ms