explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 5,050.509 11,840.895 ↑ 1.4 2,261,446 1

Gather (cost=1,000.43..1,824,507.31 rows=3,249,374 width=1,802) (actual time=1.690..11,840.895 rows=2,261,446 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,804.739 6,790.386 ↑ 1.8 753,815 3 / 3

Nested Loop (cost=0.43..1,498,569.91 rows=1,353,906 width=1,802) (actual time=3.045..6,790.386 rows=753,815 loops=3)

3. 677.615 677.615 ↑ 1.3 1,077,008 3 / 3

Parallel Seq Scan on fiboguia guia_h (cost=0.00..337,253.08 rows=1,353,906 width=901) (actual time=2.695..677.615 rows=1,077,008 loops=3)

  • Filter: (guiorigem = 'HOSPITAL'::text)
  • Rows Removed by Filter: 834,613
4. 4,308.032 4,308.032 ↑ 1.0 1 3,231,024 / 3

Index Scan using idx_fiboguia_guiguiaassoc_idx on fiboguia guia_c (cost=0.43..0.85 rows=1 width=901) (actual time=0.004..0.004 rows=1 loops=3,231,024)

  • Index Cond: (guiguiaassoc = guia_h.id)
Planning time : 0.431 ms
Execution time : 11,935.103 ms