explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.045 2,947.913 ↑ 1.8 11 1

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

2. 0.132 2,947.868 ↑ 113.5 11 1

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

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

Seq Scan on l_areas (cost=0.00..37,951.32 rows=1,248 width=33) (actual time=2,793.925..2,947.582 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.899 ms
Execution time : 2,948.032 ms