explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C8M6

Settings

Optimization(s) for this plan:

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

Limit (cost=1,000.43..338,261.63 rows=1 width=1,802) (actual time=693.900..693.900 rows=0 loops=1)

2. 0.000 693.899 ↓ 0.0 0 1

Nested Loop (cost=1,000.43..338,261.63 rows=1 width=1,802) (actual time=693.899..693.899 rows=0 loops=1)

3. 23.459 699.181 ↓ 0.0 0 1

Gather (cost=1,000.00..338,253.18 rows=1 width=901) (actual time=693.898..699.181 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 675.722 675.722 ↓ 0.0 0 3 / 3

Parallel Seq Scan on fiboguia guia_c (cost=0.00..337,253.08 rows=1 width=901) (actual time=675.722..675.722 rows=0 loops=3)

  • Filter: (discriminador = 'HOSPITAL'::text)
  • Rows Removed by Filter: 1,911,621
5. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = guia_c.guiguiaassoc)
Planning time : 59.362 ms
Execution time : 699.263 ms