explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GNIY : Optimization for: plan #pmnC

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 7.562 7,535.977 ↑ 1.4 4,387 1

Nested Loop (cost=13.10..545,675.64 rows=6,050 width=258) (actual time=296.732..7,535.977 rows=4,387 loops=1)

2. 7,177.615 7,177.615 ↓ 365.4 4,385 1

Seq Scan on resource_view ado (cost=0.00..516,523.70 rows=12 width=122) (actual time=296.582..7,177.615 rows=4,385 loops=1)

3. 306.950 350.800 ↑ 1.0 1 4,385

Bitmap Heap Scan on resource_view quiz (cost=13.10..2,429.32 rows=1 width=188) (actual time=0.077..0.080 rows=1 loops=4,385)

  • Rows Removed by Filter: 4086644
  • Rows Removed by Filter: 29
  • Recheck Cond: ((arquiznumber)::text = (ado.arquiznumber)::text)
  • Heap Blocks: exact=78396
  • Filter: ((islatest = 1) AND ((resourcesubtype)::text = 'STA'::text) AND ((ado.ado_id)::text <> (ado_id)::text) AND ((ado.resourcelanguage)::text = (resourcelanguage)::text))
  • Filter: ((arquiznumber IS NOT NULL) AND ((ado_id)::text ~~ 'ADO_AR360_ASSIGNMENT_%'::text) AND ((arquiznumber)::text <> ''::text) AND ((itemtype)::text = 'AR360 Assignment'::text) AND (islatest = 1))
4. 43.850 43.850 ↑ 20.8 30 4,385

Bitmap Index Scan on idx_resource_view_arquiznumber (cost=0.00..13.10 rows=623 width=0) (actual time=0.010..0.010 rows=30 loops=4,385)

  • Index Cond: ((arquiznumber)::text = (ado.arquiznumber)::text)
Execution time : 7,537.216 ms