explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZZGj : Optimization for: plan #LOe

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.010 1,861.356 ↑ 20.0 1 1

Limit (cost=1,000.00..5,230.14 rows=20 width=547) (actual time=1,774.606..1,861.356 rows=1 loops=1)

2. 0.000 1,861.346 ↑ 147.0 1 1

Nested Loop (cost=1,000.00..32,091.53 rows=147 width=547) (actual time=1,774.600..1,861.346 rows=1 loops=1)

  • Join Filter: (bib_areas_types.id_type = l_areas.id_type)
  • Rows Removed by Join Filter: 24
3. 16.920 1,861.975 ↑ 147.0 1 1

Gather (cost=1,000.00..31,928.35 rows=147 width=33) (actual time=1,774.407..1,861.975 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 1,845.055 1,845.055 ↓ 0.0 0 3 / 3

Parallel Seq Scan on l_areas (cost=0.00..30,913.65 rows=61 width=33) (actual time=1,817.694..1,845.055 rows=0 loops=3)

  • Filter: ((unaccent((area_name)::text) ~~* unaccent('Aubenas'::text)) OR (unaccent((area_code)::text) ~~* unaccent('Aubenas'::text)))
  • Rows Removed by Filter: 244788
5. 0.092 0.146 ↑ 2.8 25 1

Materialize (cost=0.00..11.05 rows=70 width=522) (actual time=0.023..0.146 rows=25 loops=1)

6. 0.054 0.054 ↑ 2.8 25 1

Seq Scan on bib_areas_types (cost=0.00..10.70 rows=70 width=522) (actual time=0.012..0.054 rows=25 loops=1)

Planning time : 0.790 ms
Execution time : 1,862.305 ms