explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eT7V

Settings
# exclusive inclusive rows x rows loops node
1. 0.466 2,300.370 ↑ 1.0 1 1

Update on tb_dispositivo d (cost=0.57..389,765.52 rows=1 width=1,190) (actual time=991.120..2,300.370 rows=1 loops=1)

2.          

CTE tmp

3. 1.005 1.005 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=128) (actual time=1.004..1.005 rows=1 loops=1)

4. 4.901 2,299.904 ↑ 1.0 1 1

Nested Loop (cost=0.56..389,765.50 rows=1 width=1,190) (actual time=990.657..2,299.904 rows=1 loops=1)

5. 1.022 1.022 ↑ 1.0 1 1

CTE Scan on tmp (cost=0.00..0.02 rows=1 width=280) (actual time=1.018..1.022 rows=1 loops=1)

6. 2,293.981 2,293.981 ↑ 1.0 1 1

Index Scan using idx_tb_dispositivo_ni_identificador_novo on tb_dispositivo d (cost=0.56..389,765.47 rows=1 width=774) (actual time=984.742..2,293.981 rows=1 loops=1)

  • Index Cond: ((identificador)::text = tmp.identificador)
  • Filter: ((bloqueado_em IS NULL) AND (tmp.ni = (ni)::text))
  • Rows Removed by Filter: 1
Planning time : 0.849 ms
Execution time : 2,300.458 ms