explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GQhy : Optimization for: Optimization for: Optimization for: Optimization for: plan #C8M6; plan #QHXK; plan #d8bq; plan #bFAU

Settings

Optimization path:

Optimization(s) for this plan:

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

Limit (cost=1.09..143.38 rows=200 width=1,802) (actual time=0.016..0.728 rows=200 loops=1)

2. 0.286 0.714 ↑ 16,246.9 200 1

Merge Join (cost=1.09..2,311,771.77 rows=3,249,374 width=1,802) (actual time=0.015..0.714 rows=200 loops=1)

  • Merge Cond: (guia_c.guiguiaassoc = guia_h.id)
3. 0.273 0.273 ↑ 28,674.3 200 1

Index Scan using idx_fiboguia_guiguiaassoc_idx on fiboguia guia_c (cost=0.43..1,258,914.55 rows=5,734,864 width=901) (actual time=0.005..0.273 rows=200 loops=1)

4. 0.155 0.155 ↑ 16,246.9 200 1

Index Scan using fiboguia_pkey on fiboguia guia_h (cost=0.43..1,276,940.72 rows=3,249,374 width=901) (actual time=0.004..0.155 rows=200 loops=1)

  • Filter: (guiorigem = 'HOSPITAL'::text)
Planning time : 0.510 ms
Execution time : 0.795 ms