explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hnoq : Optimization for: Optimization for: Optimization for: Optimization for: plan #LOe; plan #ZZGj; plan #gmfp; plan #x3qQ

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.043 2,183.065 ↑ 1.8 11 1

Limit (cost=0.14..612.29 rows=20 width=547) (actual time=2,057.764..2,183.065 rows=11 loops=1)

2. 0.130 2,183.022 ↑ 113.5 11 1

Nested Loop (cost=0.14..38,198.03 rows=1,248 width=547) (actual time=2,057.758..2,183.022 rows=11 loops=1)

3. 2,182.738 2,182.738 ↑ 113.5 11 1

Seq Scan on l_areas (cost=0.00..37,951.32 rows=1,248 width=33) (actual time=2,057.719..2,182.738 rows=11 loops=1)

  • Filter: ((unaccent((area_name)::text) ~~* unaccent('%Auben%'::text)) OR ((area_code)::text ~~ '%Auben%'::text))
  • Rows Removed by Filter: 734355
4. 0.154 0.154 ↑ 1.0 1 11

Index Scan using pk_bib_areas_types on bib_areas_types (cost=0.14..0.20 rows=1 width=522) (actual time=0.014..0.014 rows=1 loops=11)

  • Index Cond: (id_type = l_areas.id_type)
Planning time : 0.957 ms
Execution time : 2,183.187 ms