explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zQFZ : Optimization for: plan #QwbO

Settings

Optimization path:

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

Limit (cost=403.24..403.25 rows=1 width=8) (actual time=2.322..2.322 rows=1 loops=1)

2. 0.010 2.320 ↑ 1.0 1 1

Sort (cost=403.24..403.25 rows=1 width=8) (actual time=2.320..2.320 rows=1 loops=1)

  • Sort Key: ag_nodo5__competencia_ficha_modificacion.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.003 2.310 ↑ 1.0 1 1

Nested Loop Semi Join (cost=0.29..403.23 rows=1 width=8) (actual time=2.305..2.310 rows=1 loops=1)

4. 2.300 2.300 ↑ 2.0 1 1

Seq Scan on ag_nodo5__competencia_ficha_modificacion (cost=0.00..386.61 rows=2 width=8) (actual time=2.295..2.300 rows=1 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 8,554
5. 0.007 0.007 ↑ 1.0 1 1

Index Scan using ag_nodo5__competencia_ficha_modificacion_pkey on ag_nodo5__competencia_ficha_modificacion ag_nodo5__competencia_ficha_modificacion_1 (cost=0.29..8.30 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id_nodo = ag_nodo5__competencia_ficha_modificacion.id_nodo)
  • Filter: (indice_ficha = 1)
Planning time : 0.642 ms
Execution time : 2.356 ms