explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QHXK : Optimization for: plan #C8M6

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.014 1.076 ↑ 1.0 200 1

Limit (cost=1.38..186.66 rows=200 width=1,802) (actual time=0.016..1.076 rows=200 loops=1)

2. 0.266 1.062 ↑ 12,427.5 200 1

Merge Join (cost=1.38..2,302,528.00 rows=2,485,490 width=1,802) (actual time=0.015..1.062 rows=200 loops=1)

  • Merge Cond: (guia_c.guiguiaassoc = guia_h.id)
3. 0.532 0.532 ↑ 12,427.5 200 1

Index Scan using idx_fiboguia_guiguiaassoc_idx on fiboguia guia_c (cost=0.43..1,273,251.71 rows=2,485,490 width=901) (actual time=0.006..0.532 rows=200 loops=1)

  • Filter: (discriminador = 'CONVENIO'::text)
4. 0.264 0.264 ↑ 28,674.3 200 1

Index Scan using fiboguia_pkey on fiboguia guia_h (cost=0.43..1,262,603.56 rows=5,734,864 width=901) (actual time=0.004..0.264 rows=200 loops=1)

Planning time : 0.426 ms
Execution time : 1.143 ms