explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.053 ↓ 0.0 0 1

Nested Loop (cost=0.99..17.04 rows=1 width=1,802) (actual time=0.053..0.053 rows=0 loops=1)

2. 0.052 0.052 ↓ 0.0 0 1

Index Scan using fiboguia_pkey_discriminador on fiboguia guia_h (cost=0.56..8.57 rows=1 width=901) (actual time=0.052..0.052 rows=0 loops=1)

  • Index Cond: (discriminador = 'HOSPITAL'::text)
3. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_fiboguia_guiguiaassoc_idx on fiboguia guia_c (cost=0.43..8.45 rows=1 width=901) (never executed)

  • Index Cond: (guiguiaassoc = guia_h.id)
Planning time : 0.416 ms
Execution time : 0.100 ms