explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.044 2,203.651 ↑ 1.8 11 1

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

2. 0.128 2,203.607 ↑ 113.5 11 1

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

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

Seq Scan on l_areas (cost=0.00..37,951.32 rows=1,248 width=33) (actual time=2,077.566..2,203.325 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.013..0.014 rows=1 loops=11)

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