explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.045 8,994.258 ↑ 1.8 11 1

Limit (cost=11.57..578.14 rows=20 width=547) (actual time=8,563.327..8,994.258 rows=11 loops=1)

2. 7,491.898 8,994.213 ↑ 113.5 11 1

Hash Right Join (cost=11.57..35,365.09 rows=1,248 width=547) (actual time=8,563.320..8,994.213 rows=11 loops=1)

  • Hash Cond: (l_areas.id_type = bib_areas_types.id_type)
  • Filter: ((f_unaccent((l_areas.area_name)::text) ~~* unaccent('%Auben%'::text)) OR ((l_areas.area_code)::text ~~ '%Auben%'::text))
  • Rows Removed by Filter: 734384
3. 1,502.066 1,502.066 ↑ 1.0 734,366 1

Seq Scan on l_areas (cost=0.00..30,607.66 rows=734,366 width=33) (actual time=0.013..1,502.066 rows=734,366 loops=1)

4. 0.118 0.249 ↑ 1.9 36 1

Hash (cost=10.70..10.70 rows=70 width=522) (actual time=0.247..0.249 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
5. 0.131 0.131 ↑ 1.9 36 1

Seq Scan on bib_areas_types (cost=0.00..10.70 rows=70 width=522) (actual time=0.032..0.131 rows=36 loops=1)

Planning time : 0.734 ms
Execution time : 8,994.381 ms