explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S3UH

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 22.478 ↑ 1.0 20 1

Limit (cost=5,850.35..5,850.40 rows=20 width=405) (actual time=22.474..22.478 rows=20 loops=1)

2. 3.778 22.474 ↑ 297.1 20 1

Sort (cost=5,850.35..5,865.20 rows=5,943 width=405) (actual time=22.473..22.474 rows=20 loops=1)

  • Sort Key: (((locality_name_lower)::text = 'нов'::text)) DESC
  • Sort Method: top-N heapsort Memory: 42kB
3. 16.709 18.696 ↑ 1.2 5,084 1

Bitmap Heap Scan on geo (cost=58.06..5,692.21 rows=5,943 width=405) (actual time=2.814..18.696 rows=5,084 loops=1)

  • Recheck Cond: ((locality_name_lower)::text ~~ 'нов%'::text)
  • Rows Removed by Index Recheck: 206
  • Heap Blocks: exact=4994
4. 1.987 1.987 ↑ 1.1 5,290 1

Bitmap Index Scan on geo_locality_name_lower_idx_2 (cost=0.00..56.58 rows=5,943 width=0) (actual time=1.987..1.987 rows=5,290 loops=1)

  • Index Cond: ((locality_name_lower)::text ~~ 'нов%'::text)
Planning time : 0.237 ms
Execution time : 22.544 ms