explain.depesz.com

PostgreSQL's explain analyze made readable

Result: arXP

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 53.299 ↑ 1.0 1 1

Limit (cost=0.42..46.10 rows=1 width=4) (actual time=53.298..53.299 rows=1 loops=1)

2. 0.002 53.297 ↑ 193.0 1 1

Subquery Scan on x (cost=0.42..8,815.62 rows=193 width=4) (actual time=53.297..53.297 rows=1 loops=1)

3. 53.295 53.295 ↑ 193.0 1 1

Index Scan using cliente_unidade_negocio_pkey on cliente_unidade_negocio cun (cost=0.42..8,813.69 rows=193 width=8) (actual time=53.295..53.295 rows=1 loops=1)

  • Filter: (cun_cd_unidade_negocio = 647)
  • Rows Removed by Filter: 102,511
Planning time : 0.163 ms
Execution time : 53.325 ms