explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 15,849.270 ↓ 0.0 0 1

Limit (cost=0.56..255.65 rows=200 width=1,802) (actual time=15,849.270..15,849.270 rows=0 loops=1)

2. 1,904.013 15,849.269 ↓ 0.0 0 1

Nested Loop (cost=0.56..3,170,067.73 rows=2,485,490 width=1,802) (actual time=15,849.269..15,849.269 rows=0 loops=1)

3. 1,426.056 1,426.056 ↓ 1.0 2,503,840 1

Seq Scan on fiboguia guia_c (cost=0.00..379,069.80 rows=2,485,490 width=901) (actual time=0.061..1,426.056 rows=2,503,840 loops=1)

  • Filter: (discriminador = 'CONVENIO'::text)
  • Rows Removed by Filter: 3,231,024
4. 12,519.200 12,519.200 ↓ 0.0 0 2,503,840

Index Scan using fiboguia_pkey_discriminador on fiboguia guia_h (cost=0.56..1.12 rows=1 width=901) (actual time=0.005..0.005 rows=0 loops=2,503,840)

  • Index Cond: ((discriminador || (id)::text) = (guia_c.discriminador || (guia_c.guiguiaassoc)::text))
Planning time : 0.386 ms
Execution time : 15,849.574 ms