explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LOe

Settings

Optimization(s) for this plan:

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

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

2. 0.000 1,865.065 ↑ 147.0 1 1

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

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

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

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

Parallel Seq Scan on l_areas (cost=0.00..30,913.65 rows=61 width=33) (actual time=1,826.798..1,854.437 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.024..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.013..0.054 rows=25 loops=1)

Planning time : 0.619 ms
Execution time : 1,870.360 ms